Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Clarity v13 Incompatible SQL Server 2008

  • 1.  Clarity v13 Incompatible SQL Server 2008

    Posted Mar 20, 2014 08:52 AM

    Hello All,

    I have a problem about DB compatibility that I couldnt understand the reason. 

    I'm trying to create a test environment for myself and I use a virtual Win2012 on ESXi. I installed SQL Server 2008 R2 on the same server for DB. I have installed CA Clarity v13.1. It works very well but in CSA health report I see that my DB version is not compatible even MSSQL Server 2008 seems compatible for all service packs in relase notes. It was not a big issue until I try to upgrade my CA Clarity to v13.3. But when I run upgrade script it doesnt start because of this uncompatible database version. 

    My full db version is as follows;;
    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 

    What may be the reason of this uncompatibility. 

    Thanks in advance for all comments 

    Regards

     



  • 2.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 20, 2014 08:57 AM

    I'm suspecting the issue may be that you are running Standard vs. Enterprise edition.

    We just completed an upgrade to v13.2, and a prerequisite for successful script execution was that we run enterprise edition. 

    Hope this helps.

     



  • 3.  RE: Clarity v13 Incompatible SQL Server 2008

    Broadcom Employee
    Posted Mar 20, 2014 09:01 AM

    Hi..

     

    Please check the pre requisite parameter required for MSSQL like

     

    Important! Mixed collations is not supported. If you change the server-level default from SQL_Latin1_General_CP1_CI_AS to another collation, create a new SQL Server instance with the correct collation SQL_Latin1_General_CP1_CI_AS before creating the CA Clarity PPM database.
    The import procedure creates the database with the following options:
    Option
    Value / Choice
    ARITHABORT
    ANSI NULLS
    QUOTED IDENTIFIER
    ON
    To apply, execute:
    ALTER DATABASE <database> SET ARITHABORT ON
    ALTER DATABASE <database> SET ANSI_NULLS ON
    ALTER DATABASE <database> SET QUOTED_IDENTIFIER ON
    Option
    Value / Choice
    Compatibility level
    90
    To apply, execute:
    EXEC SP_DBCMPTLEVEL <database>, 90
    Database user name
    niku
    The login name can be anything, but the databaseusername (schema) must be niku.
    Database user roles
    db_owner
    The database user must have the ability to alter the Clarity-schema and otherwise own the database.
    READ COMMITTED SNAPSHOT
    ON
    To apply, execute:
    ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON
    VIEW_SERVER_STATE
    Granted to database user.
    To apply, execute:
    GRANT VIEW SERVER STATE to niku
     
    Regards
    Suman


  • 4.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 21, 2014 04:16 AM

    Hello Suman, 

    I did your suggestions step by step and re-run health report but result is the same, 

    Hi Scott,

    Both OS and DB is standart. 

    Thanks to both of you for your suggestions

    Regards



  • 5.  RE: Clarity v13 Incompatible SQL Server 2008

    Broadcom Employee
    Posted Mar 21, 2014 07:46 AM

    Hi..

    Please share the me the healthreport.xml and the screeshot and i will take a look.


    Regards

    Suman Pramanik



  • 6.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 21, 2014 10:01 AM

    Hello Suman,

    Files are attached, thanks in advance for your support.

    Regards

    Attachment(s)

    xml
    healthreport.xml   1 KB 1 version


  • 7.  RE: Clarity v13 Incompatible SQL Server 2008

    Broadcom Employee
    Posted Mar 21, 2014 10:56 AM

    HI..

     

    I should have told you before itself that we dont support Microsoft standard edition. Below are the versions we support with 13.2

     

    Microsoft SQL Server 2008 Enterprise Edition: Any service pack7c), 7d)
    ■ Microsoft SQL Server 2008 R2 Enterprise Edition: Any service pack7c), 7d)
    ■ Microsoft SQL Server 2012 Enterprise Edition: Any service pack7d)
     
    Regards
    Suman Pamanik


  • 8.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 21, 2014 11:06 AM

    Sunman,  a little off topic here but can you give me any idea as to why standard edition is no longer supported?  I ran this past our DBA's and from their vantage point and from what they've seen (i.e. we've run standard edition in previous versions) that standard edition would be sufficient.

    Any insight you can give would be appreciated.

     

    Thanks!



  • 9.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 21, 2014 11:11 AM

    Standard edition has never been supported.

    One reason is that standard edition doesnot support indexed views which makes a drastic reduction in performance in production environments.

    There was a post by Josh L. about that some two years ago.

     

    Martti K.



  • 10.  RE: Clarity v13 Incompatible SQL Server 2008

    Broadcom Employee
    Posted Mar 21, 2014 11:32 AM

    I agree with Martti, Standard Edition was never been supported but with 13.3 in the upgrade script we have put a check where if you have standard edition you cannot upgrade.

     

    Regards

    Suman Pramanik



  • 11.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 21, 2014 12:00 PM

    Still I should suspect that it does not stop you from doing where we once got hurt: restoring a backup from entended edition to standard edition.

     

    Martti K.



  • 12.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 21, 2014 05:51 PM

    Hello Suman, 

    So is it possible to skip the script that you mention? I mean this SQL Server Standart control? using Force or any other option? 

    I want to note that SQL Server Enterprise is more expensive and using enterprise release on test environments is not cost effective. I think being able to install CA Clarity on standart version would be better even its not supported.

     

    Regards 



  • 13.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 22, 2014 04:23 PM

    This is my db in my VMware.

    I have successfully upgrade that to v13.3 and done a fresh install of v13.3 without any complaint about compatibility or version of the db.

     

    Martti K.

     



  • 14.  RE: Clarity v13 Incompatible SQL Server 2008

    Posted Mar 21, 2014 05:07 AM

    Hello,

    If  possible, can any one who use CA Clarity v13 with SQL Server 2008 R2 on virtual environment share full version of his database? 

    Regards