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|
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.
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