Error: com.snc.cmdb.CmdbRuntimeException: Model too big, field 'state' on table 'svc_model_obj_service' won't fit. - Support and Troubleshooting

Error: com.snc.cmdb.CmdbRuntimeException: Model too big, field 'state' on table 'svc_model_obj_service' won't fit. Description  Symptoms ServiceMapping throws error like:

com.snc.cmdb.CmdbRuntimeException: Model too big, field 'state' on table 'svc_model_obj_service' won't fit. Field size: 9,320,000. Actual value size: [some_larger_value_other_than_9,320,000]

Release Any

Cause The 'State' field on the table 'svc_model_obj_service' has a default value of 9,320,000 characters.

In some cases where we have larger maps, this might not be enough and this error will be thrown.

Resolution 1) Go to the "svc_model_obj_service" table

2) Open the sys_dictionary entries for that table

3) Find the "state" field

4) Modify the field size of that dictionary entry to something higher than the second number you see in that error message.

For example:

ERROR:

com.snc.cmdb.CmdbRuntimeException: Model too big, field 'state' on table 'svc_model_obj_service' won't fit. Field size: 9,320,000. Actual value size: 11,484,666

Change the size of the field to 12,000,000.

Additional Information Note: Once you increase the size of the field you should not decrease the size. You can only increase further. Only if necessary.