Database Errors

ORA-22275: invalid LOB locator specified

Oracle users may encounter this error when attempting to copy, edit, or submit assets in the system. The behavior will cause messages similar to the following to appear in the cascade.log file:

2015-09-14 07:54:10,936 WARN [JDBCExceptionReporter] SQL Error: 22275, SQLState: 99999
2015-09-14 07:54:10,937 ERROR [JDBCExceptionReporter] ORA-22275: invalid LOB locator specified

This problem is caused by the following Oracle bug (Oracle account login required to view): Bug 19703301 ORA-22275 "invalid lob locator specified" if fix for bug 14044260 present

To correct the issue, apply DATABASE PATCH SET UPDATE 12.1.0.2.160719 or greater to your Oracle environment as described in the link above.

Back to Top ↑