Clarity

  • 1.  Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link

    Posted Apr 26, 2017 04:29 AM

    Hi,

     

    I am upgrading from Clarity 13.3 to 14.3. The check install logs are good when I execute the checkinstall.bat without any error.

    Now when I start the actual installation for 14.4, I get the below message after initial file updates :

    The Post Check result log error message is :

     

    Process Type:
    AFTER INSTALL

    Utility Version:
    1.2.0.5

    Upgrade From Version:
    13.3.0.286

    Upgrade To Version:
    14.3.0.298

     

    check-dwh-dblink-dbserver.xml WARNING Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link. Refer to Installation guide for more details.

     

    How should I fix this and complete the upgrade.

    Please anyone who knows the solution on this, kindly suggest.

     

    Thanks in advance.



  • 2.  Re: Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link
    Best Answer

    Broadcom Employee
    Posted Apr 26, 2017 04:35 AM

    Hi Heeral,

     

    DWH will give an warning as you need DWH in order for Jaspersoft reporting to work but its not mandatory, so you can safely ignore and proceed. 

     

    Regards

    Suman Pramanik 



  • 3.  Re: Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link

    Posted Apr 26, 2017 06:47 AM

    Thanks alot Suman for your guidance. The upgrade worked smoothly this time and was successful.



  • 4.  Re: Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link

    Broadcom Employee
    Posted Apr 26, 2017 06:50 AM

    Hi Heeral,

     

    Thank you for letting me know, I am glad to hear that upgrade was smooth and successful.

     

    Regards

    Suman Pramanik 



  • 5.  Re: Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link

    Posted Apr 26, 2017 02:13 PM

    Hi Suman,

     

    I need your help again.

    I have upgraded to Clarity 14.3, but now  I do not see the option Add-ins under studio to apply the two csp  and csk add-ins.

     

    So next I tried is to import the reports using Import Wizard and importing CA_Clarity_Universes_MSSQL.biar file, but the CA Clarity folder in http://localhost:8080/CmcApp is blank, it does not have CSP folder and the standard Clarity reports.

    Am I missing something? I followed the document, but here I am with no success.

     

    Kindly suggest what is to be done to correctly import all the standard reports?

    Thanks again for all your help.

     

    Note: All Clarity related queries should be addressed to dl Clarity Help Desk. Email sent to individuals may result in delayed response.

    Thanks & Regards, 

    Heeral S. Thakore

    Xcel Energy | Clarity Help Desk

    C: 91.779.857.7706

    E: Heeral.S.Thakore@xcelenergy.com<mailto:Heeral.S.Thakore@xcelenergy.com>



  • 6.  Re: Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link

    Posted Apr 26, 2017 02:16 PM

    I am trying to import all the reports under : F:\SPF\Niku\Clarity\reporting\content\csp\bo\reports\mssql

     

    Note: All Clarity related queries should be addressed to dl Clarity Help Desk. Email sent to individuals may result in delayed response.

    Thanks & Regards, 

    Heeral S. Thakore

    Xcel Energy | Clarity Help Desk

    C: 91.779.857.7706

    E: Heeral.S.Thakore@xcelenergy.com<mailto:Heeral.S.Thakore@xcelenergy.com>



  • 7.  Re: Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link

    Broadcom Employee
    Posted Apr 27, 2017 02:13 AM

    Hi Heeral,

     

    I would request you to start a new thread for different issue, it will help other community members to look out for answer when they hit the same. 

     

    Also when you upgrade to 14.3 you need to install the addin too and for the BO reports it would be csp and to install the addin it would be 

     

    admin content csp 

     

    For CSP biar file we had a discussion before see this thread Report missing in CA Clarity PPM 13.3 new installation 

     

    Ref: How do I install CSP and PMO Add-Ins in Clarity PPM 13.3? 

     

    Note: Also I would like to let you know that we have stopped support for BO and request you to plan your migration to Jaspersoft. 

     

    Regards

    Suman Pramanik 



  • 8.  Re: Provide database Link Server details to both Clarity and DWH in CSA and Click Save to create the database link

    Posted Apr 27, 2017 03:52 AM

    Thanks a lot Suman. I have created a thread for this issue: https://communities.ca.com/message/241975456

    I have installed both csk and csk from command prompt, the issue is this:

     

     

    -          There is no add-in option in Clarity -> Admin -> Studio

     

    -          The CSP report is missing in http://localhost:8080/CmcApp

    I know we had discussed this but kindly help me on this for now and I will document it correctly for future use.

     

    Note: All Clarity related queries should be addressed to dl Clarity Help Desk. Email sent to individuals may result in delayed response.

    Thanks & Regards, 

    Heeral S. Thakore

    Xcel Energy | Clarity Help Desk

    C: 91.779.857.7706

    E: Heeral.S.Thakore@xcelenergy.com<mailto:Heeral.S.Thakore@xcelenergy.com>