SQL Job Microsoft Forefront Client Security fails

• sábado, 13 de outubro de 2007 02:36

   

   
  

  0

  the DTSrun job is failing

  SQL Server Scheduled Job 'Microsoft Forefront Client Security' (0x00CDA1DA6B519346AF3397A0CB4030A0) - Status: Failed - Invoked on: 2007-10-12 21:30:04 - Message: The job failed. The Job was invoked by User <account details>. The last step to run was step 1 (Microsoft Forefront Client Security).

   

  the prior message is:

  The description for Event ID ( 81 ) in Source ( DataTransformationServices ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:

  Error Source: Microsoft Data Transformation Services (DTS) Package

  Error Descriptionackage failed because Step 'DTSStep_DTSTransferObjectsTask_1' failed.

  Error code: 80040428

  \Error Help Fileqldts80.hlp

  Error Help Context ID:700

   

  Package Name: Microsoft Forefront Client Security

  Package Description: Microsoft Forefront Client Security DTS

  Package ID: {4589F8C7-17D3-4A87-BB5B-0DBF47B6D00A}

  Package Version: {EC964566-0311-4BDB-BA92-D5643AC65656}

  Package Execution Lineage: {15A8994C-9346-4241-B62C-1D3C93069D15}

  Executed On: <HOST>

  Executed By: NETWORK SERVICE

  Execution Started: 10/12/2007 9:30:07 PM

  Execution Completed: 10/12/2007 9:30:08 PM

  Total Execution Time: 1.672 seconds

  Package Steps execution information:

   

  Step 'DTSStep_DTSTransferObjectsTask_1' failed

  Step Error Source: Microsoft Data Transformation Services (DTS) Package

  Step Error Description:Invalid OLEVERB structure

  (Microsoft Data Transformation Services (DTS) Package (80040000): Invalid OLEVERB structure

  ) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on '<host>.OnePoint.LOG'. )

  Step Error code: 80040000

  Step Error Help Fileqldts80.hlp

  Step Error Help Context ID:1100

  Step Execution Started: 10/12/2007 9:30:08 PM

  Step Execution Completed: 10/12/2007 9:30:08 PM

  Total Step Execution Time: 0.703 seconds

  Progress count in Step: 0

  Step 'DTSStep_DTSTransferObjectsTask_3' was not executed

  Step 'DTSStep_DTSExecuteSQLTask_1' was not executed

  Step 'DTSStep_DTSDynamicPropertiesTask_1' succeeded

  Step Execution Started: 10/12/2007 9:30:07 PM

  Step Execution Completed: 10/12/2007 9:30:07 PM

  Total Step Execution Time: 0.094 seconds

  Progress count in Step: 0

  Step 'DTSStep_DTSExecuteSQLTask_2' succeeded

  Step Execution Started: 10/12/2007 9:30:07 PM

  Step Execution Completed: 10/12/2007 9:30:08 PM

  Total Step Execution Time: 0.766 seconds

  Progress count in Step: 0