Something for the admins to file away...maybe this will save someone
else some time down the road. If you ever want to repeat this process
(at least this is how it went for me), you'll need to manually edit a
file that tells Vantage you've already run the schema change.
In other words, if you want to pull your 305 DB over to the 400 DB,
restore, and redo the schema change/conversion process (for whatever
reason), remember this:
There is a file here:
\epicor\mfgsys803\Clientserver\db\SQL\vschmsql.dcd
This gets modified when you run the schema change from the Admin
Tools. The end of the file will look something like this:
"803-301DF.SQL" ? yes 11/06/07 "10:36" no
"803-302DF.SQL" ? yes 11/06/07 "10:36" no
"803-303DF.SQL" ? yes 11/06/07 "10:36" no
"803-304DF.SQL" ? yes 11/06/07 "10:36" no
"803-400DF.SQL" ? yes 11/06/07 "11:40" no
You'll need to manually change that file to look something like this:
"803-301DF.SQL" ? no ? "" no
"803-302DF.SQL" ? no ? "" no
"803-303DF.SQL" ? no ? "" no
"803-304DF.SQL" ? no ? "" no
"803-400DF.SQL" ? no ? "" no
Before you do that, you'll get a message similar to:
"Database Level 8.03.300 Program Level: 8.03.400 No schema change
required."
-Steve
else some time down the road. If you ever want to repeat this process
(at least this is how it went for me), you'll need to manually edit a
file that tells Vantage you've already run the schema change.
In other words, if you want to pull your 305 DB over to the 400 DB,
restore, and redo the schema change/conversion process (for whatever
reason), remember this:
There is a file here:
\epicor\mfgsys803\Clientserver\db\SQL\vschmsql.dcd
This gets modified when you run the schema change from the Admin
Tools. The end of the file will look something like this:
"803-301DF.SQL" ? yes 11/06/07 "10:36" no
"803-302DF.SQL" ? yes 11/06/07 "10:36" no
"803-303DF.SQL" ? yes 11/06/07 "10:36" no
"803-304DF.SQL" ? yes 11/06/07 "10:36" no
"803-400DF.SQL" ? yes 11/06/07 "11:40" no
You'll need to manually change that file to look something like this:
"803-301DF.SQL" ? no ? "" no
"803-302DF.SQL" ? no ? "" no
"803-303DF.SQL" ? no ? "" no
"803-304DF.SQL" ? no ? "" no
"803-400DF.SQL" ? no ? "" no
Before you do that, you'll get a message similar to:
"Database Level 8.03.300 Program Level: 8.03.400 No schema change
required."
-Steve
--- In vantage@yahoogroups.com, "jariwala_dhaval" <djariwala@...> wrote:
>
> Thanks everybody for the help. I did what Bill suggested and we are up
> and running on the test server. The mistake that I did, the last time,
> was I logged into admin tools before I restored our database. This
> time around, I restored our database and then ran schema changes.
> Still we were not at the right patch, so I ran the 803-400DF.sql from
> the client server->db->sql folder and that moved us up to 400. Then I
> logged into admin tools.
>
> --- In vantage@yahoogroups.com, Bill Baraski <bilbaraski@> wrote:
> >
> > I had a couple problems that sound like that. Honestly, it took a
> full reinstall. Backed up and detached the SQL DB's. I did the
> openedge, the service pack, then the hot fix. restart. Then a
> reinstall of 400. Make sure not to select the unicode support. Install
> the Training DB. It actually installs some Test DB files that helped
> me. Moved the Test/Live DB folders (Just for safety). ran ProEnv and
> changed to the test db directory (G:\epicor\MfgTest803\db). "prorest
> mfgtestsh G:\epicor\mfgsys803\db\newdb\test\mfgtestsh". ReAttach your
> DB in SQL Explorer. restart. Run the Progress Explorer Tool. start
> your TestDB. Run Test Schema Change. Then run Test Admin.
> > It was far from a clean upgrade, but when you take it to the point
> where it's a clean install, then put your SQL data back in the picture
> it seems to work better. Make sure to backup reports and export
> customizations. The Report Data Definations that are custom will stay,
> but you need to make sure you change back the report styles to use
> them again.
> >
> > PS: if you have problems starting your app servers, make sure you
> change the port information in the "SysAgent" table to make it match
> Test/Live depending on what you are running if it has changed.
> >
> > Post back the specific error you're getting with the Admin Tools and
> the one your getting for Schema Change. I have a feeling I ran into it
> as well. If I remember right it had to do with the database schema not
> matching. Allowing the SQL I still have to do some tweaking to get the
> MfgSys803 working. For now, MfgTest803 is working and I ran with it.
> >
> > PS: The speed gain is well worth it, still a few bugs laying around
> though.
> >
> > ----- Original Message ----
> > From: Paul V. Blais <pblais@>
> > To: vantage@yahoogroups.com
> > Sent: Monday, December 3, 2007 1:46:55 PM
> > Subject: RE: [Vantage] Convert Database from 8.03.305K to 8.03.400
> >
> > You defiantly ran the schema change after you did a prorest on a
copy of
> > your live data?
> >
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
> Behalf
> > Of jariwala_dhaval
> > Sent: Monday, December 03, 2007 1:38 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Convert Database from 8.03.305K to 8.03.400
> >
> > We are having problem upgrading from 8.03.305K to 8.03.400 on a test
> > server.
> >
> > We un-installed everything and started off from scratch, by installing
> > SQL server 2005, progress open edge 10.1B and Vantage Manufacturing
> > Systems. We started the database and the appservers and logged into
> > the system, everything was good so far. Then we restored the clean
> > database with our database and ran the Vantage schema change. Now, we
> > are trying to start our appservers and they are not starting. We also
> > tried to log in on the admin tool that gives us an error. We figured
> > out that the error was related to our data is not converted to 400
> > which resulted in a support call. We called up support and they asked
> > us to send our database to them; so that, they can convert it and send
> > it back to us. As usual we are waiting for their reply.
> >
> > Can somebody guide us, where did we go wrong?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
>
____________________________________________________________________________________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search.
> http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> >
> > [Non-text portions of this message have been removed]
> >
>