Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

james
Contributor III

Copy all jobs via xml?

All, is it possible to copy certain files into QVPR and have the jobs automatically re appera with all the triggers and dependancies?

We upgraded from SR2 to SR3 and lost all jobs. Without having to recreate the wheel, can I not copy over certain files and have it all back? I have the old folder saved off on another drive so I have access to all of the files. I just cannot seem to put the right "Puzzle" together for all of it to work

Any Ideas?

8 Replies
vgutkovsky
Honored Contributor II

Copy all jobs via xml?

James,

Why did upgrading to SR3 make you lose all your jobs?

I think this is possible. I've never tried it with ALL tasks, but since it definitely works with 1 task I don't see why not. Stop the Distribution, Management, and Publisher services. Here are the files that you will need to copy (replacing the files that are there):

  • C:\ProgramData\QlikTech\Publisher\CommandCenter\Workorders should contains 1 xml file. Don't replace it, but rather open it for editing and then copy the contents of the backup into the new one (so that the new name is preserved)
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\DistributionDetail.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\DocumentTask.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\ExternalProgramTask.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\Rule.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\SourceDocument.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\SourceDocumentFolderResource.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\TaskCategory.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\TaskDependency.xml
  • C:\ProgramData\QlikTech\Publisher\CommandCenter\QVPR\Trigger.xml
  • C:\ProgramData\QlikTech\Publisher\Qlikview Distribution Service\Workorder.xml
  • C:\ProgramData\QlikTech\Publisher\Qlikview Distribution Service\1\Workorder.xml


Once the files have been replaced, you can start the stopped services. I think that should do the trick. Let me know how it goes.

Regards,

james
Contributor III

Copy all jobs via xml?

I will test this out.. We lost the jobs cause we wanted to test out the ability to replace xml files. So basically it was a clean install. Thanks Vlad

james
Contributor III

Copy all jobs via xml?

No good, now I lost all source documents. I copied back all of the data in publisher and now Im back to where i was

vgutkovsky
Honored Contributor II

Copy all jobs via xml?

OK, stop your services again. I think the problem is the DistributionServiceID field in the following files:

  • DocumentTask.xml
  • ExternalProgramTask.xml
  • SourceDocument.xml
  • SourceDocumentFolderResource.xml


This field probably contains the old values, so you need to update it for each document. You can get the proper value from the DistributionService.xml file (the corresponding field in that file is called DSCID). I would also check the QVSResourceID field in DistributionDetail.xml and make sure you copy the proper value from QlikviewServerResource.xml. Finally, check the 3 workorder files and make sure no old resource IDs are there (I think there should not be any problem with these files, but you can never be too sure). Then start your services again.

Regards,

Not applicable

Re: Copy all jobs via xml?

Did this work?

james
Contributor III

Re: Copy all jobs via xml?

it didnt work from what I recall...

Not applicable

Re: Copy all jobs via xml?

Not for us either

gainkarthi
Valued Contributor

Re: Copy all jobs via xml?

If you have temp license, You can try copying the files using remote management services.

Regards,

Karthi

Community Browser