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
What is the datatype of the column - make sure you arent trying to total a non numeric value.