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.
Metadata not found
Moderators: chulett, rschirm, roy
Just to confirm - by saying the "same job" you mean one that was exported and reimported by yourself so that there is no chance of a mistake? Are DEV and PROD the same version with the same configuration files?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Yes, it is the same job. The one exported and imported from prod to dev. The config file is also the same.
Only the user id used to run the job and connection parameters to database are different in both the evnvironments.
And as i said, it used to work fine until yesterday.
And also the above errors occur at the initialisation step , i e i mean no data has been read from the input source to be skeptical about the input nature of data.
Only the user id used to run the job and connection parameters to database are different in both the evnvironments.
And as i said, it used to work fine until yesterday.
And also the above errors occur at the initialisation step , i e i mean no data has been read from the input source to be skeptical about the input nature of data.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I seem to remember that much of the error message is printed out when you have bad userid/password/database parameters.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>