SM7.01: Unable to modify DDL with SM Alters.

  • KM498626
  • 25-Sep-2008
  • 25-Sep-2008

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.