AnsweredAssumed Answered

SSRS / OLEDBEnt Queries

Question asked by gtranter on Oct 10, 2016
Latest reply on Oct 10, 2016 by avanfosson

Having some issues with OLEDB Enterprise queries in SSRS 2016.

 

I can create simple shared datasets such as:

 

SELECT

e.name AS Site

FROM [TableNAME].Asset.Element e

 

This data is able to be previewed and reported against in Report Builder.

 

 

As soon as I expand the query to include anything useful, such as:

 

SELECT

e.name AS Site,

valueFF.Value

FROM [TableNAME].Asset.Element e

INNER JOIN [TableNAME].Asset.ElementAttribute eaFF ON eaFF.ElementId = e.Id

INNER JOIN [TableNAME].Data.Snapshot valueFF ON valueFF.ElementAttributeID = eaFF.ID

WHERE eaFF.Name IN ('Level')

 

The query works in SQL Commander but i get the following error in SSRS when attempting to preview.

The following error when i attempt to use it in Report Builder

Query timeout is deactivated in SSRS:

I am currently trying to remote error logs enabled.


Any thoughts?

 

 

Grant

Outcomes