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 (18.104.22.168 )
- PI AF Server 2016 R2