Hello,
We are facing errors while importing the database of 7.2 to new ARIS 9.7. The import process runs for many hours and then throws the following error
Unable to import database. Restore error: Migration of V72 database <database name> failed: com.sag.aris.cip.api.CipException: error during mutation
The backend database for the ARIS installation is Oracle. We are able to create new databases in ARIS but are not able to import any of the old version databases.
If anyone has faced the same issue, it would be great if you share your experience and resolution on this.
Regards,
Amol Patil
I just collected more information on this from the log files
2015-04-24T18:54:05,599 com.sag.aris.cip.api.CipException: error during mutation at com.sag.aris.cip.impl.hib.HibMutator.execute(HibMutator.java:577) at com.sag.aris.cip.impl.hib.HibDelegateOnExecuteMutator.execute(HibDelegateOnExecuteMutator.java:40) at com.sag.aris.cip.impl.hib.HibWorkingAreaOrArchiveAreaMutator.execute(HibWorkingAreaOrArchiveAreaMutator.java:33) at com.sag.aris.cip.impl.hib.HibCopingWithStaleObjectsMutator.execute(HibCopingWithStaleObjectsMutator.java:43) at com.aris.modeling.server.dao.aris.impl.cipbased.AWriterDAO.writeDTO(AWriterDAO.java:144) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.writeDTOs(ADataMigrationServiceBase.java:2284) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.handleNewDTOs(ADataMigrationServiceBase.java:1895) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.migrateDataRecords(ADataMigrationServiceBase.java:1766) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.migrateEntry(ADataMigrationServiceBase.java:1604) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.migrateEntries(ADataMigrationServiceBase.java:1398) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.migrateWorkingAreaData(ADataMigrationServiceBase.java:1374) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.migrateDBImpl(ADataMigrationServiceBase.java:1118) at com.aris.modeling.server.services.datamigration.common.ADataMigrationServiceBase.migrateDB(ADataMigrationServiceBase.java:1040) at com.aris.modeling.server.bl.admin.logic.AServerAdminImpl.migrateDB(AServerAdminImpl.java:1118) at com.aris.modeling.server.bl.admin.logic.AServerAdminImpl._restoreDb(AServerAdminImpl.java:955) at com.aris.modeling.server.bl.admin.logic.AServerAdminImpl.restoreDb(AServerAdminImpl.java:936) at com.aris.modeling.server.bl.components.serveradmin.AServerAdmin$ARestoreAction.run(AServerAdmin.java:805) at com.aris.modeling.server.common.AServerTaskRunnable.run(AServerTaskRunnable.java:28) at java.lang.Thread.run(Thread.java:745) Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3240) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3138) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3468) at org.hibernate.internal.StatelessSessionImpl.update(StatelessSessionImpl.java:192) at com.sag.aris.cip.impl.hib.hibernate.HibDataStore.updateRows(HibDataStore.java:137) at com.sag.aris.cip.impl.hib.HibRowSaver.saveIndexRows(HibRowSaver.java:286) at com.sag.aris.cip.impl.hib.MergedIndexRowVersionStrategy.saveModifiedIndexRows(MergedIndexRowVersionStrategy.java:68) at com.sag.aris.cip.impl.hib.MergedIndexRowVersionStrategy.processAndWriteIndexRows(MergedIndexRowVersionStrategy.java:35) at com.sag.aris.cip.impl.hib.HibMutator.writeModifiedRowsToDatabase(HibMutator.java:766) at com.sag.aris.cip.impl.hib.HibMutator.executeNormalBatchOperations(HibMutator.java:1057) at com.sag.aris.cip.impl.hib.HibMutator.execute(HibMutator.java:553) ... 18 more Caused by: java.sql.SQLException: ORA-22922: nonexistent LOB value at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) ... 29 more
Regards,
Amol Patil
Hi Amol,
I also faced same issue. That was due to Oracle DBMS (tablespace) size was almost full.
Check your Oracle DBMS tablespace free size. Your Oracle DBMS administrator can also set auto-extend parameter of tablespace, so that whenever migration needs more oracle tablespace, Oracle DBMS will automatically extend it.
One important thing is : Migration from ARIS 7.2 to ARIS 9.x will consume lot of space in Oracle BDMS... for my migration of adb (size approx 40 MB), it consumed approx 5 GB in Oracle DB. Again it is depends on numbers of versions in your adb...More numbers of version in adb requires more space in DBMS. Migration process treats version as a separate DB for migration, so make sure you have very good free space in DBMS.
How much is the adb file size your are trying to migrate?
//yubhesh
Hi Yubhesh,
Yes, might be the reason. The database backup size for Design DB is 540MB and Release DB is around 250MB. I will check with DBA and will analyze the trace logs.
We had similar situation with ARIS using MS SQL as backend database system. Import of 500MB database almost took 45GB SQL database space and the internal tempDB expanded upto 120GB. But in that case the error message was proper.
Thanks, I will post my findings on this.
Regards,
Amol Patil
Hi Yubhesh,
Yes, as guessed, the tablespace is completely filled up. We have requested to increase the size by 500GB. I think it should be sufficient. Once we get the increased space, I think the import should run fine.
Thank you very much for your help.
Regards,
Amol Patil
Hi Yubhesh,
This dosen't seems to be tablespace issue. We increased the ARISDATA to 500GB, and TEMP to 300GB, still the error occurs. I did some testing, and it successfully import small databases, even the big one, if I break it into multiple small databases, the import runs fine. But fails to import the complete database.
My guess is that Oracle runs in some errors while handling huge amount of data. Do you know any performance improvement tips for ARIS-Oracle. The required oracle settings are also not properly document in the ARIS official admin documents.
Regards,
Amol Patil