CA Service Management

 View Only
  • 1.  Installing an SDM 14.1 Swingbox fails

    Posted Jun 22, 2022 05:55 PM

    Hi,

     

    I am supposed to install an SDM 14.1 as a Swingbox with SQL2012 in a migration project.

    I have already started the setup several times but it always runs with errors.

    The following error appears:

    582 Configuration task (Configure MS SQL Server) is failed in step : 11

    Can any of you remember getting such errors and what was a solution for it?

    I've attached the screenshot of the error message and the install.log.

    Thanks and best regards

    Janos Mertz

    Attachment(s)

    log
    install - Copy.log   181 KB 1 version


  • 2.  RE: Installing an SDM 14.1 Swingbox fails

    Broadcom Employee
    Posted Jun 22, 2022 07:29 PM
    Hi Janos,

    Try to see if the mdbadmin password have ampersand or any
    "weird" character...



    Cmpts,

    *Paulo Pedrosa*

    Mobile: + 351 93 24 23 146

    pauloalexan.pedrosa@broadcom.com

    --
    This electronic communication and the information and any files transmitted
    with it, or attached to it, are confidential and are intended solely for
    the use of the individual or entity to whom it is addressed and may contain
    information that is confidential, legally privileged, protected by privacy
    laws, or otherwise restricted from disclosure to anyone else. If you are
    not the intended recipient or the person responsible for delivering the
    e-mail to the intended recipient, you are hereby notified that any use,
    copying, distributing, dissemination, forwarding, printing, or copying of
    this e-mail is strictly prohibited. If you received this e-mail in error,
    please return the e-mail to the sender, delete it from your computer, and
    destroy any printed copy of it.




  • 3.  RE: Installing an SDM 14.1 Swingbox fails

    Posted Jun 23, 2022 03:33 AM

    Hi Paulo,

    Thank you for your hint, it wasn't the password.

    To be able to test it a bit more freely, I recreated the configuration in my VMWare environment and I was able to reproduce the error. First I got the following error message:

    The TCP/IP connection to the host has failed

    Searching for this message led me to the following knowledge document:

    The TCP/IP connection to the host has failed error

    Broadcom remove preview
    The TCP/IP connection to the host has failed error
    CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager Issue/Introduction How to bypass error attempting to install the mdb on 2016 SQL database server with 14.1 product version The Database version SQL 2016 is not supported for SM 14.1 application.
    View this on Broadcom >



    It then describes a different configuration, but I tried it anyway.

    I have SQL 2012, but on Windows 2016, and the OS version Windows 2016 is not supported for SDM 14.1.

    So I made the changes described in the knowledge document in all java.security files in the copied installation image.

    Even so I got the error during installation:

    582 Configuration task (Configure MS SQL Server) is failed in step : 11

    I found that the installation created the java.security file in the … SC\JRE\1.7.0_10\lib\security directory without the needed changes.

    I changed it there too and let the installation continue, which then ran to the end.

    It seems to be working correctly now.

    I will find out today whether it will also work for the customer.

     

    Thanks and best regards

    Janos




  • 4.  RE: Installing an SDM 14.1 Swingbox fails

    Posted Jun 24, 2022 03:25 AM
    Great Find Janos.
    Hope this works in the customer environment as well.
    Thanks for letting us know.
    ...Michael


  • 5.  RE: Installing an SDM 14.1 Swingbox fails

    Posted Jun 23, 2022 07:50 AM
    As a caution, MSSQL 2012 is end of line in 3 weeks on July 12, 2022, and CASD 14.2 has been EOL for some time.  You may want to consider newer and supportable versions of these apps.


  • 6.  RE: Installing an SDM 14.1 Swingbox fails

    Posted Jun 23, 2022 02:21 PM
    Hi John,

    Thank you for your note.
    This is a swingbox installation and not the final application installation.
    Swingbox is used to upgrade production data from old releases to new releases, and it must have the same release and schema as the old production environment.
    The new release is installed with the latest Windows and SQL versions and uses SDM 17.3 with one of the latest cumulative fixes and as an advanced availability configuration.

    Thanks and best regards
    Janos Mertz


  • 7.  RE: Installing an SDM 14.1 Swingbox fails

    Broadcom Employee
    Posted Jun 29, 2022 04:47 PM
    Hi Janos,
    this helped me in the past...

    the error message:
    2022/06/22 23.01.27.545 INFO [AWT-EventQueue-0] [DatabasePersister] Unable to obtain Database Connection for user : mdbadmin May be a fresh installation.The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.lang.RuntimeException: Could not generate DH keypair". ClientConnectionId:98ff43d3-32f9-4f85-8875-2ab6ba59fd96
    2022/06/22 23.01.27.545 ERROR [AWT-EventQueue-0] [DatabasePersister] Connection to database failed

    and the solution:
    https://knowledge.broadcom.com/external/article?articleId=100959&_ga=2.70322384.196905303.1584100937-651272050.1583837925

    Good luck,
    Jakub


  • 8.  RE: Installing an SDM 14.1 Swingbox fails

    Broadcom Employee
    Posted Jun 29, 2022 04:48 PM
    Hi,
    this helped me in the past...

    the error message:
    2022/06/22 23.01.27.545 INFO [AWT-EventQueue-0] [DatabasePersister] Unable to obtain Database Connection for user : mdbadmin May be a fresh installation.The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.lang.RuntimeException: Could not generate DH keypair". ClientConnectionId:98ff43d3-32f9-4f85-8875-2ab6ba59fd96
    2022/06/22 23.01.27.545 ERROR [AWT-EventQueue-0] [DatabasePersister] Connection to database failed

    and the solution:
    https://knowledge.broadcom.com/external/article?articleId=100959&_ga=2.70322384.196905303.1584100937-651272050.1583837925

    Good luck,
    Jakub