This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
if you generate an excel report or a graph based on it, you will get error massage âThe server failed to return business view dataâ.
In ALM 11.52 and above, you may add your own business view or modify the existing one with defined DQL as below format, which contains at least two SELECT clauses and the Sub-SELECT clause is after the key word “Not EXISTS”/” EXISTS”/”NOT IN”/”IN” of the WHERE clause.
WHERE Not EXISTS/ EXISTS/NOT IN/IN
( Sub-SELECT clause
Even though the validation of this business view succeeds, if you generate an excel report or a graph based on it, you will get error massage “The server failed to return business view data”.
The server side would translate DQL of the business view to SQL by parsing the DQL as a tree, when each select clause is a node. During the process, the server is not able to resolve the embedded Select clause with Referred Field in Where clause correctly.
Change you DQL to avoid using “NOT EXISTS”/” EXISTS”/”NOT IN”/”IN”, instead, use “COUNT” , “NOT EXISTS”/”NOT IN” is equivalent to COUNT(‘required field’)<1, while ” EXISTS”/”IN” is equivalent to COUNT(‘required field’)>0. For example
Where test.id Not In (Select test.id From test Where test.id < 2)
Change to –
From test A
Where (Select Count( B.id) From test B Where B.id < 2 AND B.id=A.id)<1
After changing the DQL, save it for the business view and generate BV graph/BV excel report based on it.