COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: glim on 13 Apr 2023 06:14:43 PM

Title: An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'
Post by: glim on 13 Apr 2023 06:14:43 PM
wonder if there is a way to fix this error?

Title: Re: An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'
Post by: MFGF on 14 Apr 2023 07:32:41 AM
Quote from: glim on 13 Apr 2023 06:14:43 PM
wonder if there is a way to fix this error?

Hi,

"An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'" is a generic error, and just means something went wrong when the server was trying to execute the query. This would normally be followed by more details in the error message - these details can usually help you pinpoint what the server is unhappy with. If you are using Compatible Query, I'd expect to see a follow-on message that begins "UDA-SQL-<something>"

Cheers!

MF.
Title: Re: An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'
Post by: glim on 16 Apr 2023 05:52:26 PM
Thx for your reply.
Title: Re: An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'
Post by: MFGF on 17 Apr 2023 07:07:44 AM
Quote from: glim on 16 Apr 2023 05:52:26 PM
Thx for your reply.

Hi,

What was the rest of the error? Did you find the issue?

Cheers!

MF.