Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > ORA-01461: can bind a LONG value only for insert into a LONG column

ORA-01461: can bind a LONG value only for insert into a LONG column

Overview

The following error or similar are found in the DPA (Ignite) logs:

org.quartz.JobExecutionException: TextPollJob failed [See nested exception: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO CONST_4 (H, P, ST, SS, SE, PNAME, LN, TRUNCATED, D) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column

Note: The location of the error can change. For example, it can occur in modules other than TextPollJob.

Environment

DPA (Ignite) 4.3

Resolution

 

  1. Edit the <ignite_home>/iwc/tomcat/ignite_config/idc/repo.properties file on the Ignite PI server and add the following line:
    repo.additionalProperties=oracle.jdbc.RetainV9LongBindBehavior=true
  2. Restart the Ignite PI Server.
    • Windows: Restart the Ignite PI service.
    • UNIX or Linux: Run the following:
      1. shutdown.sh
      2. startup.sh
Last modified
19:16, 22 Jun 2016

Tags

Classifications

Public