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
How to clear node secret from NetScreen Firewall Number of Views 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 MFA Agent 9.0 for PAM - Installation and Configuration Guide for Solaris (French) Number of Views RSA Governance & Lifecycle Recipes: Chart - AD Orphan Account Summary Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
