Database Tuner V609

12.4.0 Beta seems smooth
by beagle - 04/15/2026 4:06 PM

NewCrop
by Bert - 04/15/2026 6:50 AM

Retirement
by dgrauman - 04/09/2026 9:42 PM

My email complaint to AC Support
by Shrinkrap - 04/05/2026 12:12 PM

Ambient Scribes
by ChrisFNP - 03/24/2026 9:27 AM

DCubed
Baltimore

Posts: 679
Joined: February 2011

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