My own 5.1 frustrations

Nope. Did the 5.0 schema, db conversions, patches, and procopy to 5.1.

Rick


> I had that same error, it happens when you use a 4.0 database
> and try to go straight to 5.1. You have to run the 5.0 schema and DB
> changes first, then run the 5.1 schema and DB changes.
>
>
> - Ed
I'm in the process of doing a 3.0 to 5.1 upgrade on our test server and I've
run in to some problems. Thought I would throw them out here and see what
everyone thinks.

I've successfully gotten to 5.0, this being the third successful upgrade to
5.0 on our test server. For 5.1 the schema changes, although they took 8+
hours for a 1.5gb database, went through fine with no errors. I started the
db conversions yesterday about this time and had some errors plus now it is
hung on the same process for over 18 hours.

Here are the errors:

1. Program: cv/cves0001.p
Description: Initialize new shop load fields
Message: Updating shopload table
Error: No WrkCenter -0 record is available (91)
Occurances: 20

2. Program: cv/cvxa0043.p
Description: Fix bad partbin quantities
Error: No Whsebin record is available (91)
Occurances: 37

Now it is hung on this:

Program: cv/cvxa0047.p
Description: Reverse PartTran for shipdtl records which are not
shipped
Message: Reversing extra parttran records

We did not do a dump and load, did not close jobs, did not close financials,
etc. I just did a db copy from each version to the next, ran the schema
changes, then the db conversions. The workstation I'm using is W98 so I
can't see any activity and only know that progress is still responding. The
server is pretty much idle at 97% and shows an occasional 1-3% usage on
_mprosrv.exe. Crash protection is turned off. My guess is this is hung and
I'm starting over again.

Any suggestions?

Thanks,
Rick
Has any one else run into a problem with "Program: cv/cvxa0047.p" when
doing the 5.1 database conversion? I just hung here also.


Ron Newell
IT/MIS
Neon Products
1695 Sargent Ave.
Winnipeg, MB R3H 0C4

http://www.neon-products.com/
mailto:rnewell@...

-----Original Message-----
From: Rick Spriggle [mailto:rspriggle@...]
Sent: Thursday, December 06, 2001 8:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] My own 5.1 frustrations

I'm in the process of doing a 3.0 to 5.1 upgrade on our test server and I've
run in to some problems. Thought I would throw them out here and see what
everyone thinks.

I've successfully gotten to 5.0, this being the third successful upgrade to
5.0 on our test server. For 5.1 the schema changes, although they took 8+
hours for a 1.5gb database, went through fine with no errors. I started the
db conversions yesterday about this time and had some errors plus now it is
hung on the same process for over 18 hours.

Here are the errors:

1. Program: cv/cves0001.p
Description: Initialize new shop load fields
Message: Updating shopload table
Error: No WrkCenter -0 record is available (91)
Occurances: 20

2. Program: cv/cvxa0043.p
Description: Fix bad partbin quantities
Error: No Whsebin record is available (91)
Occurances: 37

Now it is hung on this:

Program: cv/cvxa0047.p
Description: Reverse PartTran for shipdtl records which are not
shipped
Message: Reversing extra parttran records

We did not do a dump and load, did not close jobs, did not close financials,
etc. I just did a db copy from each version to the next, ran the schema
changes, then the db conversions. The workstation I'm using is W98 so I
can't see any activity and only know that progress is still responding. The
server is pretty much idle at 97% and shows an occasional 1-3% usage on
_mprosrv.exe. Crash protection is turned off. My guess is this is hung and
I'm starting over again.

Any suggestions?

Thanks,
Rick
I had that same error, it happens when you use a 4.0 database and try to go
straight to 5.1. You have to run the 5.0 schema and DB changes first, then
run the 5.1 schema and DB changes.


- Ed

-----Original Message-----
From: Ron Newell [mailto:rnewell@...]
Sent: Sunday, December 09, 2001 10:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] My own 5.1 frustrations


Has any one else run into a problem with "Program: cv/cvxa0047.p" when
doing the 5.1 database conversion? I just hung here also.


Ron Newell
IT/MIS
Neon Products
1695 Sargent Ave.
Winnipeg, MB R3H 0C4

http://www.neon-products.com/ <http://www.neon-products.com/>
mailto:rnewell@...

-----Original Message-----
From: Rick Spriggle [mailto:rspriggle@...]
Sent: Thursday, December 06, 2001 8:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] My own 5.1 frustrations

I'm in the process of doing a 3.0 to 5.1 upgrade on our test server and I've
run in to some problems. Thought I would throw them out here and see what
everyone thinks.

I've successfully gotten to 5.0, this being the third successful upgrade to
5.0 on our test server. For 5.1 the schema changes, although they took 8+
hours for a 1.5gb database, went through fine with no errors. I started the
db conversions yesterday about this time and had some errors plus now it is
hung on the same process for over 18 hours.

Here are the errors:

1. Program: cv/cves0001.p
Description: Initialize new shop load fields
Message: Updating shopload table
Error: No WrkCenter -0 record is available (91)
Occurances: 20

2. Program: cv/cvxa0043.p
Description: Fix bad partbin quantities
Error: No Whsebin record is available (91)
Occurances: 37

Now it is hung on this:

Program: cv/cvxa0047.p
Description: Reverse PartTran for shipdtl records which are not
shipped
Message: Reversing extra parttran records

We did not do a dump and load, did not close jobs, did not close financials,
etc. I just did a db copy from each version to the next, ran the schema
changes, then the db conversions. The workstation I'm using is W98 so I
can't see any activity and only know that progress is still responding. The
server is pretty much idle at 97% and shows an occasional 1-3% usage on
_mprosrv.exe. Crash protection is turned off. My guess is this is hung and
I'm starting over again.

Any suggestions?

Thanks,
Rick






Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
83:HM/A=879171/R=0/*http://www.fastweb.com/ib/yahoo-57f>

<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
l/S=1705007183:HM/A=879171/rand=253809729>

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
<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
<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]