When trying run a report in Java Infoview it shows ERROR: "FAILED TO OPEN CONNECTION"

book

Article ID: 53510

calendar_today

Updated On:

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:

This document explains the steps to resolve connection error in Java Infoview.

Solution:

The error message ERROR: "FAILED TO OPEN CONNECTION" generally appears if the ODBC connection to ServiceDesk is having a problem.

Steps to verify if the ODBC connection is working:

  1. On the BOXI server, go to Start ->All Programs->Business Objects XI Release 2->Business Objects Enterprise->Designer

  2. Login to Designer as Administrator.

  3. In Designer, click on Tools->Connections Fig 1

    Figure 1

    <Please see attached file for image>

    Figure 1

  4. Select CA ServiceDesk and click on Edit.

  5. In the next screen the UserName and Password being used are displayed. Click on Next . Figure 2

    Figure 2

    <Please see attached file for image>

    Figure 2

  6. Click on Test to validate the connection. It should display a message "The Server is responding" If not there is a problem with the connection. The error message is displayed on the left side. Figure 3

    Figure 3

    <Please see attached file for image>

    Figure 3

  7. In this example it displayed Login Failed. Click on Back button and re-type the password in the password field. Then click on Next and test the connection again. Figure 4

    Figure 4

    <Please see attached file for image>

    Figure 4

  8. Close the Designer and the reports in infoview will work.

Environment

Release:
Component: ARGIS

Attachments

1558711175863000053510_sktwi1f5rjvs16s5j.gif get_app
1558711173968000053510_sktwi1f5rjvs16s5i.gif get_app
1558711172160000053510_sktwi1f5rjvs16s5h.gif get_app
1558711170027000053510_sktwi1f5rjvs16s5g.gif get_app