ackup\backup_mysql_8121_fullbackup_07_20_2014_14_45.data

********************************************************************************

                         Restore DB Setup Wizard

********************************************************************************

FYI [SEVERE]: Please don't kill this utility until the operation is completed

5/8/2014 7:56:10 com.adventnet.servicedesk.server.utils.SDDataManager setStandAl one

INFO: Going to set the standAlone param as : true

5/8/2014 7:56:10 com.adventnet.servicedesk.server.utils.SDDataManager setStandAl one

INFO: Going to reset rootDir using server.dir

5/8/2014 7:56:10 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: rootDir :: .

5/8/2014 7:56:10 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: netutilsData :: {RELEASE={version=8.1.0}, BUILD={number=8121}}

5/8/2014 7:56:10 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser

viceDesk Plus}, ADMANAGER={name=ADManager}}

5/8/2014 7:56:10 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: architectureData :: {ARCHITECTURE={version=32}}

Extracting backup file....

Please wait extracting backup file

Replacing for Mysql 5.1.50

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils changeDocType

INFO: Entering changeDocType

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils changeDocType

INFO: publicChanged :: false

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils changeDocType

INFO: Does not contain SYSTEM in the line

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils changeDocType

INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils changeDocType

INFO: Finally publicChanged :: false

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils changeDocType

INFO: public ID not there in datasource-configuration.xml

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils changeDocType

INFO: Exiting changeDocType

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB

INFO: extractLocation : file:/D:/ManageEngine/ServiceDesk/applications/extracted /

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB

INFO: startDBServer :: [true]

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB

INFO: jndiName :: [MySqlDS]

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB

INFO: setdbhomearg set in mappings.xml :: [null]

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB

INFO: Final setdbhomearg :: [false]

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB

INFO: properties sent to adapter initialization :: {jndiname=MySqlDS, name=mysql

, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mysql.MysqlSQLGenera

tor}

5/8/2014 7:56:17 com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB

INFO: db.home :: [.\mysql] finally

5/8/2014 7:56:18 com.adventnet.updatemgr.util.ConfUtils initDataAccess

INFO: connectionProperties :: [useUnicode=true

characterEncoding=UTF-8 ]

5/8/2014 7:56:18 com.adventnet.updatemgr.util.ConfUtils initDataAccess

INFO: url :: [jdbc:mysql://localhost:33366/servicedesk?&useUnicode=true&characte

rEncoding=UTF-8]

Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mysql.My

sqlSQLGenerator javax.naming.NoInitialContextException: Need to specify class na

me in environment or system property, or as an applet parameter, or in an applic

ation resource file:  java.naming.factory.initial

5/8/2014 7:56:20 com.adventnet.db.adapter.DBInitializer startDBServer

INFO: Command to start DB server [cmd, /c, ".\bin\startDB.bat", 33366]

140805  7:56:20 [Warning] '--default-character-set' is deprecated and will be re

moved in a future release. Please use '--character-set-server' instead.

Active DB Server = mysql

Database connectionProp : useUnicode=true

characterEncoding=UTF-8

Database started

*************************************************************.\backup_info.xml

         Backpup data    : Sun Jul 20 14:45:02 EEST 2014

         Database name   : servicedesk

         Total Tables    : 1178

         Database Server : mysql

         Build Number    : 8121

*************************************************************

Please wait ! Deleting table data in Progress..

0-----------------------50------------------------100(%)

===================================================

Error Tables : wordmap,wordoccurrences

0-----------------------50------------------------100(%)

Please wait ! Restoring in Progress...................

Error Tables : wordmap,wordoccurrences

0-----------------------50------------------------100(%)

=================================QUERY = INSERT INTO SoftwareManufacturer (SWMAN

UFACTURERID,NAME,CREATEDBY,SUPPORTDEFLICENSETYPES,DESCRIPTION) VALUESnull

java.sql.BatchUpdateException: null,  message from server: "Duplicate entry '¦Ю¦

Ю¦Ю '¦Ы¦Ш¦У¦Р ¦Ч¦Р¦Ъ¦Ю¦Э' for key 'SoftwareManufacturer_UK1'"

        at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)

        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest

oreSDBackup.java:749)

        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto

reSDBackup.java:279)

        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.

java:131)

        at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java

:319)

java.sql.BatchUpdateException: null,  message from server: "Duplicate entry '¦Ю¦

Ю¦Ю '¦Ы¦Ш¦У¦Р ¦Ч¦Р¦Ъ¦Ю¦Э' for key 'SoftwareManufacturer_UK1'"

        at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)

        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest

oreSDBackup.java:749)

        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto

reSDBackup.java:279)

        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.

java:131)

        at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java

:319)

Unable to restore database : null,  message from server: "Duplicate entry '¦Ю¦Ю¦

Ю '¦Ы¦Ш¦У¦Р ¦Ч¦Р¦Ъ¦Ю¦Э' for key 'SoftwareManufacturer_UK1'"

null,  message from server: "Duplicate entry '¦Ю¦Ю¦Ю '¦Ы¦Ш¦У¦Р ¦Ч¦Р¦Ъ¦Ю¦Э' for k

ey 'SoftwareManufacturer_UK1'"

5/8/2014 8:02:15 com.adventnet.updatemgr.util.ConfUtils stopDB

INFO: dbadapter :: [com.adventnet.db.adapter.mysql.MysqlDBAdapter@1c888d9], star

tDBServer :: [true], dbProp :: {BlockingTimeoutMillis=30000, ManagedConnectionFa

ctoryProperties=

, Criteria=ByContainer, LocalTransactions=true, MinSize=0, Password=, JndiName=M

ySqlDS, MaxSize=20, SecurityDomainJndiName=DBPwdEncrypt, DriverClass=org.gjt.mm.

mysql.Driver, TransactionIsolation=TRANSACTION_READ_COMMITTED, ConnectionPropert

ies=useUnicode=true

characterEncoding=UTF-8

, TrackConnectionByTx=true, UserName=root, IdleTimeoutMinutes=15, ConnectionURL=

jdbc:mysql://localhost:33366/servicedesk}

5/8/2014 8:02:15 com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownDB

INFO: connectionURL :: [jdbc:mysql://localhost:33366/servicedesk], userName :: [

root], password :: []

5/8/2014 8:02:15 com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownDB

INFO: Stopping MySQL Server ...

5/8/2014 8:02:15 com.adventnet.db.adapter.DBInitializer stopDBServer

INFO: Command to stop DB server [cmd, /c, .\bin\stopDB.bat, 33366, root, ]

5/8/2014 8:02:15 com.adventnet.updatemgr.util.ConfUtils stopDB

INFO: waitAfterDBStop :: val :: [5]

5/8/2014 8:02:15 com.adventnet.updatemgr.util.ConfUtils stopDB

INFO: Thread is going to sleep for [5] seconds

5/8/2014 8:02:20 com.adventnet.updatemgr.util.ConfUtils stopDB

INFO: Coming out of stopDB

D:\ManageEngine\ServiceDesk\bin>run.bat

===============================================================================

.   JBoss Bootstrap Environment

.   JBOSS_HOME: D:\ManageEngine\ServiceDesk\bin\\..

.   JAVA: .\..\jre\bin\java

.   JAVA_OPTS:  -Dserver.dir=D:\ManageEngine\ServiceDesk\bin\\.. -Dprogram.name=ru

n.bat -Djboss.server.type=com.adventnet.j2ee.deployment.system.AdventNetServerIm

pl -Djboss.boot.library.list=log4j-boot.jar,jboss-common.jar,jboss-system.jar,Ad

ventNetDeploymentSystem.jar,commons-logging.jar -Dsdp.java.gc=false -Xms128m -Xm

x512m -XX:PermSize=64m -XX:MaxPermSize=128m  -Ddb.home=.\..\mysql -Dorg.jboss.lo

gging.Log4jService.catchSystemOut=false -Dorg.jboss.logging.Log4jService.catchSy

stemErr=false -Djava.util.logging.manager=com.adventnet.logging.LogManager -Djav

a.util.logging.config.file="D:\ManageEngine\ServiceDesk\bin\\..\server\default\c

onf\logging.xml" -Djava.util.logging.config.class=com.adventnet.logging.LoggingS

canner -Dlog.dir="D:\ManageEngine\ServiceDesk\bin\\..\server\default" -Djava.lib

rary.path="D:\ManageEngine\ServiceDesk\bin\\..\lib\native;D:\ManageEngine\Servic

eDesk\bin\\..\lib;D:\ManageEngine\ServiceDesk\bin\\..\bin" -Dtier-type=BE -Dtier

-id=BE1 -Dfile.encoding=UTF-8 -Duser.language=en -Duser.region=US -Dstart.type=c

ommand

.

  CLASSPATH: .\..\jre\lib\tools.jar;D:\ManageEngine\ServiceDesk\bin\\run.jar;D:\

ManageEngine\ServiceDesk\bin\\..\lib\AdventNetLogging.jar;D:\ManageEngine\Servic

eDesk\bin\\..\lib\AdventNetNPrevalent.jar;D:\ManageEngine\ServiceDesk\bin\\..\li

b;D:\ManageEngine\ServiceDesk\bin\\..\lib\AdventNetUpdateManagerInstaller.jar

===============================================================================

Не удается найти D:\ManageEngine\ServiceDesk\bin\jndi.properties

Server is starting. This may take a minute ...

This copy is licensed to DHL Freight  DHL Logistics Ukraine

Failed to start the server. Please refer logs for more details

D:\ManageEngine\ServiceDesk\bin>