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

Last updated on NOVEMBER 01, 2022

Applies to:

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=<AssetID>}]
[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.

Changes

Cause

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