Unable to open a Form from Change Requests after making changes to a text in a Static Text Control Type in a form
Originally Published: 2019-06-04
Last Modified: 2023-09-22
Article Number
Applies To
Customer made changes to their custom form. Change was made to a field named 'TextNoteAltManager' which is Static Text Field. So only text was slightly changed.
But after this change, he observed that, ALL CRs that were generated before this change, are not showing the form details when clicked on the form name in that CR.
Problem Form Name: CLIQ Key Access
Clicking on that form name gives error --> “An error occurred loading the fields of the form”
Environment Information
=========================
7.0.2 P06, Remote DB + WebLogic
Cluster with 2 nodes: AveksaSrv1 (SON) and AveksaSrv2
STEPS TAKEN
==============
- Imported the custom form 'CLIQ Key Access / Accès à la clé CLIQ' in my 7.0.2 P08 system and tested the issue.
- Removed the validation URI and made changes to the static text to the field 'TextNoteAltManager' and saved the ran the form again.
- Created a new CR: 00062
- Approved and Completed the CR
- Issue is not reproduced. Was able to open the form from link within the new CR successfully.
- Provided my form to customer and asked them to test that form. This did not fix exisiting CRs and still unable to open the form.
- Looks like exisiting CRs are now corrupted and only solution is to restore the previos database backup.
- Customer may do that, however wants to do the RCA since they are concerned about these CRs for Audit.
Cause
While fetching the request form details in change request summary page, we were getting the error ORA-01722: invalid number on executing the query to get the details.
In the T_AV_AUDIT_SNAPSHOT table, ALT_ID was varchar2 and while passing this parameter to the query we were passing as number. Sometimes oracle was doing the auto conversion from number to string but, sometimes it used to fail when auto conversion didn't happen.
Related Articles
When accessing the enrollment page or admin console on RCM/RRM get certificate error on browser if certificate name does … Number of Views What is the originator info? Number of Views AdminServiceException when attempting to import partner metadata xml file. Number of Views RSA SecurID Authentication Agent 8.1 for PAM Installation and Configuration Guide for SUSE (French) Number of Views RSA SecurID Software Token for Android Quick Start (French) Number of Views
Trending Articles
Artifacts to gather in RSA Identity Governance & Lifecycle How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle How to Download and Reinstall the AFX Server Archive in RSA Governance & Lifecycle
Don't see what you're looking for?
