Catobase problem with team abbreviations

sporr · 03-19-2005, 07:48 PM

I have successfully used Catobase for 11 seasons in Baseball Maelstrom. However, when trying to update season 12 I'm getting an error that I've never gotten before. When the program is importing the ltrans file (or maybe immediately after) I get an error message:

"The following team abbreviations are new from last year. However, they exist for earlier years. This is probably not correct. You can either change them now or not"

The problem is that I have never changed the team abbreviations for the league and never received such an error when updating Cato for last year.

This is followed shortly after when the Master Data is being updated with:

"Run-time error '-2147467259 (80004005)':

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship..."

Anyone have any clue to how to fix these problems?

plannine · 03-19-2005, 08:13 PM

I had the same message yesterday.....what i found (on my system) that the files being imported were corupted. I had to redo the season in 00tP and then it imported correctly.

[note: i also had catobase backed up, deleted the existing and restored it from the backup copy - i didnt try re-importing, and maybe i should have at this point]

sporr · 03-19-2005, 09:27 PM

Quote:

Originally Posted by plannine

I had the same message yesterday.....what i found (on my system) that the files being imported were corupted. I had to redo the season in 00tP and then it imported correctly.
(mine was in my 25th season replay, 1926). I've plan to backup every 5th year just in case it happens again or it really isnt fixed.

Well that bites. Since it's an online league I can't really redo the season.

Looks like that's the end of Cato for the league.

Malleus Dei · 03-19-2005, 10:03 PM

Sorry, Sporr, it sucks when that happens.

The Five Golden Rules of Backing Up

1. That which has not been backed up cannot be recovered.
2. That which has not been backed up offsite will not survive the fire.
3. That which that has not been tested with a recovery is not yet a backup.
4. Backup plans which aren't a priority result in backup failures.
5. Back it up now or give it up later.

endgame · 03-20-2005, 09:36 PM

Sporr, you didn't surrender yet to that Cato problem did you? Or are you convinced there's just no going back? Granted, I'm no expert but if it's ltrans related there may have simply been some text in there gone awry. I'd take a long hard look before you give up on it. Maybe Horn can lend a hand. He seems to always find a way out of the dark and the deep.

Tiger Fan · 03-20-2005, 10:16 PM

Sporr. I am just now having the exact same problem. No issues at all through 46 seasons of my league but now at the end of 1947 getting the same team abbreviation issue.

I will keep tinkering with things and let you know if I find a solution. Please do the same.

Btw, I tried again with a backup file and had the same issue.

sporr · 03-20-2005, 10:38 PM

Yeah, I'm not going to give up on it yet. Unfortunately, I just have no idea where to look to see what could be causing it.

Tiger Fan · 03-20-2005, 11:27 PM

Me neither. All my team abbreviations are unchanged.

I did switch from version 6.12 I believe to the latest version - 6.13 but I thought I did so prior to running 1946 without any issues.

endgame · 03-20-2005, 11:45 PM

Quote:

Originally Posted by Tiger Fan

Me neither. All my team abbreviations are unchanged.

I did switch from version 6.12 I believe to the latest version - 6.13 but I thought I did so prior to running 1946 without any issues.

It's just too strange that both of you, this close in time, would be experiencing the same problem. There must be some commonality that might correlate with a causal change. I'm thinking back to when I first installed Cato, and that was an attempt with 6.0 or such .... don't remember the exact version. When I finally succeeded in installing 6.14, and after about three trials overcoming other sorts of problems with it, I ran into a snag wherein I had to go back to my teams --- and even though nothing had changed within those teams --- the workaround that version required was that all of my teams had to have an equal number of letters in the abbreviation. One team even had to be renamed to its original abbreviation - that's right, I deleted the three-letter abbreviation and put the same one right back in. But in the end, all my teams had three-letter abbreviations and everything finally went smoothly and completely without error.

Just some thoughts. Maybe one of them will get to another that will get us somewhere besides stuck. Good luck guys.

<o> · 03-21-2005, 12:59 AM

Had the very same thing happen to me when I was doing my history of baseball. I just gave up using Cato because i couldn't figure out the problem. Oh well.

Aordolin · 03-21-2005, 08:39 AM

happened to me too after about 2 months of dicking around in csv files and trying to find a way to import the season I gave up and resimmed that year after which it worked. I tried sending Cato a trouble ticket on his website but he never responded now that hes disappeared and his website as gone poof I guess we are SOL.

Hammer755 · 03-21-2005, 10:27 AM

Quote:

Originally Posted by endgame

It's just too strange that both of you, this close in time, would be experiencing the same problem. There must be some commonality that might correlate with a causal change. I'm thinking back to when I first installed Cato, and that was an attempt with 6.0 or such .... don't remember the exact version. When I finally succeeded in installing 6.14, and after about three trials overcoming other sorts of problems with it, I ran into a snag wherein I had to go back to my teams --- and even though nothing had changed within those teams --- the workaround that version required was that all of my teams had to have an equal number of letters in the abbreviation. One team even had to be renamed to its original abbreviation - that's right, I deleted the three-letter abbreviation and put the same one right back in. But in the end, all my teams had three-letter abbreviations and everything finally went smoothly and completely without error.

Just some thoughts. Maybe one of them will get to another that will get us somewhere besides stuck. Good luck guys.

I also hit this bug for the first time yesterday trying to update the Cato for the 12th season of the USBA. I agree that it is an odd coincidence that it has seemingly popped up out of nowhere for several people.

Has anybody tried re-importing the prior season then moving on to the current one that gave the error?

DaveHorn · 03-21-2005, 12:11 PM

Its almost as if a Microsoft update than many of you recently received contained an update to one of the DAO components or something and this new component is not compatible with CATO.

Tiger Fan · 03-21-2005, 12:52 PM

Quote:

Originally Posted by DaveHorn

Its almost as if a Microsoft update than many of you recently received contained an update to one of the DAO components or something and this new component is not compatible with CATO.

I was thinking maybe you were on to something but I just ran Catobase with a new league I created and had no issues. However, still the same problem for my main league.

Hammer755 · 03-21-2005, 12:56 PM

Quote:

Originally Posted by Tiger Fan

I was thinking maybe you were on to something but I just ran Catobase with a new league I created and had no issues. However, still the same problem for my main league.

I just got a new computer, so I thought maybe you were on to something. Then I realized that, like TF, I've run the Catobase on a solo league since I've had the new machine.

DaveHorn · 03-21-2005, 01:57 PM

Weird. Well I'm out of ideas.

Tiger Fan · 03-21-2005, 02:25 PM

The windows update issue idea may still have merit.

I had the 1946 season and league files on cdrom after switching from my old cpu to a new one. I reran it with the exact same version of catobase (6.1) and the exact same files as worked successfully on my old computer back in August. The result was the same team issue as reported above.

Could it be that I had no trouble with my fictional league because it was started just a few weeks ago (perhaps after whatever Microsoft update changed things?)

sporr · 03-21-2005, 06:41 PM

Quote:

Originally Posted by Tiger Fan

The windows update issue idea may still have merit.

I had the 1946 season and league files on cdrom after switching from my old cpu to a new one. I reran it with the exact same version of catobase (6.1) and the exact same files as worked successfully on my old computer back in August. The result was the same team issue as reported above.

Could it be that I had no trouble with my fictional league because it was started just a few weeks ago (perhaps after whatever Microsoft update changed things?)

I might think you were right, but I haven't updated any Microsoft components in a LONG time.

sporr · 03-21-2005, 10:12 PM

Come to think of it, I have disabled some items that automatically startup with Windows recently...

Hammer755 · 03-23-2005, 01:10 AM

For those interested: I hate to say it, but it seems to be a corrupted data problem, as plannine indicated. After failing to incorporate 1996 into the historical Catobase, I tried to run that year as a standalone, and it wouldn't work. I then did the same thing with the previous year, 1995, and it worked perfectly, which rules out any OS problems. Some piece of data in the 1996 file seems to be causing the problem.

03-19-2005, 07:48 PM	#1
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Catobase problem with team abbreviations I have successfully used Catobase for 11 seasons in Baseball Maelstrom. However, when trying to update season 12 I'm getting an error that I've never gotten before. When the program is importing the ltrans file (or maybe immediately after) I get an error message: "The following team abbreviations are new from last year. However, they exist for earlier years. This is probably not correct. You can either change them now or not" The problem is that I have never changed the team abbreviations for the league and never received such an error when updating Cato for last year. This is followed shortly after when the Master Data is being updated with: "Run-time error '-2147467259 (80004005)': The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship..." Anyone have any clue to how to fix these problems?

03-19-2005, 08:13 PM	#2
plannine All Star Reserve Join Date: Mar 2003 Location: Michigan Posts: 572	I had the same message yesterday.....what i found (on my system) that the files being imported were corupted. I had to redo the season in 00tP and then it imported correctly. [note: i also had catobase backed up, deleted the existing and restored it from the backup copy - i didnt try re-importing, and maybe i should have at this point] Last edited by plannine; 03-20-2005 at 10:50 PM.

03-20-2005, 09:36 PM	#5
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,842	Sporr, you didn't surrender yet to that Cato problem did you? Or are you convinced there's just no going back? Granted, I'm no expert but if it's ltrans related there may have simply been some text in there gone awry. I'd take a long hard look before you give up on it. Maybe Horn can lend a hand. He seems to always find a way out of the dark and the deep. __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

03-20-2005, 10:16 PM	#6
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,873	Sporr. I am just now having the exact same problem. No issues at all through 46 seasons of my league but now at the end of 1947 getting the same team abbreviation issue. I will keep tinkering with things and let you know if I find a solution. Please do the same. Btw, I tried again with a backup file and had the same issue. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

03-20-2005, 11:27 PM	#8
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,873	Me neither. All my team abbreviations are unchanged. I did switch from version 6.12 I believe to the latest version - 6.13 but I thought I did so prior to running 1946 without any issues. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

03-20-2005, 10:38 PM	#7
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Yeah, I'm not going to give up on it yet. Unfortunately, I just have no idea where to look to see what could be causing it.

03-21-2005, 08:39 AM	#11
Aordolin All Star Reserve Join Date: Apr 2004 Location: Houston, TX Posts: 586	happened to me too after about 2 months of dicking around in csv files and trying to find a way to import the season I gave up and resimmed that year after which it worked. I tried sending Cato a trouble ticket on his website but he never responded now that hes disappeared and his website as gone poof I guess we are SOL.

03-21-2005, 12:11 PM	#13
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Its almost as if a Microsoft update than many of you recently received contained an update to one of the DAO components or something and this new component is not compatible with CATO. __________________ Dave HFTC Commish

03-21-2005, 01:57 PM	#16
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Weird. Well I'm out of ideas. __________________ Dave HFTC Commish

03-21-2005, 02:25 PM	#17
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,873	The windows update issue idea may still have merit. I had the 1946 season and league files on cdrom after switching from my old cpu to a new one. I reran it with the exact same version of catobase (6.1) and the exact same files as worked successfully on my old computer back in August. The result was the same team issue as reported above. Could it be that I had no trouble with my fictional league because it was started just a few weeks ago (perhaps after whatever Microsoft update changed things?) __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

03-21-2005, 10:12 PM	#19
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Come to think of it, I have disabled some items that automatically startup with Windows recently...

03-23-2005, 01:10 AM	#20
Hammer755 Hall Of Famer Join Date: Dec 2001 Location: Houston, TX Posts: 2,348	For those interested: I hate to say it, but it seems to be a corrupted data problem, as plannine indicated. After failing to incorporate 1996 into the historical Catobase, I tried to run that year as a standalone, and it wouldn't work. I then did the same thing with the previous year, 1995, and it worked perfectly, which rules out any OS problems. Some piece of data in the 1996 file seems to be causing the problem. Last edited by Hammer755; 03-23-2005 at 01:15 AM.