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

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

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

.lck file issues

.lck file issues in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: lck   lck file  
Martin.T2
AeroSpring & Mfg
Phoenix, AZ USA

We have a mixed environment of 15 Windows XP, 7 & 10 machines most of which are on the system at once.

Occasionally when navigating from one record to another or printing a report a workstation will lock up and in doing so lock out all the other machines.  We have all machines starting paradox with the following string...

"C:\Program Files (x86)\Paradox\Programs\pdxwin32.exe" -w Y:Pdox9  -o Y:\Pdox9Netfile\idapi32.cfg -p C:\PdxPriv genmenu.fsl

Allcomputers open the same start form in Paradox genmenu which reads a configuration table which determins which buttons are visible on the menu screen , said buttons opening the appropriate forms for that user.

The main table that is in the datamodel of several forms , shoporders.db , has 53500+ records and is 26,402 Kb and is often the table referenced in .lck timeout errors

Y: is a mapped drive from a SBS2008 box  

BDE version is 5.1

Any suggeswtions as to where to look for possible causes would be most welcome.

Martin

 Posted 102 days ago (Thread Starter)
Comment Quote
About Martin.T2 -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 #17600, 8 replies
Thread Started 7/12/2019 10:10:58 AM
View Counter=113
Last Reply Posted 7/15/2019 9:40:06 AM)
Location=Phoenix, AZ USA 
Joined=37 months ago   MB Posts=4  
Moderator
Steven.G
Myrtle Beach, SC USA

putting the manu menu in the priv will force you to change it everywhere, if you ever need to change it

what's the exact error? sounds like the error is context, not access.. i.e. somebody has a write lock or full lock when they shouldn't

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

Post ID #17601 (Level 2) and Parent is 17600
Reply Posted 7/13/2019 4:58:24 AM
Location=Myrtle Beach, SC USA 
Joined=37 months ago   MB Posts=314  
Martin.T2
AeroSpring & Mfg
Phoenix, AZ USA

Genmenu.fsl is not in :Priv: it is in :Work:  There is no specific error message the system just freezes.  Martin

 Posted 99 days ago (Thread Starter)
Comment Quote
About Martin.T2 -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 #17602 (Level 3) and Parent is 17600
Reply Posted 7/15/2019 7:40:52 AM
Location=Phoenix, AZ USA 
Joined=37 months ago   MB Posts=4  
Moderator
Steven.G
Myrtle Beach, SC USA

so it just generates the main menu, or does other "setup" stuff, too?

if it doesn't leave anything behind to give you a clue (like a partially filled or missing table), my best option is to put a bunch of "msginfo" lines in the code, to show you how far it got

msginfo("hey","this is the 1st message")

msginfo("hey","this is the 2nd message")

might drive you crazy when it works fine, until it helps you see where it froze

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

Post ID #17603 (Level 4) and Parent is 17600
Reply Posted 7/15/2019 9:03:20 AM
Location=Myrtle Beach, SC USA 
Joined=37 months ago   MB Posts=314  
rum
Frankfort, KY USA

You could forego the annoying messages with a call to a logging table,  such as:

method LogEvent(Msg String, Success String, Info String) Logical

var
t, t1 tcursor
RET logical
mySql SQL
S String
db database
bSuccess logical
siRecNo LongInt
endvar
If NOT isTable ("DBActivity.db") then
MSGSTOP("CONFIGURATION ERROR","The working directory must contain the DBActivity table!")
return FALSE
endif


RET = FALSE
; UserName=getNetUserName() - SET in OPEN event
;Make sure we have a Group Value
if lProcessgroup=0 then
if db.Open(":WORK:") then
S = "Select Max(ID) MID from DBActivity"; where UserName="+chr(34)+Username+Chr(34)+" "
MySql.ReadFromString(S)
If MySql.ExecuteSQL(db,t1) then
siRecNo = t1.nrecords()
if siRecNo > 0 then
if t1.moveToRecNo(1) then
lProcessGroup = T1.MID+1
Else
lProcessGroup = 1
endif
else
errorShow("Invalid record number.")
endIf
t1.close()
endif
db.close()
endif
endif
If Success ="F" then
bSuccess=False
Else
bSuccess=True
Endif

If t.Open("DBActivity.DB") then
t.edit()
t.Insertrecord()
t."ProcessGroup"=lProcessGroup
t."ProcessDate"=dateTime()
t."Username"=UserName
t."Action"=msg
t."Info"=Info
t."Success"=bSuccess
t.EndEdit()
t.Close()
RET = True
endif

Return RET

endMethod

 Posted 99 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 #17604 (Level 5) and Parent is 17600
Reply Posted 7/15/2019 7:55:31 AM
Location=Frankfort, KY USA 
Joined=28 months ago   MB Posts=90  
rum
Frankfort, KY USA

Do your users change printers while in the software?    I have had issue where changing printers locks up paradox (run report, select a different printer, lockup,  @#$#@#$surprised, Kill sealedwith task manager)

 Posted 99 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 #17605 (Level 6) and Parent is 17600
Reply Posted 7/15/2019 7:55:31 AM
Location=Frankfort, KY USA 
Joined=28 months ago   MB Posts=90  
Moderator
Steven.G
Myrtle Beach, SC USA

navigation.. always the same table? same user? same type of data change?

printer.. same printer? same user? same report?

these are example questions.. again, looking for patterns, looking for clues

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

Post ID #17606 (Level 7) and Parent is 17600
Reply Posted 7/15/2019 9:08:37 AM
Location=Myrtle Beach, SC USA 
Joined=37 months ago   MB Posts=314  
Martin.T2
AeroSpring & Mfg
Phoenix, AZ USA

Genmenu does a number of things, It runs a scan of the working and private directories checking for corrupt tables. It builds a couple of reference tables in the users :Priv: which do not change very often but are large so being in :Priv speeds up access.

 Posted 99 days ago (Thread Starter)
Comment Quote
About Martin.T2 -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 #17607 (Level 8) and Parent is 17600
Reply Posted 7/15/2019 7:43:13 AM
Location=Phoenix, AZ USA 
Joined=37 months ago   MB Posts=4  
Most Recent Post
Martin.T2
AeroSpring & Mfg
Phoenix, AZ USA

90% of the time it is the same table, Shoporders.db.  There are three forms that access this table The first creates new shoporder records from quotrations.  The second allows shipping info to be entered into a child of shoporders and the third looks promerily at the child but has shoporders in the datamodel and screen header. So we would be looking at header info of one record in shoporders.db with multiple lines of the child shipping table visible in a tableframe.  The info in Shoporders.db changes very little over the life of the order but the child shipping table is constantly updated top reflect work status for that shipping line. A shop order can have multiple shipping lines spanning a period that can be years long.

 Posted 99 days ago (Thread Starter)
Comment Quote
About Martin.T2 -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 #17610 (Level 9) and Parent is 17600
Reply Posted 7/15/2019 9:40:06 AM
Location=Phoenix, AZ USA 
Joined=37 months ago   MB Posts=4  

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 = P1223A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17600 Counter
113
Since 7/12/2019

Follow PrestwoodBoards on: 


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