API tools faq
paste
rabusiak

upgrade error

rabusiak
Jul 10th, 2019
554
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.58 KB | None | 0 0
raw download clone embed print report
  1. c:\ManageEngine\ServiceDesk\bin>restoreData.bat
  2. *********************************************************************************
  3. Restore DB Setup Wizard
  4. *********************************************************************************
  5.  
  6. Execute Restore DB Utility from command prompt
  7.  
  8. For Windows users :
  9. bin>restoreData -c [backup file]
  10.  
  11. For Linux users :
  12. bin]#sh restoreData.sh -c [backup file]
  13.  
  14. *********************************************************************************
  15. lip 10, 2019 12:27:11 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
  16. INFO: Going to set the standAlone param as : true
  17. lip 10, 2019 12:27:11 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
  18. INFO: Going to reset rootDir using server.dir
  19. lip 10, 2019 12:27:13 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
  20. INFO: rootDir :: .\
  21. lip 10, 2019 12:27:13 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
  22. INFO: netutilsData :: {RELEASE={version=9.4}, BUILD={number=9406}}
  23. lip 10, 2019 12:27:13 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
  24. INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager Plus}}
  25. You chose to open this file: C:\ManageEngine\ServiceDesk\backup\backup_mssql_9406_fullbackup_07_09_2019_14_50\backup_mssql_9406_fullbackup_07_09_2019_14_50_part_1.data
  26. File name is : C:\ManageEngine\ServiceDesk\backup\backup_mssql_9406_fullbackup_07_09_2019_14_50\backup_mssql_9406_fullbackup_07_09_2019_14_50_part_1.data
  27. lip 10, 2019 12:27:28 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
  28. INFO: Going to set the standAlone param as : true
  29. lip 10, 2019 12:27:28 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
  30. INFO: Going to reset rootDir using server.dir
  31. lip 10, 2019 12:27:28 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
  32. INFO: rootDir :: .\
  33. lip 10, 2019 12:27:28 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
  34. INFO: netutilsData :: {RELEASE={version=9.4}, BUILD={number=9406}}
  35. lip 10, 2019 12:27:28 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
  36. INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager Plus}}
  37. Extracting backup file....
  38.  
  39. Please wait extracting backup file
  40. Please wait extracting backup file
  41. Please wait extracting backup file
  42. Please wait extracting backup file
  43. Please wait extracting backup file
  44. lip 10, 2019 12:30:43 PM com.zoho.framework.utils.FileUtils copyFile
  45. INFO: Entered into copyFile :: sourceFile :: [.\conf\SnmpConfigurations.xml], destinationFile :: [.\conf\SnmpConfigurations_1562754643663.xml]
  46. lip 10, 2019 12:30:43 PM com.zoho.framework.utils.FileUtils copyFile
  47. INFO: Entered into copyFile :: sourceFile :: [.\SnmpConfigurations.xml], destinationFile :: [.\conf\SnmpConfigurations.xml]
  48.  
  49. *************************************************************.\\backup_info.xml
  50. Backpup data : Tue Jul 09 14:50:14 CEST 2019
  51. Database name : Servicedesk
  52. Total Tables : 1430
  53. Database Server : mssql
  54. Build Number : 9406
  55. Backupid : 1562676614769
  56. *************************************************************
  57.  
  58. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIdentifierFile
  59. WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
  60. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
  61. INFO: isDBMigration running :: false
  62. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
  63. INFO: isDBMigration dest DB :: false
  64. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
  65. SEVERE: Exception occured while initializing datasource.
  66. lip 10, 2019 12:30:48 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
  67. SEVERE: Encryption failed
  68. Database started
  69. lip 10, 2019 12:30:48 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
  70. INFO: Processing c:\ManageEngine\ServiceDesk\.\conf\product-config.xml
  71. lip 10, 2019 12:30:48 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
  72. INFO: Processing c:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
  73. lip 10, 2019 12:30:48 PM com.zoho.framework.utils.crypto.CryptoUtil setEnDecryptInstance
  74. INFO: Already crypt instance has been set and hence this [com.zoho.framework.utils.crypto.EnDecryptImpl@5e10fe31] is ignored
  75. lip 10, 2019 12:30:48 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
  76. SEVERE: Encryption failed
  77. lip 10, 2019 12:30:48 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
  78. INFO: Processing c:\ManageEngine\ServiceDesk\.\conf\product-config.xml
  79. lip 10, 2019 12:30:48 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
  80. INFO: Processing c:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
  81. lip 10, 2019 12:30:48 PM com.zoho.framework.utils.crypto.CryptoUtil setEnDecryptInstance
  82. INFO: Already crypt instance has been set and hence this [com.zoho.framework.utils.crypto.EnDecryptImpl@5b7b1176] is ignored
  83. lip 10, 2019 12:30:48 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
  84. SEVERE: Encryption failed
  85. lip 10, 2019 12:30:48 PM com.adventnet.persistence.PersistenceInitializer getDBParamsFilePath
  86. INFO: Reading .\conf\database_params.conf
  87. lip 10, 2019 12:30:48 PM com.adventnet.ds.DefaultDataSourcePlugIn initialize
  88. INFO: ConnectionPoolParams :: minSize :: [1], maxSize :: [20], idleTimeout :: [15 milliseconds], blockingTimeout :: [30 000 milliseconds]
  89. lip 10, 2019 12:30:48 PM com.adventnet.ds.DefaultDataSourcePlugIn getDataSource
  90. INFO: DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@1526c3d4
  91. lip 10, 2019 12:30:48 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
  92. INFO: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter
  93. lip 10, 2019 12:30:48 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
  94. INFO: Storage Adapter class ::: null
  95. lip 10, 2019 12:30:48 PM com.adventnet.db.api.RelationalAPI <clinit>
  96. SEVERE: haltjvm.on.dbcrash is set to [false]
  97. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter getShutDownStrings
  98. INFO: shutDownStrings :: []
  99. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
  100. INFO: Loading the function patterns from the file :: [.\conf\Persistence\mssql_functionpatterns.txt]
  101. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIdentifierFile
  102. WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
  103. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
  104. INFO: isDBMigration running :: false
  105. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
  106. INFO: isDBMigration dest DB :: false
  107. lip 10, 2019 12:30:48 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
  108. SEVERE: Encryption failed
  109. lip 10, 2019 12:30:48 PM com.adventnet.persistence.PersistenceInitializer initializeRelationalAPI
  110. INFO: DataSourcePlugIn is initialized successfully
  111. lip 10, 2019 12:30:48 PM com.adventnet.persistence.PersistenceInitializer createDestinationDataBase
  112. INFO: create.db is :: null
  113. lip 10, 2019 12:30:48 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
  114. INFO: Template replaced url :: jdbc:jtds:sqlserver://localhost:1433;DatabaseName=servicedesk_new;charset=utf-8
  115. log4j:WARN No appenders could be found for logger (org.jboss.resource.connectionmanager.IdleRemover).
  116. log4j:WARN Please initialize the log4j system properly.
  117. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
  118. INFO: Incoming collation string is Polish_CI_AS
  119. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
  120. INFO: Collation String constructed is Polish_CS_A%
  121. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
  122. INFO: The Toggle collation string is Polish_CS_AI
  123. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.AbstractRestoreHandler doRestoreSanityTesting
  124. INFO: Restore process fully completed.
  125. lip 10, 2019 12:30:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter getDBProps
  126. INFO: splitConnectionURL :: {DatabaseName=servicedesk_new, Port=1433, url_props_delimiter=;, urlWithoutProps=jdbc:jtds:sqlserver://localhost:1433, jdbcurl_props_separator=;, charset=utf-8, properties={Server=localhost, DatabaseName=servicedesk_new, DBName=localhost:1433, Port=1433, charset=utf-8}, DBName=localhost:1433, Server=localhost, urlProps={DatabaseName=servicedesk_new, charset=utf-8}}
  127. lip 10, 2019 12:30:48 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
  128. INFO: Template replaced url :: jdbc:jtds:sqlserver://localhost:1433;DatabaseName=servicedesk_new;charset=utf-8
  129. lip 10, 2019 12:30:48 PM com.adventnet.db.persistence.metadata.parser.DataDictionaryParser getDataDictionary
  130. INFO: Parsing the File :: file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/meta-dd.xml
  131. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer loadModule
  132. INFO: loaded the module dd :: Persistence
  133. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer initializePersistence
  134. INFO: persURL :: jar:file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/personality-configuration.xml
  135. lip 10, 2019 12:30:49 PM com.adventnet.persistence.xml.XmlParser startDocument
  136. INFO: Going to parse the XML :: [jar:file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/personality-configuration.xml]
  137. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer initializePreprocessor
  138. INFO: No Preprocessor found.
  139. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer loadErrorCodes
  140. INFO: Going to loadErrorCodes :: [c:\ManageEngine\ServiceDesk\.\conf\Persistence\error-codes.xml]
  141. lip 10, 2019 12:30:49 PM com.adventnet.persistence.xml.XmlParser startDocument
  142. INFO: Going to parse the XML :: [file:/c:/ManageEngine/ServiceDesk/./conf/Persistence/error-codes.xml]
  143. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer loadErrorCodes
  144. SEVERE: Already an errorcode [1 217] has been defined, hence over-writing it
  145. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer loadErrorCodes
  146. SEVERE: Already an errorcode [1 451] has been defined, hence over-writing it
  147. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer loadErrorCodes
  148. SEVERE: Already an errorcode [547] has been defined, hence over-writing it
  149. lip 10, 2019 12:30:49 PM com.adventnet.persistence.PersistenceInitializer loadErrorCodes
  150. INFO: ErrorCodes :: {MsSQLErrorCode={207=1011 - ER_WRONG_COLUMN_NAME, 2627=1001 - ER_DUP_ENTRY, 547=1016 - ER_ROW_IS_REFERENCED, 8115=1014 - ER_TOO_BIG_SET, 8114=1017 - ER_WRONG_VALUE_FOR_VAR, 515=1004 - ER_BAD_NULL_ERROR, 110=1008 - ER_WRONG_VALUE_COUNT, 8152=1018 - ER_WARN_DATA_OUT_OF_RANGE, 109=1008 - ER_WRONG_VALUE_COUNT}, AdventNetErrorCode={1032=1032 - ER_MIX_OF_GROUP_FUNC_AND_FIELDS, 1016=1016 - ER_ROW_IS_REFERENCED, 1017=1017 - ER_WRONG_VALUE_FOR_VAR, 1018=1018 - ER_WARN_DATA_OUT_OF_RANGE, 1019=1019 - ER_WRONG_TYPE_FOR_VAR, 1024=1024 - ER_LOCK_WAIT_TIMEOUT, 1008=1008 - ER_WRONG_VALUE_COUNT, 1025=1025 - ER_LOCK_TABLE_FULL, 1010=1010 - ER_WRONG_FIELD_SPEC, 1027=1027 - ER_LOCK_DEADLOCK, 1011=1011 - ER_WRONG_COLUMN_NAME, 1012=1012 - ER_INVALID_DEFAULT, 1013=1013 - ER_NO_DEFAULT, 1014=1014 - ER_TOO_BIG_SET, 1031=1031 - ER_INVALID_GROUP_FUNC_USE, 1015=1015 - ER_NO_REFERENCED_ROW, 1001=1001 - ER_DUP_ENTRY, 1003=1003 - ER_DUPLICATED_VALUE_IN_TYPE, 1005=1005 - ER_INVALID_USE_OF_NULL, 1004=1004 - ER_BAD_NULL_ERROR, 1007=1007 - ER_PRIMARY_CANT_HAVE_NULL, 1006=1006 - ER_WARN_NULL_TO_NOTNULL}, OracleErrorCode={1=1001 - ER_DUP_ENTRY, 12899=1018 - ER_WARN_DATA_OUT_OF_RANGE, 937=1032 - ER_MIX_OF_GROUP_FUNC_AND_FIELDS, 1400=1004 - ER_BAD_NULL_ERROR, 904=1011 - ER_WRONG_COLUMN_NAME, 2292=1015 - ER_NO_REFERENCED_ROW, 934=1031 - ER_INVALID_GROUP_FUNC_USE, 1722=1017 - ER_WRONG_VALUE_FOR_VAR, 1438=1014 - ER_TOO_BIG_SET, 947=1008 - ER_WRONG_VALUE_COUNT}, PgSQLErrorCode={23502=1004 - ER_BAD_NULL_ERROR, 22001=1018 - ER_WARN_DATA_OUT_OF_RANGE, 23503=1015 - ER_NO_REFERENCED_ROW, 22003=1014 - ER_TOO_BIG_SET, 42703=1011 - ER_WRONG_COLUMN_NAME, 23505=1001 - ER_DUP_ENTRY, 42601=1008 - ER_WRONG_VALUE_COUNT, 22P02=1017 - ER_WRONG_VALUE_FOR_VAR}, MySQLErrorCode={1067=1012 - ER_INVALID_DEFAULT, 1217=1016 - ER_ROW_IS_REFERENCED, 1216=1015 - ER_NO_REFERENCED_ROW, 1097=1014 - ER_TOO_BIG_SET, 1263=1006 - ER_WARN_NULL_TO_NOTNULL, 1058=1008 - ER_WRONG_VALUE_COUNT, 1231=1017 - ER_WRONG_VALUE_FOR_VAR, 1230=1013 - ER_NO_DEFAULT, 1062=1001 - ER_DUP_ENTRY, 1063=1010 - ER_WRONG_FIELD_SPEC, 1166=1011 - ER_WRONG_COLUMN_NAME, 1291=1003 - ER_DUPLICATED_VALUE_IN_TYPE, 1048=1004 - ER_BAD_NULL_ERROR, 1171=1007 - ER_PRIMARY_CANT_HAVE_NULL, 1206=1025 - ER_LOCK_TABLE_FULL, 1232=1019 - ER_WRONG_TYPE_FOR_VAR, 1264=1018 - ER_WARN_DATA_OUT_OF_RANGE, 1205=1024 - ER_LOCK_WAIT_TIMEOUT, 1111=1031 - ER_INVALID_GROUP_FUNC_USE, 1451=1016 - ER_ROW_IS_REFERENCED, 1140=1032 - ER_MIX_OF_GROUP_FUNC_AND_FIELDS, 1452=1015 - ER_NO_REFERENCED_ROW, 1138=1005 - ER_INVALID_USE_OF_NULL, 1213=1027 - ER_LOCK_DEADLOCK}}
  151.  
  152.  
  153. Please wait ! Deleting table data in Progress..
  154. 0-----------------------50------------------------100(%)
  155. Invalid object name 'FlexiViewSQL'. : delete from SelectQuery
  156.  
  157. ==================================================
  158. Error occured while deletion of all table
  159. data please see the error log
  160.  
  161.  
  162. Please wait ! Restoring in Progress...................
  163. Error Tables : wordmap,wordoccurrences,errorlog
  164. 0-----------------------50------------------------100(%)
  165. QUERY = INSERT INTO SelectQuery (QUERYID,STARTINDEX,NUMOFOBJECTS) VALUESnull
  166. java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'QUERY_PK'. Cannot insert duplicate key in object 'dbo.SelectQuery'. The duplicate key value is (9).
  167. at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
  168. at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:860)
  169. at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:398)
  170. at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:117)
  171. at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
  172. at java.lang.Thread.run(Unknown Source)
  173. java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'QUERY_PK'. Cannot insert duplicate key in object 'dbo.SelectQuery'. The duplicate key value is (9).
  174. at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
  175. at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:860)
  176. at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:398)
  177. at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:117)
  178. at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
  179. at java.lang.Thread.run(Unknown Source)
  180. Unable to restore database : Violation of PRIMARY KEY constraint 'QUERY_PK'. Cannot insert duplicate key in object 'dbo.SelectQuery'. The duplicate key value is (9).
  181. Violation of PRIMARY KEY constraint 'QUERY_PK'. Cannot insert duplicate key in object 'dbo.SelectQuery'. The duplicate key value is (9).
  182.  
  183. stopping DB Server >>>>> false
  184.  
  185. c:\ManageEngine\ServiceDesk\bin>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!