Hello, We recently upgraded our DEV instance from 6.0 -> 7.1 -> 7.5 sp4 and discovered some serious issues with "some" of our custom validations. Validation values have simply disappread, especially for those which had Approved or Not Approved values. Like in one case where we had "Approved" and "Not Approved", there are "NO" values remaining there after the upgrade. Same is true for another validation which used to have sinlge value as "Succeeded". And for other case, which used to have 2 values : "Approved" AND "Need More Info" before, now only the "Need More info" is remaining. Has anyone run into similar issues before ? -Raj
Yes Eric, All of these are Drop-down List validations. It seems somehow during the upgrade the entries for these validations in KNTA_LOOKUPS table got Deleted. Interesting part is it seems only valeus like APPROVED, NOT-APPROVED, SUCCEED etc. etc. are affected. Some values like NEED_MORE_INFO, RETEST,CONFIRM_FAILURE are not affected ???
Stil trying to figure out with HP Support but no one seems to have any idea yet. -Raj
We were finally able to figure out the cause for this. Looks like some of our very old validation values had “user_maintainable_flag” set as 'N' in knta_lookups table. Looks like upgrade wipes out any values with 'N' value even if the lookup type is from a customized validation. Since we had only 17 validations affected, we updated the values manually in new instance. Production valeus will be updated usign a script. Thank you all for your help. -Raj