Dear support team,

I’m writing regarding problems we faced during servicedesk upgrade. Actually we are using  8.2.0    Build   8217 and we planned to go through 9.0 build 9020.  We have successfully installed service pack in test environment where database  and application are in one server.

In Production we have separated servers for database and application.

Trying to install the first service pack we faced error like in the attached screen. We try to make a rollback using your advices for rollback of upgrade during installation but was impossible to restore full backup.

After that,  we restore a application server snapshot a make a new uninstall , install and connect the application with the SQL database.

Before restoring snapshot I only saved error log from update.log, below is part of the error.

ep 10, 2014 6:14:20 PM  [com.adventnet.persistence.DefaultDDUpdator]  [WARNING] : DDFile [./eeartemp/applications/AdventNetServiceDesk.eear/AdventNetHelpDesk.ear/conf/data-dictionary.xml] Not found.

Sep 10, 2014 6:14:20 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : Entering changeDocType

Sep 10, 2014 6:14:20 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : publicChanged :: false

Sep 10, 2014 6:14:20 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : written the file :: [server\default\conf\datasource-configuration.xml_tmp]

Sep 10, 2014 6:14:20 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : Finally publicChanged :: false

Sep 10, 2014 6:14:20 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : public ID not there in datasource-configuration.xml

Sep 10, 2014 6:14:20 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : Exiting changeDocType

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : extractLocation : file:/C:/ManageEngine/ServiceDesk/applications/extracted/

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : startDBServer :: [true]

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : jndiName :: [MSSQLDS]

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : setdbhomearg set in mappings.xml :: [false]

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : Final setdbhomearg :: [false]

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mssql.MssqlSQLGenerator}

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : db.home :: [C:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : connectionProperties :: [null]

Sep 10, 2014 6:14:21 PM  [com.adventnet.updatemgr.util.ConfUtils]  [INFO] : url :: [jdbc:jtds:sqlserver://bkt-servicedesk-db:1433;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;]

Sep 10, 2014 6:14:21 PM  [com.adventnet.db.adapter.Jdbc20DBAdapter]  [INFO] : AUTO_QUOTE_IDENTIFIER value : false

Sep 10, 2014 6:14:21 PM  [com.adventnet.db.adapter.Jdbc20DBAdapter]  [WARNING] : AUTO_QUOTE_IDENTIFIERS not supported for this DB...

Sep 10, 2014 6:14:21 PM  [SYSERR]  [INFO] : Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.MssqlSQLGenerator javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial

Sep 10, 2014 6:14:21 PM  [SYSERR]  [INFO] :

Please give some advice what have cause the error of installation and why restoring a huge database it is impossible?