| Issue | After applying RSA Identity Governance & Lifecycle 7.1.0 P02, the system cannot be restarted. Browsing to the RSA Identity Governance & Lifecycle login page shows the Initialization Status screen with the following errors:
Initialization operations completed with errors. Please resolve the problem(s) before the application server can accept requests.
ORA-06502: PL/SQL:numeric or value error: raw variable length too long
ORA-06512: at line 1
ORA-06512: at line 8
The error is logged to the aveksaServer.log file ($AVEKSA_HOME/wildfly/standalone/log/aveksaServer.log):
08/22/2018 01:13:38.645 ERROR (ServerService Thread Pool -- 83)
[SystemErr] log4j:ERROR Attempted to append to closed appender named [null].
08/22/2018 01:13:38.654 FATAL (ServerService Thread Pool -- 83)
[com.aveksa.server.runtime.AveksaSystem]
****************************************
Initialization has failed!
ORA-06502: PL/SQL: numeric or value error: raw variable length too long
ORA-06512: at line 1
ORA-06512: at line 8
The error is also logged to the patch.log file ($AVEKSA_HOME/wildfly/standalone/log/patch.log):
-------
SQL/line#: /home/oracle/wildfly-10.1.0.Final/standalone/tmp/vfs/deployment/
deploymentd0b59d4df687a3b8/aveksa.war-85a2bac88d7eef71/WEB-INF/database/updates/7.0/ACM-88297.sql(1):
Start time [Wed Aug 22 01:13:38 CST 2018]
DECLARE
v_key varchar2(100);
v_index number := 0;
v_value varchar2(100);
v_cnt number := 0;
BEGIN
--Read the BLOB from T_AV_FILES and convert to CLOB to split the .properties file content into lines.
Restrict the loop only for VIEW_PASSWORD_EXTERNAL_URL to avoid unnecessary iterations.
FOR rec IN (select * from (WITH clob_table(clb)
as (select (select to_clob(UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(data,32767,1)))
from T_AV_FILES WHERE PATH LIKE '%/custom/strings/customerstrings.properties%') clb from dual)
SELECT regexp_substr(clb, '.+', 1, level) text,level line
FROM clob_table
CONNECT BY LEVEL <= regexp_count(clb, '.+')) where text like 'VIEW_PASSWORD_EXTERNAL_URL%') LOOP
v_index := instr(rec.text,'=');
v_key := substr(rec.text,0,v_index-1);
v_value := substr(rec.text,v_index + 1);
if (v_key='VIEW_PASSWORD_EXTERNAL_URL') then
SELECT COUNT(1) INTO v_cnt FROM T_SYSTEM_SETTINGS WHERE PARAMETER='ViewPasswordUrl';
if(v_cnt = 0) then
insert into T_SYSTEM_SETTINGS values ('ViewPasswordUrl',v_value);
else
update T_SYSTEM_SETTINGS set value = v_value where parameter = 'ViewPasswordUrl';
end if;
end if;
END LOOP;
commit;
END;
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: raw variable length too long
ORA-06512: at line 1
ORA-06512: at line 8
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment if you are on a WildFly cluster or a non-WildFly platform.
|
on Sep 12, 2018