Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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
Top Solution Authors