|Issue||After performing 7.1 P03 upgrade on existing 7.1 environment, IGL fails to start and UI web page throws this error:|
Issue is that upgrade SQL script ACM-83939.sql failed to execute with below error log from AveksaServer logs
|Cause||When 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.
‘SEGMENT SPACE MANAGEMENT’ needs to be set to AUTO so ASSM is enabled and securefile lob can be set.