Qlik Community

Ask a Question

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitk1609
Specialist III
Specialist III

Automatic Backup of Qlik Sense Repository Failed Randomly

Hi Techies,

I have Qlik Sense Sep 2018 SR2. I have created a batch file which has commands to

1.stop Qlik Sense services except repo

2.take repository backup and

3.start the Qlik Sense services.

Below are the commands in order:

net stop "Qlik Sense Engine Service"
net stop "Qlik Sense Printing Service"
net stop "Qlik Sense Proxy Service"
net stop "Qlik Sense Scheduler Service"
net stop "Qlik Sense Repository Service"
net stop "Qlik Sense Service Dispatcher"

 

set pgbin=D:\Program Files\Qlik\Repository\PostgreSQL\9.6\bin\

"%pgbin%pg_dump.exe" -h localhost -p 4432 -U postgres -b -F t -f "D:\QSR Backup\QSR_backup_%dtStamp%.tar" QSR

 

net start "Qlik Sense Engine Service"
net start "Qlik Sense Printing Service"
net start "Qlik Sense Proxy Service"
net start "Qlik Sense Repository Service"
net start "Qlik Sense Scheduler Service"
net start "Qlik Sense Service Dispatcher"

 

Then I created a window task as and below setting I have set into it:

Setting1.pngTriggerSetting.pngConditions.pngSettings.png

It was working fine when we had Feb 2018 version but since we moved to Sep 2018 it is not executing fine and No backup is getting generated and services are stopped randomly after automatically trigger.

Window task remains in running stage till it will be killed by set time like an hour.

Note: If we run the window task manually it runs fine and generate backup fine but automatically it fails.

Can you please help me to fix it ?

Thanks,

Rohit

 

 

Labels (1)
4 Replies
jonathandienst
Partner
Partner

Perhaps the restart order needs reviewing. I think the repository service needs to be first.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rohitk1609
Specialist III
Specialist III
Author

Thanks Jonty for quick reply. I have revised the start order of services start with repository services to rest. I will monitor it for few days and inform you.

 

Thanks,

Rohit

rohitk1609
Specialist III
Specialist III
Author

Hi Jonty,

My new order for stopping the service is:

net stop "Qlik Sense Engine Service"
net stop "Qlik Sense Printing Service"
net stop "Qlik Sense Proxy Service"
net stop "Qlik Sense Scheduler Service"
net stop "Qlik Sense Service Dispatcher"
net stop "Qlik Sense Repository Service"

and starting order is:

net start "Qlik Sense Repository Service"
net start "Qlik Sense Engine Service"
net start "Qlik Sense Printing Service"
net start "Qlik Sense Proxy Service"
net start "Qlik Sense Scheduler Service"
net start "Qlik Sense Service Dispatcher"

 

but still it fails by window schedule task, If i run it manually by opening TASK SCHEDULER=> right click=>run it works fine and created backup, problem is automatic trigger is not working.

 

Thanks,
Rohit

rohitk1609
Specialist III
Specialist III
Author

Hi Jonty,

Can you please add your input ?

 

Thanks,

Rohit