SQL Server Management Data Warehouse.

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.
angel7170Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason Yousef, MSSr. BI  DeveloperCommented:
Hi,
You can read all about these jobs here...

http://technet.microsoft.com/en-us/library/dd939169(v=sql.100).aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.