T65-2016: Oracle Patch 17501296 is required on Oracle 11.2.0.4 for use with BIOVIA Workbook (formerly BIOVIA ELN)
The following error may be encountered when running BIOVIA Workbook (formerly BIOVIA ELN) on Oracle 11.2.0.4 database. This error message may be present in the Vault Server log files, and it can cause failures when running database upgrade scripts.
Symyx.Framework.Data.DatabaseException: An error occurred while executing ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored. Exception: ExecuteNonQuery ---> Oracle.DataAccess.Client.OracleException ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
Operating System
All supported operated systems.
Resolution:
This error message is caused by Oracle bug 17501296. To resolve the problem, apply Oracle Database Patch 17501296 - UNABLE TO DELETE ROWS FROM TABLE WITH TEXT INDEX AFTER UPGRADE TO 11.2.0.4
How to contact BIOVIA Support
If you have any questions, please contact BIOVIA Support.