000036989 - Initialization operations completed with errors after RSA Identity Governance & Lifecycle 7.1P03 upgrade

Document created by RSA Customer Support Employee on Dec 28, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036989
Applies To
 RSA Product Set: RSA Identity Governance & Lifecycle 7.1
IssueAfter performing 7.1 P03 upgrade on existing 7.1 environment, IGL fails to start and UI web page throws this error:


Initialization Status
Initialization operations completed with errors. Please resolve the problem(s) before the application server can accept requests.

ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "DATA_50M"
ORA-06512: at line 6

 

Issue is that upgrade SQL script ACM-83939.sql failed to execute with below error log from AveksaServer logs



java.sql.SQLException: ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "DATA_50M"
ORA-06512: at line 6
 
CauseWhen the column did not exist in this database, and the patch is trying to create it as a securefile lob which requires the tablespace to be of type ASSM.
It is possible that ‘SEGMENT SPACE MANAGEMENT’ is not set to AUTO.
Run below as avuser to verify:

Select * from user_tablespaces;

If ‘SEGMENT SPACE MANAGEMENT’ is set to MANUAL for tablespace DATA_50M, that could be the reason why you noticed the error message and it should be set to AUTO.




 
Resolution
‘SEGMENT SPACE MANAGEMENT’ needs to be set to AUTO so ASSM is enabled and securefile lob can be set.

 

Attachments

    Outcomes