MRCNSW Memory Based Snapshot Worker Errors Ora-08004 mrsngs_snp_gross_rqmts - Also MSCPUSH - Push Plan Errors ORA-02055 ORA-08004 ORA-2063
(Doc ID 577658.1)
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Advanced Supply Chain Planning - Version 18.104.22.168 and later
Oracle Materials Requirement Planning - Version 11.0.3 and later
Information in this document applies to any platform.
Materials Requirement Planning - Version: 11.0.3 and Up
ConcurrentProgram:MRCNSW - Memory-based Snapshot Worker
EXECUTABLE:MRCNSP - Memory-based Snapshot
EXECUTABLE:MSCPUSH - Push Plan
*** Checked for relevance on 23-Apr-2012 ***
***Checked for relevance on 07-Oct-2013***
User is running MRP and MRCNSW - Memory Based Snapshot Worker errors with the following:
APP-01564: ORACLE error 8004 in mrsngs_snp_gross_rqmts
Cause: mrsngs_snp_gross_rqmts failed due to ORA-08004: sequence MRP_GROSS_REQUIREMENTS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
The SQL statement being executed at the time of the error was: SELECT
dates.inventory_item_i and was executed from the file 1880439/mrp/src/mrlsdi.pc.
APP-22075: An internal error has occurred (mrsndi_snp_demand_info, 2, , )
APP-22075: An internal error has occurred (mrnspxt, 20, 10008, )
APP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10008, )
APP-22075: An internal error has occurred (main, 13, , )
Contact your customer supportrepresentative.
Statement with the error:
New update 15-APR-2015 - Problem also occurs in ASCP with MSCPUSH - Push Plan with the following errors:
ORACLE error 2055 in FDPSTP
Cause: FDPSTP failed due to ORA-02055: distributed update operation failed; rollback required
ORA-08004: sequence MRP_GROSS_REQUIREMENTS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-02063: preceding line from
The issue can be reproduced at will with the following steps:
1. Run MRP Plan
2. Log file shows failure
1. Run MSCPUSH from ASCP to populate MRP tables
2. Log files shows failure
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Recovery from Error Condition|
|DROP AND RE-CREATE THE SEQUENCE|
|CHECK DATA AND PERFORM MAINTENANCE|