We recently migrated from 8.0 M040, where we had changed the VALUE and VALUE2 fields in the STRINGVALUE table to 4000. I was able to get the length value of 4000 through the UpgradeManager with no problem. The problem we are experiencing now is we have a new soft type object based on a WTDocument with an IBA for a summary filed, and 9.1 does a length check for only 500 characters, causing the create to blow up if the user types a dissertation. I found the section in the Customizers Guide on how to alter column lengths, but the example given is for the WTDoucmentt object, and I cannot figure out how to to do this for the STRINGVALUE table. Just wondering if any brave explorers in PTCland have done something similar to this. Thanks in advance! Send lawyers, guns, and money...the sh!t has hit the fan!
I thought the length requirement for stringvalue was altered only with rational rose. Serialization is the issue. The code doesn't know the db capacity has increased. I think the column customization covers modeled elemtns vs non modeled. PTC should be able to show you how to do this if you license Windchill Information Modeler.
One thing I am concerned when we increase the column length on STRINGVALUE table. We have over 21 million rows in this table in database. This is the only table which stores string IBAs for all object types.
Did you see any performance issues when the VALUE column length has increased?
We also have about 25 million records in StringValue table and we do not have any performance issue when creating/editing IBAs.
We had performance issue when searching against IBAs. Search used to take 2 minutes with one IBA in search criteria and with three IBAs (one being discrete set constraint) it used to take 17 minutes. PTC has fixed this issue through SPR 1888550. We applied the patch for the same and now any search against IBAs takes only 5 seconds . Attached is the patch details.