Sign in
 
HomeProductsLibraryLearnDownloadsSupportForums
Microsoft Forefront TechCenter >
> 
> 
MOM.Datawarehousing.DTSPackageGenerator.exe fails daily on schdule task and manual ones.

Proposed MOM.Datawarehousing.DTSPackageGenerator.exe fails daily on schdule task and manual ones.

  • Wednesday, May 13, 2009 6:05 PM
     
     
    Sign In to Vote
    0
    I have been receiving this error on our Forefront sever for a couple of months now. I have tried ever solution out on the web and nothing seems to help. I have run MOM.Datawarehousing.DTSPackageGenerator.exe /latency:XX many times and not really sure if this is working anymore. If someone has cracked the code on this, could you please help? I have posted my eventlog property on this error.

    Thanks in advance.




    Log Name:      Application
    Source:        MOM.Datawarehousing.DTSPackageGenerator.exe
    Date:          5/13/2009 1:49:21 PM
    Event ID:      1001
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      FOREFRONTWH01.polk.edu
    Description:
    Step StepInvokeInnerPackage failed.
    Step Error Source: Microsoft OLE DB Provider for SQL Server
    Step Error Description: (1:SC_Inner_DTS_Package) SubStep 'DTSStep_ExecuteSQLTask_SC_EventFact_View_1_Insert' failed with the following error:
    Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Execution was canceled by user.
    Step Error Code: -2147220441
    Step Error Help File:
    Step Error Help Context ID:0
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MOM.Datawarehousing.DTSPackageGenerator.exe" />
        <EventID Qualifiers="0">1001</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2009-05-13T17:49:21.000Z" />
        <EventRecordID>29605</EventRecordID>
        <Channel>Application</Channel>
        <Computer>FOREFRONTWH01.polk.edu</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Step StepInvokeInnerPackage failed.
    Step Error Source: Microsoft OLE DB Provider for SQL Server
    Step Error Description: (1:SC_Inner_DTS_Package) SubStep 'DTSStep_ExecuteSQLTask_SC_EventFact_View_1_Insert' failed with the following error:
    Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Execution was canceled by user.
    Step Error Code: -2147220441
    Step Error Help File:
    Step Error Help Context ID:0</Data>
      </EventData>
    </Event>
     

All Replies

  • Wednesday, May 27, 2009 9:48 AM
     
     
    Sign In to Vote
    0
    Hello,

    I have the same issue in our FCS environment. Did you get the issue already resolved?

    thanks,
     
  • Thursday, July 02, 2009 8:12 AM
     
     
    Sign In to Vote
    1
    Hello,

    I found the solution.

    Take a look on your scheduled task on your FCS Server, there is a different configuration between Windows Server 2003 and Windows Server 2008. On Windows Server 2008, you have to add the switch "/maxconn:5" at the end of your SystemCenterDTSPackageTask task.

    After you have added this switch, the 14 day history reports will work.

    br,
     
  • Wednesday, April 21, 2010 12:53 AM
     
     Proposed
    Sign In to Vote
    0

    Thanks mate.

    I have added the switch "/maxconn:5" and re-ran the scheduled task on the W2K8 Server and it's all good. No repeat errors and 14 day history now appears.

    The command is:  "C:\Program Files\Microsoft Forefront\Client Security\Server\Reporting\Reporting\MOM.Datawarehousing.DTSPackageGenerator.exe"

    Arguement is:  /silent /srcserver:SERVERNAME /srcdb:OnePoint /dwserver:SERVERNAME /dwdb:SystemCenterReporting /product:"Microsoft Operations Manager" /maxconn:5

     

    Thanks for the up, KRC