Page 1 of 1

Error 904 Occured

Posted: Tue Dec 28, 2004 12:08 pm
by Aswini
We are implementing the Peoplesoft Warehouse module, We are working on the ETL jobs deleivered by Accential, One of the job fails and it comes back with this error message,

From previous run
DataStage Job 2002 Phantom 20571
jobnotify: Error 904 occurred.
DataStage Phantom Finished.
[741508] Done : DSD.StageRun FDM84_88_BUS_UNIT_TBL_PM. FDM84_88_BUS_UNIT_TBL_PM.exp_LASTUPDDTTM_RUN_HST 1 0/0
[737516] DSD.StageRun FDM84_88_BUS_UNIT_TBL_PM. FDM84_88_BUS_UNIT_TBL_PM.exp_EMPTY_STRING_FDM 1 0/0 - terminated.

Thanks
ash

Posted: Tue Dec 28, 2004 3:15 pm
by ray.wurlod
Welcome aboard! :D

There's not really much information here. Were there any other warnings in the log for this job? What I can see is that you have a job with two Transformer stages, and the one called FDM84_88_BUS_UNIT_TBL_PM.exp_EMPTY_STRING_FDM had a problem.

But without other error messages, this is quite difficult to diagnose further.

Posted: Tue Dec 28, 2004 3:56 pm
by dsrules
Ray I use your greeting :D , hope its not copyrighted. :P
I just welcomed a guy, but guess he needs more information.

Posted: Tue Dec 28, 2004 4:06 pm
by Aswini
thanks a lot for the welcome.
I am not able to get anything, this is the info i got after resetting the job, please let me know if there is a palce i should look for.......right now this is the error log, please review the attachment.


Posted: Wed Dec 29, 2004 8:57 am
by kiran_kom
Aswini wrote:thanks a lot for the welcome.
I am not able to get anything, this is the info i got after resetting the job, please let me know if there is a palce i should look for.......right now this is the error log, please review the attachment.
Which job is it?

Posted: Wed Dec 29, 2004 9:03 am
by Aswini
It is the FDM84_88_BUS_UNIT_TBL_PM