Need help understanding certain points in 4D data management?

Question

I work for a tenant screening company and I use a program called 4D not 4th dimension for graphic design, but a data management program, recently about 3 to 4 months ago I would transfer batches of files from our 4D program over to our RDM server which stores all of our Unlawful Detainer court files. But for some odd reason when we send the batch over to RDM it doesn't always update with the changes that I made in 4D it will only update a certain amount of records. So my main question is why is this happening? is it possible that the server is acting up? or am I missing a step, it would be much helpful if someone who has a decent amount of knowledge towards 4D data management.

Answer 1

I don't quite understand what you are trying to do but being that I worked as a 4D tech support engineer and Quality Assurance engineer for 2yrs, I can say that perhaps you may have some sort of data corruption. 4D is notorious for data corruption. Go to their web site and download 4D tools. Be warned though that you should not run 4D tools against your live database. Make a copy of your database and run it on the side so see if 4D tools finds any problems.

If you decide to run 4D tools against your live database, make plenty of backups because 4D tools will remove anything it cannot read. I've seen customers databases go from 1gb to 300mb after a 4D tools run. If this happens, we normally recommend that the customer export all data out as text, create a new data file and reimport all the data back.

The very best thing you could do is (if you have the structure aka interrperted version of the database) to use the debugger and step through the code to see what the code is doing. Maybe there is a bug in the code. I wouldn't be suprised.

Their web site is down at the moment so I can't pull up a quick link for you but you'll also want to get yourself on the 4D mailing list. Its very active.

Good Luck