January 12, 2016 at 1:44 am
Hi, I have a problem with one server and the default data collection job failing.
If someone could help that would be great!
collection_set_3_upload job is failing on step 2.
Message
Executed as user: RES-AD\SQLAgent. SSIS error. Component name: DFT - Upload collection snapshot, Code: -1071636471, Subcomponent: ODS - Upload snapshots into active_sessions_and_requests table [11], Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_active_sessions_and_requests'. Cannot insert duplicate key in object 'snapshots.active_sessions_and_requests'. The duplicate key value is (380133, 2015-10-25 02:45:27.3930000 +02:00, 1).". . SSIS error. Component name: DFT - Upload collection snapshot, Code: -1073450974, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ODS - Upload snapshots into active_sessions_and_requests table" (11) failed with error code 0xC0202009 while processing input "OLE DB Destination Input" (24). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. .The master package exited with error, previous error messages should explain the cause. Process Exit Code 5. The step failed.
January 12, 2016 at 2:49 am
Solve!
Delete the oldest days files in cache directory and wait for job to run again.
It's works!
😀
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply