Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PPES_DISPATCHER was not found in the dictionary

Status
Not open for further replies.

bostondba

IS-IT--Management
Jul 8, 2008
4
US
Hi All,

I have tested the cognos_audit database connection in Access Manager and test works fine. But when I run PPESAuditFileProcessor from the command line I hit by this error.
Even database has the table also. Can any one provide me some information about this error

------------------------------------------------------------
ERROR ==>>
UDA Status: -239.DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
DMS-E-RBI_TABLE, The table or view cognos_audit...PPES_DISPATCHER was not found in the dictionary.
-------------------------------------------------------------------
********************************************************************
C:\cognos\cer4\bin> PPESAuditFileProcessor
-dbname cognos_audit
-dbconnect "^User ID:^?Password:;LOCAL;OL;Provider=SQLOLEDB;User ID=%s;Password=%s;Data Source=devcognos;Provider_String=intial catalog=cognos_audit@COLSEQ="
-dbuser sa -dbpass xxxxxxxxxx
-auditlocation C:\cognos\cer4\ppserver

********************************************************************

Here our cognos_audit database table list
=======================================
PPES_ADMIN_SOURCE
PPES_DIM_USAGE
PPES_DISPATCHER
PPES_LEVEL_USAGE
PPES_MEASURE_USAGE
PPES_REQUEST
PPES_SESSION
PPES_USER_SOURCE


Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top