search

ameyer505 / D365FOAdminToolkit

A D365FO administrative toolkit created by and for the community
MIT License
38 stars 12 forks source link

Error during Disable User Job #27

Closed eatufano closed 3 months ago

eatufano commented 3 months ago

Hi all, I got sql error below during Disable Users Job (with 30 days as param). Can you help me to better understand the reason? Many thanks!

UPDATE USERINFO SET ENABLE=?,RECVERSION=? WHERE (((PARTITION=?) AND (ID=?)) AND (RECVERSION=?)) [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]PowerPlatformApp user cannot be disabled! Object Server Azure: Cannot edit a record in User Information (UserInfo). User Information: 101090. The SQL database has issued an error.

jofme commented 3 months ago

Hi @eatufano

It looks like the job is trying to disable a service account. Are you using the latest version of the toolkit? if yes can you check if the user is in this form:

image

ameyer505 commented 3 months ago

To add onto what @jofme said, there is a 'Populate Excluded Users' button which will add the default service accounts to the 'Excluded Users' list automatically. The PowerPlatformApp user is a part of this list.

image