OLEDB connection to OSI PI timing out

[Former Member]

I have a connection to OSI PI that times out on large queries after ~80-90 seconds. We've changed the ICM, UDS, and data server connection properties to 600 seconds just to test, and we still get the error. The SQL query block is also set above 600 seconds. I've been told the timeout on the PI server is 180s. The errors below are what is showing in the logs:

2011-07-28 15:28:29:231 Error has occurred while processing data stream OLEDB Query error

2011-07-28 15:28:29:231 Error reading proxy return stream

2011-07-28 15:28:29:231 OLEDB Query error

2011-07-28 15:28:29:231 Error has occurred while processing data stream OLEDB Query error

2011-07-28 15:28:29:231 Error reading proxy return stream

2011-07-28 15:28:29:231 OLEDB Query error

Does anyone have an idea what I may be missing here?

Grant

[agentry_src]

Hi Grant,

PI OLEDB is not referencing a true relational database. So there are some different considerations when building your sql scripts. OSI has a white paper regarding tips and tricks to use when building OLEDB scripts against their data storage structures. Check their website (I usually go through their vCampus site) for it. If you can't find it, I can send you a fairly old copy which will still be applicable.

Regards,

Mike