|
|
|
|
|
|
AC 12.4
by JamesNT - 12/17/2025 6:41 PM
|
|
|
Posts: 12,899
Joined: September 2003
|
|
#32979
07/23/2011 5:46 PM
|
Joined: Feb 2010
Posts: 52
Member
|
OP
Member
Joined: Feb 2010
Posts: 52 |
I was trying to update our AC this weekend to 6.09 but when I run the database tuner i get this error message. Conversion failed when converting the nvarchar value 'U' to data type int. Any ideas?
|
|
|
|
|
Joined: Feb 2010
Posts: 52
Member
|
|
OP
Member
Joined: Feb 2010
Posts: 52 |
it seems to stop at 'UpdatedRaceMissingValues'
|
|
|
|
|
Joined: Jun 2009
Posts: 1,811
Member
|
|
Member
Joined: Jun 2009
Posts: 1,811 |
Sounds like the tuner is updating a field definition from a CHAR to an INT - much preferable from a design and performance perspective, but requires a lookup table {parent table} as well as converting existing data.
I wonder if they have mapped U [Unknown?] to an INT in the conversion code ....
|
|
|
|
|
Joined: Feb 2010
Posts: 52
Member
|
|
OP
Member
Joined: Feb 2010
Posts: 52 |
Yeah guess I'll have support take a look at that table to see where it's crashing.
|
|
|
|
0 members (),
534
guests, and
35
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
|
