Post reply

Package fails to run on every friday

  • June 24, 2008 at 12:40 pm

    #189602

    Hi,

    I have an SSIS package that is scheduled to run everyday evening at 9pm. This package clears all the alert messages. It fails on every Friday and the error message is like :

    IDBinitialization::Initialization failed: The external request has been completed.

    Can anyone help me out what is causing this error? it runs fine all the other days...Thank you

  • June 24, 2008 at 12:56 pm

    #833555

    I don't know about anyone else, but I need just a little bit more info on the package. What step is it failing on, etc.

    However, w/o knowing anything else, the best place to start is on the server itself. What else is going on at the same time your package kicks off? Can you move the fri schedule up or down an hour? If you run it right after it fails does it complete?

    Basically, there has to be something else going on fri to make it fail consistently like that.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • June 25, 2008 at 12:23 am

    #833718

    Do you have package logging enabled?

    This will allow you to at least see where in the process it is failing.

    I would also take a Friday night off of drinking and sit there at the time it is scheduled to run to have a look at what other activity is occurring (but thats just pedantic old me)

    ~PD

  • June 25, 2008 at 3:55 am

    #833783

    Thanks a lot for the replies...we solved the issue....we have 1 more job on the same data....so we changed the times...

Viewing 4 posts - 1 through 3 (of 3 total)

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