Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error SQLPrepare: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error; 303 invalid DATE,TIME 0

BAvitia88
8 - Asteroid

Need help with an error

 

Background:

  1. Using Alteryx Designer 2020.3
  2. Created a workflow App saved in company's galley
  3. Opened it to make some changes to it tried to save it and keep getting this error Error SQLPrepare: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error; 303 invalid DATE,TIME 0
  4. The error is a the dynamic input tool
  5. Ran the debug no real insights
  6. The Dynamic Input does not have any date fields
  7. The field I'm replacing is a vwstring

Not sure what the conflict is or how to resolve. 

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hey @BAvitia88 

It does seem to be wanting a date type variable not text/string data type. Have you tried passing the today column as a date:

IraWatt_1-1655501709723.png

Then:

IraWatt_2-1655501740430.png

 

 

BAvitia88
8 - Asteroid

Tried it and it did not work. The strange thing is that when I run the model in Alteryx it works fine, when I publish to the Alteryx server and try to run is when the error shows. 

Labels