UDA-SQL-0196 The table or view "dsb_sequence" was not found in the dictionary

Technote (troubleshooting)


Problem(Abstract)

Attempting to run a Data Manager build via the data movement service fails with an error.

Unsetting the DM_AUDIT_DB and DM_AUDIT_DB_DRIVER variables removes the error but no audit information is written.

Symptom

DM-DBM-0400 UDA driver reported the following on connection ALIAS_0106BD90
UDA-SQL-0107 A general exception has occurred during the operation "columns".
ORA-00942: table or view does not exist
UDA-SQL-0196 The table or view "dsb_sequence" was not found in the dictionary.


Cause

Data Manager audit tables don't exist in the audit database

Environment

Windows

Diagnosing the problem

Check DM_AUDIT_DB and DM_AUDIT_DB_DRIVER variables

Resolving the problem

DM_AUDIT_DB and DM_AUDIT_DB_DRIVER variables were set but were pointing to a separate database to the Data Manager catalog database. The audit database did not contain the Data Manager audit tables.
Either use change the audit variables to use the Data Manager catalog database for auditing or create the audit tables in the audit database. The simplest way to do this is to create a new Data Manager catalog in the audit database as this will create the audit tables automatically.

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence
Data Manager

Software version:

10.1, 10.1.1, 10.2, 10.2.1

Operating system(s):

Windows

Reference #:

1651296

Modified date:

2013-09-27

Translate my page

Machine Translation

Content navigation