If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

UDA-SQl-0283 Error in Report Studio

Started by vkishore760, 06 Aug 2009 11:25:32 AM

Previous topic - Next topic

vkishore760

I have a strange situation.
I have imported a stored procedure in Oracle in to FM as query subject  and it is executing fine by asking for input parameters in FM.
But when I simply pull the same in Report studio after publishing the package,it is not working and throwing the following error.

QE-DEF-0177 An error occurred while performing operation
'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation
"APICursor::OpenResult" is inactive.
UDA-SQl-0283 Metadata describing "XXX"
does not match results from the database wheree XXX stands for the name of the procedure.

Is it like the data that is retrieved would be converted to char by Rp as I have some Float fileds also that are returende.
I tried casting the same to char but still getting the same error.Can u pls help me asap.

Mary11

Hi Kishore,
Even i am facing the same issue. It would be help if you can post the solution for the same