We have a job that is failing from the past couple of days. In the first run I am getting the following error:
Code: Select all
J_Fact_PS_F_CI_BILLING_FAR..HASH_PS_D_BUSINESS_UNIT_1.DRS_PS_D_BUSINESS_UNIT_in: WriteHash() - Write failed for record id '03687
GL
NAFTA'
Code: Select all
J_Fact_PS_F_CI_BILLING_FAR..DRS_PS_CI_FAR_BIL_LKP: Using NLS map MS1252
J_Fact_PS_F_CI_BILLING_FAR..DRS_PS_CI_FAR_BIL_LKP: Client Library property required for stage J_Fact_PS_F_CI_BILLING_FAR.DRS_PS_CI_FAR_BIL_LKP
Attempting to Cleanup after ABORT raised in stage J_Fact_PS_F_CI_BILLING_FAR..DRS_PS_CI_FAR_BIL_LKP
When I imported the job from another environment and when I restarted the DataStage services, the job ran fine for a couple of runs.
But again the sequence of errors got repeated again.
Also FYI the same job is running fine in another environment with the same data.
Please help me. Thanks in advance for the reply.
Thanks,
Pavan.