Summary
When adding fields to dbdicts in Service Manger 7.X, the system prompts with a screen showing DDL commands that will be executed. The instructions on the screen state that the code can be modified, but when you change the VARCHAR() value, and then click SM Alters, the system ignores the changes entered and simply maps the field as the default VARCHAR(60). SCR42155 has been opened to address this issue
Error
RTE / RAD: SM7.01 / SM7.0 + 7.01 unloads.
Server OS: Windows 2003 Enterprise
Client: Eclipse 7.01
RDBMS: MS SQL Server 2005
RDBMS OS: Windows 2003 Enterprise
When adding fields to dbdicts in Service Manger 7, the system prompts with a screen showing DDL commands that will be executed. The instructions on the screen state that the code can be modified, but when I change the VARCHAR() value, and then click SM Alters, the system ignores the changes entered and simply maps the field as the default VARCHAR(60).
Cause
RTE issue in the code.
Fix
SCR42155
Workaround:
1. Let the system create the default varchar size.
2. Modify the sqlmapping to the correct size.
3. Modify the field on the RDBMS to the correct size.