SHAREPLEX: ORA-01400

sp_ctrl (openstack02:2100)> show log reverse
Error 2015-05-15 09:34:58.733430 46266 784828160 s:2 Poster: Unexpected Oracle error: ORA-01400: cannot insert NULL into (“YTCRM”.”AO_AUTOMATIC_BASE”.”USER_CODE”). (object name: “YTCRM”.”AO_AUTOMATIC_BASE”) (posting from ifdb, queue express, to intwebdb) [module opo]
Notice 2015-05-15 09:34:56.024503 46266 889710336 Poster: SQL Cache disabled. (posting from ifdb, queue express, to intwebdb) [module opo]
Info 2015-05-15 09:34:54.785300 46266 4213745408 Poster launched, pid = 46266 (posting from ifdb, queue express, to intwebdb)
Notice 2015-05-15 09:34:54.783704 46262 451921664 User command: oracle start post (from openstack02)

Compare errors with following event_log errors:
01/22/07 19:38 Internal error: Error -1 in de_compare_client see sebprod_declt-owner-table-pid-*.log [sp_declt(deq)/pid]
01/22/07 18:17 Error: Oracle Error 1400: ORA-01400: cannot insert NULL into
(“owner”.”table”.”col”)

Cause
This error is thrown if an attempt is made to insert a null into a column that has not null constraint.

RESOLUTION:
Check deferrable primary key constraints: when the constraint is set immediate causing the error或者修改报错列让其能接受其null值(需要和app商量)

sp_ctrl (openstack02:2100)> status

Brief Status for openstack02
Process State PID Running Since
————— —————————— ——– ——————–
Cop Running 14108 23-Apr-15 14:51:19
MTPost Running 46798 15-May-15 09:47:19
Import Running 37315 08-May-15 17:12:20
Cmd & Ctrl Running 46262 15-May-15 09:34:31
There are no active configuration files

sp_ctrl (openstack02:2100)> qstatus

Queues Statistics for openstack02
Name: express (o.ifdb-o.intwebdb) (MTPost queue)
Number of messages: 13582373 (Age 5793 min; Size 6474 mb)
Backlog (messages): 13582094 (Age 5757 min)

sp_ctrl (openstack02:2100)> /

Queues Statistics for openstack02
Name: express (o.ifdb-o.intwebdb) (MTPost queue)
Number of messages: 13581655 (Age 5793 min; Size 6474 mb)
Backlog (messages): 13581330 (Age 5757 min)