User Directory Connector Stuck at Database Store Status

[MohamedZaitoon]

Hi everyone,

I am facing a problem where the active directory connection does not sync the data. It is retrieving the users from active directory but the data can't be stored in the postgres database (Repository DB).

Screenshots of the logs:

The error raised:

synchronizing all users for cf4583e1-22a7-410b-805a-74b6fa6d9e99 was not successful
missing chunk number 0 for toast value 4281022 in pg_toast_22083 

@Troy_Raney @Bjorn_Wedbratt @Andre_Sostizzo  @Albert_Candelario @Seanog_Murphy 

Thanks in advance

Qlik Sense Enterprise on Windows 

[Seanog_Murphy]

Hi @MohamedZaitoon 

According to the articles below error is associated with data corruption in your TOAST tables
- https://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a
- https://newbiedba.wordpress.com/2015/07/07/postgresql-missing-chunk-0-for-toast-value-in-pg_toast/ 

[MohamedZaitoon]

Thanks @Seanog_Murphy  for your reply,

I saw one of these articles but there is not a psql tool installed on the server.

what can I do from Qlik Sense side?

[Seanog_Murphy]

@MohamedZaitoon 
Perhaps you  could install PGAdmin and see if you can get one of the solutions from the articles to work. If the table is indeed corrupted, then I'm not sure much can be done from the Qlik Sense side.
As always I would recommend that you take backups before making any changes.