Error during BW upgrade java stack - J2ee_CONFIGENTRY table

[Former Member]

Dear Experts,

We are upgrading BW system from 7.02 to 7.3

The ABAP stack upgrade is completed. We are having issues during JAVA stack upgrade. Please help us.

The issue is with J2EE_CONFIGENTTRY table data type. It is trying to convert some column data type and failing. Please find attached logs.

1. Contains Aborted deployment component:

sap.com_com.sap.engine.jddischema

Mar 12, 2012 1:54:06 PM [Error]: com.sap.sdt.j710.deploymentmgr.DeploymentManagerImpl [Thread[main,5,main]]: Deployment of archive /SAPUP/SUM/java/data/patches/BASETABLES05_0-10007973.SCA --> sap.com~com.sap.engine.jddischema.sda for component sap.com/com.sap.engine.jddischema aborted

Mar 12, 2012 1:54:06 PM [Error]: com.sap.sdt.j710.deploymentmgr.DeploymentManagerImpl [Thread[main,5,main]]: Detailed message: 1. [ERROR CODE DPL.DBC.901] Deploy operation finished with ERROR code.

The following messages were collected by DBModificationController during deployment:

13:50:25 2012-03-12 dbs-Info: <<< Analyze table J2EE_CONFIGENTRY >>>

13:50:25 2012-03-12 db2-Info: database object type for J2EE_CONFIGENTRY is Table

13:50:25 2012-03-12 dbs-Info: J2EE_CONFIGENTRY modify column VBYTES from type : LONGVARBINARY,len : 2000,dec : 0,not null : false,default : |<null>|

13:50:25 2012-03-12 dbs-Info: J2EE_CONFIGENTRY modify column VBYTES to type : VARBINARY,len : 2000,dec : 0,not null : false,default : |<null>|

13:50:25 2012-03-12 db6-Info: compareTo: column FBLOB: target column differs in length.

13:50:25 2012-03-12 db6-Info: compareTo: column FBLOB: table conversion is required to shrink column length.

13:50:25 2012-03-12 db6-Info: compareTo: column FBLOB: a table conversion is required

13:50:25 2012-03-12 dbs-Info: J2EE_CONFIGENTRY modify column FBLOB from type : BLOB,len : 2147483647,dec : 0,not null : false,default : |<null>|

13:50:25 2012-03-12 dbs-Info: J2EE_CONFIGENTRY modify column FBLOB to type : BLOB,len : 0,dec : 0,not null : false,default : |<null>|

13:50:25 2012-03-12 db6-Info: table J2EE_CONFIGENTRY contains data

E R R O R ******* (DbDeployConfig dev 14.09.2010 16:00:00)

13:50:25 2012-03-12 dbs-Error: Refuse due to data loss in column VBYTES

13:50:25 2012-03-12 dbs-Info: ColumnsAction = REFUSE, IndexesAction = null, PrimaryKeyAction = null

E R R O R ******* (DbTableModificationAnalyser dev 14.09.2010 16:00:00)

13:50:25 2012-03-12 dbs-Error: Modification is refused for J2EE_CONFIGENTRY see note 1383461

E R R O R ******* (DbTableModificationAnalyser dev 14.09.2010 16:00:00)

13:50:25 2012-03-12 dbs-Error: Stack trace: com.sap.dictionary.database.dbs.JddRuntimeException: Modification is refused for J2EE_CONFIGENTRY see note 1383461

at com.sap.dictionary.database.dbs.DbTableModificationAnalyser.defineAction(DbTableModificationAnalyser.java:284)

at com.sap.dictionary.database.dbs.DbTableModificationAnalyser.analyseTable(DbTableModificationAnalyser.java:92)

at com.sap.dictionary.database.dbs.DbTableModificationAnalyser.analyse(DbTableModificationAnalyser.java:68)

at com.sap.dictionary.database.dbs.DbModificationController.analyse(DbModificationController.java:456)

at com.sap.dictionary.database.dbs.DbModificationController.distribute(DbModificationController.java:393)

at com.sap.dictionary.database.dbs.DbModificationController.distribute(DbModificationController.java:384)

at com.sap.dictionary.database.dbs.DbModificationController.distribute(DbModificationController.java:262)

at com.sap.engine.services.dbcontainer.lib.DBDeployLibImpl.deployDbSchemaInternal(DBDeployLibImpl.java:160)

at com.sap.engine.services.dbcontainer.lib.DBDeployLibImpl.deployDbSchema(DBDeployLibImpl.java:123)

at com.sap.engine.services.dc.cm.deploy.offline_phase.impl.ExternalDbDeployLibWrapper.deployDbSchema(ExternalDbDeployLibWrapper.java:96)

at com.sap.engine.services.dc.cm.deploy.offline_phase.impl.JddOfflinePhaseDeployProcessor.doProcess(JddOfflinePhaseDeployProcessor.java:43)

at com.sap.engine.services.dc.cm.deploy.offline_phase.impl.AbstractOfflinePhaseDeployProcessor$ProcessorHelper.visit(AbstractOfflinePhaseDeployProcessor.java:128)

at com.sap.engine.services.dc.cm.deploy.impl.DeploymentItemImpl.accept(DeploymentItemImpl.java:84)

at com.sap.engine.services.dc.cm.deploy.offline_phase.impl.AbstractOfflinePhaseDeployProcessor.doProcess(AbstractOfflinePhaseDeployProcessor.java:45)

at com.sap.engine.services.dc.cm.deploy.offline_phase.impl.AbstractWorkflowStrategyDeployer.doDeploy(AbstractWorkflowStrategyDeployer.java:51)

at com.sap.engine.services.dc.cm.deploy.offline_phase.impl.NormalStrategyDeployer.deploy(NormalStrategyDeployer.java:47)

at com.sap.engine.services.dc.cm.deploy.offline_phase.impl.OfflinePhaseDeployerImpl.deploy(OfflinePhaseDeployerImpl.java:48)

at com.sap.engine.services.dc.cm.offline_phase.impl.OfflinePhaseProcessorImpl.process(OfflinePhaseProcessorImpl.java:92)

at com.sap.engine.services.dc.cm.offline_phase.Runner.run(Runner.java:55)

at com.sap.engine.services.dc.cm.offline_phase.Runner.main(Runner.java:78)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:162)

E R R O R ******* (DbTableModificationAnalyser dev 14.09.2010 16:00:00)

13:50:25 2012-03-12 dbs-Error: Table J2EE_CONFIGENTRY could not be analysed

Thanks in Advance. Please help ASAP.

[JPReyes]

I not sure if this will help, but check SAP Note 1675832

If this doesn't help maybe you should post your question under http://scn.sap.com/community/db2-for-linux-unix-windows

Regards, Juan