Empty User Records Created in the sys_user Table

[Lavanya11]

Hi All,

for the past 2 months in the sys_user table I see more empty records which is created under my name. But I checked all the customisations with sys_user table. I couldn't find any. Anyone had the similar situation like this or Please give me out some suggestions

[Jaspal Singh · Accepted solution]

Hi,

Did you do any data load for group membership or for any other table involving users? If so, seems the reference field value was not passed as expected and you see these records.

Seems, some job or some action on any table involving user was handled which resulted in this. If all are at the same time more or less then look for scheduled job or try to see if there was any manual load actioned. 

[Jaspal Singh · Accepted solution]

Hi,

Did you do any data load for group membership or for any other table involving users? If so, seems the reference field value was not passed as expected and you see these records.

Seems, some job or some action on any table involving user was handled which resulted in this. If all are at the same time more or less then look for scheduled job or try to see if there was any manual load actioned. 

[Anil Lande]

Hi,

Check the source of records (a field on User table).

Is there any integration running on your instance that loads data like SuccessFactor integration or AD integration or LDAP ? 

You might have executed any Job (or Flow) manually and it might have created some records.

[Harish KM]

Hi @Lavanya11 Kindly check if there are any scheduled jobs, data load via transform maps, or any other jobs which creates record on User table.

[Lavanya11 · Accepted solution]

Actually I was looking in the logs table. Then I came to find out, I import some datas to the Problem table and export it back again. So during that time only this empty user IDs are getting created. Now I have to take a look at the Transform map where we have a referncefield to the sys_user