Max length of dictionary entry doesn't update properly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2014 04:43 PM
I'm having trouble updating the maximum length of field entries in my SN instance. The first time I make a change to the max_length of a newly created column, the change is reflected. However, every subsequent change is behind by an update. Here's an example:
- Column is initially created and has a maximum data length of 20.
- I change the max length to 30, and update it. This change is reflected.
- I change the max length to 50. This time, the length is still stuck at 30 even though the dictionary item says 50.
- I change the max length to 60. Now the actual length the field will accept is 50. It appears that the thing is now an update behind.
I found a business rule in the dictionary ("Dictionary change length") which has a single line of code:
system.alterSqlFieldDefintion(current.name, current.element, previous.max_length);
It seems like this might be the culprit for the late updates. Changing the last parameter to "current.max_length" seems to break things, however. The field's length seems to get hard-locked to 40 no matter how many times I end up making an update. Any ideas?
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2014 02:29 AM
Hi
Please try to deactivate the business rule first before increasing the data length.Then make the required
change to the length.
Make sure to activate the business rule again after the changes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2014 09:30 AM
Deactivating the business rule has the effect of preventing any changes to the maximum length. The changes aren't reflected in the form, so if I make a string which is too long, it'll truncate the string down to whatever the max length was before I deactivated the business rule. When I reactive the business rule, I have the same symptoms as describe in the original post.