I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Setup, Vista, etc. Topic   Print This     

Paradox on Windows 10 Locking Up

Paradox on Windows 10 Locking Up in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Paradox   Windows   Locking   Paradox Windows   Paradox Windows 10   Locking Up  
Jeff Wampler
12:34 MicroTechnologies
-- USA

I have a customer that insists on continuing to use Paradox. We have the files stored on a file server that has a share that is mapped to all users workstations as a drive. It has been working fine for years. Recently, we migrated the server to from 2008 R2 to 2016. We now have users complaining about the application locking up especially if inactive for a while. I'm wondering if anyone has an ideas to prevent this from happening?

Thanks,

Jeff

 Posted 66 days ago (Thread Starter)
Comment Quote
About Jeff Wampler -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17720, 12 replies
Thread Started 11/13/2019 11:27:51 AM
View Counter=97
Last Reply Posted 11/19/2019 5:01:52 AM)
Location=-- USA 
Joined=66 days ago   MB Posts=7  
Moderator
Steven.G
Myrtle Beach, SC USA

any and all of the usual suspects

oplocks/caching, screen savers/sleep, network cards

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 66 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17721 (Level 2) and Parent is 17720
Reply Posted 11/13/2019 11:44:53 AM
Location=Myrtle Beach, SC USA 
Joined=40 months ago   MB Posts=333  
Jeff Wampler
12:34 MicroTechnologies
-- USA

OK, so what can be done about it. Anything? I'm an outside consultant and know very little about Paradox. The on-site guy that builds all the databases, only knows how to build them. He doesn't know anything about keeping them stable. I'd prefer if them move to something that is still a viable piece of software which I asked them to do in 2008, but they keep creating more databases that are in use all over the company!

 Posted 66 days ago (Thread Starter)
Comment Quote
About Jeff Wampler -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17722 (Level 3) and Parent is 17720
Reply Posted 11/13/2019 11:31:19 AM
Location=-- USA 
Joined=66 days ago   MB Posts=7  
Jeff Wampler
12:34 MicroTechnologies
-- USA

OK, so what can be done about it. Anything? I'm an outside consultant and know very little about Paradox. The on-site guy that builds all the databases, only knows how to build them. He doesn't know anything about keeping them stable. I'd prefer if them move to something that is still a viable piece of software which I asked them to do in 2008, but they keep creating more databases that are in use all over the company!

 Posted 66 days ago (Thread Starter)
Comment Quote
About Jeff Wampler -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17723 (Level 4) and Parent is 17720
Reply Posted 11/13/2019 11:31:19 AM
Location=-- USA 
Joined=66 days ago   MB Posts=7  
Jeff Wampler
12:34 MicroTechnologies
-- USA

OK, so what can be done about it. Anything? I'm an outside consultant and know very little about Paradox. The on-site guy that builds all the databases, only knows how to build them. He doesn't know anything about keeping them stable. I'd prefer if them move to something that is still a viable piece of software which I asked them to do in 2008, but they keep creating more databases that are in use all over the company!

 Posted 66 days ago (Thread Starter)
Comment Quote
About Jeff Wampler -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17724 (Level 5) and Parent is 17720
Reply Posted 11/13/2019 11:31:19 AM
Location=-- USA 
Joined=66 days ago   MB Posts=7  
Moderator
Steven.G
Myrtle Beach, SC USA

all of those things are external

on the server and on every machine, turn off oplocks in the registry, turn off all write caching in the machine settings

make sure the machine doesn't go to sleep after the screen saver comes on

make sure the network cards don't go to sleep with inactivity

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 66 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17725 (Level 6) and Parent is 17720
Reply Posted 11/13/2019 12:46:34 PM
Location=Myrtle Beach, SC USA 
Joined=40 months ago   MB Posts=333  
rum
Frankfort, KY USA

The first thing I would check is whether or not the windows OS on the client side is putting the mapped network drive to sleep.  (Red X in File explorer)..

I use PDOX,  and rather too often walk away and come back another day with a database open.  That in and of itself never causes a problem.    

Howver,  the drive mapping being marked as asleep/disconnected is always a problem and there is a registry edit to fix that.

 Posted 66 days ago
Comment Quote
About rum -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17726 (Level 7) and Parent is 17720
Reply Posted 11/13/2019 12:44:43 PM
Location=Frankfort, KY USA 
Joined=31 months ago   MB Posts=100  
Jeff Wampler
12:34 MicroTechnologies
-- USA

I don't believe you can turn off oplocks in Server 2016 and Windows 10 because they are using SMB 2.0

 Posted 66 days ago (Thread Starter)
Comment Quote
About Jeff Wampler -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17727 (Level 8) and Parent is 17720
Reply Posted 11/13/2019 11:31:19 AM
Location=-- USA 
Joined=66 days ago   MB Posts=7  
Moderator
Steven.G
Myrtle Beach, SC USA

one day last week, all the drives were X'd out.. never figured out why

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 66 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17728 (Level 9) and Parent is 17720
Reply Posted 11/13/2019 1:01:32 PM
Location=Myrtle Beach, SC USA 
Joined=40 months ago   MB Posts=333  
Jeff Wampler
12:34 MicroTechnologies
-- USA

So I discovered that with Server 2019 and SMB 3.0, there is an option that disables OpLocks. I did an in-place upgrade (Don't shoot me) to 2019 and ran the powershell command to disable oplocks. Today everyone is telling me that the Paradox database are crawling!! So we went from locking to to locking up and crawling. 

 Posted 61 days ago (Thread Starter)
Comment Quote
About Jeff Wampler -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17733 (Level 10) and Parent is 17720
Reply Posted 11/18/2019 4:25:18 PM
Location=-- USA 
Joined=66 days ago   MB Posts=7  
Moderator
Steven.G
Myrtle Beach, SC USA

that is totally contrary to historical logic, and I don't have the registry entries to check, for server 2019.. but that applies to the workstations, too

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 61 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17734 (Level 11) and Parent is 17720
Reply Posted 11/18/2019 4:57:37 PM
Location=Myrtle Beach, SC USA 
Joined=40 months ago   MB Posts=333  
Jeff Wampler
12:34 MicroTechnologies
-- USA

I'm also reading that disabling Oplocks can cause network performance issues and it is not recommended to do it. It is to prevent issues with database corruption, not to stop the application from locking up. We don't have issues with corruption.

 Posted 61 days ago (Thread Starter)
Comment Quote
About Jeff Wampler -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17735 (Level 12) and Parent is 17720
Reply Posted 11/18/2019 4:27:55 PM
Location=-- USA 
Joined=66 days ago   MB Posts=7  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

opportunistic locking was made to control access tables, which work differently than other "database desktops" like paradox, dbase, etc.. over time, it became obvious that it was problematic for access, too

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 60 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17736 (Level 13) and Parent is 17720
Reply Posted 11/19/2019 4:58:55 AM
Location=Myrtle Beach, SC USA 
Joined=40 months ago   MB Posts=333  
Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1187A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17720 Counter
97
Since 11/13/2019

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech