Database Tuner V609

Template check boxes
by It's me - 10/15/2026 11:24 PM

ransomware attack
by It's me - 10/15/2026 6:11 PM

Finding my API
by It's me - 10/15/2026 5:41 PM

SQL server
by JamesNT - 10/12/2026 9:12 AM

ICD-10 codes
by It's me - 10/11/2026 2:32 PM

bmdubu
Tampa

Posts: 34
Joined: August 2010

Print Thread

Rate Thread

Database Tuner V609 #32979 07/23/2011 6:46 PM
Joined: Feb 2010 Posts: 52 NeoMatrix1217 OP Member
OP NeoMatrix1217 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?

Re: Database Tuner V609 NeoMatrix1217 #32980 07/23/2011 7:02 PM
Joined: Feb 2010 Posts: 52 NeoMatrix1217 OP Member
OP NeoMatrix1217 Member Joined: Feb 2010 Posts: 52	it seems to stop at 'UpdatedRaceMissingValues'

Re: Database Tuner V609 NeoMatrix1217 #32989 07/24/2011 1:35 PM
Joined: Jun 2009 Posts: 1,811 Western US Indy Member
Indy Member Joined: Jun 2009 Posts: 1,811 Western US	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 .... Indy "Boss" Indy's Blog www.BestForYourPractice.com Our Name is Our Creed

Re: Database Tuner V609 NeoMatrix1217 #32994 07/24/2011 8:07 PM
Joined: Feb 2010 Posts: 52 NeoMatrix1217 OP Member
OP NeoMatrix1217 Member Joined: Feb 2010 Posts: 52	Yeah guess I'll have support take a look at that table to see where it's crashing.

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Home Forums Discussions Problems Database Tuner V609