Page 1 of 1
Medisoft 17 update problems
Posted: Wed Oct 03, 2012 8:16 pm
by dr kelly smith
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?
Re: Medisoft 17 update problems
Posted: Wed Oct 03, 2012 10:26 pm
by Gavin Walker
If you didn't purchased the Reports Pro addon, then you need to uninstall Reports Pro and then your Medisoft should function normally.
Re: Medisoft 17 update problems
Posted: Sat Nov 09, 2013 7:54 pm
by aunknown2
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