ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Usage statistics tool fails with "U00003590 UCUDB - DB error" using MS-SQL DB

book

Article ID: 88140

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
U00003590 UCUDB - DB error: 'SQLNumResultCols', 'ERROR ', '42000', 'Statement(s) could not be prepared.'
U00003592 UCUDB - Status: '42S02' Native error: '208' Msg: 'Invalid object name 'MQCP001'.'

The Usage Statistic tool fails immediately upon execution, and does not generate output files.

The invalid object name error, as shown above, occurs because a change in the MS-SQL DB schema was introduced with version 11.2.  The MQ tables have been modified and renamed.  Therefore, these errors indicates that the Usage statistic tool is from a prior version.  You must use a version of the Automation Engine and the tool that is compliant with each other.

Investigation

The last entry in the log is :

U00003590 UCUDB - DB error: 'SQLNumResultCols', 'ERROR   ', '42000', 'Statement(s) could not be prepared.'

In in the Usage Statictic tools' logs: Search for these errors :
 
20170120/064459.357 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 4b7260  DB-HDBC: 4b7330
20170120/064459.358 - U00003591 UCUDB - DB error info: OPC: 'SQLNumResultCols' Return code: 'ERROR'
20170120/064459.358 - U00003592 UCUDB - Status: '42S02' Native error: '208' Msg: 'Invalid object name 'MQCP001'.'


 

Cause

Cause type:
Configuration
Root Cause: Versions of AE and Usage Statistics tool not compliant versions.

Environment

OS Version: N/A

Resolution

Use a version of the Automation Engine and Usage Statistic tool that are compliant.

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A