Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Request Header Type Field content in Proposals Deleted in Database after Validation Change

SOLVED
Go to solution
Highlighted
Alex Madison
Super Collector

Request Header Type Field content in Proposals Deleted in Database after Validation Change

Hi,
We have a proposal request type with one of the fields which has a text field validation using 200 characters. Based on new requirements, this text field needed to be increased to accomodate 400 characters.
This field was a part of the Request Header Type. We changed the validation associated with this field in the request header type section to Text - 400 and saved the Proposal request type in the workbench.
However, it was noticed that all the existing proposals which had this field populated before the change were wiped off once the changes were implemented. Basically, the only change which was carried out was to change the validation, from Text - 200 to Text - 400.
How could we retrieve the information back?
We checked the parameter associated with this field in KCRT_Request_Header_Details table but most of the proposals had this field empty.
Any response would be appreciated
4 REPLIES
Alex Madison
Super Collector

Re: Request Header Type Field content in Proposals Deleted in Database after Validation Change

In addition to a solution for the above issue, is there a way to create a new text field validation to accomodate 500 characters? I tried to create a validation but it prompted with a box warning that max character length is 200 characters. Also, the 400 character text field validation which was used in the above request header type was a custom creation and HP says there is a hack to create a validation with more than 200 characters. Any solution to the above two issues would be highly appreciated.
Solution

Re: Request Header Type Field content in Proposals Deleted in Database after Validation Change

Hi,

the "parameter" fields from 1 - 40 of the kcrt_req_header_details can only store 200 characters.
The fields 41 - 50 can store 4000 characters.
When you change the validation of a request header type field to more than 200 characters the request header type fields points automatically to a "parameter41" or above field.

Check out the configuration details of the request header type field (storage tab).

You must copy the information from the "old" kcrt_req_header_details field to the new one.

Regards
Volker




Darshan Bavisi
Occasional Visitor

Re: Request Header Type Field content in Proposals Deleted in Database after Validation Change

Hi Alex,

Your earlier data must be still there in the system (database). All you need to do is find out which parameter number you used for the old Text Field - 200 or browse through the table to see where you see your old values. The users cannot see it on the forms, because now the application is fetching data from another parameter that your new Text Field - 400 is using. Since both the columns that are holding your old and new data are different so the it won't be visible on the form fields. As Volker mentioned you will need to manually move the old field values based on each request number to the new field for the same request number and it should resolve the problem.
Alex Madison
Super Collector

Re: Request Header Type Field content in Proposals Deleted in Database after Validation Change

Perfect solution by both of you, thank you Darshan and Volker.
This is the perfect solution, as proposed by both of you.
Thanks a Ton!
//Add this to "OnDomLoad" event