Database dump not fixed?

dimjulskur · 06-14-2006, 12:21 AM

I have attempted to utilize the SQL Dump feature within the database menu and specifically the CSV file option. I have made at least 5 attempts to date... the problem is simple:

When the process kicks off and begins to run through the dump steps. It runs through the first # of steps very quickly (10 seconds), however as soon as it reaches the point where it attempts to save players (37%) the program seems to freeze... now, how do i know this... because the typical answer would be to simply wait because there are quite a bit of players in the league... well, the last two times i have attempted this, I left my PC on overnight and both times the program remained at 37% completed... so this signalled that there was a problem... I am willing to wait for a few hours... but waiting 8+ hours is probably not the intention of the developers for this particular feature... here are the database parameters of the Database File:

Number of Leagues 16
Number of Teams 320
Number of Ballparks 288
Number of Players 32,903
Number of Coaches 3,053
Number of Human Managers 2
Number of Scheduled GAmes 20,397

dimjulskur · 06-15-2006, 08:27 AM

bump....

Raidergoo · 06-15-2006, 10:25 AM

Don't know much about this, but it has been raised . . .a bit loudly by others.

dimjulskur · 06-19-2006, 02:23 PM

Has a TT# been established?

redmarkYankees · 06-21-2006, 08:07 AM

A bump with data... I ran a 16 team league for 110 years, majors/reserves rosters only. At the end of that period, a csv dump failed, also on 37%.

Database Info suggests there are 38,472 players. The players.csv file (1 entry per player only, according to smaller dumps) is 2.04gb, wasn't updated for the last hour or so the dump was supposedly running, and unopenable even in Notepad. Querying it with a vbscript however reveals it to have 4,614,004 lines (119 lines per player - and the dump never completed?).

redmarkYankees · 06-21-2006, 09:58 AM

dola

I don't suppose anyone has a game database which just happens to have slightly less than 32,768 players in it and fancies running a csv export?

dimjulskur · 06-28-2006, 03:37 PM

has anyone tried dumping to the other sql programs and file extensions?

DaveM0 · 07-08-2006, 09:53 AM

I still have the problem with the database dump being stuck exporting players. I have 37k players in my leagues but I thought the patch was supposed to fix this issue?

DaveM0 · 07-08-2006, 08:25 PM

yes? no? anyone know? Not that is that important but I thought that was one of the fixes in this partial patch? Am I not waiting long enough, the players.csv file was 400+MB when I decided to kill the game, shouldn't be that large of a file I wouldn't think.

battists · 07-10-2006, 03:50 PM

DaveM0,

Do you happen to have a specific TT# that you are referring to? I'm having trouble finding this issue in our systems.

Meanwhile, if you don't, can you please describe the issue? Selecting the SQL dump causes your PC to freeze or something? Which SQL dump is it?

Thanks,

Steve

battists · 07-17-2006, 02:05 PM

I'm sorry for the awfully slow response to this thread.

Obviously, some time has passed since you posted this issue, and the 1.0.2 patch has since been released as well. Are you still seeing this issue? I have not been able to reproduce it so far.

Please let me know!

Thanks,

Steve

battists · 07-17-2006, 04:40 PM

Merged a few related threads.

Can someone please indicate if you are still seeing this problem in 1.0.2?

Thanks!

Steve

battists · 07-24-2006, 04:46 PM

This issue has been resolved in the latest patch.

The problem was due to players with a quotation mark (") in a field. The game should allow this now, but if you're still having issues, do a search on your roster file for quotations and erase them out before reimporting.

Thanks!

Steve

06-14-2006, 12:21 AM	#1
dimjulskur Minors (Single A) Join Date: May 2006 Location: Natick, MA Posts: 78	SQL Dump Fails repeatedly I have attempted to utilize the SQL Dump feature within the database menu and specifically the CSV file option. I have made at least 5 attempts to date... the problem is simple: When the process kicks off and begins to run through the dump steps. It runs through the first # of steps very quickly (10 seconds), however as soon as it reaches the point where it attempts to save players (37%) the program seems to freeze... now, how do i know this... because the typical answer would be to simply wait because there are quite a bit of players in the league... well, the last two times i have attempted this, I left my PC on overnight and both times the program remained at 37% completed... so this signalled that there was a problem... I am willing to wait for a few hours... but waiting 8+ hours is probably not the intention of the developers for this particular feature... here are the database parameters of the Database File: Number of Leagues 16 Number of Teams 320 Number of Ballparks 288 Number of Players 32,903 Number of Coaches 3,053 Number of Human Managers 2 Number of Scheduled GAmes 20,397

06-21-2006, 08:07 AM	#5
redmarkYankees All Star Starter Join Date: Nov 2003 Posts: 1,283	A bump with data... I ran a 16 team league for 110 years, majors/reserves rosters only. At the end of that period, a csv dump failed, also on 37%. Database Info suggests there are 38,472 players. The players.csv file (1 entry per player only, according to smaller dumps) is 2.04gb, wasn't updated for the last hour or so the dump was supposedly running, and unopenable even in Notepad. Querying it with a vbscript however reveals it to have 4,614,004 lines (119 lines per player - and the dump never completed?). __________________ In times of universal deceit, telling the truth will be a revolutionary act. George Orwell

06-21-2006, 09:58 AM	#6
redmarkYankees All Star Starter Join Date: Nov 2003 Posts: 1,283	dola I don't suppose anyone has a game database which just happens to have slightly less than 32,768 players in it and fancies running a csv export? __________________ In times of universal deceit, telling the truth will be a revolutionary act. George Orwell

07-08-2006, 09:53 AM	#8
DaveM0 Minors (Single A) Join Date: Apr 2003 Posts: 57	Database dump not fixed? I still have the problem with the database dump being stuck exporting players. I have 37k players in my leagues but I thought the patch was supposed to fix this issue?

06-15-2006, 08:27 AM	#2
dimjulskur Minors (Single A) Join Date: May 2006 Location: Natick, MA Posts: 78	bump....

06-15-2006, 10:25 AM	#3
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,005	Don't know much about this, but it has been raised . . .a bit loudly by others.

06-19-2006, 02:23 PM	#4
dimjulskur Minors (Single A) Join Date: May 2006 Location: Natick, MA Posts: 78	Has a TT# been established?

06-28-2006, 03:37 PM	#7
dimjulskur Minors (Single A) Join Date: May 2006 Location: Natick, MA Posts: 78	has anyone tried dumping to the other sql programs and file extensions?

07-08-2006, 08:25 PM	#9
DaveM0 Minors (Single A) Join Date: Apr 2003 Posts: 57	yes? no? anyone know? Not that is that important but I thought that was one of the fixes in this partial patch? Am I not waiting long enough, the players.csv file was 400+MB when I decided to kill the game, shouldn't be that large of a file I wouldn't think.

07-10-2006, 03:50 PM	#10
battists Hall Of Famer Join Date: Jul 2004 Posts: 18,506	DaveM0, Do you happen to have a specific TT# that you are referring to? I'm having trouble finding this issue in our systems. Meanwhile, if you don't, can you please describe the issue? Selecting the SQL dump causes your PC to freeze or something? Which SQL dump is it? Thanks, Steve

07-17-2006, 02:05 PM	#11
battists Hall Of Famer Join Date: Jul 2004 Posts: 18,506	I'm sorry for the awfully slow response to this thread. Obviously, some time has passed since you posted this issue, and the 1.0.2 patch has since been released as well. Are you still seeing this issue? I have not been able to reproduce it so far. Please let me know! Thanks, Steve

07-17-2006, 04:40 PM	#12
battists Hall Of Famer Join Date: Jul 2004 Posts: 18,506	Merged a few related threads. Can someone please indicate if you are still seeing this problem in 1.0.2? Thanks! Steve

07-24-2006, 04:46 PM	#13
battists Hall Of Famer Join Date: Jul 2004 Posts: 18,506	This issue has been resolved in the latest patch. The problem was due to players with a quotation mark (") in a field. The game should allow this now, but if you're still having issues, do a search on your roster file for quotations and erase them out before reimporting. Thanks! Steve