Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
vuan
Partner - Contributor II
Partner - Contributor II

missing chunk number 0 for toast value

Hi everybody,
I tried to backup the QSR database. But it does not work and I get an error.

"missing chunk number 0 for toast value 235067 in pg_toast_16621"

I already locate the corrupted value in our database

vuan_0-1737556976676.png

It works when  "MetaDataObject" is excluded.

My question is can i delete this row without corrupting our Qlik Sense Enterprise?

Or is there another way to fix this Dataset?

Kind regards

 

Labels (1)
1 Reply
Alan_Slaughter
Support
Support

Hi maybe this would be helpful to you? Always make a backup of your db prior to making any changes. 

https://newbiedba.wordpress.com/2015/07/07/postgresql-missing-chunk-0-for-toast-value-in-pg_toast/

https://community.qlik.com/t5/Official-Support-Articles/How-To-Take-Backup-And-Restore-Qlik-Sense-En...

 

Or restore a backup of the database prior to the corruption.