Return
-
Title
Post stops with "Error: Unexpected Oracle error: ORA-00932: inconsistent datatypes: expected %s g -
Description
Post errors out with the following message:
02/03/18 09:54 Notice: ORA-00932: inconsistent datatypes: expected - got CLOB. [sp_opst_mt(osp)/3099]
02/03/18 09:54 Error: Unexpected Oracle error: ORA-00932: inconsistent datatypes: expected - got CLOB. (object name: "SCHEMA"."TABLE") [sp_opst_mt (for o.SID-o.SID queue queuename)/3099
02/03/18 09:54 Process exited sp_opst_mt (for o.SID-o.SID queue queuename) [pid = 3099] - exit(1) -
Cause
The structure of the table is different between source and target
-
Resolution
Correct the discrepancy in the table structure and start post
-
Additional Information
SP-OPO01011 To verify which table is affected turn on full debug and sql debug on post: sp_ctrl> set param SP_OPO_DEBUG_FLAG 0x1f0021ff sp_ctrl> set param SP_OPO_SQL_DEBUG 0x40 sp_ctrl> start post when post is stopped due to error, then turn off debug
sp_ctrl> reset param SP_OPO_DEBUG_FLAG sp_ctrl> reset param SP_OPO_SQL_DEBUG Get the opo.log and check for a line like this: 02/03/18 09:54:50.063735 4684 1 insert_in_row_lob: sqlStmt->SELECT t."COLUMN" FROM "SCHEMA"."TABLE" t WHERE ROWID =
02/03/18 09:54:50.063735 4684 1 'AAAfs9AAUAAAC5aAAA' FOR UPDATE
02/03/18 09:54:50.078141 4684 1 Error 932 in call to OCIStmtExecute in insert_in_row_lob()