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

Product(s)

Issue



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.


Error



There is no error presented when modifying the datatype.


Environment



ServiceDesk 7.0
ServiceDesk 7.1
Workflow 7.0
Workflow 7.1


Solution



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