Reports do not show up the content in right pane when you try to see under the [Public Folders] - [CA Reports] on the InfoView.

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

When you try to see under the [Public Folders] - [CA Reports] on the InfoView on the Business Intelligence box that is installed to different box (Not installed USRD to the box), the database logon screen appears. This article explains the solution at the situation.

Solution:

[Problem]

When you try to access the [Public folders] - [CA Reports] on the InfoView, you may see the database logon screen in the right pane. The environment is installed Service Desk and BOXI to different machines, not installed them to the same box. i.e. public folder\CA Reports\CA Service Desk\Asset\Asset List.

<Please see attached file for image>

[Solution]

This problem is known problem. The reason why the problem occurs is that the CA Service Desk ODBC Client is not installed correctly when the Business Intelligence is installed. The below steps will solve the problem.

1. Go to c:\Program Files\CA\SC\CASD_ODBC and remove the "schema" file that does not have an extension on the Business Intelligence box.
   
   
2. Run the <Drive of the Service Desk installation DVD2>\ca_tps.nt\CABO\ca_odbc_client\setup.exe.
   
   
3. CA Service Desk ODBC Client Setup will appear. Click 'Next' button.
   
   

   <Please see attached file for image>

   
   
   
4. Click 'Yes' button.
   
   

   <Please see attached file for image>

   
   
   
5. Select c:\Program Files\CA\SC\CASD_ODBC as destination folder and click next.
   
   

   <Please see attached file for image>

   
   
   
6. Input the value as below.
   
   Name: casd_<ServiceDesk server name>
   Description: Input an optional value
   TCP/IP Address: IP Address of ServiceDesk server
   TCP/IP Port: Input '1706'
   
   

   <Please see attached file for image>

   
   
   
7. Select the below file and click 'next' button.
   
   <Drive of the Service Desk installation DVD2>\ca_tps.nt\CABO\ca_odbc_client\oaclientkey.lic
   
   

   <Please see attached file for image>

   
   
   
8. Click 'Next' button.
   
   

   <Please see attached file for image>

   
   
   
9. Click 'Next' button.
   
   

   <Please see attached file for image>

   
   
   
10. Click 'Finish' button.
    
    

    <Please see attached file for image>

    
    
    
11. In order to check the database access, start the 'Interactive SQL(ODBC)' from the below shortcut.
    
    Start button -> DataDirect OpenAccess ODBC Driver v5.6 -> Interactive SQL (ODBC)
    
    
12. Run the below command to check the MDB access.
    
    

    <Please see attached file for image>

    
    
    i.e. connect administrator*<administrator's password>@<Value that you set at #6 as the Name>
    
    If the connection succeeds, the below message will appear.
    
    

    <Please see attached file for image>

    
    
    
13. Copy the 'oainfo.ini' in the below location on the Service Desk server box.
    
    $NX_ROOT\CA\Service Desk\pdmconf\schema\oainfo.ini
    
    
14. Paste the 'oainfo.ini' that you copied at #13 to the below location on the Business Intelligence box.
    
    C:\Program Files\CA\SC\CASD_ODBC\schema
    
    
15. Run the 'CA Business Intelligence Configuration'
    
    

    <Please see attached file for image>

    
    
    
16. Click 'Next' button.
    
    

    <Please see attached file for image>

    
    
    
17. Input the necessary information as follows and click 'Finish' button.
    
    

    <Please see attached file for image>

    
    
    
18. When the configuration completes, the below message will appear. Click OK to close.
    
    

    <Please see attached file for image>

    
    
    
19. Start the 'Central Management Server' service on the Business Intelligence box.
    
    
20. You will see the content under the [public folder] - [CA Reports] on the InfoView without any problems.

Environment

Release:
Component: ARGIS