DSXchange

Hi, how many other sides are there in the job? No there is no other link for update or any other stage. The error is occuring on the insert side I guess I had earlier thought that this error might occur during the select statement or the insert and so tried to specify that it is occuring on the inse...

Hi Ray, This is the generated sql INSERT INTO SYSADM.EXTPS_CW_HIRE_REQ (MNTCRC,MNTNCI,CW_STATUS_FORM_NUM,CW_HIRE_TYPE,RQST_TYP,REG_TEMP,FULL_PART_TIME,CW_WORK_CITY,CW_START_DATE,MODIFIED_BY,CW_DT_MODIFIED,CW_AD_REF_NUM,CW_AD_DATE,CW_AD_COST,CW_REPL_EMPLID,CW_HIR_REPL_REASON,CW_NO_OF_POSITIONS,CW_DT_...

Hi, I am sort of hijacking this thread because i thought this as a related thread. I am pulling data using ODBConnectivity and loading using a DRStage. I am using 7.5.1 version. and this is a server job. Windows. i am getting a ORA-01008 for a GENERATED ddl and The column number is the same.......Th...

Hi Roy, Thanks . . One correction..in one of the earlier posts I mentioned that the job was running fine with an array size of 100. My tansaction size was 1000 and array size before was 500 which when changed to 100 got rid of the error The original post is correct and the job is only accepting an a...

Hi, yes it was imported from oracle alright. 8) ....but is this a factor that was contributing anyway for causing the illegal variable error. Anyway the column remained there before the error and after so I dont think it was causing the error. But I was wondering if a Clob contributes in any manner ...

Hi Craig, No. U r right. transaction size was 1000 and array size was 500 when i git that error and when i made the array size 100 and transaction handling read committed Ds did not give me the error. (And all other things were unchanged). :?: There is a column with longvarchar and size is 214748364...

Hi Ray ,
My tansaction size was 1000 and array size before was 500 which when changed to 100 got rid of the error. Thanks for showing the direction.
Ash.

Hi Ketfos, it was not a user defined sql but a generated one. following is the error message that i was getting before making changes to the array size. CW_HR_init_histPS_RC_CASE..XFM_PS_RC_CASE.LNK_Out_PS_RC_CASE: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO SYSADM.HISTPS_RC_CASE...

Hi, I first looked into all the names..when I did not find anything ilegal over there. I guessed it must be something wrong with a numeric variable and since i had changed the array size earlier .i tried playing with it. I am also curious why it it did not like array size of 100 and was OK with an a...

Hi All,
Making the array size as 1 and transaction handling = read committed....took care of the error.
Thanks for your attention and time,
Ashish.

Hi, I am getting the following error in a straight move initial load job. ORA-01036: illegal variable name/number :? I am using ODBC to pull the data as well to load the data. I AM NOT USING A CUSTOM SQL in this job. Also there is no lookup. The column names i am using also do not include any reserv...

Are you using any stage variable named pin 4 in the transformer_9?
Ash.

Thanks Vincent..

Hi KirtiKumar, Thanks for the reply. It is not generating any other errors than mentioned above. The other errors that follow the above errors are: Lookup_14,0: Operator terminated abnormally: runLocally did not return APT_StatusOk main_program: Unexpected exit status 1 main_program: Step execution ...

Hi, While using lookup stage in a job I am getting the following error Lookup_14,0: Could not map table file "/dsresource01/hr_dev/datasets/lookuptable.20050811.4k2zscc (size 496 bytes)": Invalid argument Error finalizing / saving table /tmp/dynLUT3483346a65d3a7 Lookup_14,0: Operator's run...