Database logon screen appears during create a report.

book

Article ID: 50302

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 KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

CA Support reproduced a problem with the combination of Service Desk Manager (SDM) r12.6 CA SDM CA SDM Japanese version and BOXI Japanese version that are installed on different servers. Please note that this issue is not reproducible with the English version of SDM r12.6 CA SDM CA SDM and BOXI.

When you try to create a report in BOXI InfoView, the following error appears:

Figure 1. Database logon screen in BOXI InfoView

<Please see attached file for image>

Figure 1

Solution:

  1. Check the 'CA\SC\CASD_ODBC' folder where the DataDirect OpenAccess ODBC driver has been installed.

    Figure 2. Incorrect contents of the '\CA\SC\CASD_ODBC' folder

    <Please see attached file for image>

    Figure 2

    The 'schema' file should not be a file but rather a folder that contains certain configuration files.

  2. Move the schema file from the 'CA\SC\CASD_ODBC' folder to another location as backup. From the SDM r12.6 CA SDM CA SDM DVD #2 install media, copy the '\ca_tps.nt\CABO\oa_odbc_6_client' folder to the '\CA\SC\CASD_ODBC' directory.

    Figure 3. Contents of the '\ca_tps.nt\CABO\oa_odbc_6_client' folder on the SDM r12.6 CA SDM CA SDM DVD #2 install media

    <Please see attached file for image>

    Figure 3

  3. Run the Business Intelligence Configuration program from the SDM r12.6 CA SDM CA SDM DVD #2 install media.

  4. After successful completion of the Business Intelligence Configuration program, the '\CA\SC\CASD_ODBC' folder will be correct as shown in Figure 4.

    Figure 4. Content of the '\CA\SC\CASD_ODBC' folder after the Business Intelligence Configuration program completes successfully.

    <Please see attached file for image>

    Figure 4

  5. Attempt to create a new BOXI report via BOXI Infoview - the database logon screen should no longer appear.

    Figure 5.

    <Please see attached file for image>

    Figure 5

If your SDM version is r12.1, please refer to the following technical document:
https://support.ca.com/irj/portal/anonymous/redirArticles?reqPage=search&searchID=TEC509575.

Environment

Release:
Component: ARGIS

Attachments

1558698671580000050302_sktwi1f5rjvs16odd.gif get_app
1558698669700000050302_sktwi1f5rjvs16odc.gif get_app
1558698667843000050302_sktwi1f5rjvs16odb.gif get_app
1558698665951000050302_sktwi1f5rjvs16oda.gif get_app
1558698664007000050302_sktwi1f5rjvs16od9.gif get_app