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

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

After upgrading to 10.7 SP1, the following exception started appearing in the MOM EM logs:

[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

Environment

• APM 10.7 SP 1

Resolution

This issue is addressed in Service Pack 2:

CA Application Performance Management - 10.7