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

book

Article ID: 108118

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER 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: https://docops.ca.com/ca-apm/10-7/en/blog/2018/09/announcing-the-availability-of-ca-apm-10-7-sp2