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

sqlPrepareWithOptions status = -256

Started by smtest, 06 Jun 2007 12:06:56 PM

Previous topic - Next topic

smtest

I have a query studio report, when ever i publish a package and tries to open an existing report with an updated package, it throws the sqlprepareWithoptions stutus = -256 error. After analysing, i found out it is happening because of one column, which is an attribute and i am using count distinct and total as an aggregate rule. if i remove that column and put it back, it works fine. But same error if i publish that package again. Error in Detail: UDA-SQL-0213 The data type of an argument to an aggregate function is invalid. RSV-SRV-0042 Trace back: RSReportService.cpp(613): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(202): QFException: CCL_RETHROW: RSReportServiceMethod

goose

What is the datatype of the column - make sure you arent trying to total a non numeric value.