Unable To Update The Progress In The Database On Reindexing Collection
(Doc ID 1464334.1)
Last updated on SEPTEMBER 16, 2019
Applies to:Oracle WebCenter Content - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
A Collection rebuild is required if any new metadata tables are added to the Content Server or if the current collection is damaged. While the user executes the collection rebuild cycle , one of the common errors related to several services and tables is :
Unable to update the progress in the database. Possible database connection failure encountered. Error message: (!csDbUnableToExecuteQuery,UscheduledJobProgress(UPDATE ScheduledJobs SET dSjProgress='\!csSjProgressReport...(!csDbUnableToCreateResultSet,QdocumentUpdatable(SELECT dDocName FROM IdcText2...Connection has already been closed.). java.sql.SQLException: Connection has already been closed..
All the table status is verified and is correct.
After every rebuild of collecton most of the documents are stuck in Genwww state .
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