Clarity

Expand all | Collapse all

Out of the BOX BO Reports are not working

  • 1.  Out of the BOX BO Reports are not working

    Posted 05-11-2017 01:33 PM

    Hi We recently upgraded out BO Server to BOXI 3.3 SP2 and having Clarity 14.2 SP11. We are unable to run any of the reports available in CSP folder.

     

    We are getting error like this.when running missing time report or any other report.

    Error in formula no_data: 'IsNull (Count ({Command.resource_id}))' This field name is not known. 

     

    This seems like we are unable to connect the database. WE have checked the following things...

    CABI (32 bit version installed)

    we also have 32 bit data source ODBC on server

    CSA has correct setting

    Create BO Users and Update BO Objects job ran successfully

     

    Any thoughts?

     

    Thanks,

    Sal.



  • 2.  Re: Out of the BOX BO Reports are not working

    Posted 05-11-2017 02:51 PM

    Hi Shalinee,

     

    Is this only with one particular report or all, to ensure BO reports to work you need to ensure CSP solution pack and PMO accelerator pack to be installed. 

     

    Regards

    Suman Pramanik 



  • 3.  Re: Out of the BOX BO Reports are not working

    Posted 05-11-2017 03:00 PM
      |   view attached

    All Out of the Box Reports under CSP folder are not working. Yes, we have

    successfully installed the  CSP solution pack and PMO accelerator pack  in

    our instance.

     

    Thanks,

    Shalinee



  • 4.  Re: Out of the BOX BO Reports are not working

    Posted 05-11-2017 03:07 PM

    Have you granted the Role CA-PPM-Reporting-User and Everyone, please check the below thread to see if it helps

     

    RPT-0014: Unable to retrieve the report information from reporting server 

     

    Also try running the reports from Crystal Report Designer to see if it works 

     

    Ref :How to get the SQL query running in CA Clarity PPM Solution Pack (CSP) reports 

     

    Let me know how it goes?

     

    Regards

    Suman Pramanik 



  • 5.  Re: Out of the BOX BO Reports are not working

    Posted 05-11-2017 03:33 PM

    Here is the case.

     

    I am trying to login as "adminxog" users and it is in both the groups on

    CMC. Please refer the attached screen. Also all the clarity active users

    are in both the groups.

     

    (Embedded image moved to file: pic55073.gif)

     

     

    (Embedded image moved to file: pic41097.gif)

     

     

    When we are going in CMC and doing the Database configuration with the

    below setting. Report is running fine however when we are trying to run

    from Clarity it is switching back the "Specify a custom table prefix"

    setting ""

     

    (Embedded image moved to file: pic61754.gif)

    (Embedded image moved to file: pic58904.gif)

     

     

    When we are giving the custom table prefix then reports are not running

    from CMC or Clarity.

     

    Thanks for your help.

     

    Sal.