DSXchange

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]

has any one come across this error .?


Thanks.

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.