The CreatorCon Call for Content is officially open! Get started here.

SYS_choice records automatically deleted

prasad48
Tera Guru

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?

9 REPLIES 9

balkal
Kilo Explorer

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


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.


Jithendra Kumar
Tera Contributor

Hi,


Is this issue resolved? If so, could you please share the details as we are facing similar issue after upgrading to Jakarta.


Yes. Looks like with Jakarta patch 4 this is ok.


At least our problem with the install_status.


Hi Jithendra,



When you update any choice field , Update set will capture total choice set and overrides choice set in targeted instance.



I