ORA-14450 attempt to access a transactional temp table already in use.

This error in SystemOut.log is caused by an Oracle Feature no longer supported by current Oracle database versions. Use of this feature will be discontinued in future Portal WCM Versions.

The issue can occur with various WCM Authoring operations, most recently seen while attempting to move content items from draft to publish workflow stages on a Version 8.0.0.1 Server. 

SOLUTION:

Retry the last operation. If that does not address the issue, restart the Portal Server.

POSSIBLE WORKAROUND FOR RELIEF:

WAS Admin Console > Resources > JDBC > JDBC Providers > provider > Data Sources > datasource > Connection Pools > set the Aged Timeout to 35 seconds and set the Reap Time to 30 seconds

If it fails, retry the operation after 30 seconds