IBM Support

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

Technote (troubleshooting)


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.


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.


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



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 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.

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: 28 April 2016

Translate this page: