Tried to upgrade version. Encounter error.
Anyone can provide some insights to solve this issue.
Thanks.
pr 19, 2024 3:18:35 PM [com.adventnet.tools.update.installer.UpdateManager] [INFO] :
Apr 19, 2024 3:18:35 PM [com.adventnet.tools.update.installer.UpdateManager] [INFO] : Invoking UpdateManager in UI mode
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : The ppm file path:C:\Users\administrator.MPSB\Documents\Servicedesk Upgrade\ManageEngine_ServiceDesk_Plus_9_4_0_SP-1_0_0.ppm
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : The ppm file path:C:\Users\administrator.MPSB\Documents\Servicedesk Upgrade\ManageEngine_ServiceDesk_Plus_9_4_0_SP-1_0_0.ppm
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : The Patch Version:AdventNet_ManageEngine_ServiceDesk_Plus-9.4.0-SP-1.0.0
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.ApplyPatch] [INFO] : Context NameSERVICEDESK
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Pre Invocation in progress
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Executing class:com/adventnet/servicedesk/updatemgr/util/SDPreFileRemoval.class
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Executing class:com/adventnet/persistence/UMPreInvoke.class
Apr 19, 2024 3:18:45 PM [com.adventnet.tools.update.installer.Unzipper] [INFO] : Executing class:com/adventnet/servicedesk/updatemgr/util/SDPreValidation.class
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Patch version name [AdventNet_ManageEngine_ServiceDesk_Plus-9.4.0-SP-1.0.0]
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : context name [SERVICEDESK]
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DD-XMLs default Listener class [com.adventnet.persistence.DefaultDDChangeListener]
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Meta-dd.xml Listener class [com.adventnet.persistence.migration.MetaDDListener]
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : DO-XMLs default Listener class [com.adventnet.persistence.DefaultDOXMLChangeListener]
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : default Configuration Updator class [com.adventnet.persistence.migration.DefaultConfigurationUpdater]
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : Config Change Listener class [com.adventnet.persistence.migration.DefaultConfigChangeListener]
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.home.
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.dirC:/ManageEngine/ServiceDesk
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.UpdateManagerUtil] [INFO] : server.confC:\ManageEngine\ServiceDesk\conf
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing C:\ManageEngine\ServiceDesk\.\conf\product-config.xml
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.ConfigurationParser] [INFO] : Processing C:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Reading .\conf\database_params.conf
Apr 19, 2024 3:18:45 PM [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : ConnectionPoolParams :: minSize :: [1], maxSize :: [20], idleTimeout :: [15 milliseconds], blockingTimeout :: [30,000 milliseconds]
Apr 19, 2024 3:18:45 PM [com.adventnet.ds.DefaultDataSourcePlugIn] [INFO] : DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@7a766ca0
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Storage Adapter class ::: null
Apr 19, 2024 3:18:45 PM [com.adventnet.db.api.RelationalAPI] [SEVERE] : haltjvm.on.dbcrash is set to [false]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : shutDownStrings :: []
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : Loading the function patterns from the file :: [.\conf\Persistence\postgres_functionpatterns.txt]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [WARNING] : Identifier [pgsql_identifiers.txt] file not exist for this database
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration running :: false
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : isDBMigration dest DB :: false
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.PostgresSQLGenerator] [INFO] : Encryption algorithm used :: [aes256]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.PostgresSQLGenerator] [INFO] : Encryption s2k-mode used :: [1]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : db.home ::: C:\ManageEngine\ServiceDesk\bin\\..\pgsql
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : dataDirectory :: C:\ManageEngine\ServiceDesk\pgsql\data
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : DataSourcePlugIn is initialized successfully
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.AbstractRestoreHandler] [INFO] : Restore process fully completed.
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk?charSet=UTF-8
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Reading .\conf\database_params.conf
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : C:\ManageEngine\ServiceDesk\bin\..\pgsql\bin\pg_isready.exe isExists :: true
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [C:\ManageEngine\ServiceDesk\bin\..\pgsql\bin\pg_isready.exe, --host, localhost, --port, 65432, --username, postgres]
Apr 19, 2024 3:18:45 PM [SYSOUT] [INFO] : localhost:65432 - accepting connections
Apr 19, 2024 3:18:45 PM [SYSOUT] [INFO] :
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : pg_isready returning status :: 0
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Validating data_directory path with running server.
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : hostAddress of localhost is 127.0.0.1
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed :::: [C:\ManageEngine\ServiceDesk\pgsql\bin\psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : dataDirectory path from server :: C:/ManageEngine/ServiceDesk/pgsql/data
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : DB server already running in :: C:\ManageEngine\ServiceDesk\bin\\..\pgsql
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk?charSet=UTF-8
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : hostAddress of localhost is 127.0.0.1
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed :::: [C:\ManageEngine\ServiceDesk\pgsql\bin\psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, CREATE DATABASE \"servicedesk\", -d, postgres, -w]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\psql, -U, postgres, -p, 65432, -h, 127.0.0.1, -c, CREATE DATABASE \"servicedesk\", -d, postgres, -w]
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : ErrorStream ::: ERROR: database "servicedesk" already exists
Apr 19, 2024 3:18:45 PM [com.adventnet.db.adapter.postgres.PostgresDBAdapter] [INFO] : createDB returns ::: true
Apr 19, 2024 3:18:45 PM [com.adventnet.persistence.PersistenceInitializer] [SEVERE] : Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: org.postgresql.Driver; - nested throwable: (java.lang.ClassNotFoundException: org.postgresql.Driver)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: org.postgresql.Driver; - nested throwable: (java.lang.ClassNotFoundException: org.postgresql.Driver)))org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: org.postgresql.Driver; - nested throwable: (java.lang.ClassNotFoundException: org.postgresql.Driver)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: org.postgresql.Driver; - nested throwable: (java.lang.ClassNotFoundException: org.postgresql.Driver)))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:898)