Thanks for the feedback everyone. I'm doing the ASCII D&L over the weekend, so hope it helps.
--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> The ASCII D&L will correct some database problems that the binary one won't.  I've done both and I don't recall any difference in the time it took, but the ASCII D&L does take some extra hard drive space to perform.
> ÂÂ
>
> ________________________________
> From: Vic Drecchio <vic.drecchio@...>
> To: vantage@yahoogroups.com
> Sent: Friday, June 7, 2013 9:38 AM
> Subject: RE: [Vantage] Re: Progress Dump & Load Question
>
>
>
> ÂÂ
> I've always done ASCII D&L's on 8.03.xxx. I'm unsure what the difference
> is, but I bet I know what you'll be doing over the weekend. ;-)
>
> I was always very cautious on my D&L's (and still am). I'll always run the
> post D&L db in Test/Pilot first before restoring it to Production.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> nustepvantage
> Sent: Friday, June 07, 2013 8:35 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Progress Dump & Load Question
>
> The Inventory WIP report isn't the only problem we are having. I use the E9
> Performance Diagnostic Tool and our business object processes are taking a
> lot longer to complete. I did speak with support about the issue. I told
> them I did a binary dump & load. They are advising that I do an ASCII dump &
> load. Would this make a difference? When I did the binary dump & load I did
> keep the block size at 4096.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Ned"
> <TechnoBabbly@> wrote:
> >
> > It's possible that the indexes did not get rebuilt completely or
> correctly,
> > or there could be a different issue where the Inventory WIP wasn't
> actually
> > accurate before because it wasn't getting all the data for some reason.
> >
> > Can you take a copy of your DB prior to the D&L, put it into your test DB
> > and see how it works?
> >
> > Also, did you use a DB with the same blocksize as the DB you dumped from?
> > Often times people make that mistake and go from a DB with a 8192
> blocksize
> > to a 4096 when they reload it.
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> > nustepvantage
> > Sent: Thursday, June 06, 2013 2:28 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Progress Dump & Load Question
> >
> >
> > Hi All,
> >
> > Last weekend I did a binary dump & load of our Progress 64-bit database.
> We
> > are currently running Epicor 9.05 701.
> >
> > Ever since the dump & load it takes over an hour to run a simple inventory
> > wip report. It never took this long before. I followed the dump & load
> > instructions provided by support and also ran the 5460 conversion program
> at
> > the end. I'm beginning to think I may have done something wrong? Any
> > feedback would be helpful.
> >
> > Thanks,
> > David
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> > already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>