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\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.
OK, stop your services again. I think the problem is the DistributionServiceID field in the following files:
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.