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

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

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

2003 server to 2016 server lock time out / slow

2003 server to 2016 server lock time out / slow in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: 2003 server   2003 server 2016   server lock   time out   / slow  
coconut73
-- USA

Hello,

We upgraded from 2003 server to 2016 server last thursday and are noticing a couple problems:

we Using paradox 10 and 11 on all 10 nodes.. 

i am not an it guy nor a paradox expert...

The entire company runs paradox daily for multiple things and in general is stable but seems to be slower.  All programs but two are running ok. (so far)

1.  Lock time out error on a specific program...has something to do with hanging when adding a table.

the program will run if the you change the location of one of the tables.

we fixed by hardcoding a workaround by changing table location to a different sub directory but still on the server.

now we found another program with same similar problem.  

2.  very slow to change directories/subdirectories when using a form ... i get the wheel of death but eventually  it will change to the desired directory 

any help would be appreciated 

thanks

frustrated coconut 

 Posted 6 months ago (Thread Starter)
Comment Quote
About coconut73 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17416, 5 replies
Thread Started 1/30/2019 8:08:25 AM
View Counter=209
Last Reply Posted 1/31/2019 10:54:56 AM)
Location=-- USA 
Joined=12 years ago   MB Posts=20  
Moderator
Steven.G
Myrtle Beach, SC USA

same files and folders, same mapping, same private folders, access rights, BDE config, same everything, except for the server?

get everyone out, blow away the net file and all the lock files, if any.. try again, see if that changes anything.. always a good way to begin

you can use my old lock removal tool, it'll be slow, too.. download Remlok32 on the link below

http://www.oasistradingpost.com/cartpages/downloads.htm

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 6 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17417 (Level 2) and Parent is 17416
Reply Posted 1/30/2019 9:23:10 AM
Location=Myrtle Beach, SC USA 
Joined=34 months ago   MB Posts=291  
coconut73
-- USA

thanks for reply Steven...

Yes all same files, folders etc..

i took your advise blew out lck and net files with no positive or negative outcome... 

thanks...

any other thought??

 Posted 6 months ago (Thread Starter)
Comment Quote
About coconut73 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17418 (Level 3) and Parent is 17416
Reply Posted 1/31/2019 10:26:20 AM
Location=-- USA 
Joined=12 years ago   MB Posts=20  
Moderator
Steven.G
Myrtle Beach, SC USA

nothing else that's this generic.. like I said, this is something to do periodically anyhow

most of the symptoms you describe sound external/environmental.. writing to disk, changing directories, etc..

if the things that fail have internal commonality (only this process, this folder, this user, etc.), that can be a starting point to see if certain users and/or folders didn't maintain necessary rights, or an alias or folder is missing, or lost BDE or app settings, etc.. but don't ignore the network side, especially if this applies to all users and processes

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 6 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17419 (Level 4) and Parent is 17416
Reply Posted 1/31/2019 10:30:43 AM
Location=Myrtle Beach, SC USA 
Joined=34 months ago   MB Posts=291  
rum
Frankfort, KY USA

There was a change to the default SMB protocol on Windows servers in that past few years.  This is the protocol that Paradox usies to talk to the server.

You can use powershell to check what versions are running on each of the servers and make adjustments if you see a need.

Also,  you may want to make sure you are using the most up to date version of the BDE. (5.2. I think)

 Posted 6 months 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 #17420 (Level 5) and Parent is 17416
Reply Posted 1/31/2019 10:44:14 AM
Location=Frankfort, KY USA 
Joined=25 months ago   MB Posts=83  
Most Recent Post
rum
Frankfort, KY USA
 Posted 6 months 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 #17421 (Level 6) and Parent is 17416
Reply Posted 1/31/2019 10:54:19 AM
Location=Frankfort, KY USA 
Joined=25 months ago   MB Posts=83  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

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 = P1163A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17416 Counter
209
Since 1/30/2019
Follow PrestwoodBoards on: 


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