Hi Folks,
My application is on PB 2017 R2 and its running on windows server 2012 R2 OS. Application is connecting with local DB which is in SQL anywhere and remote database which is in SQL server.
This application is basically fetching the files from a location, storing the data in local dbase (SQL anywhere ) and making the PDFs. While creating the PDFs its doing a entry of report category in few tables of SQL server database.
Exe is scheduled to execute in every 1 and half hour.
Recently we have upgraded our dbase from SQL server 2008 to SQL server 2016. After this we have started receiving the below error frequently. Every alternate day mostly.
Error connecting to Web Reports database SQLSTATE = 08001
Microsoft SQL Server Native Client 11.0
TCP Provider: An existing connection was forcibly closed by the remote host.
We have upgraded SQL native client as well , it has version 2011.110.7001.00.
There is no SQL log created for this error at database side. We also checked the database server timeout settings , this is also set as 0 (no timeout limit).
We have checked event logs as well but didn't found anything suspicious. Windows firewall is off.
As a work around we are restarting the exe and it starts working but we are looking for permanent solution of this.
We are struggling to find the cause and solution of this issue since couple of weeks. Any help on this issue would be highly appreciated.
Thanks,
Deepshikha
Yes I am starting the exe with scheduler.
So when exe is running its connecting with db, performing tasks and disconnecting. its not because of inactivity.
yes there is no reason to stay connected with db while waiting. And I am not doing this :)
in the meantime, a few things to try/consider:
Your remote sql server - how are you connected to it: internet ? are you using a vpn?
if your network is wireless, then try wired instead.
make sure you have latest windows patches
make sure you database does not autoclose.