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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Tables Topic   Print This     

Table Corruption

Table Corruption in Paradox Tables topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Corruption   Table Corruption  
rum
Frankfort, KY USA

OK Friends,  I need enlightenment, guidance or magic...

I have a an application running PDOX 11.  I have deployed this application to roughly 250 customers.  All customers have their own local database.  This application (or some form thereof) has been deployed this way for over 20 years. My point,  it is not new.

This is the problem

I have one specific customer,  (PDOX11, Windows 10, database is on the C drive )

There is one table that is persistantly corrupted for this costumer.  The table has roughly 250,000 records.

I can repair the table and they go about thier business for a time, In the past 3 days I have repaired the table three times.

I have found no perceivable difference between her table structure and that of other customers.

Diagnostics to data:

I have copied her data from her table into another NEW table.

The user has had a new PC installed (there were no issues for about 2 months after the new PC was installed)

lots of table repairs.

Anyone have another idea?

SMB, file locking issues or Anti-Virus

Jeff

 Posted 5 months ago (Thread Starter)
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 #17400, 4 replies
Thread Started 1/23/2019 10:18:36 AM
View Counter=241
Location=Frankfort, KY USA 
Joined=24 months ago   MB Posts=79  
rum
Frankfort, KY USA

Also,  I would add,  the KEY structure on this table is fat (8 fields) 

 Posted 5 months ago (Thread Starter)
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 #17401 (Level 2) and Parent is 17400
Reply Posted 1/23/2019 10:31:10 AM
Location=Frankfort, KY USA 
Joined=24 months ago   MB Posts=79  
Moderator
Steven.G
Myrtle Beach, SC USA

is the "corruption" just the indexes? is the table size more than 1/2 the max, for that block size?

query out the data to a temp table.. run tutility or chimney sweep on it.. export to ascii.. make a new table from scratch.. import the ascii.. run tutility or chimney sweep on it.. add the indexes, pack the table

literally, do it all from scratch

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

Post ID #17402 (Level 3) and Parent is 17400
Reply Posted 1/23/2019 11:24:02 AM
Location=Myrtle Beach, SC USA 
Joined=33 months ago   MB Posts=276  
rum
Frankfort, KY USA

Please confirm this statement
" is the table size more than 1/2 the max, for that block "

I believe you are referring to
Paradox tables hold a max of 65536 blocks, which can be block sizes of 1,2,4,16,32kb therefore the max sizes per table can be (in approx sizes):

1kb blocks - 64Mb
2Kb blocks - 128Mb
4Kb blocks - 256mb
16Kb blocks - 1Gb
32Kb blocks - 2Gb

In this users problem table: 

The block size is 32

The record byte size is 207

24 Fields

The file size on disk is 86,210 KB

I will work on your steps,  However I dont have Chimney Sweep,   but I might have the tutility.

However,  I don't see how this is any different than taking a virgin copy of the table and inserting the records,  which has been done.

Thanks

Jeff

 Posted 5 months ago (Thread Starter)
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 #17403 (Level 4) and Parent is 17400
Reply Posted 1/23/2019 11:36:22 AM
Location=Frankfort, KY USA 
Joined=24 months ago   MB Posts=79  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

> Please confirm this statement
" is the table size more than 1/2 the max, for that block " <

32k blocks, table has a max size of 2 gig.. sec indexes become disfunctional if the table is over 1 gig.. this particular table is only 86 meg, so no issue

> I will work on your steps,  However I dont have Chimney Sweep,   but I might have the tutility. <

tutility is the built in repair tool.. CS catches some advanced stuff, sometimes, that tutility doesn't.. an actual Repair catches many things that Verify doesn't even see.. it's all art, not science, unfortunately

in this case, what are the actual symtoms and/or error messages in the app that become the source of the problem?

in this case, other than the stupid "low ascii" errors, what errors does Verify give you?

> However,  I don't see how this is any different than taking a virgin copy of the table and inserting the records,  which has been done. <

if there's a bad pointer in the file, or a bad block on the disk, the ascii export process will often be "cleaner" than simply adding the records from the bad table to the empty table

if there's a "bad block" error in Verify, or something similar, and it's' still there after you go thru all the hoops I suggested, now you'll know you're doing the same "rinse and repeat" that won't go away

yes, I've seen that happen.. recently, I had a table like that.. trial and error, narrowed it down to one block of data.. added a record that split the block, the error moved to the new block.. deleted the new record, packed the table, it moved back.. deleted the "offending record", the next record error'd out.. kids, don't try this at home :-)

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

Post ID #17404 (Level 5) and Parent is 17400
Reply Posted 1/23/2019 1:20:13 PM
Location=Myrtle Beach, SC USA 
Joined=33 months ago   MB Posts=276  

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


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