Catobase problem with team abbreviations - Page 2

sporr · 03-23-2005, 07:21 PM

Odd that this particular problem would affect all of us at about the same time. Do you have any leads on where the corrupt data may be?

Tiger Fan · 03-23-2005, 07:43 PM

This might help find the problem if not the solution. I want back to an older saved Catobase data file from my league (after 1945) from my catobase and then reimported 1946 with no problems at all. However, when I went to import 1947 (the season that first gave me these problems) I had the exact same issue on team abbreviations occurring.

I looked through my Cato access file for the league and found that for whatever reason the teamposchart table did not update for 1946 in both cases. With the original file and with the new test I tried today.

I have no idea why it is not importing as I am doing nothing different and tried it a second time with a backup league file but in both cases it did not add that data.

Sporr, can you check your team pos chart table and see if it did not import the season prior to your current year.

If so, maybe we can manually add the data somehow and solve this issue.

sporr · 03-24-2005, 12:01 AM

I think you may be on to something. My teamposchart table is also not updated for my season. Instead, one team's positional players are listed with a year of '0' instead of 2012 in my case. However, I wonder if there is some other corruption in the program that is leading to this problem. Could it have something to do with the team abbreviation issue in the program? i.e. which problem is causing the other one and which problem is the true root of the trouble?

Tiger Fan · 03-24-2005, 01:12 AM

Yes, there most be something more to it. I tried adding the 1946 data manually into the teamposchart prior to importing 1947 but got the same crash.

QuestGAV · 03-24-2005, 02:13 AM

Did you all just update to OOTP 6.12? Could be a subtle tweak by Markus throwing Catobase all out of whack.

SandMan · 03-24-2005, 07:57 AM

Quote:

Originally Posted by QuestGAV

Did you all just update to OOTP 6.12? Could be a subtle tweak by Markus throwing Catobase all out of whack.

Actually, if it were the case, it would appear that it did not throw CATOBASE off, but perhaps the Exporter that CATOBASE uses to update the CATOBASE MDB file with. If this is the problem, it could be a major issue with a LOT of leagues....

Tiger Fan · 03-24-2005, 09:51 AM

Quote:

Originally Posted by QuestGAV

Did you all just update to OOTP 6.12? Could be a subtle tweak by Markus throwing Catobase all out of whack.

I dont think that would be the issue because it works fine for one of my leagues and not the other. I have simmed both using 6.12

Hammer755 · 03-24-2005, 10:05 AM

Quote:

Originally Posted by Tiger Fan

I dont think that would be the issue because it works fine for one of my leagues and not the other. I have simmed both using 6.12

I've not updated to 6.12 yet, so that's not it.

I noticed that the program first gives me an error when it is trying to read the ltrans.txt file. I'm not sure how that would relate, though, since the ltrans file doesn't use team abbreviations.

SandMan · 03-24-2005, 10:44 AM

Quote:

Originally Posted by Hammer755

I've not updated to 6.12 yet, so that's not it.

I noticed that the program first gives me an error when it is trying to read the ltrans.txt file. I'm not sure how that would relate, though, since the ltrans file doesn't use team abbreviations.

That may be the issue. CATOBASE sometimes will give you an error but the actual problem may be an earlier error. Check you ltrans.txt file for dates that are out of order or players that are retired (r#). I have had issues with the ltrans getting messed up and then I just cut out the bad records and everything worked fine. Usually this is when you have something like this:

6: 6/11

1: some transactions

6: 6/12

1: some transactions

6: 6/11

1: some transactions

Also this happens when a player has more than one transaction on the same day. Multiple trades on the same day will cause problems - and this may give you the abbreviation problem if the system is expecting the games to be played for team 2 and your player is actually now on team 3..... look for these in the file.......

sporr · 04-09-2005, 02:25 AM

Well, I have examined all of these issues and still can't find a solution. For all of us to be having this problem at the same time seems strange. I'm wondering if ANYBODY has been able to use Cato recently without this error. If not, there must be some system issue that is causing this. Or maybe not. I'm just all tapped out of ideas and wish I could figure out how to get it to work.

crackpott · 04-09-2005, 05:24 AM

Quote:

Originally Posted by sporr

Well, I have examined all of these issues and still can't find a solution. For all of us to be having this problem at the same time seems strange. I'm wondering if ANYBODY has been able to use Cato recently without this error. If not, there must be some system issue that is causing this. Or maybe not. I'm just all tapped out of ideas and wish I could figure out how to get it to work.

I've got a whole other error going on.

If I can somehow fix that one, I'll let you know if I get this one too.

Hammer755 · 06-19-2005, 05:51 PM

Guys, I managed to work through the error and get my Cato updated for the year that was choking it!

I did 3 things, but I think the last one was the most important.

1. Removed all cash from trades in the ltrans.txt file - I did this because I had read that the cash part was confusing the program in some cases.

2. I examined the prior year's ltrans file and found that only one item was really different - in the year that I was having problems, waiver claims were showing up 2 different ways. I edited each to read like Example A since that was the way it was done uniformly the year before.
A.) Team X: Claimed Player Y off waivers from Team Z.
B.) Team X: Player Y was claimed off waivers from Team Z.

3. After searching the board and reading this thread, I found one, single, tiny little instance where a player page was being cited as rXXXX instead of pXXXX. I changed the r to p and everything went according to plan. As I said before, I think this is the one that was causing the problems.

sporr · 06-19-2005, 07:30 PM

Thanks for the info. Unfortunately, it didn't seem to fix things for our league. I made all of the suggested corrections, but I still get the abbreviation error followed by the runtime error.

LivnLegend · 06-20-2005, 01:12 AM

Hammer, you are a genius! Thanks for your tireless commitment to this project!
Whatever the USBA is paying you, it's not enough!

Hammer755 · 06-24-2005, 09:20 AM

sporr,

Here's another excellent tip from Sandman.

http://www.ootpdevelopments.com/boar...d.php?t=101655

sporr · 06-25-2005, 05:03 PM

Quote:

Originally Posted by Hammer755

sporr,

Here's another excellent tip from Sandman.

http://www.ootpdevelopments.com/boar...d.php?t=101655

Thanks Hammer I'll check that out.

Hammer755 · 06-27-2005, 02:42 PM

Shane,

Check your e-mail and cross your fingers.

03-23-2005, 07:43 PM	#22
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,873	This might help find the problem if not the solution. I want back to an older saved Catobase data file from my league (after 1945) from my catobase and then reimported 1946 with no problems at all. However, when I went to import 1947 (the season that first gave me these problems) I had the exact same issue on team abbreviations occurring. I looked through my Cato access file for the league and found that for whatever reason the teamposchart table did not update for 1946 in both cases. With the original file and with the new test I tried today. I have no idea why it is not importing as I am doing nothing different and tried it a second time with a backup league file but in both cases it did not add that data. Sporr, can you check your team pos chart table and see if it did not import the season prior to your current year. If so, maybe we can manually add the data somehow and solve this issue. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

03-24-2005, 01:12 AM	#24
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,873	Yes, there most be something more to it. I tried adding the 1946 data manually into the teamposchart prior to importing 1947 but got the same crash. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

06-20-2005, 01:12 AM	#34
LivnLegend Hall Of Famer Join Date: Dec 2001 Location: 100% pure adrenaline! Posts: 5,624	Hammer, you are a genius! Thanks for your tireless commitment to this project! Whatever the USBA is paying you, it's not enough! __________________ Excess ain't rebellion. You're drinking what they're selling.

03-23-2005, 07:21 PM	#21
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Odd that this particular problem would affect all of us at about the same time. Do you have any leads on where the corrupt data may be?

03-24-2005, 12:01 AM	#23
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	I think you may be on to something. My teamposchart table is also not updated for my season. Instead, one team's positional players are listed with a year of '0' instead of 2012 in my case. However, I wonder if there is some other corruption in the program that is leading to this problem. Could it have something to do with the team abbreviation issue in the program? i.e. which problem is causing the other one and which problem is the true root of the trouble?

03-24-2005, 02:13 AM	#25
QuestGAV Hall Of Famer Join Date: Mar 2002 Posts: 2,010	Did you all just update to OOTP 6.12? Could be a subtle tweak by Markus throwing Catobase all out of whack.

04-09-2005, 02:25 AM	#30
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Well, I have examined all of these issues and still can't find a solution. For all of us to be having this problem at the same time seems strange. I'm wondering if ANYBODY has been able to use Cato recently without this error. If not, there must be some system issue that is causing this. Or maybe not. I'm just all tapped out of ideas and wish I could figure out how to get it to work.

06-19-2005, 05:51 PM	#32
Hammer755 Hall Of Famer Join Date: Dec 2001 Location: Houston, TX Posts: 2,348	Guys, I managed to work through the error and get my Cato updated for the year that was choking it! I did 3 things, but I think the last one was the most important. 1. Removed all cash from trades in the ltrans.txt file - I did this because I had read that the cash part was confusing the program in some cases. 2. I examined the prior year's ltrans file and found that only one item was really different - in the year that I was having problems, waiver claims were showing up 2 different ways. I edited each to read like Example A since that was the way it was done uniformly the year before. A.) Team X: Claimed Player Y off waivers from Team Z. B.) Team X: Player Y was claimed off waivers from Team Z. 3. After searching the board and reading this thread, I found one, single, tiny little instance where a player page was being cited as rXXXX instead of pXXXX. I changed the r to p and everything went according to plan. As I said before, I think this is the one that was causing the problems.

06-19-2005, 07:30 PM	#33
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Thanks for the info. Unfortunately, it didn't seem to fix things for our league. I made all of the suggested corrections, but I still get the abbreviation error followed by the runtime error.

06-24-2005, 09:20 AM	#35
Hammer755 Hall Of Famer Join Date: Dec 2001 Location: Houston, TX Posts: 2,348	sporr, Here's another excellent tip from Sandman. http://www.ootpdevelopments.com/boar...d.php?t=101655

06-27-2005, 02:42 PM	#37
Hammer755 Hall Of Famer Join Date: Dec 2001 Location: Houston, TX Posts: 2,348	Shane, Check your e-mail and cross your fingers.