My Oracle Support Banner

APS Collections Refresh Snapshot Thread for WSH_TRIP_STOP_SN Failed Without Message (Doc ID 2446010.1)

Last updated on AUGUST 15, 2024

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
When running standard data collection, Refresh Collection Snapshots and APS Collections Refresh Snapshot Thread for WSH_TRIP_STOP_SN failed.

In the log of "Refresh collection snapshot" there is a description suggesting referring to its concurrent log, but nothing is outputted in the log of APS Collections Refresh Snapshot Thread for WSH_TRIP_STOP_SN.

Also, when running Gather Schema Statistics for WSH schema in same instance, it occurs below error massage.

 index "APPS"."WSH_TRIP_STOP_SN_N1"  or partition of such index is in unusable state***
 
Error

-Log of Refresh Collection Snapshots

      :
05-SEP 11:38:53 : ERROR : Please see the log files of request, 54939303, for details
05-SEP 11:38:53 : Cancelling pending/running snapshots
05-SEP 11:38:53 : Cancelled pending/running snapshots
05-SEP 11:38:53 : User-Defined Exception
05-SEP 11:38:53 : User-Defined Exception

-Log of APS Collections Refresh Snapshot Thread (Request id is above 54939303. For WSH_TRIP_STOP_SN)

**Starts**05-SEP-2018 11:33:02

(There is no message in the log)

 

-Log of Gather Schema Statistics

Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=APPS.WSH_TRIP_STOP_SN***ORA-20000: index "APPS"."WSH_TRIP_STOP_SN_N1"  or partition of such index is in unusable state***
Error #2: ERROR: While GATHER_TABLE_STATS:

 

 

Steps to Reproduce

  1. Run Data Collection

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.