Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎06-16-2022 06:57 AM

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. 

Preview file
17 KB
Preview file
56 KB
Preview file
9 KB
Preview file
23 KB
Production Material Plan Error Help.yxzp
Labels:
Reply
0 Likes
2 REPLIES 2
IraWatt
17 - Castor
17 - Castor
‎06-17-2022 02:36 PM

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

 

 

Reply
0 Likes
BAvitia88
8 - Asteroid
‎06-22-2022 06:03 AM

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. 

Reply
0 Likes
Labels