When extending DataTypes in SD.Data.integration project, Properties with multiple capital letters and underscores result in column name being created incorrectly

Article:TECH150228  |  Created: 2011-01-25  |  Updated: 2012-09-14  |  Article URL http://www.symantec.com/docs/TECH150228
Article Type
Technical Solution



When extending the DataTypes contained in the SD.Data.integration project per the ServiceDesk 7.0 Customization Guide, if you add a property that contains capital letters and underscores, the column created to hold the data for this property is created incorrectly.

For example, if you create a property named SD_mycustom on the ServiceDeskIncident datatype, the column created in the ServiceDeskIncidentManagement table is called s_d_mycustom.

This issue will be present in similiar user created integration projects in Workflow that use the Multiple Generator Container integration component containing a User Defined Type with DB mapping integration component.


There is no error presented when modifying the datatype.


ServiceDesk 7.0
ServiceDesk 7.1
Workflow 7.0
Workflow 7.1


To avoid this issue, when adding properties do not use capital letters or multiple underscores in the property name.

Article URL http://www.symantec.com/docs/TECH150228

Terms of use for this information are found in Legal Notices