Medisoft 17 update problems
-
- Posts: 1
- Joined: Wed Oct 03, 2012 8:04 pm
Medisoft 17 update problems
- Gavin Walker
- Posts: 4625
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
Re: Medisoft 17 update problems
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386
-
- Posts: 8
- Joined: Sat Nov 09, 2013 4:57 pm
Re: Medisoft 17 update problems
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