Microsoft Windows [Версия 6.0.6001]
(C) Корпорация Майкрософт, 2006. Все права защищены.
D:\>cd ManageEngine\ServiceDesk\bin
D:\ManageEngine\ServiceDesk\bin>restoreData.bat d:\ManageEngine\ServiceDesk\back
up\backup_mysql_8121_fullbackup_07_20_2014_14_45.data
********************************************************************************
*
Restore DB Setup Wizard
********************************************************************************
*
Execute Restore DB Utility from command prompt
For Windows users :
bin>restoreData -c [backup file]
For Linux users :
bin]#sh restoreData.sh -c [backup file]
********************************************************************************
*
5/8/2014 7:54:15 com.adventnet.servicedesk.server.utils.SDDataManager setStandAl
one
INFO: Going to set the standAlone param as : true
5/8/2014 7:54:15 com.adventnet.servicedesk.server.utils.SDDataManager setStandAl
one
INFO: Going to reset rootDir using server.dir
D:\ManageEngine\ServiceDesk\bin>restoreData.bat -c d:\ManageEngine\ServiceDesk\b
ackup\backup_mysql_8121_fullbackup_07_20_2014_14_45.data
********************************************************************************
*
Restore DB Setup Wizard
********************************************************************************
*
Execute Restore DB Utility from command prompt
For Windows users :
bin>restoreData -c [backup file]
For Linux users :
bin]#sh restoreData.sh -c [backup file]
********************************************************************************
*
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>