topic Error while restoring Qlik Sense site in Management & Governance

Error while restoring Qlik Sense site

User93 — Fri, 10 Nov 2023 13:33:09 GMT

Hi all,

I need help on a Qlik Sense migration I am doing.

Since we use the May 22 version, I use this documentation : https://help.qlik.com/en-US/sense-admin/May2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backup-and-restore.htm

Everything went well until I got to the restoration part : https://help.qlik.com/en-US/sense-admin/May2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-a-site.htm

When I used this command : pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\QSR_backup.tar", I got the following error message :
pg_restore: while PROCESSING TOC
pg_restore: from TOC entry 3; 2615 2200 SCHEMA public postgres
pg_restore: error: could not execute query: ERROR: schema "public" already exists
Command was: CREATE SCHEMA public;

pg_restore: error: could not find header for file "3735.dat" in tar archive

I tried the commands of the documentation :
dropdb -h localhost -p 4432 -U postgres QSR
createdb -h localhost -p 4432 -U postgres -T template0 QSR

But when I ran the restore command again I got the same error message.

Is there something else I can try to solve this ?

Best regards.

Re: Error while restoring Qlik Sense site

Ray_Strother — Mon, 13 Nov 2023 19:30:30 GMT

Hello ,

Please review the following article link.
https://community.qlik.com/t5/Official-Support-Articles/How-to-manually-upgrade-the-bundled-Qlik-Sense-PostgreSQL/ta-p/1820358

Re: Error while restoring Qlik Sense site

User93 — Thu, 16 Nov 2023 08:10:00 GMT

Hi,

Thank you for the quick answer.

The link you gave clearly explains that we can ignore the first error, and after a few tests, it seems our problem is indeed with the second error :

pg_restore: error: could not find header for file "3735.dat" in tar archive

Apparently, the problem comes from our backup file QSR_backup.tar

Even if we deactivated the Qlik Servives (except the one for the repository database), we encountered this error when creating the file :

pg_dump: Dumping the contents of table ”_deletedentitylog”: PQgetResultQ failed.

pg_dump: Error message from server: ERROR: invalid page in block 246294 of relation base/16384/16633

pg_dump: The command was: COPY public._deletedentitylog (entityid, entitytype, deletedbyuser, deleteddate, info) TO stdout;

Is there something we can test about it ?

Best regards.

Re: Error while restoring Qlik Sense site

User93 — Tue, 21 Nov 2023 09:30:43 GMT

Hi,

It looks like we have a problem with the current [_deletedentitylog] table, we plan to fix that, and then recreate the backup files.

I will post the update.

Best regards.

Re: Error while restoring Qlik Sense site

User93 — Thu, 07 Dec 2023 07:53:20 GMT

Hi,

Fixing the _deletedentitylog table (empty, recreate) before recreating the backup files worked well, and we succeeded with the restore part.

Best regards.