ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Update Material Standard Costs
http://www.istechforum.com/YaBB.pl?num=1288354006

Message started by Shanthi Nair on 10/29/10 at 05:06:41

Title: Update Material Standard Costs
Post by Shanthi Nair on 10/29/10 at 05:06:41

Hello,
We are having difficulty Updating the Material Standard Costs under the Items > IN menu in DBA. It should normally take about 15-20 minutes to complete however, as soon as someone enters A and presses enter the Update Material Standard Costs box exits out and nothing happens.

I have tried rebooting the server that hosts the DBA program but it did nothing to help.

Can someone please help?

Thanks in Advance!

Title: Re: Update Material Standard Costs
Post by GasGiant on 10/29/10 at 05:20:52

Sounds like you have a corrupted item entry in the beginning of the table. Try bringing up each of the first dozen or so items in IN-B and see if you receive an error. Could be other things, but that will give you something to try. You can also try doing a range of items with IN-L-E by entering the From item number with the tenth or twentieth item in your inventory through to the last item. That could help you narrow down exactly where the problem lies.

Title: Re: Update Material Standard Costs
Post by Shanthi Nair on 10/29/10 at 05:55:53

I will try that and see how it goes, thanks.

Any other suggestions in the meantime?

Title: Re: Update Material Standard Costs
Post by Lynn_Pantic on 10/29/10 at 14:35:11

For reference, the problem was a file bigger than 2GB

Title: Re: Update Material Standard Costs
Post by Shanthi Nair on 10/01/12 at 07:17:58

Not sure if my previous message got through. I am seeing this problem again.

DBA 2004.1 update 12/15/07.

How can I fix the problem and with which file. I presume BKICMSTR.B. Will a reindex help it.

Thanks
Shanthi

Title: Re: Update Material Standard Costs
Post by Kelloggs on 10/01/12 at 08:35:24

We have 11,000 Sku's (171 MB)
If your table is bigger than 2GB, I can calculate that you could have over 1.2 Million Sku's ???

Ouchhhh

:-X

Kelloggs

Title: Re: Update Material Standard Costs
Post by Shanthi Nair on 10/01/12 at 09:15:18

As far as I can see only ISMICADT.B is over 2G. What can I do to fix that. And is that the cause of this problem.

Thanks
shanthi

Title: Re: Update Material Standard Costs
Post by Kelloggs on 10/01/12 at 09:26:36

That cann't be!!! There is something wrong with that table.

Are you a big company? Many employees on DBA?

If not just ask everybody to log off. Make a backup of your entire system
then re-index that table.

Other way to do this is to create a play company
Then do the re-index there, see if that make a difference....

UT-C Reindex File

:P

Kelloggs

Title: Re: Update Material Standard Costs
Post by Shanthi Nair on 10/01/12 at 15:06:19

It turns out Lynn told us previously to delete the file. I did that but am still seeing the problem. From my previous motes there is a dbaif program. I am not sure what that is. I am in the process of reindexing the files. Any ideas what more I can do.

Title: Re: Update Material Standard Costs
Post by Shanthi Nair on 10/02/12 at 07:01:19

Thank you all for your help. For reference, I deleted the two ISMICADT.B and ISMICADT^01 files and the used UT-A -> DBAIF to recreate it but the file does not seem to have been created. Everything is working fine howerver.

Title: Re: Update Material Standard Costs
Post by Lynn_Pantic on 10/02/12 at 07:36:16

The ISMICADT file is on of the audit files that tracks changes to inventory items and if you frequently roll standard costs, it can get very large. There is a default setting to disable the change tracking for standard cost rollup. There is also a setting in Pervasive on the server (Version 9 or later) to enable file size larger than 2 GB which will allow the file to grow rather than create the ^01 extension file when it hits 2 GB which is what makes Evo/DBA blow up.