CATO import error

noble · 03-18-2004, 05:14 PM

I am importing my first season into CATO and ran into a few problems. The one I can't get past is
rte '-2147467259 (80004005)'
key column information is insufficient or incorrect. Too many rows were affected by update.

It happens during the "adjusting fields" period of the import.

Anyone ran into this before? I don't even know where to start looking for the key information.

Thanks for any help!

Killebrew · 03-18-2004, 07:00 PM

I have never seen this error before, so let's make sure you are using the right programs & files first.

Did you initially install the 'full' Catobase program (with MDAC and other required files - about a 10 MB install file)?

What version of OOTP are the files you are using coming from?

What version of Catobase are you using?

Are you using the correct CommishJoe CSV Exporter from Jeff Cato's site (www.jcato.net)?

noble · 03-18-2004, 11:50 PM

I installed the full 5.3.1 catobase program. I did not install 4 and then 5 on top. I know I got the MDAC files.

OOTP5 files from "2004" 2 years into the league. I don't have the first 2 years

the exporter is the one from cato's site.

Can I check the players.csv for duplicate entries?

Killebrew · 03-19-2004, 01:29 AM

Quote:

Originally posted by noble
I installed the full 5.3.1 catobase program. I did not install 4 and then 5 on top. I know I got the MDAC files.

OOTP5 files from "2004" 2 years into the league. I don't have the first 2 years

the exporter is the one from cato's site.

Can I check the players.csv for duplicate entries?

Doesn't sound like a dupe record, honestly I've never seen it before

. I've just PMed you about this - if I can find the trouble I'll post the solution in this thread.

SirOrion · 03-19-2004, 02:41 AM

I'm having very nearly the same problem, when I try and edit some of the Options, like where to check for the .csv files and such I get this error:

RTE '-2147217887 (80040e21)':
Multiple-step operation generated errors. Check each status value.

I'm not even trying to import the files, I'm just trying to designate where to get them from. I just downloaded 5.3.1 from Equalnicity.com and installed it. I installed everything, except when I installed it, it said the MDAC file was older than what I currently have so I said not to overwrite.

Killebrew · 03-19-2004, 01:31 PM

Quote:

Originally posted by SirOrion
I'm having very nearly the same problem, when I try and edit some of the Options, like where to check for the .csv files and such I get this error:

RTE '-2147217887 (80040e21)':
Multiple-step operation generated errors. Check each status value.

I'm not even trying to import the files, I'm just trying to designate where to get them from. I just downloaded 5.3.1 from Equalnicity.com and installed it. I installed everything, except when I installed it, it said the MDAC file was older than what I currently have so I said not to overwrite.

This quote in particular: "I'm not even trying to import the files, I'm just trying to designate where to get them from." makes me think that your incomplete install is causing the problem. Perhaps Catobase does not work with the latest version of MDAC. Unless you are doing a lot of DB programming from home I'd suggest uninstalling catobase, then reinstalling and choosing to overwrite the newer MDAC files on your system. It would only take a few seconds to see if this worked - just open Catobase, choose file --> 'new' and see if it will crash when you type in the input boxes of the Catobase options.

Killebrew · 03-19-2004, 01:33 PM

Dola - and note that due to the fact noble is importing already that means your error is different from nobles, just happens to be the same message.

SirOrion · 03-19-2004, 11:53 PM

Okay, I reinstalled it and it seems to work fine. But now when I'm importing I get this message:

There is a problem importing line 2 in the file \league.csv.

Now, I checked it, and I didn't see any weird symbols or anything. So here is a link to my league.csv file...

http://allbaseball.staghost.com/league.csv

noble · 03-20-2004, 11:30 AM

I had that problem, but using the exporter from cato's site fixed it. Have you tried that?

SirOrion · 03-20-2004, 02:23 PM

I use CommishJoe's exporter.

BESTDJINFL · 03-22-2004, 09:45 AM

I too have that same problem and everything looks finr in my csv file

dougaiton · 03-22-2004, 10:05 AM

It's kind of easy to download the wrong version of Commish Joe's Exporter. Make sure you get 5, not 3.1.1. (which is the most intuitive to click).

I know this may sound ridiculous, but this was one of the mistakes I made.

Killebrew · 03-22-2004, 11:30 AM

Quote:

Originally posted by SirOrion
I use CommishJoe's exporter.

You are using the wrong CommishJoe's exporter - download & use the version for OOTP5 from jcato.net . Catobase will not work with the latest BOSI CSV Exporter.

Edit: BTW, I figured this out by running the correct CSV Exporter on your league file, and it did not match the league.csv file you said was erroring out in Catobase. That means the latest BOSI CSV Exporter was used.

Killebrew · 03-22-2004, 11:32 AM

Quote:

Originally posted by BESTDJINFL
I too have that same problem and everything looks finr in my csv file

That means you are using the wrong CSV Exporter as well - download and use the correct Exporter (correct=the one for the version of the OOTP game you are importing) from jcato.net .

noble · 03-22-2004, 11:44 AM

Killebrew thanks for helping me. The problem I had was the MDAC files needed to be overwritten.

I now get the EOF/BOF error on the fielding splits but I can't resolve it. I have placed all free agents with stats on their old teams but still get the error. Any thoughts?

Killebrew · 03-22-2004, 11:57 AM

Quote:

Originally posted by noble
Killebrew thanks for helping me. The problem I had was the MDAC files needed to be overwritten.

I now get the EOF/BOF error on the fielding splits but I can't resolve it. I have placed all free agents with stats on their old teams but still get the error. Any thoughts?

At this point I think it would be best to put in a Catobase ticket at http://www.equalnicity.com (under "Support Tickets"). The reason is that you have worked yourself around a few of the easier-to-find technical problems that were not necessarily the fault of Catobase, but now some unusual player stat or team data is causing Catobase to fail, and the source of these kinds of errors are very difficult to find without stepping through the import process with the uncompiled Catobase application. I was getting this same EOF/BOF error as well, and could not find anything in the MDB database or the OOTP htm/CSV data (I was hoping that I had made a mistake on league start/end dates).

Note for the equalnicity.com ticket file attachment: There is a 1 MB file upload limit for tickets, so in your case I think you'd have to split up your ticket attachment in 2 parts (I think your CSV's and OOTP html added up to more than 1MB). Good luck and feel free to PM me if you have trouble putting in the support ticket.

SirOrion · 03-22-2004, 11:02 PM

I got everything working, but when I go to Create HTML Pages, I get the following message:

Error 94: Invalid use of Null has occured

And then it stops.

dougaiton · 03-23-2004, 05:24 AM

Do you have 'Minor Leagues' off? If so, there are a number of workarounds - do a search on 'Cato Overflow'.

jcato · 03-23-2004, 10:51 AM

The minor league problem should be fixed in 5.3.1, so make sure you're using the latest version.

I've upped the upload limit to 2.5 MB, so enter a support ticket and attach your zipped data files and I'll take a look.

03-18-2004, 05:14 PM	#1
noble Minors (Double A) Join Date: Mar 2004 Location: Alabama Posts: 143	CATO import error I am importing my first season into CATO and ran into a few problems. The one I can't get past is rte '-2147467259 (80004005)' key column information is insufficient or incorrect. Too many rows were affected by update. It happens during the "adjusting fields" period of the import. Anyone ran into this before? I don't even know where to start looking for the key information. Thanks for any help!

03-19-2004, 02:41 AM	#5
SirOrion Minors (Triple A) Join Date: Jul 2003 Location: Portland, Oregon, USA Posts: 263	I'm having very nearly the same problem, when I try and edit some of the Options, like where to check for the .csv files and such I get this error: RTE '-2147217887 (80040e21)': Multiple-step operation generated errors. Check each status value. I'm not even trying to import the files, I'm just trying to designate where to get them from. I just downloaded 5.3.1 from Equalnicity.com and installed it. I installed everything, except when I installed it, it said the MDAC file was older than what I currently have so I said not to overwrite. __________________ I'm not cool enough to have a signature.

03-19-2004, 11:53 PM	#8
SirOrion Minors (Triple A) Join Date: Jul 2003 Location: Portland, Oregon, USA Posts: 263	Okay, I reinstalled it and it seems to work fine. But now when I'm importing I get this message: There is a problem importing line 2 in the file \league.csv. Now, I checked it, and I didn't see any weird symbols or anything. So here is a link to my league.csv file... http://allbaseball.staghost.com/league.csv __________________ I'm not cool enough to have a signature.

03-20-2004, 02:23 PM	#10
SirOrion Minors (Triple A) Join Date: Jul 2003 Location: Portland, Oregon, USA Posts: 263	I use CommishJoe's exporter. __________________ I'm not cool enough to have a signature.

03-22-2004, 09:45 AM	#11
BESTDJINFL Major Leagues Join Date: Oct 2003 Posts: 307	I too have that same problem and everything looks finr in my csv file __________________ The New BARSL Commish

03-18-2004, 07:00 PM	#2
Killebrew Hall Of Famer Join Date: Dec 2001 Posts: 3,326	I have never seen this error before, so let's make sure you are using the right programs & files first. Did you initially install the 'full' Catobase program (with MDAC and other required files - about a 10 MB install file)? What version of OOTP are the files you are using coming from? What version of Catobase are you using? Are you using the correct CommishJoe CSV Exporter from Jeff Cato's site (www.jcato.net)?

03-18-2004, 11:50 PM	#3
noble Minors (Double A) Join Date: Mar 2004 Location: Alabama Posts: 143	I installed the full 5.3.1 catobase program. I did not install 4 and then 5 on top. I know I got the MDAC files. OOTP5 files from "2004" 2 years into the league. I don't have the first 2 years the exporter is the one from cato's site. Can I check the players.csv for duplicate entries?

03-19-2004, 01:33 PM	#7
Killebrew Hall Of Famer Join Date: Dec 2001 Posts: 3,326	Dola - and note that due to the fact noble is importing already that means your error is different from nobles, just happens to be the same message.

03-20-2004, 11:30 AM	#9
noble Minors (Double A) Join Date: Mar 2004 Location: Alabama Posts: 143	I had that problem, but using the exporter from cato's site fixed it. Have you tried that?

03-22-2004, 10:05 AM	#12
dougaiton Hall Of Famer Join Date: Mar 2003 Location: Location: Posts: 3,414	It's kind of easy to download the wrong version of Commish Joe's Exporter. Make sure you get 5, not 3.1.1. (which is the most intuitive to click). I know this may sound ridiculous, but this was one of the mistakes I made. __________________ tThis shower of clowns My park-adjusted, historically split Born in '69 league file! (also at Joe's wonderful site +BBSC)

03-22-2004, 11:44 AM	#15
noble Minors (Double A) Join Date: Mar 2004 Location: Alabama Posts: 143	Killebrew thanks for helping me. The problem I had was the MDAC files needed to be overwritten. I now get the EOF/BOF error on the fielding splits but I can't resolve it. I have placed all free agents with stats on their old teams but still get the error. Any thoughts?

03-22-2004, 11:02 PM	#17
SirOrion Minors (Triple A) Join Date: Jul 2003 Location: Portland, Oregon, USA Posts: 263	I got everything working, but when I go to Create HTML Pages, I get the following message: Error 94: Invalid use of Null has occured And then it stops. __________________ I'm not cool enough to have a signature.

03-23-2004, 05:24 AM	#18
dougaiton Hall Of Famer Join Date: Mar 2003 Location: Location: Posts: 3,414	Do you have 'Minor Leagues' off? If so, there are a number of workarounds - do a search on 'Cato Overflow'. __________________ tThis shower of clowns My park-adjusted, historically split Born in '69 league file! (also at Joe's wonderful site +BBSC)

03-23-2004, 10:51 AM	#19
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	The minor league problem should be fixed in 5.3.1, so make sure you're using the latest version. I've upped the upload limit to 2.5 MB, so enter a support ticket and attach your zipped data files and I'll take a look.