Error SQLPrepare: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error; 303 invalid DATE,TIME 0
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BAvitia88
8 - Asteroid
‎06-16-2022
06:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Apps
- Error Message
- Workflow
2 REPLIES 2
17 - Castor
‎06-17-2022
02:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
‎06-22-2022
06:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
