unresolved reference

Detlef Biederma
Tera Expert

‎09-05-2023 02:35 AM

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

 

0 Helpfuls
  • 391 Views
2 REPLIES 2

Community Alums
Not applicable

‎09-05-2023 03:11 AM - edited ‎09-05-2023 03:12 AM

@Detlef Biederma --

 

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

 

 

Thank you!

 

Preview file
11 KB
0 Helpfuls

SteveMacWWT
Kilo Sage

‎09-05-2023 05:57 AM

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.