Most Recent Posts
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
NewCrop
by Naeem - 03/18/2026 10:38 AM
Searches
by Bert - 03/18/2026 7:39 AM
Missing Photographs
by Bert - 03/18/2026 7:34 AM
R codes -- answers for billers and coders
by Bert - 03/18/2026 7:31 AM
Member Spotlight
barcafan1990
barcafan1990
Brandon, FL
Posts: 272
Joined: June 2012
Newest Members
Lisawilliam, Denton13173, BPeds, PMG Care, KeepingItAnon
4,609 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#32979 07/23/2011 6:46 PM
Joined: Feb 2010
Posts: 52
Member
OP Offline
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 Offline
Member
Joined: Feb 2010
Posts: 52
it seems to stop at 'UpdatedRaceMissingValues'

Joined: Jun 2009
Posts: 1,811
Member
Offline
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 ....


Indy
"Boss"

Indy's Blog

www.BestForYourPractice.com
Our Name is Our Creed
Joined: Feb 2010
Posts: 52
Member
OP Offline
Member
Joined: Feb 2010
Posts: 52
Yeah guess I'll have support take a look at that table to see where it's crashing.


Moderated by  ChrisFNP, DocGene, JBS, Wendell365 

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 166 guests, and 27 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
Bert 5
Naeem 1
Top Posters
Bert 12,904
JBS 3,002
Wendell365 2,370
Sandeep 2,316
ryanjo 2,084
Leslie 2,002
Wayne 1,889
This board is dedicated to the memory of Michael "Indy" Astleford. February 6, 1961 -- April 16, 2019




SiteLock
Powered by UBB.threads™ PHP Forum Software 7.7.5