"invalid LOB locator specified" error in updating backing store

"invalid LOB locator specified" error in updating backing store

book

Article ID: KB0079749

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition 5.4.1, 5.5.0

Description

We are having an issue updating Oracle backing store with a CLOB column: 
2018 Dec 13 01:01:01:000 GMT test Debug [/Channels/JMSLocalChannel/JMSDestination-1] - [jdbcstore] [inference] SaveTransaction SQLException.
java.sql.BatchUpdateException: ORA-22275: invalid LOB locator specified

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
	at com.tibco.be.jdbcstore.impl.DBAdapter.modifyConceptsUnoptimized(SourceFile:1671)

Issue/Introduction

We are getting "ORA-22275: invalid LOB locator specified" when updating backing store

Environment

All supported environments

Resolution

ORA-22275: invalid LOB locator specified may happen when updating a CLOB property with null value.
To avoid the issue:
- After creation or modification to a concept, check the CLOB property, set CLOB property with " " or "empty" String in case the CLOB property is null
- Before using the CLOB property value, verify if value of CLOB property equals to " " or "empty" String which defined to indicate null.
Powered by Wolken Software