Hi.

We now update our SDP distrib (OS linux without X server) from 7605 to latest build. To do this we sequentially applied service packs as described by http://www.manageengine.com/products/service-desk/migration-sequence.html. The latest successful update was from 8000 to 8027.

Update from 8027 to 8100 fails with errors. First of them are identical.

24.05.2012 9:50:30  [SYSERR]  [INFO] : com.adventnet.persistence.DataAccessException: [ViewConfiguration_PIDX] Exception occured while inserting rows
24.05.2012 9:50:30  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.createDataAccessException(DataAccess.java:2547)
...

24.05.2012 9:50:30  [SYSERR]  [INFO] : Caused by: java.sql.BatchUpdateException: null,  message from server: "Duplicate entry 'GroupListView-ViewConfiguration' for
 key 1"
24.05.2012 9:50:30  [SYSERR]  [INFO] :

24.05.2012 9:50:30  [SYSERR]  [INFO] :  at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1401)

Then updateManager tries to stop DB and writes another error

24.05.2012 9:50:36  [com.adventnet.persistence.DefaultPostProcessor]  [INFO] : Getting out of DefaultPostProcessor
24.05.2012 9:50:37  [com.adventnet.tools.update.installer.RevertPatch]  [INFO] : Uninstalling post invocation classes
24.05.2012 9:50:37  [com.adventnet.tools.update.installer.RevertPatch]  [INFO] : Executing class:com.adventnet.servicedesk.updatemgr.util.SDPostProcessorUpd
24.05.2012 9:50:37  [com.adventnet.servicedesk.updatemgr.util.SDPostProcessorUpd]  [SEVERE] :  Inside SDPostProcessorUpd.
24.05.2012 9:50:38  [com.adventnet.tools.update.installer.RevertPatch]  [SEVERE] : ERR:Exception in post invocation.java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.adventnet.tools.update.installer.RevertPatch.revertPostInvocationClasses(RevertPatch.java:510)
        at com.adventnet.tools.update.installer.Unzipper.failureRevertAbsolute(Unzipper.java:544)
        at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1434)
        at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1238)
        at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
        at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.awt.HeadlessException:
No X11 DISPLAY variable was set, but this program performed an operation which requires it.
        at java.awt.GraphicsEnvironment.checkHeadless(Unknown Source)
        at java.awt.Window.<init>(Unknown Source)
        at java.awt.Frame.<init>(Unknown Source)
        at java.awt.Frame.<init>(Unknown Source)
        at javax.swing.SwingUtilities$SharedOwnerFrame.<init>(Unknown Source)
        at javax.swing.SwingUtilities.getSharedOwnerFrame(Unknown Source)
        at javax.swing.JOptionPane.getRootFrame(Unknown Source)
        at javax.swing.JOptionPane.showOptionDialog(Unknown Source)
        at javax.swing.JOptionPane.showMessageDialog(Unknown Source)
        at javax.swing.JOptionPane.showMessageDialog(Unknown Source)
        at javax.swing.JOptionPane.showMessageDialog(Unknown Source)
        at com.adventnet.servicedesk.updatemgr.util.SDPostProcessorUpd.revert(SDPostProcessorUpd.java:101)
        ... 11 more

Please note, that we run updateManager.sh with -c key as we don't use X server ...

Finally updateManager copies some files, writes another error and exits

24.05.2012 9:53:10  [com.adventnet.tools.update.installer.RevertPatch]  [INFO] : Executing class:class com.adventnet.servicedesk.updatemgr.util.SDPreProcessor
24.05.2012 9:53:10  [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor]  [SEVERE] :  Inside SDPreProcessor.
24.05.2012 9:53:10  [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor]  [INFO] : P--->{version=8.0.0, patchversion=AdventNet_ManageEngine_ServiceDesk_Plus-8
.0.0-SP-1.0.0, previousversion=AdventNet_ManageEngine_ServiceDesk_Plus-7.6.0-SP-2.0.0, context=SERVICEDESK, product=AdventNet ManageEngine ServiceDesk Plus, mode=f
alse, home=/usr/local/SD/ServiceDesk_8100/ServiceDesk}
24.05.2012 9:53:10  [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor]  [INFO] : INFO mesaage --->Unable to start the DB. Possibly server is running if so P
lease shutdown the server
                     (or)
Previous upgrade is failed and the message for the same will be displayed in the Command Prompt.
24.05.2012 9:53:10  [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor]  [INFO] : INFO mode --->false
24.05.2012 9:53:10  [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor]  [INFO] : INFO messageType --->showMessageDialog