When pdm_load is run, the following ERROR message is written to the standard log: Expecting database table name.

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:

The error message, "Expecting database table name" usually indicates that there is a duplicate entry in the file that is specified by the Service Desk environment variable, NX_TABLE_MAJIC_CFG. Despite this error, pdm_load succeeds.

For example, in the case of a duplicate, the following message may be written to the stdlog:

dbload 1472 ERROR dbconfig.c 201 Error line 682: Expecting database table name

Solution:

To correct the error situation that occurs when you run pdm_load, follow these steps:

1. View the NX.env file that exists in the base installation Service Desk Manager directory, $NX_ROOT.

2. Find the statement that contains: NX_TABLE_MAJIC_CFG

For example, the file may contain this statement:
@NX_TABLE_MAJIC_CFG=$NX_SITE/tblobj.cfg

3. Open the file that is specified by the NX_TABLE_MAJIC_CFG environment variable.

For example, open C:\PROGRA~1\CA\SERVIC~1\site\tblobj.cfg

4. Search for duplicates in the file and remove them, leaving only 1 instance of each unique statement.

For example, if there are 2 instances of the statement, "org usp_organization", remove one of the statements.

Environment

Release:
Component: ARGIS