AnsweredAssumed Answered

Is there a limit on the number of Event Frames I can query using PI OLEDB to build SSAS cubes

Question asked by hmokdad on Jun 14, 2017
Latest reply on Jun 15, 2017 by hmokdad

Hi,

We are trying to query all of the Event Frames in our AF Database using PI OLEDB Enterprise to build SSAS (SQL Server Analysis Server) cubes. Our query is fairly simple, just "SELECT * FROM [MyAFDB].[EventFrame].[EventFrame]  OPTION(ALLOW EXPENSIVE)"

 

When the number of Event frames was below 1,500,000 events, everything worked fine. But when the number of Event Frames exceeded this number, we began getting this error when building our Cubes (which is basically the SSAS engine querying the Event Frames using our query):

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Internal AF Server failure. Make sure AF Server uses the latest PI SQL (AF) Service version.

Details: [Orb] Response stream corrupted..'. "

 

So our question is what is the maximum number of Event Frames that we can query from PI OLEDB Enterprise. Below are the versions of the software we are using:

  • SQL Server & SSAS 2016 SP1 (13.0.4001.0)
  • SQL Data Tools 2015
  • PI OLEDB Enterprise 2016 (1.4.1.63 )
  • PI AF Server 2016 R2

Outcomes