unresolved reference
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 03:11 AM - edited 09-05-2023 03:12 AM
Try with filter out empty records. In my case filter looks different,Please refer below screenshot.'
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.