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

[#1]

Article Number

000038384

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x

 

Issue

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)

 

Cause

One or more tables in the AVUSER schema have been compressed.

Resolution

Please contact your DBA  and request that they uncompress these tables. You willl not be able to apply a patch until this is done.