Support Article
Data Not Retaining on Screen Navigation
SA-50584
Summary
Dynamic Select drop-downs are configured on each tab of a screen-flow.
When selecting values on tabs and when user navigates back and forth, some of the answers getting reset.
Issue is occuring only in Production environment after performing an upgrade to the application from PRPC 6.3 to Pega 7.2.
Error Messages
Not Applicable
Steps to Reproduce
1. Open a loan.
2. Open a category.
3. Select answers from all drop-down.
4. Click Next to go to next screen and visit to previous screen, notice from some of the dropdowns will not have the values retained.
Root Cause
As Dynamic select control is depcrecated one must change it to drop-down with report definition as source.
After converting to Report Definition, user is seeing some garbage characters in the drop down.
If the actual data is "Test123" user was seeing only "Test12" and garbage characters in some cases.
The Report definition is using columns which are not optimized and in this scenario User Defined Functions (UDFs) will be used.
UDF's have got corrupted in the DB and thus returning garbage characters.
Resolution
Perform the following local-change steps:
1. On the database, drop any existing versions of the UDF functions on both the Data and Rules schemas: pr_read_decimal_from_stream, pr_read_from_stream, pr_read_int_from_stream
2. Update setupDatabase.properties from the distribution media to point to the database in question, ensure to specify both schemas.
3. Run the generateudf.bat or generateudf.sh script in the scripts directory, with the following parameters: generateudf --action install --dbType [db2zos|mssql|postgres|oracledate|udb]
Published February 20, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.