Failure in upgrade (8027-8100)
Dear Support team
Greeting
Please help
I am having problem in upgrading SD from 8027 to 8100. I got this message when I reached 99% of the upgrade process " Failure, Please check the link"
I went through rollback procedures and was successfully back to operation with the previous version. I do not know what was wrong.
The following are the last output from the log file (Please help!)
ep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at java.lang.reflect.Method.invoke(Unknown Source)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1406)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1238)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at java.lang.Thread.run(Unknown Source)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] : Caused by: java.sql.SQLException: null, message from server: "Duplicate entry 'Software' for key 2"
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.db.api.RelationalAPI.handleException(RelationalAPI.java:684)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:659)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2157)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
... 17 more
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] : Caused by: java.sql.BatchUpdateException: null, message from server: "Duplicate entry 'Software' for key 2"
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1401)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at org.enhydra.jdbc.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:410)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:655)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
... 18 more
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [INFO] : Closing the statements and connection
Sep 12, 2012 7:26:58 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : appDO :: [<WritableDataObject>
<Tables>
[Application] </Tables>
SelectQuery Object:
Select columnNames=[Application.APPLICATIONNAME, Application.DESCRIPTION, Application.URL, Application.FILENAME, Application.LOADCLIENTMODULES, Application.STATUS, Application.STARTUP, Application.DEPWEIGHT]
Criteria=(Application.APPLICATIONNAME = 'ServerContainer')
Number of Objects=0
Starting row=1
Order by columnNames=[]
Table List=[Application AS Application]
Joins=
SetLock= false
<JoinsInDO>
</JoinsInDO>
<Operations>
<UPDATE><Application_PK APPLICATIONNAME="ServerContainer"/></UPDATE>
</Operations>
<Rows>
<Application APPLICATIONNAME="ServerContainer" DESCRIPTION="Server Container Application - Contains all the framework modules" URL="file:/C:/ManageEngine/ServiceDesk/applications/AdventNetServerContainer.eear" FILENAME="AdventNetServerContainer.eear" LOADCLIENTMODULES="false" STATUS="PPM_FAILURE" STARTUP="WARM" DEPWEIGHT="0" />
</Rows>
</WritableDataObject>
]
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] : com.adventnet.persistence.DataAccessException: [CIType] Exception occured while inserting rows
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.persistence.DataAccess.createDataAccessException(DataAccess.java:2547)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2191)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.persistence.DataAccess.add(DataAccess.java:266)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.persistence.DataAccess.add(DataAccess.java:222)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.createNonCITypeNames(SDPostProcessor.java:2004)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.createNonCITypeNames(SDPostProcessor.java:1926)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.migrateAEDataToCMDB(SDPostProcessor.java:1818)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.updateCMDBChanges(SDPostProcessor.java:1697)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:181)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.persistence.DefaultPostProcessor.install(Unknown Source)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at java.lang.reflect.Method.invoke(Unknown Source)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1406)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1238)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at java.lang.Thread.run(Unknown Source)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] : Caused by: java.sql.SQLException: null, message from server: "Duplicate entry 'Software' for key 2"
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.db.api.RelationalAPI.handleException(RelationalAPI.java:684)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:659)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2157)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
... 17 more
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] : Caused by: java.sql.BatchUpdateException: null, message from server: "Duplicate entry 'Software' for key 2"
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1401)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at org.enhydra.jdbc.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:410)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:655)
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
... 18 more
Sep 12, 2012 7:26:58 PM [SYSERR] [INFO] :
Sep 12, 2012 7:26:58 PM [com.adventnet.updatemgr.util.ConfUtils] [INFO] : dbadapter :: [com.adventnet.db.adapter.mysql.MysqlDBAdapter@18a92e7], startDBServer :: [true], dbProp :: {Password=null, ConnectionProperties=useUnicode=true
characterEncoding=UTF-8
, TransactionIsolation=TRANSACTION_READ_COMMITTED, DriverClass=org.gjt.mm.mysql.Driver, UserName=root, ConnectionURL=jdbc:mysql://localhost:33366/servicedesk}
Sep 12, 2012 7:26:58 PM [com.adventnet.db.adapter.mysql.MysqlDBAdapter] [INFO] : connectionURL :: [jdbc:mysql://localhost:33366/servicedesk], userName :: [root], password :: [null]
Sep 12, 2012 7:26:58 PM [com.adventnet.db.adapter.mysql.MysqlDBAdapter] [INFO] : Stopping MySQL Server ...
Sep 12, 2012 7:26:58 PM [com.adventnet.db.adapter.DBInitializer] [INFO] : Command to stop DB server [cmd, /c, .\\bin\stopDB.bat, 33366, root]
Sep 12, 2012 7:26:58 PM [com.adventnet.updatemgr.util.ConfUtils] [INFO] : waitAfterDBStop :: val :: [60]
Sep 12, 2012 7:26:58 PM [com.adventnet.updatemgr.util.ConfUtils] [INFO] : Thread is going to sleep for [60] seconds
Sep 12, 2012 7:27:58 PM [com.adventnet.updatemgr.util.ConfUtils] [INFO] : Coming out of stopDB
Sep 12, 2012 7:27:58 PM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Getting out of DefaultPostProcessor
Sep 12, 2012 7:28:00 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : Uninstalling post invocation classes
Sep 12, 2012 7:28:00 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : Executing class:com.adventnet.servicedesk.updatemgr.util.SDPostProcessor
Sep 12, 2012 7:28:00 PM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [SEVERE] : Inside SDPostProcessor.
Sep 12, 2012 7:28:00 PM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [INFO] : INFO mesaage --->Failure , Please check the link
Sep 12, 2012 7:28:00 PM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [INFO] : INFO mode --->true
Sep 12, 2012 7:28:00 PM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [INFO] : INFO messageType --->showMessageDialog