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 and later
Information in this document applies to any platform.


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
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.


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