000038384 - 'ORA-39726: unsupported add/drop column operation on compressed tables' error patching RSA Identity Governance & Lifecycle

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)