Integration Stop itself mostly 33 mins after deployment starts. 追蹤
I am new to here. We recently making a web site to allow users to input the carton info then submit to trigger new record add to the database(MS SQL server at Azure). The label prints once the integration detect new record in the table has been created. It work perfectly during test. We then deploy it. We found that it usually stop itself after 33 mins but sometimes longer. Here is the error message from the log.
- Unable to run integration 'Database Integration' while opening record set with 'select * from boxSetUp order by _timestamp desc'. Details: 'ExecuteReader requires an open and available Connection. The connection's current state is closed.'
We have tried below but doesn't work.
- Changing the Error Handling time - Max Retries 5 times and Tim Between Retries 500 seconds.
- Changing the Database Connection - Poll Time to 1 min.
How do we find out the reason? What should we do? Please help.
Please let me know if you need any kind of info details about this issues.