Field length size increase from import set didn't get promoted to other environment

[Cupcake]

I did a Load data in DEV, and I noticed that one of the fields called Description was very lengthy and was truncating the information. Then I figured out that I had to increase the size of field within the Import Set itself. That resolved the problem.

My issue is after I do the initial load data, then I import the information to the other environments and it does not appear that the field length size of the description increased when I imported the data. So in my other environments the description field is truncated still.

So I am trying to figure out how can I increase that field size in the other environments when I did an import vs. a Load Data.

Please advise when you get a chance.

Karen

[Chuck Tomasi · Accepted solution]

Karen,

When you increased the field length in dev, was that change captured in an update set? Was that update set promoted to the other environments?

http://wiki.servicenow.com/index.php?title=System_Dictionary

[Cupcake]

Hi Chuck I checked my update sets, I checked the Customer table for all updates, I checked the default update set.

But I think shortly after I loaded my data, we did a clone and then upgraded our SN to Helsinki - so I think my update got lost in the sauce somewhere. I was just trying to find out if there was somewhere else that I could go to update it vs. doing the load data in the TEST and PROD environments, but I believe this is going to be my only option. Ughhhhhhhhhhhhhhhhhh.

Thank you for your help.

Karen

[Chuck Tomasi]

You CAN modify the dictionary entry manually in prod and test, to lengthen the description field - it technically can be done, but carries the usual risk of doing any system config change in prod. That being said, it won't restore your truncated data. You'll still need to reload it.

If you don't want to go through the import/transform method, you can always export the XML from dev and import it to the other instances.

Exporting and Importing XML Files - ServiceNow Wiki

[Cupcake]

Thanks for that update.

Sorry if I didn't mention it before, but I did export the data from DEV to Test, but the field information was still truncated.

Karen