1. Sivaprakash BKR
  2. PowerBuilder
  3. Thursday, 8 July 2021 10:46 AM UTC

Hello,

PB 11.5, SQL Server 2012 Express, Windows Server 2012 R2 (in server) and Windows 7 (in clients)
Also SQL Server 2000 is there to view old data.

Every day at a particular time (between 3.00 to 3.30 pm), Powerbuilder application gets disconnected from client machines.  Couldn't find out the reason so far.   

Error Message:

-1
Select Error: SQLSTATE = 08502
Microsoft SQL Server Native Client 10.0
SMux Provider: Physical connection is not usable [xFFFFFFFF]

 

No scheduled backups is there [ in both SQL Servers].
No windows update is configured.
We couldn't find any programs that's running at that point of time.

When we ping the server from client at that time, response is normal.   We could navigate the folders of the server from clients at that time, normally.  

Only thing is PB application gets disconnected automatically, which runs smoothly when we re-run the application from start.   Again it gets repeated next day.

Any idea how to proceed to find a solution ?

Happiness Always
BKR Sivaprakash

 

John Fauss Accepted Answer Pending Moderation
  1. Friday, 9 July 2021 13:49 PM UTC
  2. PowerBuilder
  3. # 1

Is the SQL Server instance running on your local PC or on a another machine that is accessed via network?

If it is running on a networked server (typical) and you have SQL Server Management Studio (SSMS) connected to that instance during the affected time range, does its connection also drop unexpectedly?

I agree with others that your issue sounds like something else on your network is causing connections to the database to be dropped. Do you have an instance of SQL Server running on your PC that you can connect your app to, temporarily, to troubleshoot? If so, I would see if the app's connection to the local instance also drops during the same time interval. If not, that would indicate something else on the network is causing the issue.

Some time ago I worked for a company that experienced a nearly identical problem. The issue was caused by Network/Security teams implementing a port scanning process to detect unauthorized network access... as a result, when the various ports used by a mission-critical, unattended process were scanned (at roughly the same time every day), it caused that application's connections to the database to be dropped, causing major service outages. Of course, this port scanning was implemented without first informing any of the development teams! A stellar example of teams working together (not!)

Comment
  1. Armeen Mazda @Appeon
  2. Friday, 9 July 2021 15:49 PM UTC
There is no "I" in "TEAM"... hahahahaha
  1. Helpful
  1. Sivaprakash BKR
  2. Saturday, 10 July 2021 04:58 AM UTC
Thanks John

It's in a network environment. Connection drop happens in server too where SQL server is installed. When we re-run the application again, from start, everything works fine.



  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 July 2021 15:41 PM UTC
  2. PowerBuilder
  3. # 2

HI Sivaprakash;

  FWIW:  As  suggestion, I would talk with your Network and DBA teams to see if there are any session / connection timeouts set in your environment that might be affecting your PB App(s).

Regards ... Chris

Comment
  1. Brad Mettee
  2. Thursday, 8 July 2021 16:19 PM UTC
I'd also suggest you ask your network teams about any servers/routers/switches that might be getting reset overnight. It's possible the AM/PM flag is set improperly and resets are being done during the day instead.
  1. Helpful
  1. Sivaprakash BKR
  2. Friday, 9 July 2021 05:20 AM UTC
Thanks Chris, Brad

All cables, switch have been replaced with newer one. Says nothing is configured in server for reset or automatic update.

SQL Server(s) were installed by me. I didn't configure any such thing that affects a particular time. Those were working fine till a particular date.

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.