Error Code | 54 |
Error Message | One of the following errors may be displayed: • From Exec SQL: SQL state 42500, message: [Actian][Ingres ODBC Driver][INGRES]Table <TableName> does not exist or is not owned by you.. Check log for more details. • From Exec SQL: 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. • From Exec SQL: SQL state 42S02, message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name <TableName>.. 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 |