Metadata not found
Posted: Wed Oct 31, 2007 3:43 am
I face a problem in DS 7.5.1 , which i can think of has no solution and DS is just crazy.
I have a simple job
Seq File Read ---> REM DUP ---> DB2 UPSERT ( with a reject link ).
I get the follwing error when I run the job, the stage is output reject stage. Basically the output reject stage is not able to see any Metadata.
Error msgs : -
fsqtranrskdtlrej: Error when checking operator: Could not find input field "ARR_ID_CHAIN".
fsqtranrskdtlrej: Error when checking operator: Could not find input field "POST_DT".
Error when checking operator: Could not find input field "TRAN_CDE".
Error when checking operator: Could not find input field "TRAN_SEQ_NUM".
Error when checking operator: Could not find input field "ACCT_NUM".
Error when checking operator: Could not find input field "CTRY_CURR_CDE".
Error when checking operator: Could not find input field "LEVEL_RISK_CTRY_CURR_CDE".
Error when checking operator: Could not find input field "CUST_1_FULL_NAME".
Error when checking operator: Could not find input field "CUST_2_FULL_NAME".
Error when checking operator: Could not find input field "PROC_DT".
Error when checking operator: Could not find input field "TRAN_AMT".
Error when checking operator: Could not find input field "TRAN_DESC".
Error when checking operator: Could not find input field "TRAN_EFF_DT".
When i run the same job in Dev. env. every thing runs fine and the error occurs in prod. env. of a real time project. Also, the job used to work fine, rather this error popped out of nowhere.
I just want to know why the Metadata is not visible or else are there any special permissions on virtual datasets to funcion properly at runtime.
Any help is highly appreciated. I would also like the readers know that there are some NULL fields being exported into the sequential file, but i guess it has little to do with the error.
I have a simple job
Seq File Read ---> REM DUP ---> DB2 UPSERT ( with a reject link ).
I get the follwing error when I run the job, the stage is output reject stage. Basically the output reject stage is not able to see any Metadata.
Error msgs : -
fsqtranrskdtlrej: Error when checking operator: Could not find input field "ARR_ID_CHAIN".
fsqtranrskdtlrej: Error when checking operator: Could not find input field "POST_DT".
Error when checking operator: Could not find input field "TRAN_CDE".
Error when checking operator: Could not find input field "TRAN_SEQ_NUM".
Error when checking operator: Could not find input field "ACCT_NUM".
Error when checking operator: Could not find input field "CTRY_CURR_CDE".
Error when checking operator: Could not find input field "LEVEL_RISK_CTRY_CURR_CDE".
Error when checking operator: Could not find input field "CUST_1_FULL_NAME".
Error when checking operator: Could not find input field "CUST_2_FULL_NAME".
Error when checking operator: Could not find input field "PROC_DT".
Error when checking operator: Could not find input field "TRAN_AMT".
Error when checking operator: Could not find input field "TRAN_DESC".
Error when checking operator: Could not find input field "TRAN_EFF_DT".
When i run the same job in Dev. env. every thing runs fine and the error occurs in prod. env. of a real time project. Also, the job used to work fine, rather this error popped out of nowhere.
I just want to know why the Metadata is not visible or else are there any special permissions on virtual datasets to funcion properly at runtime.
Any help is highly appreciated. I would also like the readers know that there are some NULL fields being exported into the sequential file, but i guess it has little to do with the error.