May 15, 2019 6:39:55 PM [com.adventnet.tools.update.installer.UpdateManager] [INFO] : May 15, 2019 6:39:55 PM [com.adventnet.tools.update.installer.UpdateManager] [INFO] : Invoking UpdateManager in CMD mode May 15, 2019 6:39:55 PM [com.adventnet.tools.update.installer.UpdateManager] [INFO] : UpdateManager ProductName:AdventNet ManageEngine ServiceDesk Plus - MSP May 15, 2019 6:39:55 PM [com.adventnet.tools.update.installer.UpdateManager] [INFO] : UpdateManager ProductVersion:9.4.0 May 15, 2019 6:39:55 PM [com.adventnet.tools.update.installer.UpdateManager] [INFO] : UpdateManager ProductContext:SERVICEDESK May 15, 2019 6:40:08 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : The ppm file path:/home/sdp-team/demolatestmsp/ManageEngine_ServiceDesk_Plus_-_MSP_9_4_0_SP-0_1_8.ppm May 15, 2019 6:40:08 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : The ppm file path:/home/sdp-team/demolatestmsp/ManageEngine_ServiceDesk_Plus_-_MSP_9_4_0_SP-0_1_8.ppm May 15, 2019 6:40:08 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : The Patch Version:AdventNet_ManageEngine_ServiceDesk_Plus_-_MSP-9.4.0-SP-0.1.8 May 15, 2019 6:40:08 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : Context NameSERVICEDESK May 15, 2019 6:40:08 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Pre Invocation in progress May 15, 2019 6:40:08 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Executing class:com/adventnet/servicedesk/updatemgr/util/SDPreFileRemoval.class May 15, 2019 6:40:08 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Executing class:com/adventnet/servicedesk/updatemgr/util/MSPPreValidation.class May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Patch version name [AdventNet_ManageEngine_ServiceDesk_Plus_-_MSP-9.4.0-SP-0.1.8] May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : context name [SERVICEDESK] May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DD-XMLs default Listener class [com.adventnet.persistence.DefaultDDChangeListener] May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Meta-dd.xml Listener class [com.adventnet.persistence.migration.MetaDDListener] May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DO-XMLs default Listener class [com.adventnet.persistence.DefaultDOXMLChangeListener] May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : default Configuration Updator class [com.adventnet.persistence.migration.DefaultConfigurationUpdater] May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Config Change Listener class [com.adventnet.persistence.migration.DefaultConfigChangeListener] May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.home. May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.dir/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP May 15, 2019 6:40:08 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.conf/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/conf May 15, 2019 6:40:09 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./conf/product-config.xml May 15, 2019 6:40:09 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./conf/customer-config.xml May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Reading ./conf/database_params.conf May 15, 2019 6:40:09 PM [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : ConnectionPoolParams :: minSize :: [1], maxSize :: [20], idleTimeout :: [15 milliseconds], blockingTimeout :: [30,000 milliseconds] May 15, 2019 6:40:09 PM [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@126db04e May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : rootDir :: /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/../ May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Root Directory in readBuildData method of SDDataManagerClass :---> /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/../ May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Reading Build Info file :---> /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/..//conf/buildInfo.xml May 15, 2019 6:40:09 PM [SYSERR] [INFO] : Exception while forming the url: null and getting the stream. /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/../conf/buildInfo.xml (No such file or directory) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : May 15, 2019 6:40:09 PM [SYSERR] [INFO] : java.io.FileNotFoundException: /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/../conf/buildInfo.xml (No such file or directory) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.io.FileInputStream.open(Native Method) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.io.FileInputStream.(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.io.FileInputStream.(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.net.www.protocol.file.FileURLConnection.connect(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.net.URL.openStream(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.nms.util.XMLDataReader.load(XMLDataReader.java:260) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.nms.util.XMLDataReader.load(XMLDataReader.java:306) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.nms.util.XMLDataReader.(XMLDataReader.java:67) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.java:24) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SDDataManager.java:106) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.SDDataManager.(SDDataManager.java:74) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDataManager.java:93) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.getGeneratorRootElement(MSPSQLGenerator.java:515) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.loadGeneratorXML(MSPSQLGenerator.java:422) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.(MSPSQLGenerator.java:45) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPPostgresSQLGenerator.(MSPPostgresSQLGenerator.java:12) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.reflect.Constructor.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.Class.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.createDBAdapter(PersistenceInitializer.java:188) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:434) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:466) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.UpdateManagerUtil.initializeDB(UpdateManagerUtil.java:651) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPreValidation.install(SDPreValidation.java:52) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.MSPPreValidation.install(MSPPreValidation.java:45) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(Unzipper.java:319) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationClasses(Unzipper.java:138) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:273) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.Thread.run(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/../conf/buildInfo.xml (No such file or directory) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : May 15, 2019 6:40:09 PM [SYSERR] [INFO] : java.lang.NullPointerException May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.java:36) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.java:25) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SDDataManager.java:106) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.SDDataManager.(SDDataManager.java:74) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDataManager.java:93) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.getGeneratorRootElement(MSPSQLGenerator.java:515) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.loadGeneratorXML(MSPSQLGenerator.java:422) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.(MSPSQLGenerator.java:45) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPPostgresSQLGenerator.(MSPPostgresSQLGenerator.java:12) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.reflect.Constructor.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.Class.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.createDBAdapter(PersistenceInitializer.java:188) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:434) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:466) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.UpdateManagerUtil.initializeDB(UpdateManagerUtil.java:651) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPreValidation.install(SDPreValidation.java:52) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.MSPPreValidation.install(MSPPreValidation.java:45) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(Unzipper.java:319) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationClasses(Unzipper.java:138) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:273) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.Thread.run(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : java.lang.NullPointerException May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.getGeneratorRootElement(MSPSQLGenerator.java:527) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.loadGeneratorXML(MSPSQLGenerator.java:422) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.(MSPSQLGenerator.java:45) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPPostgresSQLGenerator.(MSPPostgresSQLGenerator.java:12) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.reflect.Constructor.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.Class.newInstance(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.createDBAdapter(PersistenceInitializer.java:188) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:434) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:466) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.persistence.UpdateManagerUtil.initializeDB(UpdateManagerUtil.java:651) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPreValidation.install(SDPreValidation.java:52) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.MSPPreValidation.install(MSPPreValidation.java:45) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Unknown Source) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(Unzipper.java:319) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationClasses(Unzipper.java:138) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:273) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223) May 15, 2019 6:40:09 PM [SYSERR] [INFO] : at java.lang.Thread.run(Unknown Source) May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Storage Adapter class ::: null May 15, 2019 6:40:09 PM [com.adventnet.db.api.RelationalAPI] [SEVERE] : haltjvm.on.dbcrash is set to [false] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : shutDownStrings :: [] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : Loading the function patterns from the file :: [./conf/Persistence/postgres_functionpatterns.txt] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [WARNING] : Identifier [pgsql_identifiers.txt] file not exist for this database May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration running :: false May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration dest DB :: false May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.PostgresSQLGenerator] [INFO] : Encryption algorithm used :: [aes256] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.PostgresSQLGenerator] [INFO] : Encryption s2k-mode used :: [1] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : db.home ::: ./pgsql May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : dataDirectory :: /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/data May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : DataSourcePlugIn is initialized successfully May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.AbstractRestoreHandler] [INFO] : Restore process fully completed. May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65439/testdesk9418 May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Reading ./conf/database_params.conf May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready isExists :: true May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:09 PM [SYSOUT] [INFO] : localhost:65439 - accepting connections May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 0 May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Validating data_directory path with running server. May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : hostAddress of localhost is 127.0.0.1 May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed :::: [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w] May 15, 2019 6:40:09 PM [SYSOUT] [INFO] : May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : dataDirectory path from server :: /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/data May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : DB server already running in :: ./pgsql May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65439/testdesk9418 May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : hostAddress of localhost is 127.0.0.1 May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed :::: [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, CREATE DATABASE "testdesk9418", -d, postgres, -w] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, CREATE DATABASE "testdesk9418", -d, postgres, -w] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : ErrorStream ::: ERROR: database "testdesk9418" already exists May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : createDB returns ::: true May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : Postgres version ::: 9.2.4 May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : splitConnectionURL :: {Port=65439, url_props_delimiter=&, urlWithoutProps=jdbc:postgresql://localhost:65439/testdesk9418, jdbcurl_props_separator=?, DBName=testdesk9418, Server=localhost} May 15, 2019 6:40:09 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65439/testdesk9418 May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : Going to create postgres extensions if not exists ... May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.updatemgr.util.SDPreValidation] [INFO] : Inside Install patch May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.updatemgr.util.SDPreValidation] [INFO] : Is CorrectInstance is calling May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.updatemgr.util.SDPreValidation] [INFO] : Serverstatus is calling 3 May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.updatemgr.util.SDPreValidation] [INFO] : ServerStartup check is calling 9416 May 15, 2019 6:40:09 PM [com.adventnet.authentication.util.AuthUtil] [INFO] : messageDigest instance obtained for MD5 is : MD5 Message Digest from SUN, May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.updatemgr.util.MSPPreValidation] [INFO] : key 941494129408 May 15, 2019 6:40:09 PM [com.adventnet.servicedesk.updatemgr.util.SDPreValidation] [INFO] : MSSQL version check. Patch can only be applied if mssql version is 2003 and above. May 15, 2019 6:40:09 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : stopscript property is set as true to forcefully stop the DB. May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready isExists :: true May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Stopping PgSQL Server ... May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 0 May 15, 2019 6:40:09 PM [SYSOUT] [INFO] : localhost:65439 - accepting connections May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Going to stop DB server using pg_ctl utility. May 15, 2019 6:40:09 PM [SYSOUT] [INFO] : May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/pg_ctl, -w, -D, /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/data, -o, "-p65439", stop, -s, -m, fast] May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:09 PM [SYSOUT] [INFO] : localhost:65439 - rejecting connections May 15, 2019 6:40:09 PM [SYSOUT] [INFO] : May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 1 May 15, 2019 6:40:09 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerRunning :: false May 15, 2019 6:40:10 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:10 PM [SYSOUT] [INFO] : localhost:65439 - rejecting connections May 15, 2019 6:40:10 PM [SYSOUT] [INFO] : May 15, 2019 6:40:10 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 1 May 15, 2019 6:40:10 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerRunning :: false May 15, 2019 6:40:11 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:11 PM [SYSOUT] [INFO] : localhost:65439 - rejecting connections May 15, 2019 6:40:11 PM [SYSOUT] [INFO] : May 15, 2019 6:40:11 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 1 May 15, 2019 6:40:11 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerRunning :: false May 15, 2019 6:40:12 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:12 PM [SYSOUT] [INFO] : localhost:65439 - rejecting connections May 15, 2019 6:40:12 PM [SYSOUT] [INFO] : May 15, 2019 6:40:12 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 1 May 15, 2019 6:40:12 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerRunning :: false May 15, 2019 6:40:13 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:13 PM [SYSOUT] [INFO] : localhost:65439 - no response May 15, 2019 6:40:13 PM [SYSOUT] [INFO] : May 15, 2019 6:40:13 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 2 May 15, 2019 6:40:13 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerStopped :: going to return :: true May 15, 2019 6:40:13 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : is DB registered as a service ::: false May 15, 2019 6:40:13 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerStopped method returning status ::: true May 15, 2019 6:40:13 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : StopDBServer :: Waiting for 1 second... May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : isDBServerStopped returns :: true May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.updatemgr.util.MSPPreValidation] [INFO] : isPPMAppliedOverBetaBuild : false May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.updatemgr.util.MSPPreValidation] [INFO] : isBetaBuild : false May 15, 2019 6:40:14 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Executing class:com/adventnet/servicedesk/updatemgr/util/JreVersionHandler.class May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.updatemgr.util.JreVersionHandler] [INFO] : Inside preInstall() of JREVersionHandler May 15, 2019 6:40:14 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Executing class:com/adventnet/servicedesk/updatemgr/util/SDPreProcessor.class May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor] [SEVERE] : Inside SDPreProcessor() May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [SEVERE] : Inside SDPreProcessorUtil. May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : jboss {0}./ May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Going to set the standAlone param as : true May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Going to reset rootDir using server.dir May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : rootDir :: .// May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Root Directory in readBuildData method of SDDataManagerClass :---> .// May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Reading Build Info file :---> .///conf/buildInfo.xml May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : netutilsData :: {RELEASE={version=9.4}, BUILD={number=9416}} May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus - MSP}, ADMANAGER={name=ADManager}} May 15, 2019 6:40:14 PM [com.adventnet.persistence.DefaultPreProcessor] [INFO] : Entering Into :: DefaultPreProcessor :: install May 15, 2019 6:40:14 PM [com.adventnet.persistence.DefaultPreProcessor] [INFO] : Invoking preInstall() method. May 15, 2019 6:40:14 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor] [SEVERE] : Inside preInstall() of SDPreProcessor May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Patch version name [AdventNet_ManageEngine_ServiceDesk_Plus_-_MSP-9.4.0-SP-0.1.8] May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : context name [SERVICEDESK] May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DD-XMLs default Listener class [com.adventnet.persistence.DefaultDDChangeListener] May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Meta-dd.xml Listener class [com.adventnet.persistence.migration.MetaDDListener] May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DO-XMLs default Listener class [com.adventnet.persistence.DefaultDOXMLChangeListener] May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : default Configuration Updator class [com.adventnet.persistence.migration.DefaultConfigurationUpdater] May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Config Change Listener class [com.adventnet.persistence.migration.DefaultConfigChangeListener] May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.home. May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.dir/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.conf/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/conf May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : properties :: {version=9.4.0, patchversion=AdventNet_ManageEngine_ServiceDesk_Plus_-_MSP-9.4.0-SP-0.1.8, context=SERVICEDESK, product=AdventNet ManageEngine ServiceDesk Plus - MSP, mode=false, home=/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP} May 15, 2019 6:40:14 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./conf/product-config.xml May 15, 2019 6:40:14 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./conf/customer-config.xml May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DBName ::: postgres May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : startDBServer ::: true May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : osString ::: linux May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : isWindows ::: false May 15, 2019 6:40:14 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Data directory change permission steps skipped May 15, 2019 6:40:14 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./conf/product-config.xml May 15, 2019 6:40:14 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./conf/customer-config.xml May 15, 2019 6:40:14 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Reading ./conf/database_params.conf May 15, 2019 6:40:14 PM [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : ConnectionPoolParams :: minSize :: [1], maxSize :: [20], idleTimeout :: [15 milliseconds], blockingTimeout :: [30,000 milliseconds] May 15, 2019 6:40:14 PM [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@4ad496be May 15, 2019 6:40:14 PM [SYSERR] [INFO] : java.lang.NullPointerException May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.getGeneratorRootElement(MSPSQLGenerator.java:527) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.loadGeneratorXML(MSPSQLGenerator.java:422) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPSQLGenerator.(MSPSQLGenerator.java:45) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.servicedesk.db.generator.MSPPostgresSQLGenerator.(MSPPostgresSQLGenerator.java:12) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at java.lang.reflect.Constructor.newInstance(Unknown Source) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at java.lang.Class.newInstance(Unknown Source) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.createDBAdapter(PersistenceInitializer.java:188) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:434) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:466) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.UpdateManagerUtil.initializeDB(UpdateManagerUtil.java:651) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.UpdateManagerUtil.initializeMicKey(UpdateManagerUtil.java:490) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.UpdateManagerUtil.initializeMicKey(UpdateManagerUtil.java:468) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.UpdateManagerUtil.initializeForInstall(UpdateManagerUtil.java:1192) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPreProcessor.install(DefaultPreProcessor.java:89) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Unknown Source) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(Unzipper.java:319) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationClasses(Unzipper.java:138) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:273) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223) May 15, 2019 6:40:14 PM [SYSERR] [INFO] : at java.lang.Thread.run(Unknown Source) May 15, 2019 6:40:14 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter May 15, 2019 6:40:14 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Storage Adapter class ::: null May 15, 2019 6:40:14 PM [com.adventnet.db.api.RelationalAPI] [SEVERE] : haltjvm.on.dbcrash is set to [false] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : shutDownStrings :: [] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : Loading the function patterns from the file :: [./conf/Persistence/postgres_functionpatterns.txt] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [WARNING] : Identifier [pgsql_identifiers.txt] file not exist for this database May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration running :: false May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration dest DB :: false May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.PostgresSQLGenerator] [INFO] : Encryption algorithm used :: [aes256] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.PostgresSQLGenerator] [INFO] : Encryption s2k-mode used :: [1] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : db.home ::: ./pgsql May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : dataDirectory :: /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/data May 15, 2019 6:40:14 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : DataSourcePlugIn is initialized successfully May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.AbstractRestoreHandler] [INFO] : Restore process fully completed. May 15, 2019 6:40:14 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65439/testdesk9418 May 15, 2019 6:40:14 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Reading ./conf/database_params.conf May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready isExists :: true May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 2 May 15, 2019 6:40:14 PM [SYSOUT] [INFO] : localhost:65439 - no response May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Checking for IPV6 support May 15, 2019 6:40:14 PM [SYSOUT] [INFO] : May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Resolved address of host [localhost] is [localhost/127.0.0.1] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Going to start DB server using pg_ctl utility. May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/pg_ctl, -w, -D, /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/data, -o, "-p65439", start] May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : is DB registered as a service ::: false May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:14 PM [SYSOUT] [INFO] : localhost:65439 - no response May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 2 May 15, 2019 6:40:14 PM [SYSOUT] [INFO] : May 15, 2019 6:40:14 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerRunning :: false May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/./pgsql/bin/pg_isready, --host, localhost, --port, 65439, --username, postgres] May 15, 2019 6:40:15 PM [SYSOUT] [INFO] : localhost:65439 - accepting connections May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 0 May 15, 2019 6:40:15 PM [SYSOUT] [INFO] : May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Validating data_directory path with running server. May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : hostAddress of localhost is 127.0.0.1 May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed :::: [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w] May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w] May 15, 2019 6:40:15 PM [pglog] [INFO] : waiting for server to start.... done May 15, 2019 6:40:15 PM [pglog] [INFO] : server started May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : dataDirectory path from server :: /home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/data May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerStarted :: going to return :: true May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Checking is DB server ready to accept connection... May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : hostAddress of localhost is 127.0.0.1 May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed :::: [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, SELECT 1, -d, postgres, -w] May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, SELECT 1, -d, postgres, -w] May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Database server responsing... Database server is now READY to accept connections!!! May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : isDBReadyToAcceptConnection returns ::: true May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : Database server sucessfully started. May 15, 2019 6:40:15 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65439/testdesk9418 May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : hostAddress of localhost is 127.0.0.1 May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed :::: [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, CREATE DATABASE "testdesk9418", -d, postgres, -w] May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/pgsql/bin/psql, -U, postgres, -p, 65439, -h, 127.0.0.1, -c, CREATE DATABASE "testdesk9418", -d, postgres, -w] May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : ErrorStream ::: ERROR: database "testdesk9418" already exists May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : createDB returns ::: true May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : Postgres version ::: 9.2.4 May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : splitConnectionURL :: {Port=65439, url_props_delimiter=&, urlWithoutProps=jdbc:postgresql://localhost:65439/testdesk9418, jdbcurl_props_separator=?, DBName=testdesk9418, Server=localhost} May 15, 2019 6:40:15 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65439/testdesk9418 May 15, 2019 6:40:15 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : Going to create postgres extensions if not exists ... May 15, 2019 6:40:15 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Updating Migration Status May 15, 2019 6:40:15 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Updated Migration Status :: MIGRATION_INVOKED May 15, 2019 6:40:15 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [INFO] : Parsing the File :: file:/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/Patch/AdventNet_ManageEngine_ServiceDesk_Plus_-_MSP-9.4.0-SP-0.1.8/SERVICEDESK/PreInstall/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/meta-dd.xml May 15, 2019 6:40:15 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Loaded the meta-dd of persistence from existing jar. May 15, 2019 6:40:15 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Loading Persistence dd via MetaDataAccess.loadDataDictionary API May 15, 2019 6:40:15 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [INFO] : Parsing the File :: file:/home/sdp-team/demolatestmsp/ServiceDeskPlus-MSP/Patch/AdventNet_ManageEngine_ServiceDesk_Plus_-_MSP-9.4.0-SP-0.1.8/SERVICEDESK/PreInstall/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/data-dictionary.xml May 15, 2019 6:40:15 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : LoadAllDDs ::: true May 15, 2019 6:40:15 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Going to initialize SeqGenerator. May 15, 2019 6:40:15 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Going to initialize Preprocessor for SAS setup. May 15, 2019 6:40:15 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : No Preprocessor found. May 15, 2019 6:40:15 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [I18n] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Audit] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Authentication] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Authorization] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [CustomView] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [TaskEngine] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [ClientFramework] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [ClientComponents] May 15, 2019 6:40:16 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Asset] May 15, 2019 6:40:17 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [CMDB] May 15, 2019 6:40:17 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [Helpdesk] May 15, 2019 6:40:18 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [HelpDeskDynamic] May 15, 2019 6:40:18 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [ServiceDesk_Client] May 15, 2019 6:40:18 PM [com.adventnet.persistence.SchemaBrowserUtil] [INFO] : Loading module :: [MSPDesk] May 15, 2019 6:40:18 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : All Modules loaded successfully... May 15, 2019 6:40:18 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : initializeMicKey finished May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessor] [SEVERE] : Inside installPatch() of SDPreProcessor May 15, 2019 6:40:18 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Mickey already initialized. May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : dbBuildNo is : 9416 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : Instalation buildno is : 9416 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : Is It Early Access Build :false May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : buildInfo exists :::: true May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : jboss {0}./ May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Going to set the standAlone param as : true May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Going to reset rootDir using server.dir May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : rootDir :: .// May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Root Directory in readBuildData method of SDDataManagerClass :---> .// May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : Reading Build Info file :---> .///conf/buildInfo.xml May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : netutilsData :: {RELEASE={version=9.4}, BUILD={number=9416}} May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.server.utils.SDDataManager] [INFO] : rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus - MSP}, ADMANAGER={name=ADManager}} May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : ServerDir ./ May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : SystemProperty : sdp.prevBuildNo - {0}9416 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : buildNumberStr {0}9416 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : buildNumber {0}9416 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : compBuild {0}9400 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : retValue 1 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.SDPreProcessorUtil] [INFO] : Change statuses with notification content as empty are : 455222 May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO mesaage --->One or More Change Status notifications' subject and content are empty. Please find those status names in updatemgrlog0.txt, update the same in Admin Configuration and restart the migration. May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO mode --->false May 15, 2019 6:40:18 PM [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO messageType --->showMessageDialog