My Oracle Support Banner

How to clear a Webcenter Content Server Content Basket (Doc ID 1430949.1)

Last updated on MAY 09, 2023

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.

Goal

Sometimes, if a Content Basket has a lot of documents in it, on trying to open the Content Basket the user may get an error like :

Unable to retrieve search results. Unable to create result set for query 'SELECT Revisions.dID, dDocName, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, dFileSize AS VaultFileSize, DocMeta.*
FROM Revisions, DocMeta, Documents

And in the WCC logs you may see a DB error such as :
"Caused by: java.sql.SQLException: ORA-01013: user requested cancel of current operation"

and the user cannot clear out the Content Basket as the Content Basket page is never displayed and hence the user cannot use the 'Emtpy Content Basket' option under the Actions menu.

How to clear the Content Basket ?

Solution

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
Goal
Solution


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