Planning Data Pull Worker Takes a Long Time and Then Fails with ORA-01555 Pulling Data From MRP_AN2_SALES_ORDERS_V
(Doc ID 2879609.1)
Last updated on DECEMBER 02, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Data Collections
Planning Data Pull Worker is taking a long time to complete and eventually failing with the following error
ERROR
-----------------------
13-JUN 07:57:11 : Coming here :40820194
13-JUN 11:36:21 : Error pulling data from MRP_AN2_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
13-JUN 11:36:21 : ORA-01555: snapshot too old: rollback segment number 907 with name "_SYSSMU907_381304341$" too small
13-JUN 11:36:21 : ORA-01555: snapshot too old: rollback segment number 907 with name "_SYSSMU907_381304341$" too small
13-JUN 11:36:21 : Error_Stack...
13-JUN 11:36:21 : ORA-01555: snapshot too old: rollback segment number 907 with name "_SYSSMU907_381304341$" too small
ORA-06512: at "APPS.MSC_CL_PULL", line 7045
ORA-06512: at "APPS.MSC_CL_PULL", line 7022
ORA-02063: preceding line from ASCPPROD_TO_ERPPROD.US.ORACLE.COM
ORA-06512: at "APPS.MSC_CL_DEMAND_PULL", line 1090
ORA-06512: at "APPS.MSC_CL_PULL", line 6236
13-JUN 11:36:21 : Error_Backtrace...
13-JUN 11:36:21 : ORA-06512: at "APPS.MSC_CL_PULL", line 7045
ORA-06512: at "APPS.MSC_CL_PULL", line 7022
ORA-06512: at "APPS.MSC_CL_DEMAND_PULL", line 1090
ORA-06512: at "APPS.MSC_CL_PULL", line 6236
ORA-06512: at "APPS.MSC_CL_PULL", line 1825
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Responsibility: Advanced Supply Chain Planner
- Navigation: Collections > Oracle Systems > Standard Collection
- Enter the parameters for the Planning Data Pull and Planning ODS Load concurrent programs
- Submit the request
Cause
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
Symptoms |
Cause |
Solution |
References |