Output Data Tool Error Message when Integrating with OsiSoft PIDB

[ctmckay18]

Hello Alteryx Gurus,

I place my questions at your feet in the hopes of an answer!

I am working with a client who utilizes PiDB from OsiSoft.  The data is a combination of structured and unstructured, so the client is utilizing a 32-bit OleDB driver.  We have connected via Generic Connection and 32-bit connections and are receiving the following error when attempting to write to a table in PiDB:

Error: Output Data (2): Error opening query: PIOLEDB: [PI SDK] [230FET10301.oPV] Failed to retrieve events from server.  [-11091] Event collection exceeded the maximum allowed

I'm trying to figure out whether the Output Tool is attempting to query/write simultaneously or whether the Output Tool is unable to retrieve the appropriate schema it's attempting to write to.  Happy to answer any and all questions I can!  Thanks so much for your help!  Have a great day.

Best,

Christopher

[TrevorS]

Hello @ctmckay18 
Thanks for reaching out to the Community! 

At this time, OsiSoft PIDB is not a supported data source currently for Alteryx. You can submit an Idea for this suggesting OsiSoft Pi DB is added and supported.

I was able to find a similar question to this from another user which has a workaround that may help!
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-Alteryx-to-OSI-Soft-PI/td-p...

Thanks!
TrevorS