Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
RaviGinqo
Partner
Partner

Applying SLK in QlikView Management Console clears the QlikView Tasks

Hello Everyone,

We all know that Qlik introduced Subscription based license, Many Clients may already been using it and many are in process of Migrating to the new License Model. With this Qlik gives package for bunch of Qlik products and for Some Clients who have not used QlikView Publisher earlier , that would be available for use when they get into subscription license. So Upon Applying SLK it would Activate Publisher 

In this post, I would like to explain the steps I followed to Resolve below problems I faced.

Problem:

You are Activating Publisher in Qlik Deployment.

I came across the unique problem for a customer : when we apply  the Signed License Key to Existing Qlik Deployment,  which was single node with Default Qlik Reload Engine - After Applying the SLK Qlik Tasks would be cleared out.

Alternatively the Problem could be when User have Qlik Installation with Reload Engine and then after purchasing new license /Publisher license they want to migrate all their tasks from Reload Engine to New Publisher Server.

 

Resolution:

If you have lesser number of tasks (20-30) and without complex dependency/Schedules/Triggers you may create all tasks manually and avoid below hassle.

First of all, Take all the necessary backups for Existing Qlik Installation before proceeding with following steps. 

Also it is advised to execute these steps in TEST environment before performing them into your production environment. You may need to adapt to these steps according to your environment configuration.

For Convenience Below steps are tested with Singe Node QlikView Installation only.

  1. Take VM Backup of existing Qlik Node
  2. Take Backup of QVPR Files  Default Location: %ProgramData%QlikTech\ManagementService\QVPR
  3. Apply The Signed License Key / Apply the Publisher License 
  4.  After Applying the Publisher/SLK, You will observe that all Qlik Tasks will be cleared out and not available 
  5. You will also observe that New Sections of QMC  - Distribution Service will be enabled. 

Now Restore Tasks from the Backup

  1. Stop QlikView Management Service (QMS)
  2. Stop QlikView Distribution Service  (QDS)
  3. Restore Following 5 XML files from your Previous QVPR Backup.
    1. DocumentTask.xml - Contains each Individual Task Attributes such as name, trigger etc.
    2. SourceDocument.xml - Contains Tasks Mapping with folder ID and Task ID
    3. TaskCategory.xml - Category Information
    4. TaskDependency.xml - Any Dependency between tasks
    5. Trigger.xml - Contains Trigger Information
    6. RaviGinqo_0-1636582255450.png

       

    7. Note:  Another File is SourceDocumentFolderResource.xml -- It contains Folder Path, Type and ID which is used for Mapping tasks and their subsequent Triggers and other Details
  4. Start QMC, QDS Service

From here You may see that Tasks are Visible Back Again. 

Verify under Documents folder Go to Source Documents Tab check the Folders, and Tasks is associated with Appropriate QVW file.

If you are migrating tasks to another publisher  - Update the new publisher server under Systems > Distribution Service.

And Restarts QDS on new Publisher server and Disable QDS on Existing server. You may loose task history along the way.

Another Scenario: Tasks are created with QVW in subfolders.

Important Note: 

Publisher Service Does not traverse through all the sub folders, so you may need to map multiple folders in QMC.

When you add folders under Distribution service they are generated with new ID , and That Folder ID is very crucial to map the tasks

 

So, If you  have Complex Sub Folders Structure You would need to have additional changes after above steps because tasks would be visible but as orphan. It is good if you have simplified Folder Structure :

Source Documents - Folder which contains your QVW files and Reload Tasks are associated with it

User Documents - Folder which contains your QVW files consumed by users through Access point or other means

 

  1. Add Source Folder (s) where QVW files are located directly (Source Documents)
  2. As you added new Source Folder, you will see new Source Folder located under Documents ->  Source Documents tab, but no tasks are visible because they are not mapped correctly.
  3. After Adding new Folder locations you can modify some of above copied XML files to reflect actual mapping
  4. Stop QDS, QMS Service
  5. Use Notepad ++ to find/replace  - Open SourceDocumentFolderResource.xml and SourceDocument.xml
  6. Take ID (Source Documents Folder ID) from SourceDocumentFolderResource.xml  for Corresponding folder and Update the same FolderID for Tasks associated with that folder/QVW Files in SourceDocument.xmlRaviGinqo_1-1636582275302.png

     

  7. You may also need to update Task name with QVW File name e.g. Instead of folder1\folder2\Sample.qvw -> sample.qvw (See Image above)
  8. Repeat Steps 5 to 7 for all the other folders that needs to be configured
  9. After all the steps completed, Please Start QDS and QMS service
  10. Verify that Restart of Qlik Services is smooth
  11. Verify Qlik Tasks and Their Execution  (You may further need to modify the Task configuration e.g. Reduce -SourceDocument file name, Distribution etc. )

 

Also Look at this article and Video help for Migrating reloads Tasks from One  to Another Publisher node.

https://community.qlik.com/t5/Knowledge/Worry-Free-Migration-for-QlikView-Server-Publisher/ta-p/1713... 

 

Hope these helps everyone!!

Thank you

Ravi

QlikView  #Publisher 

Labels (3)
0 Replies