Troubleshooting > Troubleshooting DataConnect > No Such Table or Object
Was this helpful?
No Such Table or Object
 
Error Code
19
Error Message
From SQLPrepare: SQL state 42S02, message:[Zen][ODBC Client Interface][LNA][Zen][SQL Engine][Data Record Manager]No such table or object.. Check log for more details.
Description
This error may be displayed when insert operation fails for a new table. This error is usually displayed for multimode connectors like Actian X, Vector, Actian Zen, SQL SERVER 2019, and ODBC3.5.
Cause/Solution
 
Cause: The Table Name has not been specified using the Advanced Map View option.
Solution: Add “Transformation started map event from configuration tab:
1. Open the transformation.
2. Click the Configuration tab.
3. Go to Map events section.
4. Add transformation started map event with Drop/Create Table operation.
Related Information
Last modified date: 12/03/2024