Get an Error Running a CCA Report Error:CCA-RT-6053: Execution of report "<Report Name>" failed. - Report server login failed for user. "Administrator"

Document ID : KB000020348
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

You get an Error Running any CCA Report

Error:CCA-RT-6053: Execution of report "<Report Name>" failed. - Report server login failed for user. "Administrator"

This is due to a number of possible reasons, which this techdoc will cover a good portion of those issues.

Solution:

When running the report and getting the Error:CCA-RT-6053 error, the message reads, : Execution of report "<Report Name>" failed. - Report server login failed for user. "Administrator", however., the "login fail" is not necessarily the case, but that should be the first thing confirmed:

  1. In the CCA UI --> Administration --> Configuration --> Properties --> group="bo" --> name = "server" and name = "server.port" as well as name ="webserver.nane" and name="webserver.port". Do not forget to confirm the username and password where name="admin.password" and name="admin.user"

    Figure 1

  2. Next, confirm the CCA Report request is making it to the BOXI Server

    • Run a Report from the CCA UI (ex: Agent Status Report)
    • Log into the BOXI Central Management Console (CMC) --> All Reports --> CA reports --> CCA --> Right click on the report that was right )ex: Agent Status Report) --> Select History

      Figure 2

    • Confirm the report you just ran from CCA UI exists in the history tab

      • If it doesn't exist,

        • Confirm the BOXI server is accessible from the CCA Sever and\or Grid Nodes

      • Confirm the Ports are accessible

    • If all else fails, Reimport the Reports

  3. Setup CCA Reports in BOXI Post Installation

    • Navigate to the "<server installed location>\ reports\setup" path and edit file: "cca_biar_import.xml" with acmserver database password.
    • In command prompt, Navigate to above location and execute following command:
      importBiar -boxiAdminPwd <Boxi admin password> -boxiAdminUser <Boxi admin user name> -boxiHttpPort <boxi http port number> -boxiHttpServer <Boxi http Server name> -boxiPort <Boxi Server Port Number> -boxiServer <Boxi Server name> -password <CCA server password> -user <CCA server user>

    1. If the report exists, lets check the Universe connection and lets reset the database connection just to be sure

      1. First thing is to check if tables are bringing back data

        1. Go to Boxi Server and launch login to designer
        2. File --> Import Universe
        3. Find \ select the Universe
        4. Right click on one of the main tables (that has many relationships), select "Table Values"

          Figure 3

        5. a. If a popup box appears with values, then it works
          b. If a popup box appears with no values, continue Below to Reset BOXI Universe Connection
          c. If you get an error message of "CS:COM Provider CLSID not specified or erroneous" , then please follow this attached document(Troubleshooting_BOXI_CLSID_error), which pertains to SQL Server 2005 and 2008

    2. Reset BOXI Universe Connection

      1. Go to Boxi Server and launch login to designer
      2. Hit cancel on the popup wizard
      3. Go to tools --> connections
      4. Edit CCA
      5. Hit the back button
      6. Click a version that you are NOT using, hit next
      7. Click Back again
      8. Select the sql server version that you ARE using with OLE
      9. Fill out the information

        Figure 4

      10. Test the database connection
      11. Click next, next, finish
      12. Close the inner windows.
      13. In the designer, click on Save
      14. Then click on file--> Export


    • Remember, if the client is using

      • A named instance for the SQL database, the databasename format must be DatabaseName\InstanceName,Port

        Figure 5

        an Oracle Database, ensure the Oracle Client tools is installed on the BOXI Server