Remind Me To Never Do This Again

Curve Ball Dave · 03-19-2018, 12:04 PM

Got 19 installed!

So I decided to import the league I was running in '18.

Bad idea. Very very bad idea.

The game is doing something called, "Optimize teams transactions table". It's been doing this for well over and hour with no end in sight.

I will never try to import another league. This is ridiculous.

Lukas Berger · 03-19-2018, 12:08 PM

That shouldn't be happening. Must be a bug of some sort, but I haven't run into it before. I'll ping Matt and see if he has any ideas...

BravesChop15 · 03-19-2018, 12:15 PM

I will second this. I'm at 73800 "records done" if that provides any information

Germaniac · 03-19-2018, 12:18 PM

It took a while for me, too, but I'm ready now.

Now I'll try to find out what the game optimized

BravesChop15 · 03-19-2018, 12:19 PM

Quote:

Originally Posted by Germaniac

It took a while for me, too, but I'm ready now.

Now I'll try to find out what the game optimized

About how long did it take?

Matt Arnold · 03-19-2018, 12:22 PM

We moved some text files to a DB structure. I don't think it should have taken very long, but it's possible if you had a really large league that it could.

Andreas Raht · 03-19-2018, 12:23 PM

Yes, that's right- if you have a lot of transaction records in your saved game, it will need a long time. The more, the longer. For hugh leagues, you better let it run overnight.
It will save you ~45% of the transaction records. The database will be smaller and faster.
If your saved games used default settings ("Keep transaction logs for 2 years") you should not have too many transaction records.

Déjà Bru · 03-19-2018, 12:25 PM

Quote:

Originally Posted by Andreas Raht

The database will be smaller and faster.

I'm fine, with this as the tradeoff. Let it run.

Rosco Peabody · 03-19-2018, 12:26 PM

Mine has been running for about three hours now. The thing that takes the longest so far is transferring each year's file. I have one more year to go.

Markus Heinsohn · 03-19-2018, 12:28 PM

Well, 99.999% of computer games don't allow you to transfer saved games from previous versions, so this is the trade-off I guess

Andreas Raht · 03-19-2018, 12:34 PM

If it needs too much time, stop OOTP (kill the process). Your original OOTP 18 saved game will not be damaged because it was copied in the first step. You would just have to start the import again.

Curve Ball Dave · 03-19-2018, 12:36 PM

Quote:

Originally Posted by Andreas Raht

If it needs too much time, stop OOTP (kill the process). Your original OOTP 18 saved game will not be damaged because it was copied in the first step. You would just have to start the import again.

That what I did. I just did a ctl alt del to get it to stop. I'm working on creating a new league. The old league was being imported just to have it, I didn't intend on continuing it.

BravesChop15 · 03-19-2018, 12:38 PM

I'm not complaining at all! Hopefully I did not come off that way. I was curious if it was a bug or not. I am perfectly fine with this trade-off. My game was a default MLB Standard game that had about 3 years under its belt and it took around 45 mins. to get everything transferred. It actually gave me an excuse to step away from my computer and get work done

keeks · 03-19-2018, 12:45 PM

well by using the power of common sense we can deduce that it is doing something with the transaction history and if you have it set to ALL then it obviously would take a while seeing as there would be years and years of every single teams transactions

32koufax · 03-19-2018, 12:52 PM

My transfer from 18 to 19 went quickly. Hope all experiencing issues will be up and running soon!!!

Phatman · 03-19-2018, 04:08 PM

I am having the same issue as C.B Dave, I am converting a long running league. I guess I'll just let it run.

Germaniac · 03-20-2018, 01:32 AM

Quote:

Originally Posted by BravesChop15

About how long did it take?

About 5 minutes, but the league only has been in existence for 2 seasons ...

This was just a try to see how a "real" league shapes up instead of the MLB Quickstart

r0nster · 03-20-2018, 06:27 AM

mine took me 4 hours to move to OOTP19 and had nearly 600,000 Transaction files it was working on then it would say (not responding) once it catches up (I guessing here) then it would be ready to play. As for me I like keeping the player transaction and I have been moving games up since OOTP13. Most years I do the move at night while sleeping and just makes sure laptop doesn't fall asleep when its doing this. Works every time its tried at least for me even with new laptop

zappa1 · 03-20-2018, 07:24 AM

My largest league was a 40 team league in it's 2nd year. Over 100,000 and took about 38 minutes. I timed it after reading what was happening here. Wasn't all that bad for me. My others went way faster. Is there a way to delete those transaction files BEFORE you copy over to 19?

THEMURPH · 03-20-2018, 08:04 AM

My OOTP 18 game (1900 to 1937) is set to keep all records, transactions, news etc.. for my 15 league world. Its been running for 16 hours and still going. Says its optimized 1973460 records as of now.

03-19-2018, 12:04 PM	#1
Curve Ball Dave Hall Of Famer Join Date: Oct 2006 Location: Chicago Posts: 2,393	Remind Me To Never Do This Again Got 19 installed! So I decided to import the league I was running in '18. Bad idea. Very very bad idea. The game is doing something called, "Optimize teams transactions table". It's been doing this for well over and hour with no end in sight. I will never try to import another league. This is ridiculous. __________________ "Hitting is timing. Pitching is upsetting timing"-Warren Spahn.

03-19-2018, 12:08 PM	#2
Lukas Berger OOTP Developments Join Date: Aug 2007 Location: Nice, Côte d'Azur, France Posts: 22,210	That shouldn't be happening. Must be a bug of some sort, but I haven't run into it before. I'll ping Matt and see if he has any ideas... __________________ lukas@ootpdevelopments.com Buy Out of the Park Baseball 27! Need to upload files for us to check out? Instructions can be found here

03-19-2018, 12:15 PM	#3
BravesChop15 Minors (Single A) Join Date: Oct 2015 Posts: 76	I will second this. I'm at 73800 "records done" if that provides any information __________________

03-19-2018, 12:18 PM	#4
Germaniac Hall Of Famer Join Date: Apr 2011 Location: Frankenthal, Germany Posts: 3,092	It took a while for me, too, but I'm ready now. Now I'll try to find out what the game optimized __________________ I'm going to have to meet my Maker some day. And if He asks me why I didn't let this boy play, and I say it's because he's black, that might not be a satisfactory answer. Happy Chandler, 1947

03-19-2018, 12:23 PM	#7
Andreas Raht Administrator Join Date: Jun 2002 Location: Hollern/Stade/Germany Posts: 8,992	Yes, that's right- if you have a lot of transaction records in your saved game, it will need a long time. The more, the longer. For hugh leagues, you better let it run overnight. It will save you ~45% of the transaction records. The database will be smaller and faster. If your saved games used default settings ("Keep transaction logs for 2 years") you should not have too many transaction records. __________________ Andreas Raht andreas@ootpdevelopments.com Out of the Park Developments

03-19-2018, 12:22 PM	#6
Matt Arnold OOTP Developer Join Date: Jun 2009 Location: Here and there Posts: 16,244	We moved some text files to a DB structure. I don't think it should have taken very long, but it's possible if you had a really large league that it could.

03-19-2018, 12:26 PM	#9
Rosco Peabody All Star Starter Join Date: Jun 2013 Location: South of Boston, Massachusetts Posts: 1,092	Mine has been running for about three hours now. The thing that takes the longest so far is transferring each year's file. I have one more year to go.

03-19-2018, 12:28 PM	#10
Markus Heinsohn Developer OOTP Join Date: Dec 2001 Location: Germany Posts: 24,803	Well, 99.999% of computer games don't allow you to transfer saved games from previous versions, so this is the trade-off I guess __________________ Buy Out of the Park Baseball 25 now! Download OOTP Go 25 for iOS Download OOTP Go 25 for Android

03-19-2018, 12:34 PM	#11
Andreas Raht Administrator Join Date: Jun 2002 Location: Hollern/Stade/Germany Posts: 8,992	If it needs too much time, stop OOTP (kill the process). Your original OOTP 18 saved game will not be damaged because it was copied in the first step. You would just have to start the import again. __________________ Andreas Raht andreas@ootpdevelopments.com Out of the Park Developments

03-19-2018, 12:38 PM	#13
BravesChop15 Minors (Single A) Join Date: Oct 2015 Posts: 76	I'm not complaining at all! Hopefully I did not come off that way. I was curious if it was a bug or not. I am perfectly fine with this trade-off. My game was a default MLB Standard game that had about 3 years under its belt and it took around 45 mins. to get everything transferred. It actually gave me an excuse to step away from my computer and get work done __________________

03-19-2018, 12:45 PM	#14
keeks Minors (Single A) Join Date: Mar 2017 Posts: 77	well by using the power of common sense we can deduce that it is doing something with the transaction history and if you have it set to ALL then it obviously would take a while seeing as there would be years and years of every single teams transactions

03-19-2018, 12:52 PM	#15
32koufax Minors (Single A) Join Date: May 2017 Posts: 92	My transfer from 18 to 19 went quickly. Hope all experiencing issues will be up and running soon!!!

03-19-2018, 04:08 PM	#16
Phatman Minors (Double A) Join Date: Jun 2011 Posts: 147	I am having the same issue as C.B Dave, I am converting a long running league. I guess I'll just let it run.

03-20-2018, 06:27 AM	#18
r0nster Hall Of Famer Join Date: May 2006 Location: Michigan Posts: 3,082	mine took me 4 hours to move to OOTP19 and had nearly 600,000 Transaction files it was working on then it would say (not responding) once it catches up (I guessing here) then it would be ready to play. As for me I like keeping the player transaction and I have been moving games up since OOTP13. Most years I do the move at night while sleeping and just makes sure laptop doesn't fall asleep when its doing this. Works every time its tried at least for me even with new laptop

03-20-2018, 07:24 AM	#19
zappa1 Hall Of Famer Join Date: Apr 2012 Location: Pennsylvania Posts: 2,243	My largest league was a 40 team league in it's 2nd year. Over 100,000 and took about 38 minutes. I timed it after reading what was happening here. Wasn't all that bad for me. My others went way faster. Is there a way to delete those transaction files BEFORE you copy over to 19?

03-20-2018, 08:04 AM	#20
THEMURPH Minors (Double A) Join Date: Feb 2015 Location: KANSAS Posts: 127	My OOTP 18 game (1900 to 1937) is set to keep all records, transactions, news etc.. for my 15 league world. Its been running for 16 hours and still going. Says its optimized 1973460 records as of now.