Expose timeout setting for P2B integration

[Problem Summary]

Customer uses a stored proc in the P2B SelectCommand property to fetch the PI event frames from PI Server. It is normal for the query to run for 2 minutes or longer sometimes.

When in this situation, Ampla integration reports timeout error in the Integrations Diagnostics page, and the execution fails with the error. "Unexpected exception in archiving data Execution timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

Since it looks like the timeout settings for P2B are hardcoded as well, similar to the CLR stored procedure query timeout. Naga wants to Expose Select/Update command timeout setting for the P2B. Thanks.

[Reproduced in-house (Sydney GSC)]

[Steps to Reproduce]

[Possible Cause]

[What is the impact to Customer/s]

[Workaround]

N/A

[Checklist]

Project backup

Data Repository

Event logs

Performance logs

Runtime Diagnostic logs

Screen dumps

For more info on the primary case, please visit:

https://gcsservicecloudutils.azurewebsites.net/casedetails?casenumber=960296234