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

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

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

Paradox on Windows Server 2012

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

Quick Search: Paradox   Windows   Paradox Windows   Paradox Windows Server  
gcorvera
-- UNK

We migrated from using a run of the mill Windows XP box as a server to Windows Server 2012; one of the applications we use is a simple 3 table database which stopped working the moment the files were being accessed from the new server. We could see data but trying to add anything would result in a Lock Time Out error.

I discovered that if I remove Referential Integrity from the detail table structure, and just assign it through the data model on the form, everything works.

Would it be OK to leave it like that? or would it be somehow dangerous for the integrity of the data?

Could the problem have come from some setting on the server? The person who installed the server for us doesn't think so but I'm not sure he is as familiar with Windows 2012 Server as I thought.

For the time being I will be monitoring the data and checking that nothing is lost.

Any suggestions?

Thanks

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

Post ID #15153, 11 replies
Thread Started 6/2/2014 12:27:41 PM
View Counter=4022
Last Reply Posted 5/3/2019 7:17:16 AM)
Location=-- UNK 
Joined=9 years ago   MB Posts=14   KB Comments=1  
Wakinyan
Sinclair Manufacturing
-- --

Resurrection...

Lock Time Out errors - I am currently dealing with this, have Microsoft involved as well.

Two weeks ago, we migrated from Server 2008 R1 (Vista based) to Server 2016 (Win 10 based). We run Paradox (Office X6) on clients from XP, 7, 10 x86 / x64, and ONLY store the data on the server's mapped drives.

Paradox locks, crashes, does not behave well at all when pointing to the new server (*).
Through much testing, pointing to a Win8.1 box as a "server", works fine. Pointing to a test Server 2012 R2 box, works fine. Point to the 2016 box, and things get REALLY strange.

Pointing to a 2016 Domain Controller's shared test folder, Paradox WORKS. Huh. fails on File Server, runs on DC.

File Server (2016) #1, RAID1 (2x drives) for OS, shared folder on C:\ WORKS. Running from the RAID 10 (4x drives) data partition, fails the way I mentioned.

File Server (2016) #2, RAID 10 (6x drives, broken up into 2 partitions, 300Gb for OS, 1500Gb for data), WORKS on C: partition, fails on data partition. Install Windows Server 2016 on data partition to make it bootable, etc., FAILS. Make C:\ the entire disk, if WORKS.

I see that X8 is out. While I doubt there's been ANY changes, I'm going to try it and see if it works at all. We've been running this / some iteration of my Paradox app to run the company since... mid 90's, and the boss doesn't want to replace it before he retires. :)

 Posted 25 months ago
Comment Quote
About Wakinyan -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 #16789 (Level 2) and Parent is 15153
Reply Posted 7/21/2017 5:17:25 AM
Location=-- -- 
Joined=25 months ago   MB Posts=2  
SamSpade
DBusSol
-- USA

Did anyone get anywhere with the Server 2016 question?

I am migrating a Paradox 11 app from a 2008 R2 terminal server to a 2016 terminal server and I am having some trouble. I have not explored corel X9.  Since Paradox 11 installs, I am hoping to go with that.

When I access a single table with multiple users, the first user controls the table and edits are not seen by other users. And only the first users edits are saved.

I don‘t know if it‘s a server permissions issue, Oplocks or a BDE.CFG settings issue.

I am going to try all my old Win XP reg edits. 

I am a little out of my depth on the permissions issues.

Is anyone successfully using server 2016 terminal server for multi user paradox apps?

 Posted 116 days ago
Comment Quote
About SamSpade -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
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 #17498 (Level 3) and Parent is 15153
Reply Posted 5/1/2019 10:22:13 PM
Location=-- USA 
Joined=116 days ago   MB Posts=5  
Wakinyan
Sinclair Manufacturing
-- --

Sam,

I am hosting Paradox 11 databases on the Server 2016 file server.

I bought the newer versions Corel's Office suite, and it's the SAME Paradox build - there's been zero development on it.

I had the server broken up as described, separate Windows / Data partitions on the RAID array. That was unsuccessful.
The only way I could get Paradox to work as it did on Server 2008 was to put the data files on the C partition. Totally the WRONG way to make it work.

So, I now have a large C partition on the array, with Windows AND all data on the same partition. It works as before, with the clients running 11, and data on mapped shared drive on the file server.

Just my experiences. Best of luck.

 Posted 115 days ago
Comment Quote
About Wakinyan -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 #17501 (Level 4) and Parent is 15153
Reply Posted 5/2/2019 4:52:11 AM
Location=-- -- 
Joined=25 months ago   MB Posts=2  
Moderator
Steven.G
Myrtle Beach, SC USA

Sam.. first rule of sharing..

all users must point to the exact same net file, using the exact same mapping.. can't just resolve to same place, must be the same

all users must point to the shared data, using the exact same mapping.. can't just resolve to same place, must be the same

all users must have full read/write/create/delete for all folders with paradox objects, so it can create, modify, and delete the lock files, even if it's not gonna do that to the objects themselves

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

Post ID #17502 (Level 5) and Parent is 15153
Reply Posted 5/2/2019 5:41:12 AM
Location=Myrtle Beach, SC USA 
Joined=35 months ago   MB Posts=300  
rum
Frankfort, KY USA

Sam,  After I switched to Paradox 11,  I had issues that may be similar,  although they did  manifest differently.

In my scenario,  the 2nd, 3rd,etcuser would get an error saying they could not open a specific library. 

I tried for weeks to program around it. From the server, looking at the file locks for user 1 it showed that I had the file open for read.   for user 2 it reported that the file had an exclusive lock on it and could not be opened.

I was able to solve this issue by placing the library in a common path on the server,   

I used the server equivalent of 

C:\Program Files (x86)\Paradox\Programs

All other program items remained on the data drive.


We had one other issue,  related to the PRIVATE folder.  The default configuration of the terminal server users will cause each user to USE the same path for the private folder.   In this case we use the -p command line switch to redierct paradox private folder to  C:\Users\USERNAME\AppData\Local\Temp

Jeff

 Posted 115 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 #17503 (Level 6) and Parent is 15153
Reply Posted 5/2/2019 6:14:13 AM
Location=Frankfort, KY USA 
Joined=26 months ago   MB Posts=88  
SamSpade
DBusSol
-- USA

I think I have done everything in the previous suggestions, but I am still seeing the issue where user2 doesn't see edits by user1 if User2 opens the table while User1 has the table in edit. It's like each user is working in the table in memory seperately and the user who opens the table first blocks other users from saving edits.

I think this is an Oplocks error, but I haven't figured it out.

I am pretty sure I am using all the Reg edits and settings except Init\Localshare  = True

If someone knows of something I am not using, please point it out.

Here's what I have done On a Server 2016 Terminal server:

In Powershell as administrator

Set-SMBServerConfiguration -EnableOplocks $false

Set-SMBServerConfiguration -EnableLeasing $false

Set-SMBClientConfiguration -OplocksDisable $True

Set-SMBClientConfiguration -UseOpportunisticLocking $False

In RegEdit in LanmanWorkstation\Parameters\

EnableOplocks was not set, so I set it to 0

In Lanmanserver, EnableOplocks was 0 EnableOplocksForceclose was 1

Restart the server to make regedits take effect

I am using a -P command to set individual User :Priv: Dirs

I am using a -O command to ensure all users use the same .CFG

-W command for common working directory

The .CFG file sets Alias for Forms and Data directories

.CFG defines a common .net file in C:\Paradox\App\Active\

Installed Paradox11

Created a directory C:\Paradox\App\Active\ for Forms\ and Data\ directories

Used Properties of APP\ to set full control for Users group

     In the Security Tab set Full control for users group

     In the Advanced Security settings use inheritence and setup for full control by users group

Copy the a reference copy of server 2008R2  Data\ and Forms\ directory to Server 2016

Log into Server 2016 Terminal server with User1 and User2

Use Shortcut with Command line to open paradox form Viewing to test.DB in both users

Both user add records to the table on screen error free

After closing the form, only User1 edits are saved to the table

 Posted 115 days ago
Comment Quote
About SamSpade -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
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 #17504 (Level 7) and Parent is 15153
Reply Posted 5/2/2019 12:54:11 PM
Location=-- USA 
Joined=116 days ago   MB Posts=5  
Moderator
Steven.G
Myrtle Beach, SC USA

both users, you've gone into Tools/Settings and confirmed that the working dir is the same?

both users, you've moved off the record and see it get committed? and/or did it in code, and the postrecord() returned true?

both users, you've added new records and posted them?

you can look at the table on either session, after the form closes, and only see User 1's work?

it all looks like it's the same, on paper, but the behavior you're describing is that they're NOT the same table.. even tho that seems impossible

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

Post ID #17506 (Level 8) and Parent is 15153
Reply Posted 5/2/2019 1:33:38 PM
Location=Myrtle Beach, SC USA 
Joined=35 months ago   MB Posts=300  
SamSpade
DBusSol
-- USA

Steve, 

I figured it out, and I‘ll get to that.

But yes, I was doing it in code, adding new records, populating the fields, doing a post record, etc 10 records at a click and each user was having it‘s own reality, and only the user that opened the table first was able to save those edits.  If user1 opened the table made edits and closed, User2 could open the table, see user1s edits, make new edits, close the table and save edits.  But not two users at once.

I am convinced the first user to open the table was the only one to actually have rights to write to the table.  The other users were taking the table into memory, appeared to be making edits in memory only, but unable to write those edits to the table.  I have seen this in previous versions of Server, I am pretty sure its oplocks allowing it.

Now that I figured out the settings I have wrong, the same form, unaltered is allowing multiple users to post records to the table with the behavior we want and expect.

 Posted 115 days ago
Comment Quote
About SamSpade -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
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 #17507 (Level 9) and Parent is 15153
Reply Posted 5/2/2019 5:22:03 PM
Location=-- USA 
Joined=116 days ago   MB Posts=5  
SamSpade
DBusSol
-- USA

So.... And the Answer is..... Drum Roll Please!!

Combination of Oplocks enabled and Init|LocalShare set to False.

Server 2016 has Oplock settings in SMBServerConfiguration (new to me) and it defaults to enabled. 

When I setup the CFG file, with oplocks enabled, it would not allow a second user to open if Init|LocalShare set to true.  So I had left Localshare set to false. It took me a while to track down the SMB set commands.  It also turned out disabling Oplocks in SMB left out the LanmanWorkstation Oplocks setting (it did turn t off in in Lanmanserver). After my earlier long post, I thought to go back and try with LocalShare set to True.  With Oplocks disabled, LocalShare set to true no longer blocked multiple users and the expected behavior returned to normal.

I am going to admit that even though I have been working in Paradox since about 1992, I don't have a great understanding of Localshare.  I always try to have a Share that I point to with a mapped drive for my App directory even on a terminal server, and I think that makes local share less important. But This is some elses server, I am using a direct C:\Paradox\App\ directory setup. I think having the tables off the C:\ like this is what makes Localshare set to true necessary. I think I found that in some notes by "Mike" years ago. But since I rarely use a C:\ path, I don't think I see that behavior and turning off Oplocks is enough.

 Posted 115 days ago
Comment Quote
About SamSpade -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
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 #17508 (Level 10) and Parent is 15153
Reply Posted 5/2/2019 5:33:42 PM
Location=-- USA 
Joined=116 days ago   MB Posts=5  
SamSpade
DBusSol
-- USA

So to Recap, here is the setup I ended up with that was successfull for multi users on a 2016 Terminal Server with Paradox11 runtime.

Open Powershell as an Administrator and use these to correct server 2016 defaults:

Set-SmbServerConfiguration -EnableLeasing $false
Set-SmbServerConfiguration -EnableOplocks $false
Set-SmbClientConfiguration -OplocksDisabled $true
Set-SmbClientConfiguration -UseOpportunisticLocking $false

Confirm the settings with
get-SMBClientConfiguration
get-SMBServerconfiguration

While in Powershell Open Regedit an Confirm these Keys
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters]
"EnableOpLocks"=dword:00000000
"EnableOpLockForceClose"=dword:00000001
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanworkstation\parameters]
"EnableOplocks"=dword:00000000

Restart the server

Install Paradox 11 Runtime

Setup a diectory that is accessible to all users in the same way.  I prefer a share with a mapped drive. Make sure all users have full control of the contents of the directory and it inherits to its contents.

In the CFG, Set the Net Dir in the CFG to a location common to all users and set System|Init|LocalShare to True.

Use Paradox Shortcut command line settings -P to set unique :Priv: Dirs, -W to set a common :Work: Dir and -O to set a .CFG

The SMB portion is new to me for Server2016. I found them on community.esri.com searching for Oplocks Server 2016.

The Local Share goes back to CFG settings Mike Prestwood published here sometime before 2008.

I have been using the Oplocks settings since Windows NT.

The Command line values are good hygene someone taught me when I got started.

Someone might point out something I haven't documented, but I seem to be working now.

 Posted 115 days ago
Comment Quote
About SamSpade -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
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 #17509 (Level 11) and Parent is 15153
Reply Posted 5/2/2019 6:01:39 PM
Location=-- USA 
Joined=116 days ago   MB Posts=5  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

good work, I know it wasn't easy.. these notes will come in handy for others, of course.. the Windows side of almost anything gets more complex, version after version

the one thing about "local share".. it assumes anything on a C drive is private, and yes, therefore thinks holding changes in memory is ok.. orginally, the need for TRUE was when there were other local apps using the data.. this logic goes all the way back to PdoxDOS, where "Edit" held everything in memory til the end, but "CoEdit" posted immediately

over time, of course, we learned that safety and security were way more important than the time saved holding stuff in memory, when you're playing with data.. local share off, oplocks on, caching on, etc.. all bad.. VERY bad

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

Post ID #17511 (Level 12) and Parent is 15153
Reply Posted 5/3/2019 7:12:21 AM
Location=Myrtle Beach, SC USA 
Joined=35 months ago   MB Posts=300  

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 = P1251A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15153 Counter
4022
Since 6/2/2014
Follow PrestwoodBoards on: 


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