Updated – Resolution Below!
Posts are few and far between for me these days. Simple fact is I’ve moved away from QlikView development and now am solely working with Qlik Sense.
This is great for me although as I’m learning a new tool I don’t want to shout out best practice too much until a get a real feel for something and I feel I can offer some practical well thought out advice.
This week I’ve run into a problem lwith Qlik Sense QMC and the ability to delete published application. There’s very little warning when you complete that action although please be aware you could lose work so I want to share what I’ve learned so others don’t fall into the same trap!
The work that can be lost is community published sheets and users ‘my sheets’. Once you delete the published application you will never be able to get back these user created sheets.
I created a duplicate of the application before I deleted it (into the My Work area of the Sense hub), I republishing it and the base sheets were fine but no user sheets. I then got the back up application from an IT restore. I imported the application and published it, again base sheet good, user sheets gone!
After a bit of investigating I found the objects in the Postgres database. All the objects have a unique ID (something like 2D1F7600-01F0-4422-B8DF-E3B4A56D381C) which is generated by Sense and stored in the database.
So even with the duplicated application or restored file, the objects have already been deleted from the database and the ID won’t match if you want to re-use objects.
So be warned, if you’re going to delete a published application check:
- Community Sheets
- User Sheets (you’ll have to check the QMC for these)
Are all copied into the application as base sheets, this means they’re in the application itself and can be duplicated / backed-up / etc…..
Hopefully soon Qlik will address this problem, I’m aware of a back-up tool on Branch. I’m looking into this so if anyone has got any good news about it to share please do so in the comments below. Ideally though Qlik will expand the QMC to give a bit more flexibility around backing up or restoring deleted files, At least they could give a warning that you stand to lose x number of sheets and stories if you do delete the file.
There is a workaround to this issue, as mentioned I had the application folder backed up by the IT department. The files aren’t .qvf files so you can’t just re-import them without renaming them to have a .qvf extension.
You can them import them into the QMC as you normally would. I tried that originally although I got the application but not the community sheets.
Problem was there were duplicates of the application which weren’t published and residing in users ‘My Work’ area of the Sense Hub. The application I must have imported was one of those and therefore didn’t have the community sheets in there.
Trying again today fresh I imported everything!!!! All the backup apps until Yes! I had the one I needed and the community sheets were there.
So the moral of the story here is yes, if you have an IT back up of your application folder you have options. Depending on how many apps you have it may take some time (as they’re all named something like 2D1F7600-01F0-4422-B8DF-E3B4A56D381C) although its possible to get those sheets back.
I still think there needs to be a simpler process for undoing actions made in the QMC. Also promoting and managing sheets within the QMC should be more user friendly.
That’s all for now, take care, Richard