23.4 update - Preparing failed

SLES 15 SP3
ZCM 2020.02 (20.2.0.990)


After downloading the 23.4 update, the update process doesn't move from the Preparing to the Authorized status.

prepare-update.log:
...
[DEBUG] [07/12/2024 09:53:40.547] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: Caused by: org.s
pringframework.web.client.HttpServerErrorException$InternalServerError: 500 Server Error: (HTTP ERROR 500 org.springframework.transaction.CannotCreateTransactionException: C
ould not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Una... (32245 bytes))] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.547] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.spring
framework.web.client.HttpServerErrorException.create(HttpServerErrorException.java:100)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.547] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:186)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.547] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:125)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.547] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.547] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:782)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.548] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:740)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.548] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:674)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.548] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at org.springframework.web.client.RestTemplate.postForObject(RestTemplate.java:418)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.548] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: at com.novell.zenworks.rest.util.ZeusRestServiceInvoker.invoke(ZeusRestServiceInvoker.java:78)] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.548] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: ... 5 more] [] [] [] [SystemUpdate]
[DEBUG] [07/12/2024 09:53:40.548] [12] [ThreadedStreamReader] [15453] [zenworks] [SystemUpdate] [] [/opt/microfocus/zenworks/bin/run_preglobal_update:: OUT: FINE: Failed to prepare

Parents
  • 0  

    - Don't Touch your certs based on my questions....

    Is the DNS Name of your Server or on your Cert something such as .LAN, .INTRA, or similar where it would not be possible internet resolveable.COM, .ORG, etc?

    What is the Extension on the DNS name of your server....I don't need the actual Domain Name or Server Name.

    Does your Cert have values under "Subject Alternative Names"?

    Did you try restarting services?

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0 in reply to   
    I found an error messages in the zeus-messages.log:
    [ERROR] [07/16/2024 08:58:31.15] [23388] [37] [root] [com.microfocus.zenworks.messaging.datasource.RDBMSValidator] [] [Unable toorg.postgresql.util.PSQLException: FATAL: database "zenworks" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) ~[postgresql-42.6.0.jar:42.6.0 at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2825) ~[postgresql-42.6.0.jar:42.6.0] at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:175) ~[postgresql-42.6.0.jar:42.6.0] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:313) ~[postgresql-42.6.0.jar:4 at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) ~[postgresql-42.6.0.jar:42.6.0] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:263) ~[postgresql-42.6.0.jar:42.6.0] at org.postgresql.Driver.makeConnection(Driver.java:443) ~[postgresql-42.6.0.jar:42.6.0] at org.postgresql.Driver.connect(Driver.java:297) ~[postgresql-42.6.0.jar:42.6.0] at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_382] at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_382] at com.microfocus.zenworks.messaging.datasource.RDBMSValidator.isDataSourceValid(RDBMSValidator.java:46) [messaging-service. at com.microfocus.zenworks.messaging.library.MessagingLibrary.initializeConsumers(MessagingLibrary.java:80) [messaging-servi at com.microfocus.zenworks.zeus.messaging.ZeusMessagingModule.initMessageLibrary(ZeusMessagingModule.java:94) [zeus-message- at com.microfocus.zenworks.zeus.messaging.MessagingInitThread.run(MessagingInitThread.java:39) [zeus-message-handlers.jar:?][TRACE] [07/16/2024 08:58:31.015] [23388] [ZeUSAgent] [37] [] [ZeusMessageHandlers]
     
     
    The real name of the database:
    postgres=# \l
    List of databases
    Name | Owner | Encoding | Collate | Ctype | Access privileges
    --------------------+---------------+----------+-------------+-------------+-----------------------------
    postgres | zenpostgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
    template0 | zenpostgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/zenpostgres +
    | | | | | zenpostgres=CTc/zenpostgres
    template1 | zenpostgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | zenpostgres=CTc/zenpostgres+
    | | | | | =c/zenpostgres
    zen_audit_plb_zone | zenauditadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
    zenworks_plb_zone | zenadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
    (5 rows)

    Where is the database name for the ZeUS set?

  • 0   in reply to 

    I will follow up with you and your engineer on the case directly.....

    All to often folks read 10 year olds posts that only loosely relate to them and start hacking.

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

Reply Children
No Data