-
标题
Post fails on target with oracle error :ORA-01400: cannot insert NULL into -
说明
Post fails on target with error.
ORA-01400: cannot insert NULL into ("DBOWN"."TABLE1"."COLUMN1"). (object name: "DBOWN"."TABLE1") (posting from SERV1, queue QUEUE1, to SERV2) [module opo]
-
原因
There could be many reasons for this error and here are some listed for reference.
1. Table Structure different on Source and Target. Source Table does not have the "Not Null" constraint and is present on the target table.
2. Data missing for the not null constraint columns while replicating through Shareplex.
3. Object cache corruption on source / target.
4. Using vertical partition on column(s) with "Not Null" constraint
-
解决办法
Set a full debug on post and collect the *opo* logs to read the data replicated to investigate the issue further. Refer to KB Article # 25
a. If it is a data issue, disable the object from replication, re sync the table and setup an object level debug to investigate it further. Refer KB Article # 17610
b. If it is an issue with the table structure on target, disable the "not null" constraint on target.
c. If the table structure is the same on source and target, dump the object cache to see the table structure that Shareplex has is different. Refer KB Article # 17525
d. If the issue is related to vertical partitioning on column(s) with "Not Null" constraint on target, then
i. disable "Not Null" constraint on target
ii. include column(s) in replication, and for the messages that already in post queue you can either use option i above, disable object, or discard messages.