Error Code | 54 |
Error Message | Execution ended in error--> Unexpected exception, error code 54: From Exec SQL: SQL state 42000, message: [Actian][Actian CR ODBC Driver][INGRES]line 1, Syntax error on 'EOF'. The correct syntax is: DROP [object_type] object_name {, [object_type] object_name} |
Description | This error message is displayed for ODBC 3.5 Multimode target connector, when the create or drop table syntax during execution is incorrect. |
Cause/Solution | Cause: Single quote has been used as the value of IdentifierQuotes property and this results in incorrect create or drop table syntax during execution. Solution: Change the value of IdentifierQuotes property: 1. Click the Target tab. 2. Change the IdentifierQuotes connector property value from ' (single quote) to None, Default or " (double quotes). 3. Save and Run the Map. |
Related Information |