unresolved reference

Detlef Biederma
Tera Expert

Hello 

 

I have found some unresolved references, means

  • "cmdb_ci.assigned_to"  -  has a sys_id
  • but this sys_id does not exists into to "sys_user" table

DetlefBiederma_0-1693906295431.png

 

2 questions: 

  • how this can happen, I tried different scenarios but could not reach this unresolved reference ?
  • is there a common way /script/ good practice to resolve it ?

Sincerely Detlef Biedermann

 

2 REPLIES 2

Community Alums
Not applicable

@Detlef Biederma --

 

Try with filter out empty records. In my case filter looks different,Please refer below screenshot.'

 

 

Thank you!

 

SteveMacWWT
Kilo Sage

Were these CIs created in a different environment and then copied to Prod via an XML export / import? If so, then the User that was set as the Assigned to probably has a different sys_id in that environment (i.e. the user was created in that environment manually and not copied from Prod.)

 

One other possibility is the User record was deleted.