ALM Report Error-The server failed to return business view data

  • Questions
  • ALM Report Error-The server failed to return business view data
Question ID: 105924
4
0

We are getting the following error when generating reports.."The server failed to return business view data"

Any ideas?

Marked as spam
Posted by (Questions: 23, Answers: 1)
Asked on January 31, 2015 7:41 pm
9 views
Answers (1)
4
Private answer

This is a know issue.
The DQL statement contains sub select which uses the Exist/IN and inverse Not Exist / Not In.
When the report/Graph is run, the server is not able to resolve the embedded Select clause with Referred Field in Where clause correctly.
Change the DQL query, see example below.

OLD
Select test.id
From test
Where test.id Not In (Select test.id From test Where test.id < 2) NEW Select A.id From test A Where (Select Count( B.id) From test B Where B.id < 2 AND B.id=A.id)<1

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on January 31, 2015 7:49 pm
Thank You
( at January 31, 2015 7:52 pm)