????? ??????? ????? DTS ?????? ?????? ????? ????? ?????? ?? MOM 2005 ????????

?????? ????????? ?????? ?????????
???? ???????: 899158 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

????? ???? ?? ???? ?? ??????? ??????? ??? ????? "????? ???????? ????? ????????" ?? Microsoft "(MOM) ?? MOM 2005:
  • ?????? MOM ??? ???? ?? ??? ?????.
  • ??? ?????? ??? ??? ???????? ???????? ???? ?????? ??????? MOM ?? ????? ????? ????? ???????:
    ?? ???? ??? ?????? ?????? ???? ???????.
  • ????? ??? ????? ???????? OnePoint ???? ?????. ????? ??? ????? ???????? ??? ????? ?? ??? ???? ???? ?? ???? ?? ???????? ???? ??? ??????? ?? ????????? ??????? ?? ?????? ??????? MOM. ?? ????? ??? ????? ???????? OnePoint ???? ????????? 30 ???????? (GB).
  • ???? ??????? ??????? ?? ??? ??????? ??? "???? MOM ???????":

    ???? ????? ????
    ??????: MOM.Datawarehousing.DTSPackageGenerator.exe
    ???: ??? "???? DTS ???????" MOM ?????

    ????? ?????: 81
    ???? ?????: DataTransformationServices
    ???: ??? ????? ???? DTS ???????:

???? ????? ???? ????? ??? ????? ??? ??? ???? ????? ????? ???????? (DTS). ???? ????? 81 ???? ?????? ?? ???????? ??? ??? ???? ?????. ?? ???? ??? ?? ??????? ??? ????? ????? ??? ????? ??? ????? ????????. ????? ??? ????? ??? ????????? ??? ???:
  • ???? ????? ????? ????? 'SC_EventFact_Table' ?? ????? ???????? 'SystemCenterReporting' ???? ?????? filegroup 'PRIMARY'.
  • ??? ??? ????? ?????? 'SystemCenterReporting' ?????. ?? ????? ??? ??????? ?? ??? ????????? ?????? ???????? ?????? ??? ????? ?????.
  • ???? ????? ????? '(SYSTEM table id:-548802855) ?????? ' ?? ????? ???????? 'TEMPDB' ???? ?????? filegroup 'DEFAULT'.
????? ?? ??????? ????? ? MOM ???????? DTS ?????? ??? ????? ????? ? ????? ?????. ???? ??? ??????? ??? ??? ?????? ???? ???? ???????? ???????? ?? ????? ?????? OnePoint ??? ????? ?????? ????????.

?????

???? ?????? ????? ??? ?????? DTS ?? ???? ??? ?????? ??????? ?? ????? ?????? OnePoint ?????? ?????? "???? MOM ???????". ???? ??? ????? ???????? OnePoint ?????? grooming ?? ????? ????? ??? ??? ????? ???? DTS ?????.
?? ???? ???? DTS ??? ?????? ???????:
  • ????? ???? DTS ??? ?????? ?? ???????? ??? ????? ?????? ???? ??????? MOM.
  • ??? ????? ?????? ???? ??????? MOM ??????? ????? ??? ????? ?????? ???? ???.
  • ?? ????? ???? ?????? SystemCenterDTSPackageTask ?? "?????? ????????" ?????? ?? ????????.
????? ?????? "???? MOM ???????" ?? ??? ?? ???? ??????? ????? ??? ?????? ??? ?????? ?? ????? ???????? OnePoint ???? DTS. ?? ???? ??? ?????? ??? ??? ???? MOM ???? ?????? ?? ????????. ??? ???? ??????? ???? ??? ??????? ??? ???? ??? ?????? ???????:
  • ??? ?? ????? ???? MOM ????? ?????? ??? ????? ????? ???????? MOM.
  • ??? ????? ?????? ?? ??????? ??? ?????? ??????? MOM ?? ??? ?????.
  • ????? ????? ????? ?????? ??? ???? ?? ??????? ?? ???? ????? ?? ?????? ??????.
  • ????? ??? ????? ????? ?????? ?? ??????? ???????.
  • ?? ????? ????? MOM 2005 Reorting ?? ??? ???? ?????? Service Pack 1 (SP1).

????

??? ??? ???????? ?? ?????? ??? ????? ???????? SystemCenterReporting ???? SystemCenterReporting. ?????? ????? ???? ??????? ??????? ??? "???? MOM ???????":
  1. ???? ??? ???? ???? ??? ???? ???????? ???? ??? Microsoft SQL Server ? ?? ???? ??? ????? ???????.
  2. ?? ?????? Microsoft SQL Servers \ ?????? ?????? SQL \ SQL Instance \ ????? ????? ??????.

    ?????? SQL Instance ?? ???? ??????? ???? ????? ??? ????? ?????? ???? ??????? MOM.
  3. ???? ??? ?????? ?????? ??? SystemCenterReporting ??? ?? ???? ??? ?????.
  4. ??? ????? ??????? "????? ????????" ? ???? ??? ???? ??????? ??????? (MB) ?? ?? ???? ??? ??? ????.
  5. ?? ??????? ????? ????????? ???? ??? ???? ??????? ??????? (MB) ?? ?? ???? ??? ??? ????.
  6. ???? ??? ????? ????? ?????????.
  7. ???? ?? ??? ????? Tempdb ???? ????? ?????. ????? Tempdb ???? ??????? ?????????? ???????. Tempdb ???? ???????? ????? ?????? ??? ????? ???????? ?????? ?????????. ??? Tempdb ???? ????? ? ???? ??? ?? ??? SQLERROR. ????? ??? ????? "????? ??????" ?? ???? "??? ?????????" ???????? ????? ??? ????? ?? ???? ?????? ??????? ???????? ????? ??????? ?? SQL ???????? ??????.
    ???? ?? ???? ????? ????? ??? ????? ?????? ??? ???? ??????? ??????? ??? ??? ????? Tempdb. ??? Tempdb ??? ???? ??????? ??????? ???? ??? ??? ?????.
??? ????? ??? ????? ???????? SystemCenterReporting ? ????? SystemCenterReporting ?? Tempdb ????? ???? DTS ?????? ??? ????. ??? ?????? ???? ???????? ?? ????? ?????? OnePoint ??? ????? ???????? SystemCenterReporting. ?????? ???? DTS ??????, ???? ??? ???????.

???? ?? ????? ???? ?????? SystemCenterDTSPackageTask ?? "?????? ????????" ???? ??????? ????????. ??? ??? ????? ????? ????? ??? ??????? ??????.
  1. ??????? "?????? Windows" ?????? ??? MOM reporting drive: ?????? Reporting\Reporting ???? ?????? \Program Files\Microsoft.
  2. ???? ????? ??????? ??? ????? MOM.Datawarehouse.DTSPackageGenerator.exe.
?????? ???? ????? ?????? ???????? SystemCenterDTSPackageTask ?????? ?? "?????? ????????" ?? ???? ?????? ".

??????? ????

??? ????? ???? ?? ???????? ???????? ??? ??????? /latency ?? ????? /chunksize

?? ???????? ??? ???????? ?? ??? ???? ??? ??? ???? ???? ????? ?? ???????? ???? ?? ??? ?????. ????? ??? ?? ???? ??????? ?? SQL Server. ??? ???? ????? ???? ??? ?????? ?? ??????? ??? ??????? ???? ????? ??????? SQL Server.

????? /latency

????? ??? MOM.Datawarehouse.DTSPackageGenerator.exe ????? ??? ?????? ???? ???? ?? ?????? ??? ???????? ???? ??? ????? ???????? SystemCenterReporting. ????? ??????? ??????? ??? ?????? ?????? ??? ????? ???????? ??? ????? ?????? SystemCenterReporting. ?????? ??????? ?????? ???? ?????? ??????:
/latency MOM.Datawarehousing.DTSPackageGenerator.exe: number of days
?? ???????? ??????? ??????? ??? ?????? ?? ???? ??? ???? DTS ???? ?? ????? ?? ????? ????.

??????? ??? ??? ??? ???? DTS ????? ?????? ??? ???? ReportingSettings ?? ????? ?????? OnePoint ????? TimeDTSLastRan. ??? ??? ??? ??????? ??????? (?????? ??????? ?????).

?? ??? ??????? ?? ??? ????? ???? DTS ?? 30 ?????. ????? ????? ??????? ??? ??????? ?????? ?? ???? 20 ?? ????? ?????? ????? ???? ???????? ???? ???? ?? 20 ????? ??? ????? ?????? ???????? MOM. ??? ?? ????? ??????? ???? ??? ????? ?????? of10 ???? ????? ?? ??? ???? ?? 10 ????. ????? ??? ??? ?? ????? ?????? / ??? ?????? ??????? ?? MOM.Datawarehousing.DTSPackageGenerator.exe ????? ???????? ????????. ?? ???? ?????? ????? ???? ??? ???????? ??? ????? ??????.

?????? ????? ??? ?????? ?? ????? ???? 30 ????? ?????? ?? ????? ?????? OnePoint.
  1. ?? ?????? ?????? ??? ???? MOM ??????? ???????? ???? ?? ???? ??????.
  2. ???? ??? ???? ?? ???? ??? ????? ????? cmd ?? ???? ??? ?????.
  3. ?? ???? ??????? ??? ?????? ??? ??????? SystemCenterDTSPackageTask ??? / ??? ??????: 20 ? ?? ???? ENTER.

    ???? ? 20 ? ?????? 20 ?? ??? ??????.
  4. ??? ?????? 3 ???????? timeframes ?????? ????.
  5. ????? / ??? ?????? ??????? ??? ??? ?? ????? ??????. ??????? ??? ?????? ????????? 5 ?????. ?? ??? ???????? ???? ???????? ???? ???? ?? ??? ????? ???? ?? ?????.
?????? ??? ??? ??? ???? ???? ???????? ??? "???? ???????" ??? ????? ??????? ??? ?????? ?? ???? ??????.

????? /chunksize

????? ??? ???? ??? ?????? ?? MOM 2005 ?????? ????? ?????? SP1 ????????? ??? ????? ???? DTS ?? ??? ???????:
  • /chunksize: chunk ??? ???????. ???? ??? ?????? ??????? ????? ???????? ?? ??? ????????. ????? ??? ???????? ??????? ????? ?? ????? ????? ??????. ??? ????? ???? 0 (???) ??? ??? ?? chunk ????????. (????????? = 1 ???).
  • /maxchunks: ???? ?????? ???? ??? ?????? ??? ????? chunking. (????????? = ??? 10).

?? ???? ??? ???? DTS ????? ??? ??????

???? DTS ?? ?? ???? ??? ?????? ??? ??? ???? ???? ???????? ???? ???? ????? ???? ????.

?? ????? ?? ????? ??????? 1001 ?? ????? 81 ?? ????? ????? DTS ????? ??? ??????? / ?????? ????? ????? ??? ?????? ??????? ???????:
????? ?????? ??????.
????? ???? ?????? ??? ????? ??????? ?? ?? ?????? ?? ??????.
????? ????? ?? ??? ?????? ???? ?????? ??? ?? ??????
??? ??? ?? ???? ???????? ?? ????? ??????? 81 ??? ??? ??? ??? ????? ???????? ?? ?????? ?????? ???? ? ??? ??? ?????? ???? ?????? ?? ??????? ?? ????? ?? ??????. ?????? ?????? ???? ????? ???????:
  • ?? ?????? ???? DTS ??? ????.
  • ?? ???? ??? ???? ???? DTS ????? ???? ?????? ?????????.

???? ???? ????? ???? ????????? ?????? ?? ????????? 600 ?? 1200 ????? ?? ???? ?? ??? ?? ?????? ????? ???? ????????? ?????? ??? 0 (??? ??????) ?????? ?? ??? ??? ??? ???? ?????? ??????. ?????? ???? ????????? ?????? ???? ??????? ???????:

?????? ??? ?? ??? ????? ???? ???? ????????? ?????? ??? ?? ?? SQL Server ???? ?????? ????? ?????? ???????? SQL Server ???? ?????? ????? ?????? OnePoint.
  1. ??? ??? ????? ??????? ? ???? ??? ?????? ?????? ??? ????? ???????? "????????" ???? SQL ??? ?? ???? ??? ????? ? ??????? ?????????.
  2. ?? ?????? "????? ???? SQL" ? ???? ??? ????? ??????? ?????????.
  3. ?? ?????? ??????? ?????? ?????? ? ???? 1200 ?? ?????? ???? ???? ?????????.
  4. ??? ??????? ?? 1 ??? 3 ??? ????? ?????? OnePoint SQL Server.
  5. ??? ???? DTS.
    ?????????
    • ?? ???? ???? DTS ?? ???? ???? ? ??? ??????? ?? 1 ??? 6. ??? ???? ?????? ??????? ?? ?????? 3 ??? 2400 3600 ?? 0.
    • ??? ?? ??????? ????? ????? ???? ???? ????????? ??? 600 ?? ?? ???? ?????? ?????? ??????? ?????? ?????.
?? ????? ??? ???? ????? ???? ??????? ?????? ??? ???: ???
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_SampledNumericDataFact_View_1_Insert' failed with the following error: OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached. (Microsoft OLE DB Provider for SQL Server (80040e14): OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].) (Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider returned message: Timeout expired]) Execution was canceled by user. Step Error Code: -2147220441 Step Error Help File: Step Error Help Context ID:0

??????? ?????? ??? ??????? ??????? ????????

  • ?????? ????? "???????" ? "??????" ??? ???? SQL ??? ??? ????? ?????? DTS.
  • ???? ????? SQL Server ??? ???? SQL ??? ??? ????? ?????? DTS.
  • ???? ?? ????? ????? ???????? OnePoint ???? SystemCenterReporting ??? ??? ????????? ?????. ??? ????? ??? ?? ????? ??????? ?????? ????? ????? ????????.
  • ?????? ??? ??????? ??????? ????? ??????? ?? ???????? ? ??? ??? ??????? DTS ?? ?????? ???????? ??? ???? ???????.

    ??? ???? ??????? /silent Reporting\Reporting>MOM.Datawarehousing.DTSPackageGenerator.exe ???? ?????? Files\Microsoft C:\Program /product /dwdb:SystemCenterReporting /dwserver:servername /srcdb:OnePoint /srcserver:servername: "????? ???????? Microsoft"

    ????? /silent ???????. ????? ????? ?? ???? ???????. ???? ??? ?????? ???? ??????? ????? ??????? ??? ??????. ???? ??? ??? ??? ??? ????? ?? ????????.
    ????? ???? DTS ??? ??? ?? ????? ???? ??? ???? ?????.

    ??? ??? ?? ???? ?????? ?? ????? ????? ????????

    ??? ???? ????? ?????? SystemCenterReporting ?? ??? ???? ??????? ??????? ??????? ? ??? ???? ????? ?????? ?? ????? ????? ?? ????? ?????? grooming ?????? ?????? ?????? ??? ????? ????? ???? ????? ????. ???? ???????? ???? ???????? ???????? ?? ????? ???????? SystemCenterReporting ???? 395. ??? ????? ???? ????? ???????? 2005 MOM ??? ????? p_updategroomdays ????? ???? ?? ????? ?????? SystemCenterReporting. ????? ??????? ??? ??????? ?????? ?????? ??? ?????? ???? ??? ???????? ???????? ?? ????? ?????? SystemCenterReporting. ????? ?? ????????? ??? ????? ????? ?????? ?????? grooming ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    887016????? ????? ??? ?????? ???? ????? ???????? ?? ????? ???????? SystemCenterReporting ?? Microsoft 2005 ????? ????????
????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
873235????? ????? ??? ????????? ?? ????? ?????? SQL Server ?? ????? ??? ???? ??? ?????
317375??? ??????? ????? ??? ???? ??? ????? ?? ??????? ??? ???? ??????? ???? ????? ??????? SQL Server

???????

???? ???????: 899158 - ????? ??? ??????: 19/?? ?????/1427 - ??????: 9.0
????? ???
  • Microsoft Operations Manager 2005 Enterprise Edition
????? ??????: 
kbmt kbopmanreporting kbopmaneventmgmt kbopmanalerts kbtshoot kbdatabase kberrmsg kbevent KB899158 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????899158

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com