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

Question

Need help with an error

Background:

* Using Alteryx Designer 2020.3
* Created a workflow App saved in company's galley
* 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
* The error is a the dynamic input tool
* Ran the debug no real insights
* The Dynamic Input does not have any date fields
* The field I'm replacing is a vwstring

Not sure what the conflict is or how to resolve.

Error.png

Metadata.png

Field replacing.PNG

Dinamic input.PNG

Production Material Plan Error Help.yxzp

BAvitia88 · Answer

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.

IraWatt · Answer

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:

Then: