Clarity PPM1

Expand all | Collapse all

CA PPM with RDS MS SQL 2017

Jump to Best Answer
  • 1.  CA PPM with RDS MS SQL 2017

    Posted 09-11-2019 12:50 PM
    Hello everyone,
    Did anyone has come across issues with a CA PPM 15.6.1 with RDS MS SQL 2017. The release Notes states that MS SQL is compatible.
    We have the CA PPM and RDS in AWS.
    I am able to connect form App Server to the RDS with SSM and DSN and was able to telnet/tcp ping.
    But in NSA, it the Database and Datawarehousing states unavailabe.
    opened a CA ticket as well.
    Any help is greatly appreciated.
    The error that I see is,

    The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: 111.111.11.11] 


    WARN  2019-09-02 21:54:42,249 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Found invalid database connection for local tenant clarity

    SYS   2019-09-02 21:54:42,883 [localhost-startStop-1] niku.union (clarity:none:none:none) Could not log database info for Tenant with Id = clarity



    ------------------------------
    Somi
    ------------------------------


  • 2.  RE: CA PPM with RDS MS SQL 2017
    Best Answer

    Posted 09-12-2019 05:49 AM
    Hi Sowmya

    We dont support MS SQL Server 2017 yet with 15.7 also, hence its not supposed to work. Please review the compatibility in our official documentation.

    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-7/release-information/clarity-ppm-release-notes.html#concept.dita_8ebed6ba1fc5de89d746baa8a9be14ef035caa38_Hardware

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 3.  RE: CA PPM with RDS MS SQL 2017

    Posted 09-12-2019 07:37 AM
    HI Suman,
    The Release Notes should have been clearly written. it says MS SQL 2016 or higher...:)
    Thanks for the confirmation.
    -Somi


  • 4.  RE: CA PPM with RDS MS SQL 2017

    Posted 09-12-2019 07:47 AM
    Higher means the service pack and not major release

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 5.  RE: CA PPM with RDS MS SQL 2017

    Posted 09-14-2019 03:20 PM
    Understood that. and thank you for the information.