Project and Portfolio Management Practitioners Forum
cancel

Custom validations issue after 7.5 upgrade

Highlighted
Raj Ghimire
Outstanding Contributor.

Custom validations issue after 7.5 upgrade

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
6 REPLIES
Mahen M
Acclaimed Contributor.

Re: Custom validations issue after 7.5 upgrade

Have you moved all the records of KNTA_Transactions to 7.5?

See in your PPM 7.1 staging environment whether you see the values and narrow down where you lost the values.

Regards,
Mahendran M
Raj Ghimire
Outstanding Contributor.

Re: Custom validations issue after 7.5 upgrade

Sorry Mahem I am little confused by:
"Have you moved all the records of KNTA_Transactions to 7.5?"

Is KNTA_Transactions one of the tables ?
We don't have any Table by that name either in 6.0 or recently upgraded 7.5.

-Raj
Erik Cole_1
Outstanding Contributor.

Re: Custom validations issue after 7.5 upgrade

These are Dorp-down List validations? Have you looked in KNTA_LOOKUPS to see if the values still exist there?
Erik Cole_1
Outstanding Contributor.

Re: Custom validations issue after 7.5 upgrade

These are Drop-down List validations? Have you looked in KNTA_LOOKUPS to see if the values still exist there?
Raj Ghimire
Outstanding Contributor.

Re: Custom validations issue after 7.5 upgrade

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
Raj Ghimire
Outstanding Contributor.

Re: Custom validations issue after 7.5 upgrade

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