Error when reading table using ORACLE Connector in 8.1

[kbsuryadev]

Screen shot of the job http://picasaweb.google.com/kbsuryadev/ ... ctor_ERROR#

Oracle connector: partioned reads ( ENABLED) on table a
partioned read method: Rowid hash

Custom sql: joining 2 tables( one of which is temp table)
transformer: No transformations.
target: dataset and creating a table and inserting 1 column

select a.col1,a.col2,a.col3 from table a,table b(temp table)
where a.colx=b.colx

This is the error:

In_Table_X_Carrier,0: [IIS-CONN-ORA-001001] The variable endPosition has value 353 which is not valid in the current context. (CC_OraUtils::matchingParenthesis, file CC_OraUtils.cpp, line 4,041)

Note: The job runs successfully when partioned reads is disabled.

Any inputs on this error.
Thank you all.


[/img][/quote][/list]

[kbsuryadev]

has any one come across this error .?


Thanks.

[kbsuryadev]

The issue with the above error in the job is related to Oracle connector issue, Contacted IBM reagarding this issue and installed the patch. I ran the job and the job finished successfully.

PROBLEM: JR35357 The latest patch for Oracle connector.