Qlik Community

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MohamedZaitoon
Contributor II
Contributor II

User Directory Connector Stuck at Database Store Status

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:

MohamedZaitoon_0-1652862774857.png

MohamedZaitoon_1-1652862864836.png

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 

 

Labels (1)
3 Replies
Seanog_Murphy
Creator III
Creator III

MohamedZaitoon
Contributor II
Contributor II
Author

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
Creator III
Creator III

@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.