Tuesday, March 6, 2012

2005 Update Statistics Task fails

Hi,
Can anyone, given the history below, tell me why this task fails? Or could
you tell me how to figure out why the task fails?
Thanks,
Jim
Windows Server 2003 SP2
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
---
Date 9/10/2007 9:58:00 AM
Log Job History (User Maintenance.Update Statistics)
Step ID 1
Server GENOME-GENDB
Job Name User Maintenance.Update Statistics
Step Name Update Statistics
Duration 00:03:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00 for
64-bit Copyright (C) Microsoft Corp 1984-2005.
All rights reserved.
Started: 9:58:00 AM
Progress: 2007-09-10 09:58:00.59
Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete
End Progress
Progress: 2007-09-10 10:00:10.27
Source: Update Statistics Task
Executing query "use [blast_xml] ".: 12% complete
End Progress
Progress: 2007-09-10 10:00:10.33
Source: Update Statistics Task
Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".: 25%
complete
End Progress
Progress: 2007-09-10 10:00:10.33
Source: Update Statistics Task
Executing query "use [blast_xml] ".: 37% complete
End Progress
Progress: 2007-09-10 10:00:10.44
Source: Update Statistics Task
Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".: 50%
complete
End Progress
Progres... The package execution fa... The step failed.I would create a text file for the log for more details, instead of just
relying on the job history.
You can also execute the SSIS package while in the designer window and watch
which step fails in the debug mode.
"Jim" <noreply@.noreply.com> wrote in message
news:eEJ35X88HHA.4752@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Can anyone, given the history below, tell me why this task fails? Or
> could you tell me how to figure out why the task fails?
> Thanks,
> Jim
> Windows Server 2003 SP2
> Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> ---
> Date 9/10/2007 9:58:00 AM
> Log Job History (User Maintenance.Update Statistics)
> Step ID 1
> Server GENOME-GENDB
> Job Name User Maintenance.Update Statistics
> Step Name Update Statistics
> Duration 00:03:00
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
> Message
> Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00 for
> 64-bit Copyright (C) Microsoft Corp 1984-2005.
> All rights reserved.
> Started: 9:58:00 AM
> Progress: 2007-09-10 09:58:00.59
> Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete
> End Progress
> Progress: 2007-09-10 10:00:10.27
> Source: Update Statistics Task
> Executing query "use [blast_xml] ".: 12% complete
> End Progress
> Progress: 2007-09-10 10:00:10.33
> Source: Update Statistics Task
> Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".: 25%
> complete
> End Progress
> Progress: 2007-09-10 10:00:10.33
> Source: Update Statistics Task
> Executing query "use [blast_xml] ".: 37% complete
> End Progress
> Progress: 2007-09-10 10:00:10.44
> Source: Update Statistics Task
> Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".: 50%
> complete
> End Progress
> Progres... The package execution fa... The step failed.
>|||Thank you, YPD. I will keep this in mind when I return to troubleshooting
that situation.
"YPD" <y.ding@.neu.edu> wrote in message
news:286E5C59-EE3E-4263-96C1-D51E7461915A@.microsoft.com...
>I would create a text file for the log for more details, instead of just
>relying on the job history.
> You can also execute the SSIS package while in the designer window and
> watch which step fails in the debug mode.
>
> "Jim" <noreply@.noreply.com> wrote in message
> news:eEJ35X88HHA.4752@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> Can anyone, given the history below, tell me why this task fails? Or
>> could you tell me how to figure out why the task fails?
>> Thanks,
>> Jim
>> Windows Server 2003 SP2
>> Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
>> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
>> on Windows NT 5.2 (Build 3790: Service Pack 2)
>> ---
>> Date 9/10/2007 9:58:00 AM
>> Log Job History (User Maintenance.Update Statistics)
>> Step ID 1
>> Server GENOME-GENDB
>> Job Name User Maintenance.Update Statistics
>> Step Name Update Statistics
>> Duration 00:03:00
>> Sql Severity 0
>> Sql Message ID 0
>> Operator Emailed
>> Operator Net sent
>> Operator Paged
>> Retries Attempted 0
>> Message
>> Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00
>> for 64-bit Copyright (C) Microsoft Corp 1984-2005.
>> All rights reserved.
>> Started: 9:58:00 AM
>> Progress: 2007-09-10 09:58:00.59
>> Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
>> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
>> 100% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.27
>> Source: Update Statistics Task
>> Executing query "use [blast_xml] ".: 12% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.33
>> Source: Update Statistics Task
>> Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".:
>> 25% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.33
>> Source: Update Statistics Task
>> Executing query "use [blast_xml] ".: 37% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.44
>> Source: Update Statistics Task
>> Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".:
>> 50% complete
>> End Progress
>> Progres... The package execution fa... The step failed.
>>
>

No comments:

Post a Comment