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 JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.0.3 and later
Oracle Advanced Supply Chain Planning - Version 11.5.10.2 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***

Symptoms

On 11.0.3 in Production:
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
mrp_gross_requirements_s.nextval,
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, , )
Contact your customer supportrepresentative.

Statement with the error:
SELECT mrp_gross_requirements_s.nextval,
dates.inventory_item_i
1880439/mrp/src/mrlsdi.pc

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


STEPS
The issue can be reproduced at will with the following steps:
1. Run MRP Plan
2. Log file shows failure

or

1.  Run MSCPUSH from ASCP to populate MRP tables
2.  Log files shows failure

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms