Player on two 40-Man Rosters

[JesseTerry]

Hi guys, I'm co-commish of the MLSB and have what seems to be a rare problem.

We're running OOTP 2007, fully patched. Using Nomar's 2007 roster set.

I processed a 1for1 trade between the Cubs and the Pirates, trading Scott Moore straight up for Ronny Paulino. Paulino went to the Cubbies no problem, but Moore decided that he wanted to be on the Pirates 40-man roster and active roster, and ALSO be on the Cubs 40-man roster.

I've tried a few things, like editing him to the Pirates again, cutting and re-signing him, and also retiring and unretiring him, none of which worked.

I believe the NABA Commish had this happen with one of my trades a while ago, but he doesn't remember how he fixed it, but thinks he might have just assigned him to the FA pool, simmed a day, and then reassigned him to the team he went to.

Any and all help appreciated. Thanks in advance!

[Nutlaw]

Did you not import all of your team exports, or perhaps import an older one pre-trade for the Cubs?

Do you have two separate copies of Moore in-game, or does there appear to be only one, but taking up roster space on both teams?

What happens exactly when you try to release him or edit him?

[JesseTerry]

Originally Posted by Nutlaw

Did you not import all of your team exports, or perhaps import an older one pre-trade for the Cubs?

Do you have two separate copies of Moore in-game, or does there appear to be only one, but taking up roster space on both teams?

What happens exactly when you try to release him or edit him?

From what I can tell, I got all team exports, specifically Cubs and Pirates.

When I use the in-game search for Scott Moore, only one comes up, taking roster space on two teams.

When I release him, he goes to the FA pool, comes off of Pittsburgh's 40-man, but still shows up on CHC's, but his league level says: "S. Moore".

[injury log]

This happens any time, when in Commissioner mode, you change a player's team in the Editor, if the player is on a 40-man roster. The player will be removed from (in this example) the Cubs' 25-man, but will stay on the Cubs' 40-man, and also be added to the Pirates' 25 and 40-man. The player is not duplicated; he's only taking up 40-man roster spots on two teams. It's certainly a bug.

It is fixable, though not via the Editor; you can't just reassign the guy to the Pirates, because then he'll still be on the Cubs 40-man. I *think* the following works (at least, if I recall correctly, this is how I eventually was able to fix the problem- I'll check later): in Commish mode, Act As the Cubs. Carry out the trade in reverse. Normal trading correctly clears guys from their old 40-man roster spot and assigns them to their new team, and if I recall correctly, players won't take up two 40-man roster spots on the same 40-man roster. Then you can carry out the trade again, in 'Act As' mode, or release the players first from their original teams before assigning them to new squads via the Editor.

[JesseTerry]

Originally Posted by injury log

This happens any time, when in Commissioner mode, you change a player's team in the Editor, if the player is on a 40-man roster. The player will be removed from (in this example) the Cubs' 25-man, but will stay on the Cubs' 40-man, and also be added to the Pirates' 25 and 40-man. The player is not duplicated; he's only taking up 40-man roster spots on two teams. It's certainly a bug.

It is fixable, though not via the Editor; you can't just reassign the guy to the Pirates, because then he'll still be on the Cubs 40-man. I *think* the following works (at least, if I recall correctly, this is how I eventually was able to fix the problem- I'll check later): in Commish mode, Act As the Cubs. Carry out the trade in reverse. Normal trading correctly clears guys from their old 40-man roster spot and assigns them to their new team, and if I recall correctly, players won't take up two 40-man roster spots on the same 40-man roster. Then you can carry out the trade again, in 'Act As' mode, or release the players first from their original teams before assigning them to new squads via the Editor.

I will try those, but there was no editing of any kind prior to this happening, only the actual processing of the trade.

[JesseTerry]

Ok, that didn't work unfortunately, since we've passed the trade deadline. Any other ideas?

[Nutlaw]

You can't just remove the guy from his phantom team's 40-man roster, then release him? (Maybe edit his contract to a minor league one, then edit it back?)

[JesseTerry]

Originally Posted by Nutlaw

You can't just remove the guy from his phantom team's 40-man roster, then release him? (Maybe edit his contract to a minor league one, then edit it back?)

I can't do anything with him on the Cubs 40-man, except when I'm acting as the Pirates. When I do that, even if I cut him, his (team) column in the transactions thread will read "S.Moore" instead of say, PIT (MLB, ML).

I tried your method, and he still sits on the Cubs 40-man. It's like he's hard-wired to it!

[Tony M]

As you're co-commish I presume you can dump to csv.

If you can, can you find the player in players.csv and note down his player id and then look in team_roster.csv - if you search down the second column (player_id) can you find his player id twice?

[JesseTerry]

Originally Posted by redsoxford

As you're co-commish I presume you can dump to csv.

If you can, can you find the player in players.csv and note down his player id and then look in team_roster.csv - if you search down the second column (player_id) can you find his player id twice?

Yes, in the CSV file, I do find his player ID twice. Oddly, in the CSV file I opened, his name, as well as every other players I think, was in there multiple times. It was also an insanely long scroll-down list of names.

[Tony M]

Originally Posted by JesseTerry

Yes, in the CSV file, I do find his player ID twice. Oddly, in the CSV file I opened, his name, as well as every other players I think, was in there multiple times. It was also an insanely long scroll-down list of names.

A lot of players will appear multiple times in the team_rosters.csv file as their is a roster id which means active, secondary, disabled or all. So somebody on the active roster will appear twice on the same team, but your player should have appeared twice on two teams.

[JesseTerry]

Originally Posted by redsoxford

A lot of players will appear multiple times in the team_rosters.csv file as their is a roster id which means active, secondary, disabled or all. So somebody on the active roster will appear twice on the same team, but your player should have appeared twice on two teams.

The team ID # was the same in all instances. I've also been notified that this is happening with two other players who had been traded and are now on both teams 40-man rosters.

[Tony M]

Originally Posted by JesseTerry

The team ID # was the same in all instances. I've also been notified that this is happening with two other players who had been traded and are now on both teams 40-man rosters.

So he wasn't listed against two teams then? That's thrown a spanner in where I was thinking the problem lay.

A player can only have one team/organisation listed against them as a current place, but the cross-reference information also appears in the team record which is where I thought the problem was. So either the csv isn't directly derived from teams.dat or there's another location for it.

[Tony M]

Having looked at the relevant csv's both players are on the correct team for all, active and secondary rosters, but have a phantom entry for their old clubs' secondary roster.

It's hard to reproduce this bug, but I think it can be fixed with a deft bit of database editing.

[JesseTerry]

Well, I'm definitely a layman in that regard, so any and all help is appreciated.

[Tony M]

Originally Posted by JesseTerry

Well, I'm definitely a layman in that regard, so any and all help is appreciated.

I think what I've just sent back to you should fix that problem.

[JesseTerry]

As far as I know, it worked. There are no Burke's or Moore's on incorrect rosters anymore. I'll make sure it sticks after an import when those teams export, (It should I would think).

Thanks for all help on this!

[JesseTerry]

It stuck, everything back to normal. Thanks for all that gave input and helped!

[Tony M]

Originally Posted by JesseTerry

It stuck, everything back to normal. Thanks for all that gave input and helped!

Excellent, glad it's sorted, but it's still something that we need to work out how it happened in the first place.

[Nutlaw]

Originally Posted by redsoxford

Excellent, glad it's sorted, but it's still something that we need to work out how it happened in the first place.

Something you want to discuss further here, or should I close this out?