sp_ctrl> status
Post - stopped due to error
Indicates that post process is stopped due to error.
There are a number of reasons that the post process can be stopped due to error. The event log will give more specific information regarding the error.
Run the "show log reverse" command to read the last messages in the event log to determine the exact error, then search the knowledge base for that error.
In sp_ctrl execute the command below:
sp_ctrl>show log reverse
This provides the error message :
"Internal error: Poster exit on 9i ddl error due to ORA-00942: table or view does not exist. on ALTER TABLE "FTPROD"."EID_COMPARE_RESPONSE" MODIFY("RULE_ID"... [sp_opst (for o.YEN10DB-o.YEN7DB queue yen10vip)/10514]
Process exited sp_opst (for o.YEN10DB-o.YEN7DB queue yen10vip) [pid = 10514] - exit(1)"
Search our knowledgebase for the error you see in this output for resolution.
Example:
search for "ORA-00942: table or view does not exist", or "Poster exit on 9i ddl error"
Please contact support if further assistance is needed.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy