Upgrade to 506 Problems

Unless they have changed since 10.1B then yes, they are just as portable and
can be reversed with a folder copy. Up until that point a SP for OE did not
actually make any registry changes and I have done reversals of SP and
Patches the same way.



----- Original Message -----
From: "Brian W. Spolarich " <bspolarich@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, April 01, 2010 2:48 PM
Subject: RE: [Vantage] Upgrade to 506 Problems


Thanks for the confirmation/affirmation, Ned.

I'm assuming that OpenEdge updates involve some registry changes, and
aren't as "portable" as Vantage/E9 SPs/patches.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ned
Sent: Thursday, April 01, 2010 2:22 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Upgrade to 506 Problems

You are correct, essentially, a SP or PA is just a giant, fancy, self
executing zip file. A PA only included files that have changed since the
last SP, while a SP contains every single file required to run Vantage.

Technically, if you really needed to, you can actually do an installation of
Vantage by hacking together a minor folder structure, a couple of text
files, and a SP of Vantage. Not reccomended, but it can be done.


----- Original Message -----
From: "Brian W. Spolarich " <bspolarich@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, April 01, 2010 2:12 PM
Subject: RE: [Vantage] Upgrade to 506 Problems


From what I've seen, Vantage service pack installs basically modify stuff
under your C:\Epicor\MfgSys803 directory, and doesn't touch anything else
(i.e. OpenEdge). So by running the SP installer, you're loading a bunch of
new server-side files, an updated client, and the scripts to run the
database conversion. That's *all* the installer does, from what I can tell.

Then you run the admin tool and run the db conversion/uplift scripts to
bring your database in-line with the code version.

So if you take a backup of your Epicor directory (xcopy would be the best
and fastest way I think) and your database with everything shut down, you've
effectively got everything in the filesystem you need to bring Vantage back
to where it was before the update.

I haven't touched E9 yet, but the architecture is the same. I would
assume the update process is the same. Nothing outside of the Vantage/E9
directory structure should be involved in an update install (i.e. registry
entries), unless you're upgrading OpenEdge.

If you have to touch OpenEdge, then you'll have to revert either by
uninstalling the OE patch, or reinstalling OE.

But I would assume that OE is backwards-compatible. I've heard you can
run V8 on the E9 version of OE.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Thursday, April 01, 2010 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Upgrade to 506 Problems

Thanks for the advise and I do agree. We are currently not live yet (but
close). So the impact is more of a major inconvenience than a major
problem.



Prior to going live, we will have a testing server to allows us to test
these patches first.



When you say that you take a backup of the Epicor server directory, does
this allow you the ability to just copy it back over in the event
something goes wrong, rather than having in reinstall Epicor back to a
prior version, like I will have to do?


------------------------------------

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/linksYahoo! Groups Links





------------------------------------

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/linksYahoo! Groups Links





------------------------------------

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/linksYahoo! Groups Links
Hi All,



I tried to upgrade from 9.04.504c to 9.04.506 last night.

Everything was going smoothly until I got to the mandatory data
conversions part.

I logged into the Epicor Admin Tool, said yes to run the mandatory
database conversions and it ran smoothly for a while.

When it got to the "Update Translations" program (cvsu0005.p), I
received the following error message when it gets to "Removing old
records...." (we do not have the translations option):



Unable to delete old values for the index of a word-indexed field (index
OrgWordIdx of table LangOrg). The index may be damages. (12112)



If I click ok on this error, it makes me log back into the Admin tool,
where it tells me again about mandatory conversions and the same error
pops up.



I have a call into support, but as you can image, with an end of
month/quarter period, they have not yet responded.



As anyone else encounter this error? Any ideas? We are essentially down
until I can get this fixed.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
I ran into something similar with 9.04.504 last year. A user had created a "tip of the day" custom record, and when the conversion tried to run it gave me an index error. I was able to determine what table it was leading me to. I deleted the record through SQL and reran the conversions and it worked fine
Â
If you are not sure, see if there was any customization or record entered into the table that seems unusual and then see if you can delete the record and try again

--- On Thu, 4/1/10, Joe Rojas <jrojas@...> wrote:


From: Joe Rojas <jrojas@...>
Subject: [Vantage] Upgrade to 506 Problems
To: vantage@yahoogroups.com
Date: Thursday, April 1, 2010, 12:01 PM


Â



Hi All,

I tried to upgrade from 9.04.504c to 9.04.506 last night.

Everything was going smoothly until I got to the mandatory data
conversions part.

I logged into the Epicor Admin Tool, said yes to run the mandatory
database conversions and it ran smoothly for a while.

When it got to the "Update Translations" program (cvsu0005.p) , I
received the following error message when it gets to "Removing old
records...." (we do not have the translations option):

Unable to delete old values for the index of a word-indexed field (index
OrgWordIdx of table LangOrg). The index may be damages. (12112)

If I click ok on this error, it makes me log back into the Admin tool,
where it tells me again about mandatory conversions and the same error
pops up.

I have a call into support, but as you can image, with an end of
month/quarter period, they have not yet responded.

As anyone else encounter this error? Any ideas? We are essentially down
until I can get this fixed.







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[Non-text portions of this message have been removed]











[Non-text portions of this message have been removed]
Joe, I can't help you with this specific problem, but I can tell you that my approach to upgrades is a bit more conservative than it sounds like you have been.

My plan is to do an upgrade on a Saturday (production is done from noon on Sat through Monday AM), and to have a "okay to proceed" checklist that includes comparing a number of key reports before and after the upgrade/database conversion. Implicit in this approach is the assumption that the database conversion actually runs.

I'll take a backup of the Epicor server directory and database (MSSQL, but same with Progress) before the upgrade, and I'll have the ability to revert back to the old version (8.03.405) if things go bad for some reason.

I hope you can get assistance quickly to fix this issue, but I'm suggesting that folks be a lot more deliberate with applying upgrades, like you would with any mission-critical system, and have the ability to back out changes.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Thursday, April 01, 2010 12:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Upgrade to 506 Problems

Hi All,



I tried to upgrade from 9.04.504c to 9.04.506 last night.

Everything was going smoothly until I got to the mandatory data
conversions part.

I logged into the Epicor Admin Tool, said yes to run the mandatory
database conversions and it ran smoothly for a while.

When it got to the "Update Translations" program (cvsu0005.p), I
received the following error message when it gets to "Removing old
records...." (we do not have the translations option):



Unable to delete old values for the index of a word-indexed field (index
OrgWordIdx of table LangOrg). The index may be damages. (12112)



If I click ok on this error, it makes me log back into the Admin tool,
where it tells me again about mandatory conversions and the same error
pops up.



I have a call into support, but as you can image, with an end of
month/quarter period, they have not yet responded.



As anyone else encounter this error? Any ideas? We are essentially down
until I can get this fixed.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]



------------------------------------

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/linksYahoo! Groups Links
If you're really stuck and you're on progress, it looks like PROUTIL IDXFIX might be an option.

The lgrfeng.chm help file (in the Database Utilities section) provides usage info on PROUTIL.

I'd try it on a backup of my DB of course. But Epicor support is probably going to look askance at you mucking with the database and I don't have any real experience with Progress.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, April 01, 2010 1:10 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Upgrade to 506 Problems

I ran into something similar with 9.04.504 last year. A user had created a "tip of the day" custom record, and when the conversion tried to run it gave me an index error. I was able to determine what table it was leading me to. I deleted the record through SQL and reran the conversions and it worked fine
Â
If you are not sure, see if there was any customization or record entered into the table that seems unusual and then see if you can delete the record and try again

--- On Thu, 4/1/10, Joe Rojas <jrojas@...> wrote:


From: Joe Rojas <jrojas@...>
Subject: [Vantage] Upgrade to 506 Problems
To: vantage@yahoogroups.com
Date: Thursday, April 1, 2010, 12:01 PM


Â



Hi All,

I tried to upgrade from 9.04.504c to 9.04.506 last night.

Everything was going smoothly until I got to the mandatory data
conversions part.

I logged into the Epicor Admin Tool, said yes to run the mandatory
database conversions and it ran smoothly for a while.

When it got to the "Update Translations" program (cvsu0005.p) , I
received the following error message when it gets to "Removing old
records...." (we do not have the translations option):

Unable to delete old values for the index of a word-indexed field (index
OrgWordIdx of table LangOrg). The index may be damages. (12112)

If I click ok on this error, it makes me log back into the Admin tool,
where it tells me again about mandatory conversions and the same error
pops up.

I have a call into support, but as you can image, with an end of
month/quarter period, they have not yet responded.

As anyone else encounter this error? Any ideas? We are essentially down
until I can get this fixed.







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[Non-text portions of this message have been removed]











[Non-text portions of this message have been removed]



------------------------------------

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/linksYahoo! Groups Links
Thanks for the advise and I do agree. We are currently not live yet (but
close). So the impact is more of a major inconvenience than a major
problem.



Prior to going live, we will have a testing server to allows us to test
these patches first.



When you say that you take a backup of the Epicor server directory, does
this allow you the ability to just copy it back over in the event
something goes wrong, rather than having in reinstall Epicor back to a
prior version, like I will have to do?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, April 01, 2010 1:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Upgrade to 506 Problems





Joe, I can't help you with this specific problem, but I can tell you
that my approach to upgrades is a bit more conservative than it sounds
like you have been.

My plan is to do an upgrade on a Saturday (production is done from noon
on Sat through Monday AM), and to have a "okay to proceed" checklist
that includes comparing a number of key reports before and after the
upgrade/database conversion. Implicit in this approach is the assumption
that the database conversion actually runs.

I'll take a backup of the Epicor server directory and database (MSSQL,
but same with Progress) before the upgrade, and I'll have the ability to
revert back to the old version (8.03.405) if things go bad for some
reason.

I hope you can get assistance quickly to fix this issue, but I'm
suggesting that folks be a lot more deliberate with applying upgrades,
like you would with any mission-critical system, and have the ability to
back out changes.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
Sent: Thursday, April 01, 2010 12:01 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Upgrade to 506 Problems

Hi All,

I tried to upgrade from 9.04.504c to 9.04.506 last night.

Everything was going smoothly until I got to the mandatory data
conversions part.

I logged into the Epicor Admin Tool, said yes to run the mandatory
database conversions and it ran smoothly for a while.

When it got to the "Update Translations" program (cvsu0005.p), I
received the following error message when it gets to "Removing old
records...." (we do not have the translations option):

Unable to delete old values for the index of a word-indexed field (index
OrgWordIdx of table LangOrg). The index may be damages. (12112)

If I click ok on this error, it makes me log back into the Admin tool,
where it tells me again about mandatory conversions and the same error
pops up.

I have a call into support, but as you can image, with an end of
month/quarter period, they have not yet responded.

As anyone else encounter this error? Any ideas? We are essentially down
until I can get this fixed.







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]

------------------------------------

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]
From what I've seen, Vantage service pack installs basically modify stuff under your C:\Epicor\MfgSys803 directory, and doesn't touch anything else (i.e. OpenEdge). So by running the SP installer, you're loading a bunch of new server-side files, an updated client, and the scripts to run the database conversion. That's *all* the installer does, from what I can tell.

Then you run the admin tool and run the db conversion/uplift scripts to bring your database in-line with the code version.

So if you take a backup of your Epicor directory (xcopy would be the best and fastest way I think) and your database with everything shut down, you've effectively got everything in the filesystem you need to bring Vantage back to where it was before the update.

I haven't touched E9 yet, but the architecture is the same. I would assume the update process is the same. Nothing outside of the Vantage/E9 directory structure should be involved in an update install (i.e. registry entries), unless you're upgrading OpenEdge.

If you have to touch OpenEdge, then you'll have to revert either by uninstalling the OE patch, or reinstalling OE.

But I would assume that OE is backwards-compatible. I've heard you can run V8 on the E9 version of OE.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Thursday, April 01, 2010 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Upgrade to 506 Problems

Thanks for the advise and I do agree. We are currently not live yet (but
close). So the impact is more of a major inconvenience than a major
problem.



Prior to going live, we will have a testing server to allows us to test
these patches first.



When you say that you take a backup of the Epicor server directory, does
this allow you the ability to just copy it back over in the event
something goes wrong, rather than having in reinstall Epicor back to a
prior version, like I will have to do?
Yes, you can revert to an older version of Vantage, as well as OpenEdge to a
pre-service pack environment as long as you have:

Copy of the OpenEdge Directory
Copy of the MfgsysXXX Directory
Copy of the SQL database
Copy of the OpenEdge database

Basically, easiest thing to do is just shut down everything and do a
physical file copy of the entire Epicor Folder before you actually run any
of the service packs or hot fixes.

Although you will need to manually copy the client back to whatever clients
have connected and upgraded themselves.

----- Original Message -----
From: "Joe Rojas" <jrojas@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, April 01, 2010 1:27 PM
Subject: RE: [Vantage] Upgrade to 506 Problems


> Thanks for the advise and I do agree. We are currently not live yet (but
> close). So the impact is more of a major inconvenience than a major
> problem.
>
>
>
> Prior to going live, we will have a testing server to allows us to test
> these patches first.
>
>
>
> When you say that you take a backup of the Epicor server directory, does
> this allow you the ability to just copy it back over in the event
> something goes wrong, rather than having in reinstall Epicor back to a
> prior version, like I will have to do?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Brian W. Spolarich
> Sent: Thursday, April 01, 2010 1:10 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Upgrade to 506 Problems
>
>
>
>
>
> Joe, I can't help you with this specific problem, but I can tell you
> that my approach to upgrades is a bit more conservative than it sounds
> like you have been.
>
> My plan is to do an upgrade on a Saturday (production is done from noon
> on Sat through Monday AM), and to have a "okay to proceed" checklist
> that includes comparing a number of key reports before and after the
> upgrade/database conversion. Implicit in this approach is the assumption
> that the database conversion actually runs.
>
> I'll take a backup of the Epicor server directory and database (MSSQL,
> but same with Progress) before the upgrade, and I'll have the ability to
> revert back to the old version (8.03.405) if things go bad for some
> reason.
>
> I hope you can get assistance quickly to fix this issue, but I'm
> suggesting that folks be a lot more deliberate with applying upgrades,
> like you would with any mission-critical system, and have the ability to
> back out changes.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
> www.advancedphotonix.com
>
>
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
>
>
> -----Original Message-----
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Joe Rojas
> Sent: Thursday, April 01, 2010 12:01 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Upgrade to 506 Problems
>
> Hi All,
>
> I tried to upgrade from 9.04.504c to 9.04.506 last night.
>
> Everything was going smoothly until I got to the mandatory data
> conversions part.
>
> I logged into the Epicor Admin Tool, said yes to run the mandatory
> database conversions and it ran smoothly for a while.
>
> When it got to the "Update Translations" program (cvsu0005.p), I
> received the following error message when it gets to "Removing old
> records...." (we do not have the translations option):
>
> Unable to delete old values for the index of a word-indexed field (index
> OrgWordIdx of table LangOrg). The index may be damages. (12112)
>
> If I click ok on this error, it makes me log back into the Admin tool,
> where it tells me again about mandatory conversions and the same error
> pops up.
>
> I have a call into support, but as you can image, with an end of
> month/quarter period, they have not yet responded.
>
> As anyone else encounter this error? Any ideas? We are essentially down
> until I can get this fixed.
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
> jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
> us about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> 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]
>
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>
>
>
You are correct, essentially, a SP or PA is just a giant, fancy, self
executing zip file. A PA only included files that have changed since the
last SP, while a SP contains every single file required to run Vantage.

Technically, if you really needed to, you can actually do an installation of
Vantage by hacking together a minor folder structure, a couple of text
files, and a SP of Vantage. Not reccomended, but it can be done.


----- Original Message -----
From: "Brian W. Spolarich " <bspolarich@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, April 01, 2010 2:12 PM
Subject: RE: [Vantage] Upgrade to 506 Problems


From what I've seen, Vantage service pack installs basically modify stuff
under your C:\Epicor\MfgSys803 directory, and doesn't touch anything else
(i.e. OpenEdge). So by running the SP installer, you're loading a bunch of
new server-side files, an updated client, and the scripts to run the
database conversion. That's *all* the installer does, from what I can tell.

Then you run the admin tool and run the db conversion/uplift scripts to
bring your database in-line with the code version.

So if you take a backup of your Epicor directory (xcopy would be the best
and fastest way I think) and your database with everything shut down, you've
effectively got everything in the filesystem you need to bring Vantage back
to where it was before the update.

I haven't touched E9 yet, but the architecture is the same. I would
assume the update process is the same. Nothing outside of the Vantage/E9
directory structure should be involved in an update install (i.e. registry
entries), unless you're upgrading OpenEdge.

If you have to touch OpenEdge, then you'll have to revert either by
uninstalling the OE patch, or reinstalling OE.

But I would assume that OE is backwards-compatible. I've heard you can
run V8 on the E9 version of OE.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Thursday, April 01, 2010 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Upgrade to 506 Problems

Thanks for the advise and I do agree. We are currently not live yet (but
close). So the impact is more of a major inconvenience than a major
problem.



Prior to going live, we will have a testing server to allows us to test
these patches first.



When you say that you take a backup of the Epicor server directory, does
this allow you the ability to just copy it back over in the event
something goes wrong, rather than having in reinstall Epicor back to a
prior version, like I will have to do?


------------------------------------

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/linksYahoo! Groups Links
Thanks for the confirmation/affirmation, Ned.

I'm assuming that OpenEdge updates involve some registry changes, and aren't as "portable" as Vantage/E9 SPs/patches.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Thursday, April 01, 2010 2:22 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Upgrade to 506 Problems

You are correct, essentially, a SP or PA is just a giant, fancy, self
executing zip file. A PA only included files that have changed since the
last SP, while a SP contains every single file required to run Vantage.

Technically, if you really needed to, you can actually do an installation of
Vantage by hacking together a minor folder structure, a couple of text
files, and a SP of Vantage. Not reccomended, but it can be done.


----- Original Message -----
From: "Brian W. Spolarich " <bspolarich@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, April 01, 2010 2:12 PM
Subject: RE: [Vantage] Upgrade to 506 Problems


From what I've seen, Vantage service pack installs basically modify stuff
under your C:\Epicor\MfgSys803 directory, and doesn't touch anything else
(i.e. OpenEdge). So by running the SP installer, you're loading a bunch of
new server-side files, an updated client, and the scripts to run the
database conversion. That's *all* the installer does, from what I can tell.

Then you run the admin tool and run the db conversion/uplift scripts to
bring your database in-line with the code version.

So if you take a backup of your Epicor directory (xcopy would be the best
and fastest way I think) and your database with everything shut down, you've
effectively got everything in the filesystem you need to bring Vantage back
to where it was before the update.

I haven't touched E9 yet, but the architecture is the same. I would
assume the update process is the same. Nothing outside of the Vantage/E9
directory structure should be involved in an update install (i.e. registry
entries), unless you're upgrading OpenEdge.

If you have to touch OpenEdge, then you'll have to revert either by
uninstalling the OE patch, or reinstalling OE.

But I would assume that OE is backwards-compatible. I've heard you can
run V8 on the E9 version of OE.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Thursday, April 01, 2010 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Upgrade to 506 Problems

Thanks for the advise and I do agree. We are currently not live yet (but
close). So the impact is more of a major inconvenience than a major
problem.



Prior to going live, we will have a testing server to allows us to test
these patches first.



When you say that you take a backup of the Epicor server directory, does
this allow you the ability to just copy it back over in the event
something goes wrong, rather than having in reinstall Epicor back to a
prior version, like I will have to do?


------------------------------------

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/linksYahoo! Groups Links





------------------------------------

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/linksYahoo! Groups Links