My Oracle Support Banner

Sybase (ASE, ASA & AS IQ), JConnect 'BatchUpdateException' Message Signaled In Oracle Data Integrator Integration Interfaces (Doc ID 424699.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

Adaptive Server Anywhere (ASA)  Error -143: Column '@p0' not found...

A simple Oracle Data Integrator Integration Interface, loading data to a Sybase IQ Datastore, fails at execution time with the following message:

com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException:
Error occurred while executing batch statement:
ASA Error -143: Column '@p0' not found

The '@p0' column does not exist either on the Source, the Staging Area or the Target.

Attempt to insert duplicate key row in object...

The following message is signaled when importing an Oracle Data Integrator Project into a Sybase ASE Work Repository:

com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException:
Error occurred while executing batch statement:
Attempt to insert duplicate key row in object 'SNP_TXT_CROSSR' with unique index 'PK_TXT_CROSSR'

Too many parameters -- symbol table overflow...

The following message is signaled when loading a flat file into a Sybase ASE temporary table:

com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE:BatchUpdateException:
Error occurred while executing batch statement:
Too many parameters -- symbol table overflow

Adaptive Server Anywhere (ASA) Error -1006000: IQ Internal error...

 The following message is signaled when loading data from DB2 to Sybase IQ:

com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException:
Error occurred while executing batch statement:
ASA Error -1006000: IQ Internal error. Please report this to Sybase IQ support.

Adaptive Server Anywhere (ASA) Error -180: Cursor not open...

The following message is signaled when executing an Oracle Data Integrator Specific Procedure with bind mechanism, where the command on Target is an INSERT into a Sybase IQ table: 

com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -180: Cursor not open
  at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2535)

Cursor was found to be read only...

The following message is signaled when using jConn2.jar in Oracle Data Integrator 11g:

ODI-1227: Task SrcSet0 (Loading) fails on the source <SYBASE SOURCE> connection <SYBASE CONNECTION NAME>
Caused By: com.sybase.jdbc2.jdbc.SybSQLException: Cursor '<CURSOR>' was declared with a FOR UPDATE clause.
This cursor was found to be read only
  at com.sybase.jdvc2.tds.Tds.processEed(Tds.java:3178)
  at com.sybase.jdvc2.tds.Tds.nextResult(Tds.java:2481)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
  Adaptive Server Anywhere (ASA)  Error -143: Column '@p0' not found...
 Attempt to insert duplicate key row in object...
 Too many parameters -- symbol table overflow...
 Adaptive Server Anywhere (ASA) Error -1006000: IQ Internal error...
 Adaptive Server Anywhere (ASA) Error -180: Cursor not open...
 Cursor was found to be read only...
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.