ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Document ID : KB000104901
Last Modified Date : 18/09/2018
Show Technical Document Details
Issue:
Observed following error related to the APM Database in the CA APM Introscope Enterprise Manager log:

[ERROR] [Thread-ModelSynchronization] [Manager.AppMap] Unable to complete model synchronization with storage!
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [UPDATE appmap_model _vertices SET data = ? WHERE external_id = ?]; SQL state [99999];
error code [24816]; ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column ;
nested exception is java.sql.SQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.ja va:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.ja va:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.ja va:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:933) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:313) at com.wily.introscope.appmap.em.model.dao.impl.gmt.GMTNamedParameterJdbcTemplate.update(GMTNamedParameterJdbcTemplate.java:24:
Environment:
CA Application Performance Management 10.5.2.15
Cause:
A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG.
Resolution:
This is a known issue (DE254845 - ORA-24816 error message in the em log) that has been fixed in the most recent APM 10.5.2 Hotfix which can be requested through Support. 


 
Additional Information:
Oracle Database Error: ORA-24816