Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more

  • State Not Answered
  • Replies replies
    7
  • Subscribers subscribers
    43
  • Views views
    374
  • Users 0 members are here
Related
Options

23.4 update - Preparing failed

Jiri Provaznik

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

  • 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

    The DNS extension of  the customer's server is .cz.

    A server certificate contains "Subject Alternative Names".

    I restarted services microfocus-zenloader.service and novell-zenworks-updater-service.service.

  • 0   in reply to 

    An SR would be recommended if possible.  If you have one open already post it here.  I don't have any other good ideas at the moment.

    --

    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   

    But you may also want to restart the ZEUS Service.....I doubt it helps....

    --

    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   

    The Case Number 02918099 is opened.

    I restarted ZEUS service, if you mean novell-zenworks-updater-service.service.

  • 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

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.