Medisoft 17 update problems

Posts related Medisoft software.
Post Reply
dr kelly smith
Posts: 1
Joined: Wed Oct 03, 2012 8:04 pm

Medisoft 17 update problems

Post by dr kelly smith » Wed Oct 03, 2012 8:16 pm

I have medisoft 17.1 and the update function stopped working. I updated to 17.33 with the service packs and everything works fine except for report professional. It keeps asking me to register? and it will not let me use the serial number from medisoft 17 that was the original registration (this was an update) What now?

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Medisoft 17 update problems

Post by Gavin Walker » Wed Oct 03, 2012 10:26 pm

If you didn't purchased the Reports Pro addon, then you need to uninstall Reports Pro and then your Medisoft should function normally.
Gavin Walker
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386

aunknown2
Posts: 8
Joined: Sat Nov 09, 2013 4:57 pm

Re: Medisoft 17 update problems

Post by aunknown2 » Sat Nov 09, 2013 7:54 pm

Conversion began at: 11/9/2013 1:47:13 PM
Converting from version v14 SP1 with conversion version: 17.3.3.437

Version 15 Conversion Log

Updating OHAPP Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = HY000; NativeError = 5070; [iAnywhere Solutions][Advantage SQL][ASA] Error 5070: The given data type is not valid for the requested operation. Not a valid logical value. Restructure failed on record 237.
Alter Table OHAPP
Add Column [Cell Phone] Char(13);

Updating OHAPP table failed.
Updating OHAPP Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = S0000; NativeError = 2121; [iAnywhere Solutions][Advantage SQL Engine]Column not found: Cell Phone -- Location of error in the SQL statement is: 42
Update OHAPP Set [Cell Phone] = '' Where [Cell Phone] IS NULL

Updating OHAPP table failed.

Version 16 Conversion Log


Version 17 Conversion Log

Updating OHApp Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = HY000; NativeError = 5070; [iAnywhere Solutions][Advantage SQL][ASA] Error 5070: The given data type is not valid for the requested operation. Not a valid logical value. Restructure failed on record 237.
Alter table ohapp
Add Column [Service Type Code] char(2);

Updating OHApp table failed.

Version 17 SP3 Conversion Log

Updating OHApp Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = HY000; NativeError = 5070; [iAnywhere Solutions][Advantage SQL][ASA] Error 5070: The given data type is not valid for the requested operation. Not a valid logical value. Restructure failed on record 237. ** Script error information: -- Location of error in the SQL statement is: 116 (line: 3 column: 3)
IF NOT EXISTS (SELECT * FROM system.columns
WHERE (PARENT = 'OHAPP' AND NAME = 'RepeatId')) Then
ALTER TABLE OHAPP
ADD COLUMN RepeatID Integer
ADD COLUMN [End Date] Date
ADD COLUMN Unit Char( 8 )
ADD COLUMN Skips Integer
ADD COLUMN Day Char( 14 );
ENDIF;




Updating OHApp table failed.
Conversion had errors.

How can i fix this

Post Reply