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
No we are not using any pipeline object here. We are using DWs to copy the data from files, Storing in respective tables in local dbase(ASA) then again with the help of DWs we are setting them in format we need as PDF and saving the DW as PDF and copying these PDFs to a location. After PDF creation we are doing one related entry in SQL server database and from where these reports will display under right category in another web application.
So when we are making connection with SQL server, there its giving mentioned error. And its something which is coming randomly anytime.
Thanks,
Deepshikha