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
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
RSA SecurID Software Token for Android Quick Start (French) Number of Views RSA Governance & Lifecycle Recipes: Chart - Application - Application Account & Orphan Trending Number of Views RSA Authentication Agent 7.4 for Microsoft Windows Group Policy Object Template Guide (French) Number of Views RSA MFA Agent 9.0 for PAM - Installation and Configuration Guide for Solaris (French) Number of Views RSA SecurID Authentication Agent 8.1 for PAM Installation and Configuration Guide for Oracle and RHEL (French) Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
