SYS_choice records automatically deleted
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2017 12:14 PM
Hi,
I have a issue in one of my instances. Few records in the "Sys_choice " table are deleting automatically without user interaction,
I have checked the logs and did find a record in "sys_metadata_delete" table. this is happening for few set of records in sys_choice table and it is happening weekly twice. these records are entered manually into sys_choice table and captured in update set. Please help?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2017 12:14 AM
Hi Prasad,
Was there any update from the HI team for this issue.
If so, please share the details(even we are facing the same issue after the Istanbul upgrade).
Thanks.
Regards,
Jayaruby B

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2017 09:43 AM
We had the same issue. Is to be solved with Istanbul HI told us.
See PRB714962.
Does not apply to all sys_choices. And I think only english values are effected.
Somehow is seems to be related to cmdb values ... but I would not bet as I somehow found also other sys_choices that where missing ...
We just import them via xml after each patch ... easy to do, but quite shitty if not done before productive.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2017 07:36 PM
Hi,
Is this issue resolved? If so, could you please share the details as we are facing similar issue after upgrading to Jakarta.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2017 11:51 AM
Yes. Looks like with Jakarta patch 4 this is ok.
At least our problem with the install_status.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2017 11:52 AM
Hi Jithendra,
When you update any choice field , Update set will capture total choice set and overrides choice set in targeted instance.
I