The following errors are observed in the Post queue:
sp_ctrl (sp-report1:2100)> show log reverse
Info 2010-04-22 23:12:33.240668 25501774 1 Poster exited with code=1, pid =
25297026 (posting from name, queue Queue_name, to SPREPLNT)
Info 2010-04-22 23:12:33.237288 25501774 1 Poster exited with code=1, pid =
25579626 (posting from name, queue sp-prod1, to NAME)
Error 2010-04-22 23:12:33.216817 25297026 1 Poster: failed to commit transact
ion session 0 in DoDeactivate: Will exit Post.. (posting from name, queue Pr
iceList, to NAME) [module opo]
Error 2010-04-22 23:12:33.202310 25297026 1 Poster: 12070 - OCITransCommit fa
iled with ORA--2. (posting from name, queue Queue_name, to NAME) [module o
sp]
Notice 2010-04-22 23:12:31.043448 25297026 1 Poster: Invalid object id 0 enter
ed is not disable to replicate (posting from name, queue Queue_name, to name) [module opo]
Â
Around that time, the Post is stopped due to error as the following shows:
Â
sp_ctrl (sp-report1:2100)> status
Brief Status for sp-report1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 25501774 22-Apr-10 22:42:22
Import Idle
MTPost Stopped - due to error