E10: 9.05.702A Progress Database Migration Error - Resolved

Yahoo Archive
1
For what is worth I just had this same issue happen on another migration, I was hosting the intermediate DB On the Standard SQL the issue was that I needed special SQL Drivers in the Migration Box. I installed SQL Express in the Migration Box Restarted Admin console, and its working now

Thanks!


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Sep 16, 2014 at 1:00 PM, tom.epicor.grp@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>It took about 13 hours.  I was exporting the data to an SSD drive.  So that might have speed things up for me.</p><div><br></div><div>For set 500.  I logged into the E10 server and manually created the linked server.  Then ran the *.sql files located in this folder.  C:&#92;Program Files (x86)&#92;Common Files&#92;Epicor Software Corporation&#92;Database Manager Extensions&#92;3.0.7&#92;DB Migration   The error log pointed out which ones tried to run.</div><div><br></div><div>When I get a chance I will post the complete list.</div><div> </div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

2
Thanks All for the help.

While the migration instructions say that SQL Server Express can be used, I believe SQL Server Express was the problem.
I uninstalled Express and installed Standard on my Epicor 9 server and I have gotten past this error and the migration process is running right now.

Based on some of the testing I did before uninstalling Express, I believe Express requires some additional configuration changes before you can use it to host the interim DB.
I’m not positive but having Standard work without any issue leads me to make this guess.

One thing that I didn’t know, which would have forced me to use Standard anyways, is that the max DB size is only 10GB in Express. Our Progress DB is 22GB so it’s likely the interim DB would have exceeded 10GB.

I hope this helps someone else down the road. :)





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:44fcdf.png@75fd743b.4799493d]
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.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 12, 2014 2:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error


How I was able to get it to work is.

Create a blank DB in SQL and make sure you give permissions for the administrative account!! Use that DB as the interim DB for Migration.

Going back a couple steps. Do you know for sure the E9 DB is started?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 12, 2014 12:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error



Unfortunately no.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:318833.png@471d6c29.40ade83f]
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.

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, September 12, 2014 10:25 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: Re: [Vantage] E10: 9.05.702A Progress Database Migration Error

Maybe I missed an email, but does it give you a path to the file it is looking for?

________________________________
From: "Joe Rojas jrojas@...<mailto:jrojas@...> [vantage]" <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>
To: "vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>
Sent: Friday, September 12, 2014 9:55 AM
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error

Thanks Jose.

I tried this and got the same thing.

Here is what I did:

1) Shared the folder C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA with a share name of DATA

2) Updated the Output folder to: \\SERVERNAME\DATA<file:///\\SERVERNAME\DATA>

3) Restarted the migrations process.

4) Same error

If I look in the output folder, I see the two database files (MDF, LDF), CreateDB.sql, and ProgressToSQLMigration_TableStatistics.txt
So it can access this folder and create files but still the same error.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:dc0f77.png@7e567d68.4ca4f2ee<mailto:dc0f77.png@7e567d68.4ca4f2ee><cid:dc0f77.png@7e567d68.4ca4f2ee%3cmailto:dc0f77.png@7e567d68.4ca4f2ee%3e>]
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.

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e>]
Sent: Friday, September 12, 2014 9:14 AM
To: Vantage
Subject: Re: [Vantage] E10: 9.05.702A Progress Database Migration Error

You need to share the folder where your SQL DataBase will be created your temporary DB. And make that the output folder should be something like
C:\ProgramFIles\Microsoft SQL\MSSQL\DATa

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile
E: jose@...<mailto:jose@...><mailto:jose@...<mailto:jose@...<mailto:jose@...%3cmailto:jose@...%3e%3cmailto:jose@...%3cmailto:jose@...>>>
http://www.josecgomez.com<http://www.josecgomez.com/<http://www.josecgomez.com%3chttp:/www.josecgomez.com/>>
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Sep 12, 2014 at 9:12 AM, Joe Rojas jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...>>> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>>> wrote:

Thanks Jose,

I reread the instructions and I missed this.
However, after making this change, the same thing happened.

I shared the output folder (C:\Program Files (x86)\Common Files\Epicor Software Corporation\Database Manager Extensions\3.0.7\DB Migration\Progress Output) with a share name of “ProgressOutput”.
I then change the output folder to \\SERVERNAME\ProgressOutput<file:///\\SERVERNAME\ProgressOutput<file:///\\SERVERNAME\ProgressOutput%3cfile:\SERVERNAME\ProgressOutput>>
Do I have this right?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291> | cell: 781-408-9278<tel:781-408-9278> | fax: 781-232-5191<tel:781-232-5191>

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...>>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com/<http://www.matsinc.com%3chttp:/www.matsinc.com%3chttp:/www.matsinc.com/>>>
Ask us about our clean, green and beautiful matting and flooring

[cid:c9017e.png@d6f73745.459502a1<mailto:c9017e.png@d6f73745.459502a1><cid:c9017e.png@d6f73745.459502a1%3cmailto:c9017e.png@d6f73745.459502a1%3e>]
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.

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3e>]
Sent: Friday, September 12, 2014 8:46 AM
To: Vantage
Subject: Re: [Vantage] E10: 9.05.702A Progress Database Migration Error

The output folder is:
C:\Program Files (x86)\Common Files\Epicor Software Corporation\Database Manager Extensions\3.0.7\DB Migration\Progress Output

That needs to be (at least in my case when I've done it) that needs to be the same folder that contains your MDF SQL file for the Intermediate DB and it needs to be a shared location such as \\XX\myServer\XX<file:///\\XX\myServer\XX>
If you are installing the intermediate DB in the local SQL Express then make sure you share the folder where the DB will be placed and make that the Output Folder

Jose C Gomez
Software Engineer

T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@...><mailto:jose@...<mailto:jose@...>><mailto:jose@...<mailto:jose@...><mailto:jose@...<mailto:jose@...<mailto:jose@...%3cmailto:jose@...%3e%3cmailto:jose@...%3cmailto:jose@...%3e%3e%3cmailto:jose@...%3cmailto:jose@...%3e%3cmailto:jose@...%3cmailto:jose@...>>>>
http://www.josecgomez.com<http://www.josecgomez.com/<http://www.josecgomez.com%3chttp:/www.josecgomez.com/>>
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Sep 12, 2014 at 8:24 AM, Joe Rojas jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...>>>> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>>>> wrote:

Thanks for both responses.

We have one server that is setup as a 9.05.702A server that I installed the E10 Admin Console and SQL Server Express and our E10.0.700.2 is installed on a separate server.
I am running the database migration on the 9.05 server.

My Progress Parameter file path is valid. Just confirmed it.
The output folder is:
C:\Program Files (x86)\Common Files\Epicor Software Corporation\Database Manager Extensions\3.0.7\DB Migration\Progress Output

There appear to be no other options for directories that I can change.
The process is creating the interim database in the output path above.
The whole thing only runs for less than a minute before it craps out.

Jose, to your reply, I’m not sure I follow. When you say “So it would be a shared directory on your sql server” do you mean on my E10 server or on the E9.05 server?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291><tel:781-573-0291<tel:781-573-0291<tel:781-573-0291%3ctel:781-573-0291>>> | cell: 781-408-9278<tel:781-408-9278><tel:781-408-9278<tel:781-408-9278<tel:781-408-9278%3ctel:781-408-9278>>> | fax: 781-232-5191<tel:781-232-5191><tel:781-232-5191<tel:781-232-5191<tel:781-232-5191%3ctel:781-232-5191>>>

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...>>>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com/>><http://www.matsinc.com<http://www.matsinc.com/<http://www.matsinc.com%3chttp:/www.matsinc.com%3chttp:/www.matsinc.com/%3e%3e%3chttp:/www.matsinc.com%3chttp:/www.matsinc.com/>>>
Ask us about our clean, green and beautiful matting and flooring

[cid:fcb978.png@674d6cfa.47b14089<mailto:fcb978.png@674d6cfa.47b14089><cid:fcb978.png@674d6cfa.47b14089%3cmailto:fcb978.png@674d6cfa.47b14089%3e>]
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.

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>>> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>><mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3cmailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com%3e%3e%3e>]
Sent: Friday, September 12, 2014 7:51 AM
To: Vantage
Subject: Re: [Vantage] E10: 9.05.702A Progress Database Migration Error

You need to put the log file location in the same as your intermediate db file. So it would be a shared directory on your sql server
On Sep 11, 2014 9:50 PM, "Joe Rojas jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...>>>>> [vantage]" <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>>>>> wrote:

Hi All,

Just curious if anyone has run into this.
Following the migration instructions, I installed the E10 Epicor Administrator Console and SQL Server 2012 Express.
I started the Database Migration Process from the 702A server and on the first step, it is throwing the error below fairly quickly.
Any ideas what might be wrong?

Starting Execution Phase...
- OpenEdgeMigration
Error Exception Message: The system cannot find the file specified
Exception Stack Trace: at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at Epicor.DBMigration.OpenEdgeMigration.CreateDatabase()

at Epicor.DBMigration.OpenEdgeMigration.CreateDatabase()
at Epicor.DBMigration.OpenEdgeMigration.ExecuteMigration()
at Epicor.MigrationModel.DBMigrationProcess.Run()
DB Migration process is cancelled by the user.
The total execution time is 0.2799 minutes.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291><tel:781-573-0291<tel:781-573-0291<tel:781-573-0291%3ctel:781-573-0291>>><tel:781-573-0291<tel:781-573-0291<tel:781-573-0291%3ctel:781-573-0291>>> | cell: 781-408-9278<tel:781-408-9278><tel:781-408-9278<tel:781-408-9278<tel:781-408-9278%3ctel:781-408-9278>>> | fax: 781-232-5191<tel:781-232-5191><tel:781-232-5191<tel:781-232-5191<tel:781-232-5191%3ctel:781-232-5191>>>

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>><mailto:jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3e%3cmailto:jrojas@...%3cmailto:jrojas@...%3e%3cmailto:jrojas@...%3cmailto:jrojas@...>>>>> | www.matsinc.com<http://www.matsinc.com<http://www.matsinc.com/>><http://www.matsinc.com<http://www.matsinc.com/>><http://www.matsinc.com<http://www.matsinc.com/<http://www.matsinc.com%3chttp:/www.matsinc.com%3chttp:/www.matsinc.com/%3e%3e%3chttp:/www.matsinc.com%3chttp:/www.matsinc.com/%3e%3e%3chttp:/www.matsinc.com%3chttp:/www.matsinc.com/>>>
Ask us about our clean, green and beautiful matting and flooring

[cid:a3c5e5.png@4a5d5098.4795bbb5<mailto:a3c5e5.png@4a5d5098.4795bbb5><cid:a3c5e5.png@4a5d5098.4795bbb5%3cmailto:a3c5e5.png@4a5d5098.4795bbb5%3e>]
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]

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

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

------------------------------------
Posted by: Joe Rojas <jrojas@...<mailto:jrojas@...<mailto:jrojas@...%3cmailto:jrojas@...>>>
------------------------------------

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/links
------------------------------------

Yahoo Groups Links

http://groups.yahoo.com/group/vantage/

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





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

You can expect your interm DB to be about 40 Gb and the final SQL db to be about 100 Gb.  I started with a 24 Gb progress db and that it where I ended up.

If you can make the final SQL db start at 100 Gb  You will save some time on the load.  Then the E10 SQL Db will not need to expand when the data is being loaded.

And one final note.  Let me know if you get by step 500 - IceSystemTablesMigration.   I have a call still open with Epicor to get by this step.  This is trying to open a linked server from E10 back to the interm DB.  It errors every time because of security issue on the connection.  I ended up manually running the SQL batch files from the E10 sever to get past that step.

Tom Osen
IT Manager
Water Gremlin Co.
4
Thanks Tom for this additional information.
100GB! I’m was not expecting that.

How long did step the first step take for you (10 – Convert a source Progress DB to a interim SQL DB)?
Right now I’m at 18 hours and it’s still chugging away.

In case I do get stuck at step 500, can you elaborate on how you ran the SQL batch files to get past it?






Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:6be657.png@fd543119.4b9afaf0]
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.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 10:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error - Resolved



Joe,

You can expect your interm DB to be about 40 Gb and the final SQL db to be about 100 Gb. I started with a 24 Gb progress db and that it where I ended up.

If you can make the final SQL db start at 100 Gb You will save some time on the load. Then the E10 SQL Db will not need to expand when the data is being loaded.

And one final note. Let me know if you get by step 500 - IceSystemTablesMigration. I have a call still open with Epicor to get by this step. This is trying to open a linked server from E10 back to the interm DB. It errors every time because of security issue on the connection. I ended up manually running the SQL batch files from the E10 sever to get past that step.

Tom Osen
IT Manager
Water Gremlin Co.



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

18 hours??? That’s insane!!!

 

It should not take that long! Something is not set up correctly… You know you should change some settings on the server to allow for high performance?!

 

I had a 20GB progress DB and it took me less than 4 hours to complete. My DB was about 60 GB when it finished.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 10:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error - Resolved

 

 

Thanks Tom for this additional information.
100GB! I’m was not expecting that.

How long did step the first step take for you (10 – Convert a source Progress DB to a interim SQL DB)?
Right now I’m at 18 hours and it’s still chugging away.

In case I do get stuck at step 500, can you elaborate on how you ran the SQL batch files to get past it?






Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:6be657.png@fd543119.4b9afaf0]
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.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 10:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error - Resolved



Joe,

You can expect your interm DB to be about 40 Gb and the final SQL db to be about 100 Gb. I started with a 24 Gb progress db and that it where I ended up.

If you can make the final SQL db start at 100 Gb You will save some time on the load. Then the E10 SQL Db will not need to expand when the data is being loaded.

And one final note. Let me know if you get by step 500 - IceSystemTablesMigration. I have a call still open with Epicor to get by this step. This is trying to open a linked server from E10 back to the interm DB. It errors every time because of security issue on the connection. I ended up manually running the SQL batch files from the E10 sever to get past that step.

Tom Osen
IT Manager
Water Gremlin Co.


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

6
Yeah, my Epicor 9.05.702A server is running in a virtual machine. I created it just for this conversion.
OpenEdge is “right out of the box” with no tweaks and the VM only has 8GB of RAM.
On my next migration, I will try to tweak OpenEdge and assign more RAM to the VM.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:a7bbd5.png@e35a0a5d.4db54851]
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.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 11:00 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error - Resolved


18 hours??? That’s insane!!!

It should not take that long! Something is not set up correctly… You know you should change some settings on the server to allow for high performance?!

I had a 20GB progress DB and it took me less than 4 hours to complete. My DB was about 60 GB when it finished.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 10:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error - Resolved



Thanks Tom for this additional information.
100GB! I’m was not expecting that.

How long did step the first step take for you (10 – Convert a source Progress DB to a interim SQL DB)?
Right now I’m at 18 hours and it’s still chugging away.

In case I do get stuck at step 500, can you elaborate on how you ran the SQL batch files to get past it?






Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:6be657.png@fd543119.4b9afaf0]
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.


From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 10:12 AM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: RE: [Vantage] E10: 9.05.702A Progress Database Migration Error - Resolved



Joe,

You can expect your interm DB to be about 40 Gb and the final SQL db to be about 100 Gb. I started with a 24 Gb progress db and that it where I ended up.

If you can make the final SQL db start at 100 Gb You will save some time on the load. Then the E10 SQL Db will not need to expand when the data is being loaded.

And one final note. Let me know if you get by step 500 - IceSystemTablesMigration. I have a call still open with Epicor to get by this step. This is trying to open a linked server from E10 back to the interm DB. It errors every time because of security issue on the connection. I ended up manually running the SQL batch files from the E10 sever to get past that step.

Tom Osen
IT Manager
Water Gremlin Co.


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



[Non-text portions of this message have been removed]
7
It took about 13 hours.  I was exporting the data to an SSD drive.  So that might have speed things up for me.

For set 500.  I logged into the E10 server and manually created the linked server.  Then ran the *.sql files located in this folder.  C:\Program Files (x86)\Common Files\Epicor Software Corporation\Database Manager Extensions\3.0.7\DB Migration   The error log pointed out which ones tried to run.

When I get a chance I will post the complete list.
 
8
Joe,

Here are the sql files that need to be run from the E10 SQL db server.  I have a call open with Epicor to get this to work automatically like the other conversions.  But by running this scripts I was able to get a conversion done from V9 progress to V10

Tom
9
Forgot to add the details.

 "00CreateLinkedServer"  Modified to below.
 if not exists (select 1 from sys.servers where name = 'SourceLinkServer')
  exec sp_addlinkedserver @server='SourceLinkServer', @srvproduct='', @provider='SQLOLEDB', @datasrc='ProgressSever\SQLInstance', @catalog='TempMigrationDB'
Go
  exec  sp_addlinkedsrvlogin @rmtsrvname = 'SourceLinkServer' , @useself = 'TRUE' 
Go

 "01MigrateICETables"
 "02MigrateICENonSystemData"
 "03InsertE9IceSequences"
 "04UpgradeProcessingOfZData"
 "05UpgradeProcessingOfSecurity"
 "06UpgradeProcessingOfMenu"
 "07MigrateERPTables"
 "08MigrateERPNonSystemData"
 "09MigrateCSFJapan"
 "10InsertE9ErpSequences"
 "11Mobility_UDMigration"
 "12MigrateSugPODtlShortChar05"
 "13MigratePatchFldVendBank"
 "14AEP_UDMigration"
 "15AC_UDMigration"

10
Thanks Tom!





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:b6931c.png@df744517.42947951]
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.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 1:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10: 9.05.702A Progress Database Migration Error Step 500



Forgot to add the details.

"00CreateLinkedServer" Modified to below.
if not exists (select 1 from sys.servers where name = 'SourceLinkServer')
exec sp_addlinkedserver @server='SourceLinkServer', @srvproduct='', @provider='SQLOLEDB', @datasrc='ProgressSever\SQLInstance', @catalog='TempMigrationDB'
Go
exec sp_addlinkedsrvlogin @rmtsrvname = 'SourceLinkServer' , @useself = 'TRUE'
Go

"01MigrateICETables"
"02MigrateICENonSystemData"
"03InsertE9IceSequences"
"04UpgradeProcessingOfZData"
"05UpgradeProcessingOfSecurity"
"06UpgradeProcessingOfMenu"
"07MigrateERPTables"
"08MigrateERPNonSystemData"
"09MigrateCSFJapan"
"10InsertE9ErpSequences"
"11Mobility_UDMigration"
"12MigrateSugPODtlShortChar05"
"13MigratePatchFldVendBank"
"14AEP_UDMigration"
"15AC_UDMigration"




[Non-text portions of this message have been removed]
11
Hi Tom,

So step 500 ran for about 4 hours before erroring out. The error I received is below.
Can I follow the steps you listed at this point?

Starting Execution Phase...
- IceSystemTablesMigration
Error Staging Tables Migration MigrateERPNonSystemData.sql The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.
Execute Phase Complete: 12737.4685643

Starting Cleanup Phase...
- IceSystemTablesMigration
Cleanup Phase: 0.0887892
DB Migration process is cancelled by the user.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:1132da.png@6587473d.4dae076e]
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.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 16, 2014 1:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10: 9.05.702A Progress Database Migration Error Step 500



Forgot to add the details.

"00CreateLinkedServer" Modified to below.
if not exists (select 1 from sys.servers where name = 'SourceLinkServer')
exec sp_addlinkedserver @server='SourceLinkServer', @srvproduct='', @provider='SQLOLEDB', @datasrc='ProgressSever\SQLInstance', @catalog='TempMigrationDB'
Go
exec sp_addlinkedsrvlogin @rmtsrvname = 'SourceLinkServer' , @useself = 'TRUE'
Go

"01MigrateICETables"
"02MigrateICENonSystemData"
"03InsertE9IceSequences"
"04UpgradeProcessingOfZData"
"05UpgradeProcessingOfSecurity"
"06UpgradeProcessingOfMenu"
"07MigrateERPTables"
"08MigrateERPNonSystemData"
"09MigrateCSFJapan"
"10InsertE9ErpSequences"
"11Mobility_UDMigration"
"12MigrateSugPODtlShortChar05"
"13MigratePatchFldVendBank"
"14AEP_UDMigration"
"15AC_UDMigration"




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

I get an error about NT Authority not able to access the database.  But, I would give it a try.  The scripts need to be run from the E10 server.

Tom

13
Thanks Tom.
I'll give it a go.

After I run those scripts, do I just continue the migration process starting with the next step?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:ee7fd8.png@e209f384.48b5ce28]
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.



________________________________
From: vantage@yahoogroups.com [vantage@yahoogroups.com]
Sent: Thursday, September 18, 2014 6:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: E10: 9.05.702A Progress Database Migration Error Step 500



Joe,

I get an error about NT Authority not able to access the database. But, I would give it a try. The scripts need to be run from the E10 server.

Tom





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

Yes after they run, start at the next step.
15
Hi Tom,

When trying to run the second script file (MigrateICETables), I see that there are place holders a few times.
I’m assuming you just updated these in each case.
Also what was the database you ran these under? Meaning USE what DB? I assume it’s my target DB.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:c5a86e.png@e7882504.4b99e6b1]
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.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 19, 2014 9:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: E10: 9.05.702A Progress Database Migration Error Step 500



Joe,

Yes after they run, start at the next step.



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

I put in a 'USE targerdb' at the beginning.

Then I swapped out the variables to match the migration db like this.  'from SourceLinkServer.MIG9.dbo.XFileAttch'

Tom