SQL Error When Approving an Asset with Dependencies: ORA-00904: "STATUS": invalid identifier (Doc ID 1993951.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

In Contributor UI when trying to approve an asset using the "Approve With Dependencies" button an onscreen error is received

An exception occurred on the server while executing
UI/Actions/Asset/Approve/DependentAssetApproval:
IllegalStateException: Thread [ACTIVE[
ExecuteThread: '6' for queue: 'weblogic.kernel.Default
(self-tuning)' has not acquired a connection but
attempting to release one.. If problem persists please
contact the system administrator.


And an exception is seen in sites.log:

2015-03-19 11:40:01,352 CET] [DEBUG] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQL for PreparedStatement select id from Publication where id=? and status != 'VO'
Data for PreparedStatement execution [Number of positions=1] data [{0=1343299925367}]
[2015-03-19 11:40:01,360 CET] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException executing query: select id from Publication where id=? and status != 'VO'
java.sql.SQLSyntaxErrorException: ORA-00904: "STATUS": invalid identifier


The asset does not get approved.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms