This article talks about how to restore app with the same app ID if app gets deleted unfortunately by someone.
There are many ways to restore an app with same app ID:
- Restore the VM image of Qlik central server where the QVFs are stored.
- Find out the app ID of the deleted app.
- Copy the deleted app ID “file” and “.lock” files into physical location path (F:QlikSense\apps) and replace with the ID which gets deleted.
- Open PostgreSQL editor on central node.
- How to connect to PostgreSQL DB – follow the 2nd step here
- Create the app in PostgreSQL DB by running below query with the help of any existing app id
Insert into PUBLIC."Apps"(
"ID", "Name", "AppId", "PublishTime", "Published", "Description", "LastReloadTime", "Thumbnail", "CreatedDate", "ModifiedDate", "ModifiedByUserName", "Owner_ID", "Stream_ID", "SavedInProductVersion", "MigrationHash", "DynamicColor", "SourceAppId", "TargetAppId"
) Select 'Deleted APP ID’,"Name", "AppId", "PublishTime", "Published", "Description", "LastReloadTime", "Thumbnail", "CreatedDate", "ModifiedDate", "ModifiedByUserName", "Owner_ID", "Stream_ID", "SavedInProductVersion", "MigrationHash", "DynamicColor", "SourceAppId", "TargetAppId"
from public."Apps"
where "ID"='any existing app ID’ // existing app
above query will create the deleted app on QMC
- Check the app and data on QMC/HUB
- Create reload task or try to run the app – there is an issue here to refresh the task
- It will throw an error without any logs if we refresh either app or task
- Alternative1: We must duplicate the app and refresh it then publish into actual one in QMC
- Alternative2: Open data load script editor and reload the script
- Automate the Alternative1 by using power shell script to refresh it on daily basis