Shawn, We've run into an issue over the last couple of weeks. Invoicing was running VERY slowly and crediting an invoice was even worse (10-30 minutes depending on the speed of the machine issuing the credit). I was able to help the invoice creation issue by clearing out most of the audit history, but the crediting issue is really bad. When an invoice is being credited it maxes the cpu on the client machine , but has no effect on other clients. This affects cancelling an account to because it reverses open invoices. Our server (win2k, sp4, 1G ram, dual p3 550, raid 0) is currently running v3.34 and has a webclient (for optiskin) and automated tasks client connected. I disconnected all clients, shut down the process, and restarted it with no effect. My next test was to backup a copy of the database and test from another machine. This other machine is winXP pro sp2 (512k ram, 3.00Ghz p4). Opening an invoice on this machine produces the same problem. There are no other clients connecting to this box and opti is being opened directly using main menu (no server service installed). I've run all the cleanup routines I can find, but am still unable to find the cause of the problem. I suspect we have corrupted data in on of our product tables (looking up the billing cycle item?). What do you suggest I attempt next, an upgrade to 3.37 on the test server? G
Definitely a problem in one of the files. It's MUCH faster now. It seems to have solved speed issue, but it did return an error message: "There was a problem with one or more of the file imports. Perform a RECOVER on the source files(s) in question and try again. (OKAY)" Since I don't know what data couldn't be imported I still don't want to perform the upgrade on our live database. I clicked on recover.fp5 and then have been choosing "Recover File" (_.fp5) to see if any show problems, but none give any kind of a message about fixing problems. The only file which had an older date is Vendors_fp5 (shows the backup date). Should I be attempting to recover the _.fm files instead? Is there a log which shows which files failed and why? George
The upgrade fixed the problem. I verfied all the sales, balances and customers and can't see any missing data. Also in the upgrade I discovered the bug in the masking of credit cards as well (we don't do it normally): Reported in this thread: http://forums.digitalpoint.com/showthread.php?t=10452&page=2&highlight=partial+credit+card Just letting you know there are others who have the same problem too. George.