Boy that's weird. I did have one time on my laptop where it just seemed to get 'stuck'. Disk space is one problem I've run into with Schema's because of the BI file getting so large.
Troy Funte
Liberty Electronics
Troy Funte
Liberty Electronics
----- Original Message -----
From: Britt Moelling
To: vantage@yahoogroups.com
Sent: Monday, December 03, 2001 9:00 AM
Subject: Re: [Vantage] Vantage 5.1 Data Conversion --- FRUSTRATED!
In my case, I had no one on the server, no services except progress
running. CPU utilization never got above about 3%. I aborted the
upgrade after 8 days.
Britt Moelling
M&M Manufacturing LP.
Troy Funte wrote:
> I've done schema changes both ways several times - it seems like it is
> never the same. Sometimes the workstation is faster, sometimes the
> server is faster. The only thing that has been consistent has been
> doing it on a stand alone laptop - 7 hrs every time. My theory (no
> scientific verification), is that the server would do it fastest if
> there was NO other activity on it. But if users are accessing files,
> etc. on the server, then doing the schema's from a workstation may be
> the way to go. This is only gut feel, here now. I have no clue what
> goes on behind the scenes.
>
> One note, I've never successfully done schema changes on a NT 4.0
> workstation. It always hangs up. Go figure...
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Terry Williams
> To: vantage@yahoogroups.com
> Sent: Friday, November 30, 2001 12:51 PM
> Subject: RE: [Vantage] Vantage 5.1 Data Conversion --- FRUSTRATED!
>
>
> I've run the 5.0 schema change several times at the server, never a
> hitch.
> Of course my db is nowhere near 4.8g. But still, it's not a problem
> in W2K.
>
> Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St.
> Ext.
> Meadville, PA 16335 p.8143336331 x236 f.8143372548
> tlw@...
> <mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
>
> -----Original Message-----
> From: Ed Zywiec [mailto:ed.zywiec@...]
> Sent: Friday, November 30, 2001 12:22 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Vantage 5.1 Data Conversion --- FRUSTRATED!
>
> Britt,
>
> Thanks for getting back to me. So it is best to run the schema
> change off a
> decent workstation. Do you (or anyone else) know if that is also
> true for
> 5.0?
>
> Thanks Ed
>
> -----Original Message-----
> From: Britt Moelling [mailto:bmoelling@...]
> Sent: Friday, November 30, 2001 11:29 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Vantage 5.1 Data Conversion --- FRUSTRATED!
>
>
> Ed
>
> My test server is a Pent 3 1 Gig, with 1 Gig of RAM, and a single 18
> gig
> Ultra 160 SCSI drive running Windows 2000.
> Database size is 4.8 GIG, with 10 extents of 512 meg, BI file is 512
>
> meg.
>
> First attempt to upgrade from 5.0 to 5.1, running the Schema Change
> from
> the server, ran 8 days, so I aborted the upgrade.
>
> Second attempt, I ran the Schema change from a workstation (Celeron
> 500,
> 128 meg mem), and it took 10 hrs to do the schema change, and about
> 30
> min to do the "mandatory data conversion".
>
>
> Britt Moelling
> M&M Manufacturing LP.
>
>
> Ed Zywiec wrote:
>
> > Britt,
> >
> > What finally happened? I am doing a test upgrade from 4 to 5 on
> my
> > notebook. I started a week ago, I am now watching the phase 2 of
> > idxbuild
> > command. It looks like its going to take about 24hrs for the
> idxbuild
> >
> > command to run. I sure hope there isn't a phase 3. It only took an
>
> > hour to
> > bomb on the last block of phase 1, Until yesterday I didn't think
>
> > there was
> > a phase 2. I'm so glad this is a test. How long did your schema
> > change
> > take? Do you remember how long it took going from 4 to 5. Anyone
>
> > else who
> > went to 4 to 5 with about a 2 gig data file, how long did yours
> take?
> > How
> > long did your idxbuild take? We are planning on doing ours this
> > weekend. I
> > should say starting ours this weekend. Who is the patron saint of
>
> > conversions? I think I'm going to need more than tech support
> here.
> >
> > -----Original Message-----
> > From: Britt Moelling [mailto:bmoelling@...]
> > Sent: Friday, November 16, 2001 3:43 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Vantage 5.1 Data Conversion --- FRUSTRATED!
>
> >
> >
> > Patrick
> > Task Manager shows the CPU utilization running at 1%, and in the
>
> > "processes" tab, I see activity on one of the _mprosrv processes.
> >
> > Another update!!! It has been 4 1/2 days, and I have noticed a
> slight
> >
> > change in the Vantage conversion window!!! It now has a slightly
> > darker
> > blank screen probably due to screen phosphor burn out!
> >
> > Britt
> >
> > "Winter, Patrick" wrote:
> >
> > > Are you running a performance monitor on your server or better
> yet
> > > from
> > > another server watching CPU Utilization? This may be your only
> > > indicator
> > > that it is still working an not hung up.
> > >
> > > Patrick Winter
> > > sSc Specialty Screw Corporation
> > > Vantage 5.00.317, Progress 9.1a
> > >
> > >
> > > -----Original Message-----
> > > From: Britt Moelling [mailto:bmoelling@...]
> > > Sent: Friday, November 16, 2001 8:41 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] Vantage 5.1 Data Conversion ---
> FRUSTRATED!
> > >
> > >
> > > Important Update!!!!!!!!!!!!!!!!!!!!!!!
> > >
> > > Conversion has now been going 4 days!! Still no signs of a
> screen
> > > update!!!
> > >
> > > I did talk to tech support and asked them why the programmers
> did
> > not
> > > include a screen update every once in a while, and they
> responded
> > with
> > > a
> > > " I don't know".
> > >
> > > Britt
> > >
> > > Mark Dupuis wrote:
> > >
> > > > Been there done that. A major pain, it took two days, a Sunday
> and
> > a
> > >
> > > > Monday.
> > > > I had a hard time telling people I didn't know when it would
> be
> > > done.
> > > > Mark Dupuis
> > > > Ranor Inc.
> > > >
> > > > -----Original Message-----
> > > > From: All American Products
> [mailto:miket@...]
> >
> > > > Sent: Thursday, November 15, 2001 5:08 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] Vantage 5.1 Data Conversion ---
> FRUSTRATED!
> >
> > > >
> > > >
> > > > I know the pain. I agree with you 100%. The progress bar would
> be
> > > very
> > > >
> > > > helpful.
> > > > It took me 3 weekends to upgrade from 3.0 to 4.0 and migrate
> to a
> > > new
> > > > server. The first couple of times I test ran and logged the
> > timing.
> > > > The
> > > > third time I knew how long it was going to take. It sounds
> like a
> > > > stone age
> > > > approach but it worked for me.
> > > >
> > > > Mike Tonoyan / All American Products Co.
> > > >
> > > >
> > > >
> > > > Mike Tonoyan
> > > > ----- Original Message -----
> > > > From: "Britt Moelling" <bmoelling@...>
> > > > To: <vantage@yahoogroups.com>
> > > > Sent: Thursday, November 15, 2001 1:58 PM
> > > > Subject: [Vantage] Vantage 5.1 Data Conversion --- FRUSTRATED!
>
> > > >
> > > >
> > > > > We are testing the conversion to Vantage 5.1 on a seperate
> > server.
> > >
> > > > Our
> > > > > database is almost 5 Gig, and I am running the schema
> changes
> > from
> > >
> > > > the
> > > > > server.
> > > > >
> > > > > IT HAS BEEN RUNNING FOR 3 DAYS!!! The "Task List" dosen't
> > > indicate
> > > > that
> > > > > it has stopped responding, but the Vantage window is blank,
> and
> > > the
> > > > > screen is not updated so I have absolutely no idea how much
> > longer
> > >
> > > > it
> > > > > will take,... or even if it is stuck in a loop!
> > > > >
> > > > > For the life of me I cannot understand the mentality of the
> > > Vantage
> > > > > programmers! How hard would it be to update the screen
> every
> > once
> > >
> > > > in a
> > > > > while with a conversion status, or estimated time remaining,
> or
> > > > > something!!!
> > > > > Don't they realize that their customers cannot just stop
> doing
> > > > business
> > > > > while they wait an UNKNOWN amount of time for the conversion
> to
> > > > > complete!!!!!
> > > > >
> > > > > For Example:
> > > > > What if we began conversion on a Friday evening, and come
> Sunday
> >
> > > > night
> > > > > it still wasn't finished, what do we do? Do we assume it is
> not
> > > even
> > > >
> > > > > close to being done and abort (which case we will NEVER
> > convert)?
> > > > Or,
> > > > > do we take a chance and assume it is almost done, and let it
>
> > > finish?
> > > >
> > > > > (but how long do we wait?)
> > > > >
> > > > > --
> > > > > Britt Moelling
> > > > > M&M Manufacturing Co.
> > > > >
> > > > >
> >
> > Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
> >
>
>
> 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/.
> (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/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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/.
> (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/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
ADVERTISEMENT
>
> 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/.
> (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/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
Britt Moelling
M&M Manufacturing Co.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
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/.
(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/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]