Knowledge Management Solution Index Synchronization Is Failing With Error ORA-20000
(Doc ID 1563686.1)
Last updated on JULY 21, 2020
Applies to:Oracle Knowledge Management - Version 12.1.2 and later
Information in this document applies to any platform.
When running the concurrent program "Knowledge Management Solution Index Synchronization", it ends with in error.
As per the below My Oracle Support document, ran the program with parameters DR (Drop and Recreate), but sill the concurrent program is failing.
Note 1315737.1: Knowledge Management Solution Index Synchronization Concurrent Is Ending With Error DRG-10502: index CS.CS_KB_SETS_ATTACH_TL_N3 does not exist
Sync_Set_Index: Program error: Execution failed due to unexpected error.
ORA-20000: Oracle Text error:
DRG-10502: index CS.CS_KB_SETS_ATTACH_TL_N3 does not exist
Run the following concurrent program:
CS_KB_SYNC_SOLUTIONS_INDEX - Knowledge Management Solution Index Synchronization
(R) Knowledge Administrator
(N) From the top Menu: View -> Requests
- Submit a New Request
- Single Request
- Choose the concurrent Program: Knowledge Management Solution Index Synchronization
. Build Mode: DR
. Other params: Kept the default values
=> After a while the program fails with error.
CS_KB_SETS_ATTACH_TL_N3 does exist, and it is VALID.
- Upgraded RDBMS to 18.104.22.168.5
- First time running the KM concurrent program since the upgrade.
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