Post reply

Data Pump Job failed in SQL

  • September 7, 2012 at 12:26 pm

    #263943

    Hi All,

    When i am executing the job i am getting below error any idea.

    Message

    Executed as user: --------\SYSTEM. ...9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:09:02 AM Info: 2012-09-07 11:09:02.59 Code: 0x4004300A Source: S3 DTS.Pipeline Description: Validation phase is beginning. End Info Progress: 2012-09-07 11:09:02.59 Source: S3 Validating: 0% complete End Progress Progress: 2012-09-07 11:09:02.68 Source: S3 Validating: 33% complete End Progress Progress: 2012-09-07 11:09:02.70 Source: S3 Validating: 66% complete End Progress Progress: 2012-09-07 11:09:02.72 Source: S3 Validating: 100% complete End Progress Progress: 2012-09-07 11:09:03.00 Source: S0 Executing query "-- SETTING New IdLoad DECLARE @CurrentIdLoad INT ".: 100% complete End Progress Progress: 2012-09-07 11:09:03.01 Source: S1 Executing query "EXEC dbo.Update_vFactArchiveData".: 100% complete End Progress Progress: 2012-09-07 11:09... Process Exit Code 1. The step failed.

  • September 7, 2012 at 1:58 pm

    #1535275

    You're pulling the short form of the error message from the job history. Do you have step logging turned on? If so, go into the log file that the step is producing that it failed on and look there, it should have the full error tree you'll need to troubleshoot.

    If you don't, turn it on and run (and fail) again so you can nail it down.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • September 7, 2012 at 3:34 pm

    #1535311

    Is this a DTS job or is it an SSIS job?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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