connect failed for env:in PX job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

connect failed for env:in PX job

Post by satheesh_color »

Hi All,

Today we have a strange problem while running the parallel job....These jobs was almost runs from one year, today it aborts and throws the following error:in the middle of the job execution:

Export complete. 1147082 records exported successfully, 0 rejected.
ETLRecItemSubCatOra: connect failed for env: null, user: ETLUSER, password: *****
Oracle error: -28000
ORA-28000: the account is locked

ETLRecItemSubCatOra: APT_OraWriteSubOperator: connect failed.
ETLRecItemSubCatOra: Unable to connect to Oracle.
main_program: Step execution finished with status = OK.
main_program: Startup Time 0:11 Production Run Time 49:56
Parallel job reports successful completion

Please help me on this issue..

Thanks,
Satheesh.R
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Check with your DBA. DBA has locked this oracle account.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply