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!

Error when user runs report in Report Studio 1

Status
Not open for further replies.

cog8user

Programmer
Sep 7, 2007
8
IN
Hi All,

User gets the following error when he runs a few reports in Report Studio. As part of the security, it's all fine. Could anyone let me know how I can debug this?

An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2007-12-19-16:28:51.467-#1215

Any help is appreciated very much.

Thanks in advance.
 
Take the native SQL and parse it in a query tool..

Ties Blom

 
Hi,

Thank you for your quick response.
The report I referred to is in Public Folders and I am able to run it perfectly using my credentials.
I wonder why the user only gets this error.
 
AFAIK there is a logfile on the Cognos server that stores the entire error. I forgot the name of the file, but did you check there?

Ties Blom

 
I mean the c8server.log file on the server..

Ties Blom

 
Hi,

I checked the log file (cogserver.log)in Program Files\cognos\c8\logs. I didn't find the particular error here. Can there be any other location for these logs?

Thanks
 
regardless, it has to be something particular to the user--can he do other Cognos tasks (could his setup be incorrect)? users do a lot of crazy stuff. are you SURE it's not his access? have you tried logging in as him and running the query on your pc?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top