When patching RSA Identity Governance & Lifecycle, the following error occurs and the upgrade fails.
ORA-39726: unsupported add/drop column operation on compressed tables
The following is an example of what might be logged to the patch log file ( /tmp/aveksa/<patch-name><date>-XXXX.log) depending on which patch you are installing:
SQL/line#: /opt/WAS85/profiles/AppServer01/installedApps/WASTUD_85_Intranet/aveksa.ear/aveksa.war/WEB-INF/database/updates/7.1/ACM-87252.sql(1): Start time [Tue Jul 09 16:08:35 CEST 2019] begin
if Migration_Utils_Pkg.ColumnDoesNotExist('T_AV_SECURITY_CONTEXT', 'ID') then dbms_output.put_line('Adding the column ID to T_AV_SECURITY_CONTEXT'); execute immediate ' alter table t_av_security_context add( id NUMBER GENERATED ALWAYS AS IDENTITY ( MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 ORDER CYCLE ) ) '; end if;
end; java.sql.SQLException: ORA-39726: unsupported add/drop column operation on compressed tables ORA-06512: at line 7
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1707) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1670) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteUpdate(WSJdbcStatement.java:1840) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJdbcStatement.java:1165) at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:225) at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:107) at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:98) at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:481) at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:163) at com.aveksa.migration.jdbctool.CheckDatabase.migrateSchema(CheckDatabase.java:1412) at com.aveksa.migration.jdbctool.CheckDatabase.check(CheckDatabase.java:588) at com.aveksa.server.runtime.AveksaSystem.initialize(AveksaSystem.java:309) at com.aveksa.init.Startup.init(Startup.java:52) at com.aveksa.gui.core.ACMFramework.init(ACMFramework.java:94) at com.aveksa.gui.core.ACMFramework.initInstance(ACMFramework.java:83) at com.aveksa.init.InitServlet.init(InitServlet.java:42) at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:345) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:168) at com.ibm.ws.webcontainer.servlet.ServletWrapper.loadOnStartupCheck(ServletWrapper.java:1369) at com.ibm.ws.webcontainer.webapp.WebApp.doLoadOnStartupActions(WebApp.java:640) at com.ibm.ws.webcontainer.webapp.WebApp.commonInitializationFinally(WebApp.java:606) at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:426) at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:88) at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:171) at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:904) at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:789) at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:427) at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:719) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1211) at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1390) at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:639) at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:979) at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:795) at com.ibm.ws.runtime.component.ApplicationMgrImpl$5.run(ApplicationMgrImpl.java:2279) at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5554) at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5680) at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255) at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2284) at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:436) at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123) at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:379) at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$500(CompositionUnitMgrImpl.java:127) at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:985) at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:524) |