question Re: "Invalid 'Dictionary Entry'" record error in Developer forum

"Invalid 'Dictionary Entry'" record error

Mikhail6 — Fri, 01 Dec 2023 15:54:05 GMT

When I try to update a dictionary, the following error shows up:

"Invalid 'Dictionary Entry' record even though the selected outside Table 'Business Application' is allowed."
"Invalid update".

Table is "cmdb_ci_business_app".
Any suggestions?

Thanks

Re: "Invalid 'Dictionary Entry'" record error

Bert_c1 — Fri, 01 Dec 2023 17:09:14 GMT

Hi,

I was able to create that field in my PDI. If what you see is from a hosted instance, then I believe the field creation in the database has some problem. This can happen on very large tables (cmdb, task) as it can take some time for the database alter (if needed). You should create a Support Case for this, if the field was not recently created. If recently created, a database alter may still be in process.

Re: "Invalid 'Dictionary Entry'" record error

Marcus Walbridg — Fri, 01 Dec 2023 18:03:29 GMT

I might need more information on what you are trying to do, but some questions: are you using the correct app scope?, are you trying to edit a dictionary that was inherited?

Re: "Invalid 'Dictionary Entry'" record error

Bert_c1 — Fri, 01 Dec 2023 21:53:47 GMT

cmdb_ci_bussines_app table and all of the field metadata (sys_documentation, sys_dictionary, sys_custom_db_object, and sys_storage_alias records for the field) records are in the Global application scope. Any custom fields in the cmdb table hierarchy need to be created in Global scope. The cmdb schema design used is known as "Table Per Partition". And the 'storage_name' and 'storage_table' fields on sys_storage_alias map the field to the table and column in the database. Having millions of records in cmdb when trying to create a new custom field from the UI (not in an update set) in the table hierarchy can easily lead to database "corruption".

Re: "Invalid 'Dictionary Entry'" record error

Sandeep Rajput — Sat, 02 Dec 2023 07:56:57 GMT

@Mikhail6 You are trying to add the field Operational Management on the table Business Application (cmdb_ci_business_app) in Application Portfolio Management scope. Since the table Business Application (cmdb_ci_business_app) exists in the Global scope, the operation might have been denied due to this cross scope field creation.

I recommend you to try adding the field Operational Management from the Global Scope.

Re: "Invalid 'Dictionary Entry'" record error

Bert_c1 — Sat, 02 Dec 2023 16:56:11 GMT

And to do that, records in the following tables: sys_documentation, sys_dictionary, sys_custom_db_object, and sys_storage_alias will have to be deleted before re-creating the field in Global Scope.

Re: "Invalid 'Dictionary Entry'" record error

Community Alums — Sat, 02 Dec 2023 19:14:59 GMT

Just swith to Global scope and create your new field.