ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> JC-E
http://www.istechforum.com/YaBB.pl?num=1223321239

Message started by david.carrilho on 10/06/08 at 12:27:19

Title: JC-E
Post by david.carrilho on 10/06/08 at 12:27:19

Print Material Issues (JC-E) locks up DBA at probably the same point each time it was run todayl. The error message is: Access violation at address 00401E16 in module 'TP5WDBA.exe'. Write of address 20202020. Must end-task and restart DBA. How can I fix this?

Title: Re: JC-E
Post by kkmfg on 10/06/08 at 12:39:30

A while back a few of us reported a similar problem with SO-A (Enter Sales Order)

I'm not aware of us getting such an error in SO-A for quite some time. But it also usually faulted with a 20202020 but it was reading instead of writing.

The cause is almost certainly an uninitialized pointer. But... why? The world may never know... Since this seems to have disappeared in SO-A (anyone correct me if I'm wrong) it would appear that either ISTech found the problem in SO-A or that somehow some other change that they did made that particular bug disappear.

If you are getting the error consistently then it would be best if you could find the exact spot it dies at (if its the same spot every time.) Also, you could try to do the operation the test company and see if it still blows up.

Also, what version of DBA Classic or Evo are you using?

Title: Re: JC-E
Post by david.carrilho on 10/06/08 at 13:33:21

Using DBA 2004.1 with ISTech 08/04/08.

Title: Re: JC-E
Post by Lynn_Pantic on 10/06/08 at 15:15:04

My suspicion is that there is a record in WOMAT with a corrupted date which is causing the report to blow up. Try opening WOMAT for your company in Maintain Database. If there is a corrupted date entry, the DBA Classic version of MDB will crash if you go to beginning and end of file using the date index. If that is the case, opening the same file using the Evo-ERP Maintain Database will allow you to find and fix the record - it will be either the first or last record in the file when sorted by date.

Title: Re: JC-E
Post by david.carrilho on 10/07/08 at 12:41:58

Thank you KKMFG and Lynn for helping. The program stops at the same work order number each time. I tried checking dates in WOMAT, but everything seems okay there.

We are using the program to try to solve a discrepancy between WIP inventory reported on JC-P and that reported in General Ledger (and journal entries). Running JC-P (without dates) has overstated WIP inventory by 20 percent at EOM for both Aug & Sep. Previously, the discrepancies were small (maybe up to two percent) and we adjusted GL based on what JC-P reported. We have found about two-dozen WOs with WIP value somewhere in la-la-land (JC-P), but the journal entries for those items are correct. Are we doing something wrong?

Title: Re: JC-E
Post by Lynn_Pantic on 10/07/08 at 14:58:15

You should be using JC-M to reconcile WIP balance to GL, not JC-P. However, JC-M uses the same WOMAT transaction file as JC-E so if there is a problem with that file, JC-M may blow up as well.

JC-P WIP value will not reliably match GL and may not even come close unless you never do any partial receipts from work orders and always close work orders at the same time as Enter Finished Production and do not track Labor on Routings.