SQL Server Management Data Warehouse.

Posted on 2013-10-03
Medium Priority
Last Modified: 2016-02-11
In out environment we have five jobs that runs every 15 min to upload connected data and  one of the job 'collection_set_3_upload' is failing since we failover mirrored databse to another server. The reason behind job failure is that the database being in recovery mode and the process could not access the database to collect data to upload.

1. Collection_set_1_noncached_collect_and_upload
2. Collection_set_2_collection
3. Collection_set_2_upload
4. Collection_set_3_collection
5. Collection_set_3_upload

Can someone explain me exactly what is the main purpose of these jobs? How would I troubleshoot the job to stop failing?

Error Message:
Executed as user: DS\S-SQLService. SSIS error. Component name: DFT - Find and save plan text, Code: -1071636471, Subcomponent: LKUP - Look up query plans on target server [1283], Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14.   An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "The database "Cat" cannot be opened. It is acting as a mirror database.".   .  SSIS error. Component name: DFT - Find and save plan text, Code: -1071611309, Subcomponent: LKUP - Look up query plans on target server [1283], Description: OLE DB error occurred while fetching parameterized rowset. Check SQLCommand and SqlCommandParam properties.   .  SSIS error. Component name: DFT - Find and save plan text, Code: -1073450974, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "LKUP - Look up query plans on target server" (1283) failed with error code 0xC0208253 while processing input "Lookup Input" (1284). 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.
Question by:angel7170
1 Comment
LVL 21

Accepted Solution

Jason Yousef, MS earned 800 total points
ID: 39544020
You can read all about these jobs here...


Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question