Post reply

Runnig one job daily and it is failing every single day

  • January 22, 2008 at 9:05 am

    #185950

    Hello,

    We run this job everyday, and it is not running successfully, below is the error message I am getting,

    The job failed. The Job was invoked by Schedule 42 (DTS_WAYBILL_FROM_AS400_TO_ICSTNTX). The last step to run was step 1 (DTS_WAYBILL_FROM_AS400_TO_ICSTNTX). NOTE: Failed to notify 'HELPDESK' via email.

    I would appreciate if someone can assist me on this,

    Thanks,

    Dev

  • January 22, 2008 at 9:22 am

    #770507

    Is that the only message you see when you look at job history? I'll guess that it's running an import from AS400. Is that a DTS or SSIS package? If you don't have logging enabled for the package, do so and see what errors are reported there.

    Greg

  • January 22, 2008 at 9:24 am

    #770509

    It is DTS package

  • January 22, 2008 at 9:27 am

    #770514

    Have you tried running the package by hand?

    Also - the error is having an error itself, since there seems to be something wrong with the "helpdesk" e-mail recipient as well (or - SMTP is FUBAR, etc...)

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 22, 2008 at 9:34 am

    #770521

    the detail error message is as,

    Executed as user: ICS\sqlsrvr. ...n OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 7000 Rows have been transformed or copied.; Perc... Process Exit Code 1. The step failed.

  • January 22, 2008 at 9:52 am

    #770533

    So - somewhere between row 7000 and row 8000 is some issue in the data (different format, something it doesn't expect, something violating the data types, etc...). You will need to look at that data in the file to see why it is choking.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 22, 2008 at 12:02 pm

    #770600

    Thanks Guys I will try,

    Dev

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply