Error Code | 54 |
Error Message | Error preparing map for execution: Error 25554 opening target 'Oracle 19c': ExecuteSQLCommand(OCIStmtExecute): error 942 (ORA-00942: table or view does not exist). |
Description | This error may be displayed when you try to insert data into a table using REPLACE output mode. This error is usually displayed for connectors like Oracle 19c. |
Cause/Solution | Cause: Data is not inserted into the target table when Synonyms property is set to TRUE. On running a transformation in REPLACE mode with Synonyms property set to TRUE, the table will be dropped and recreated. When it is recreated, table synonym would not exist. Solution: Use APPEND or DELETEANDAPPEND output mode. |
Related Information |