Error when user runs report in Report Studio 1

[cog8user]

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.

 

[blom0344]

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

Ties Blom

 

[cog8user]

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.

 

[blom0344]

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

 

[blom0344]

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

Ties Blom

 

[cog8user]

Thanks... I will check the file once.

 

[cog8user]

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

 

[longhorndkr]

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?