Author Topic: Error 'sqlPrepareWithOptions' status='-120' opening Analysis Studio report  (Read 6855 times)

Offline RubenvdLinden

  • Community Leader
  • *****
  • Join Date: May 2009
  • Posts: 120
  • Forum Citizenship: +5/-0
Today, I trained one of my users to work with Analysis Studio. We created some simple reports on a DMR and he saved them to the Personal Folders. Now when we try to open one of these saved reports, Analysis Studio immediately prompts "An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'"

I have never seen this error before. Any help would be appreciated.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 6,435
  • Forum Citizenship: +386/-4
  • Cognos Software Muppet
Hi,

Is there anything else indicated in the error message or is it just ''sqlPrepareWithOptions' status='-120' ?

MF.
Meep!

Offline RubenvdLinden

  • Community Leader
  • *****
  • Join Date: May 2009
  • Posts: 120
  • Forum Citizenship: +5/-0
Thanks for your response.

It's just the -120 error. I also tried to open the analysis in Report Studio, but it throws the same error. It doesn't even load the package.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 6,435
  • Forum Citizenship: +386/-4
  • Cognos Software Muppet
Hi,

That's very odd.  Usually, after the message you posted, you expect to see further info - UDA-SQL-0107 A general exception has occurred during the operation "prepare" - then a message from the database or query engine detailing what it was not happy about in the SQL query.

Can you copy the entire message and post it up?

Thanks,

Mark.
Meep!

Offline RubenvdLinden

  • Community Leader
  • *****
  • Join Date: May 2009
  • Posts: 120
  • Forum Citizenship: +5/-0
I think I found what you were looking for:

Failure   RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'.UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled.UDA-SQL-0535 CAST operation on given datatypes is not supported by the database. This operation requires local processing of the data.


Unfortunately, it doesn't tell which data item is causing the problem and as said the report doesn't open anymore in Analysis Studio, nor in Report Studio.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 6,435
  • Forum Citizenship: +386/-4
  • Cognos Software Muppet
Hi,

Right - thanks for this.  It sounds suspiciously like a modeller has changed the FM package and republished since the report was written.  To fix the issue, they need to go to the properties of the data source in Framework Manager and change the Query Processing property from Database Only to Limited Local.

Regards,

MF.
Meep!

Offline RubenvdLinden

  • Community Leader
  • *****
  • Join Date: May 2009
  • Posts: 120
  • Forum Citizenship: +5/-0
Excellent, now it's working again.

 



         
Twittear