MSCNSP Memory Based Snapshot Fails with: mscsnr_snp_routings failed due to ORA-01502: index 'MSC.MSC_ROUTINGS_N1' or partition of such index is in unusable state
(Doc ID 273298.1)
Last updated on FEBRUARY 10, 2021
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
MSCNSP module: Memory-Based Snapshot Fails with
fetching info on request: 8953
APP-FND-01564: ORACLE error 1502 in mscsnr_snp_routings
Cause: mscsnr_snp_routings failed due to ORA-01502: index 'MSC. MSC_ROUTINGS_N1' or partition of such index is in unusable state
The SQL statement being executed at the time of the error was:
select
decode(oper_res.resource_id,null ,(-1),rout_oper.department_id) and was
executed from the file 3073565/msc/src/mslsyi.pc.
APP-MRP-22075: An internal error has occurred (mrnspxt, 17, 10010, ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10010, ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
APP-MRP-22075: An internal error has occurred (main, 13, , ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
Freeing calendar memory
Statement with the error:
select decode(oper_res.resource_id,null ,(-1),rout_oper.department_id)
3073565/msc/src/mslsyi.pc
APP-FND-01564: ORACLE error 1502 in mscsnr_snp_routings
Cause: mscsnr_snp_routings failed due to ORA-01502: index 'MSC. MSC_ROUTINGS_N1' or partition of such index is in unusable state
The SQL statement being executed at the time of the error was:
select
decode(oper_res.resource_id,null ,(-1),rout_oper.department_id) and was
executed from the file 3073565/msc/src/mslsyi.pc.
APP-MRP-22075: An internal error has occurred (mrnspxt, 17, 10010, ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10010, ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
APP-MRP-22075: An internal error has occurred (main, 13, , ) ERRORTEXT
Cause: The current routine encountered the specified ERRORTEXT x
Action: Contact your customer support representative.
Freeing calendar memory
Statement with the error:
select decode(oper_res.resource_id,null ,(-1),rout_oper.department_id)
3073565/msc/src/mslsyi.pc
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! |