| Subject | Re: Error Code 239 IDAPI error |
| From | MichaelItaliano <michael@abstractservices.com.au> |
| Date | Fri, 20 Oct 2023 08:37:45 -0400 |
| Newsgroups | dbase.getting-started |
Akshat, I think your onto something, yes, I do run timers in the second app that checks if new records a re written and then writes them to a server somewhere. This small app runs in the background, the main app has a few timers in it to check tables, online order and schedueled reports. Its been very stable and runs days on end without issue but once i have the other app running , it runs and works fine for 2 or 3 sometimes four hours and then all tables simply drop out, I dont know what it is doing. each app runs perfectly well for days when I run them together it destroys its reliability. I just want to run a second process that doesnt effect the main operation similar to a windows second user, so that the main app can run faster and independantly, if you know another way of doing this, please advise. Best Regards, Michael. Akshat Kapoor Wrote: > Good Evening Michael, > > > I've tried the settings, the first time I ran it it went 3 hours before it seemed to lose the tables, they just dropped out not tables open in area 0. The second time it lasted only 30 minutes. > > Is there a timer running in the code? > I am using plus 12.31 and the code runs for approx 10 hours a day > without any issue. > > At the same time another program running timers gives issues > periodically if minimised and restored. > > Since It runs in the background without any user intervention so did not > go through the hassle of finding the root cause > > > > > The other effect I have noticed is that the index files are completely screwed, gone, destroyed.and that out of the file i am only reading data from. It makes no sense. > > The first thing I would recommend is that you should rebuild the indexes > and then createIndex.prg of duflp. > > It will create a program for recreating indexes. > This will ease issue of recreating indexes in future. > Recreating them manually is a pain. > > Regards > Akshat | |