Failed update from 10.0 Build 10013
I'm using the free version of PSD : 10.0 Build 10013
When updating, it gives a schema error mssql. (There are some inconsistencies in your database schema.Please contact support for further assistance.)
Please any help!
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DBName ::: mssql
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : startDBServer ::: false
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : osString ::: windows server 2012 r2
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : isWindows ::: true
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Data directory change permission steps skipped
17.01.2023 16:57:56 [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing C:\ManageEngine\ServiceDesk\.\conf\product-config.xml
17.01.2023 16:57:56 [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing C:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : Reading .\conf\database_params.conf
17.01.2023 16:57:56 [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : ConnectionPoolParams :: minSize :: [1], maxSize :: [20], idleTimeout :: [15 milliseconds], blockingTimeout :: [5 000 milliseconds]
17.01.2023 16:57:56 [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@51133572
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : Storage Adapter class ::: null
17.01.2023 16:57:56 [com.adventnet.db.api.RelationalAPI] [SEVERE] : haltjvm.on.dbcrash is set to [false]
17.01.2023 16:57:56 [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : shutDownStrings :: []
17.01.2023 16:57:56 [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : Loading the function patterns from the file :: [.\conf\Persistence\mssql_functionpatterns.txt]
17.01.2023 16:57:56 [com.adventnet.db.adapter.Jdbc20DBAdapter] [WARNING] : AUTO_QUOTE_IDENTIFIERS not supported for this DB...
17.01.2023 16:57:56 [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration running :: false
17.01.2023 16:57:56 [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration dest DB :: false
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : DataSourcePlugIn is initialized successfully
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : create.db is :: null
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:jtds:sqlserver://DB-03:1433;DatabaseName=sdtest;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=false;loginTimeout=5;socketTimeout=1200
17.01.2023 16:57:56 [com.adventnet.db.adapter.mssql.MssqlDBAdapter] [INFO] : Incoming collation string is Cyrillic_General_CI_AS
17.01.2023 16:57:56 [com.adventnet.db.adapter.mssql.MssqlDBAdapter] [INFO] : Collation String constructed is Cyrillic_General_CS_A%
17.01.2023 16:57:56 [com.adventnet.db.adapter.mssql.MssqlDBAdapter] [INFO] : The Toggle collation string is Cyrillic_General_CS_AI
17.01.2023 16:57:56 [com.adventnet.db.adapter.AbstractRestoreHandler] [INFO] : Restore process fully completed.
17.01.2023 16:57:56 [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : splitConnectionURL :: {DatabaseName=sdtest, urlWithoutProps=jdbc:jtds:sqlserver://DB-03:1433, jdbcurl_props_separator=;, Tds=8.0, charset=utf-8, loginTimeout=5, properties={charset=utf-8, DatabaseName=sdtest, DBName=DB-03:1433, socketTimeout=1200, PrepareSql=3, XaEmulation=false, Tds=8.0, Port=1433, Server=DB-03, loginTimeout=5}, urlProps={Tds=8.0, XaEmulation=false, PrepareSql=3, DatabaseName=sdtest, loginTimeout=5, socketTimeout=1200, charset=utf-8}, Server=DB-03, XaEmulation=false, PrepareSql=3, Port=1433, url_props_delimiter=;, socketTimeout=1200, DBName=DB-03:1433}
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:jtds:sqlserver://DB-03:1433;DatabaseName=sdtest;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=false;loginTimeout=5;socketTimeout=1200
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Updating Migration Status
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Updated Migration Status :: MIGRATION_INVOKED
17.01.2023 16:57:56 [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [INFO] : Parsing the File :: file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/meta-dd.xml
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Loaded the meta-dd of persistence from existing jar.
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Loading Persistence dd via MetaDataAccess.loadDataDictionary API
17.01.2023 16:57:56 [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [INFO] : Parsing the File :: file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/data-dictionary.xml
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : LoadAllDDs ::: true
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Going to initialize SeqGenerator.
17.01.2023 16:57:56 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Going to initialize Preprocessor for SAS setup.
17.01.2023 16:57:56 [com.adventnet.persistence.PersistenceInitializer] [INFO] : No Preprocessor found.
17.01.2023 16:57:56 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [I18n]
17.01.2023 16:57:56 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Audit]
17.01.2023 16:57:56 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Authentication]
17.01.2023 16:57:57 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Authorization]
17.01.2023 16:57:57 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [CustomView]
17.01.2023 16:57:57 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [TaskEngine]
17.01.2023 16:57:57 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [ClientFramework]
17.01.2023 16:57:57 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [ClientComponents]
17.01.2023 16:57:57 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Asset]
17.01.2023 16:57:59 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [CMDB]
17.01.2023 16:57:59 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Helpdesk]
17.01.2023 16:58:02 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [HelpDeskDynamic]
17.01.2023 16:58:02 [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [ServiceDesk_Client]
17.01.2023 16:58:02 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : All Modules loaded successfully...
17.01.2023 16:58:02 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : initializeMicKey finished
17.01.2023 16:58:02 [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor] [SEVERE] : Inside installPatch() of SDPreProcessor
17.01.2023 16:58:02 [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Mickey already initialized.
17.01.2023 16:58:02 [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : dbBuildNo is : 10013
17.01.2023 16:58:02 [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : Instalation buildno is : 10013
17.01.2023 16:58:02 [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO mesaage --->There are some inconsistencies in your database schema.Please contact support for further assistance.
17.01.2023 16:58:02 [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO mode --->true
17.01.2023 16:58:02 [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO messageType --->showMessageDialog
