Home Knowledge Articles IBM Cognos 8 BI RSV-DR-0002 Unable to execute this request
Follow us on Twitter


Countries

50.1%United States United States
7.6%India India
7%United Kingdom United Kingdom
5.1%Australia Australia
4.8%Canada Canada

Visitors

Today: 31
Yesterday: 111
Last Week: 3354
This Month: 9183
Last Month: 16191
Total: 382836


RSV-DR-0002 Unable to execute this request PDF Print E-mail
(0 votes, average 0 out of 5)
Written by Martijn Christenhusz   
Thursday, 23 July 2009 15:11

Symptom
"RSV-DR-0002 Unable to execute this request"
"UDA-SQL-0213 The data type of an argument to an aggregate function is invalid."
 
Problem
In Query studio occurs this error when double-clicking a query item. 

Cause
Datatype in the SQL server is different than expected.
 
Solution
The data type of this query item in MS SQL Server Enterprise Manager was changed to varchar(10) when it should be of type int. Changing it back to int resolved the error. 
 

Comments

Please login to post comments or replies.
Last Updated on Tuesday, 16 March 2010 16:02
 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?