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

------- 
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

	

• RSA Identity Governance & Lifecycle 7.0.2 P10
• RSA Identity Governance & Lifecycle 7.1.0 P04
• RSA Identity Governance & Lifecycle 7.1.1