Most Recent Posts
I won't get help because I am I
by JBS - 04/18/2025 10:53 PM
AC Version 12.3
by ChrisFNP - 04/15/2025 10:22 AM
An automated process failed: MedsUdates
by ChrisFNP - 04/15/2025 10:12 AM
New Feature?
by ChrisFNP - 04/11/2025 11:41 AM
Pharmacy Request Counter Issues
by Headcase - 04/08/2025 7:04 PM
phantom printer
by imcffp - 04/08/2025 10:26 AM
AC v12 mandatory upgrade
by ChrisFNP - 04/01/2025 9:47 AM
Calculating sigs for Peds and FP
by Wendell365 - 03/28/2025 12:59 PM
Member Spotlight
koby
koby
Canaan CT
Posts: 835
Joined: May 2009
Newest Members
It's me, Paradise Family, MedCode, MZ Medical Billi, girlfromwebpage
4,593 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 (), 112 guests, and 24 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
ffac 6
imcffp 5
JBS 3
koby 3
beagle 2
tcosta 2
Top Posters
Bert 12,872
JBS 2,982
Wendell365 2,363
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