RSA^® Governance & Lifecycle

Article Number 000068213 Applies To SecurID Governance & Lifecycle 7.5.2 P07 Issue After patching to version 7.5.2 P07, the GUI is showing the following initialization error: Image description And the following error is shown in the patch.log: SQL/line#: /home/oracle/wildfly-24.0.1.Final/domain/servers/img-server-1/tmp/vfs/deployment/deployment99a9ca9d5e1f36c2/aveksa.war-13593c541ef9436/WEB-INF/database/migration/createReportViews.sql(1): Start time [Wed Jun 07 19:51:53 EDT 2023] begin Report_Views_Pkg.create_av_report_views; end; java.sql.SQLException: ORA-04063: package body "AVUSER.UTILITIES_PKG" has errors ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.UTILITIES_PKG" ORA-06512: at "AVUSER.REPORT_VIEWS_PKG", line 708 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ... Caused by: Error : 4063, Position : 0, Sql = begin Report_Views_Pkg.create_av_report_views; end;, OriginalSql = begin Report_Views_Pkg.create_av_report_views; end;, Error Msg = ORA-04063: package body "AVUSER.UTILITIES_PKG" has errors ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.UTILITIES_PKG" ORA-06512: at "AVUSER.REPORT_VIEWS_PKG", line 708 ORA-06512: at line 1 Cause This is a known issue with some database deployment types where additional grants need to be provided for some RSA internal tables to facilitate feature enhancements in 7.5.2 P07. This is a known issue in the following type of RSA Governance & Lifecycle deployment: Customer-Supplied Remote Oracle Database This issue is not known to occur in the following types of RSA Governance & Lifecycle deployments: RSA-Provided Local Oracle Database RSA-Provided Remote Oracle Database RSA GL Cloud Customer-Supplied AWS RDS Oracle Database (where the "SecurID Governance & Lifecycle 7.5.2 AWS Installation and Clustering Guide" has been followed) Resolution RSA is working to provide a formal fix for this issue. Workaround If you encounter this issue, contact RSA Customer Support and quote this Knowledge Base article to get access to guidance for applying additional grants required to complete the patching process for SecurID Governance & Lifecycle 7.5.2 P07. Notes If you suspect you have encountered this issue or are susceptible to it, the following scripts can be run to validate your system requires remediation to successfully apply the patch P07 on your SecurID Governance & Lifecycle 7.5.2. Run the following select queries as SYS user (or another Oracle user with SYSDBA privilege) in SQLPLUS (or another database tool like SQL Developer): NOTE:  If your SecurID Governance & Lifecyle database schema is configured with a user other than the default AVUSER, please replace 'AVUSER' in the command with the appropriate user.   SELECT owner, table_name FROM table_privileges WHERE grantee = 'AVUSER' and table_name in ('DBA_HIST_DATABASE_INSTANCE', 'DBA_HIST_SNAPSHOT','DBMS_WORKLOAD_REPOSITORY','DBMS_LOCK') ORDER BY owner, table_name;   If the result for the above command matches with the output below, your SecurID Governance & Lifecycle deployment is NOT affected by the issue in this article. Image description If the result for the above command is empty or does not match with the above good output, your SecurID Governance & Lifecycle deployment is AFFECTED by this issue. ... View more

Article Number 000068193 Applies To This is a known issue in the following versions. RSA Governance & Lifecycle 7.5.2 P06 Issue While trying to collect data using Multi-App Account Collector on 7.5.2 P06, only the first collected account is mapped and other accounts are rejected with the below error message, EC[251] Context[RunID=200, ADC(Name=MAADC Test Collector, ID=67)] Message[Reference resolutions failed.] Image description   Resolution This issue is resolved in the following versions: SecurID Governance & Lifecycle 7.5.2 P07 ... View more

Article Number 000068202 Applies To RSA Product Set: RSA Governance & Lifecycle RSA Version/Condition:  SecurID Governance & Lifecycle 7.5.2 P04, P05, P06. Issue The Remote AveksaAgent fails to start as a service on Windows machines, Image description The following exception is shown in the wrapper.log   INFO | jvm 1 | 2023/05/28 10:20:06 | WrapperSimpleApp: Unable to locate the class com.aveksa.client.datacollector.startup.Bootstrap: java.lang.NoClassDefFoundError: org/apache/log4j/Logger   Cause Java classpath in the wrapper.conf file is pointing to a different log4j.jar file, hence remote agent was failing to start as a service Resolution This issue is resolved in the following versions/patches: SecurID Governance & Lifecycle 7.5.2 P07 Workaround Follow the below steps as a workaround on 7.5.2 P06 to run the remote agent as a service on a Windows machine: Stop RemoteAgent if running already. Uninstall Remote Agent by running "UninstallAvAgent-NT" file. Download Remote agent zip from UI and re-deploy the agent on windows box. Remove below lines from wrapper.conf file present under agent conf folder. wrapper.java.classpath.3=../common/lib/log4j-1.2.17-1.0-rsa-1.jar wrapper.java.classpath.4=../conf Add below lines in the same file & save wrapper.java.classpath.3=../common/lib/log4j-1.2-api-2.17.2.jar wrapper.java.classpath.4=../common/lib/log4j-api-2.17.2.jar wrapper.java.classpath.5=../common/lib/log4j-core-2.17.2.jar wrapper.java.classpath.6=../conf Go to Remote agent bin folder & install agent by running "InstallAvAgent-NT" file. Go to Services window and start AveksaAgent service. ... View more

Summary RSA announces the availability of Patch 7 for SecurID Governance & Lifecycle 7.5.2. This release contains numerous fixes and improvements. See the SecurID Governance & Lifecycle 7.5.2 Patch 7 Release Notes for information about the contents of the patch. Recommendation: RSA strongly recommends that customers upgrade to this latest update. Please note that all patches are cumulative. Obtaining Software and Documentation: The Release Notes are available in the SecurID Governance & Lifecycle 7.5.2 documentation area. You can access the RSA Identity Governance and Lifecycle 7.5.2 Patch 7 software in the SecurID Governance & Lifecycle 7.5.2 Downloads area on RSA Community. In the Download area, click Full Product Downloads to open myRSA and to view a list of your purchased products. Select the appropriate license link to access the RSA Identity Governance and Lifecycle software downloads. Contact RSA Customer Support if any licenses for products you have purchased are missing from the list. EOPS Policy: RSA has a defined End of Primary Support policy associated with all major versions. Please refer to the Product Version Life Cycle for additional details. ... View more