Conversion from v12 to v20 problems
Posted: Fri May 29, 2015 2:05 pm
I am trying to convert the v12 MediData to v20. I have tried clearing out appointments with repeat days but still get the following errors:
Conversion began at: 5/29/2015 12:40:33 PM
Converting from version v12 with conversion version: 20.0.2.68
Version 14 Conversion Log
Version 14 SP1 Conversion Log
Version 15 Conversion Log
Version 16 Conversion Log
Version 17 Conversion Log
Version 18 Conversion Log
Updating OHAPP Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = HY000; NativeError = 5132; [iAnywhere Solutions][Advantage SQL][ASA] Error 5132: The specified database object name is not valid. The specified field is not part of the table.
EXECUTE PROCEDURE sp_ModifyFieldProperty ( 'OHAPP',
'RepeatID', 'Field_Default_Value',
'0', 'APPEND_FAIL', 'OHAPPfail' );
Updating OHAPP table failed.
Updating OHRPTOLD Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = HY000; NativeError = 5132; [iAnywhere Solutions][Advantage SQL][ASA] Error 5132: The specified database object name is not valid. The trigger is not part of the database. ** Script error information: -- Location of error in the SQL statement is: 106 (line: 3 column: 12)
IF EXISTS (SELECT * FROM system.triggers
WHERE (NAME = 'OHRPTUPDATE_AUDIT')) Then
DROP TRIGGER OHRPTOLD.OHRPTUPDATE_AUDIT;
ENDIF;
IF EXISTS (SELECT * FROM system.triggers
WHERE (NAME = 'OHRPTDELETE_AUDIT')) Then
DROP TRIGGER OHRPTOLD.OHRPTDELETE_AUDIT;
ENDIF;
IF EXISTS (SELECT * FROM system.triggers
WHERE (NAME = 'OHRPTINSERT_AUDIT')) Then
DROP TRIGGER OHRPTOLD.OHRPTINSERT_AUDIT;
ENDIF;
Updating OHRPTOLD table failed.
Conversion had errors.
Conversion finished at: 5/29/2015 12:52:53 PM
----------------------------------------------------------------------------------
Any help on converting v12sp2 data to v20 would be appreciated. I assume there is a few steps in the conversion process I am missing. Is assume based on the first error there is a table that is in v12 OH data that is not in newer versions. I just do not know what data to remove so the conversion will complete.
Conversion began at: 5/29/2015 12:40:33 PM
Converting from version v12 with conversion version: 20.0.2.68
Version 14 Conversion Log
Version 14 SP1 Conversion Log
Version 15 Conversion Log
Version 16 Conversion Log
Version 17 Conversion Log
Version 18 Conversion Log
Updating OHAPP Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = HY000; NativeError = 5132; [iAnywhere Solutions][Advantage SQL][ASA] Error 5132: The specified database object name is not valid. The specified field is not part of the table.
EXECUTE PROCEDURE sp_ModifyFieldProperty ( 'OHAPP',
'RepeatID', 'Field_Default_Value',
'0', 'APPEND_FAIL', 'OHAPPfail' );
Updating OHAPP table failed.
Updating OHRPTOLD Table had an error.
EADSDatabaseError: cpQryConvert: Error 7200: AQE Error: State = HY000; NativeError = 5132; [iAnywhere Solutions][Advantage SQL][ASA] Error 5132: The specified database object name is not valid. The trigger is not part of the database. ** Script error information: -- Location of error in the SQL statement is: 106 (line: 3 column: 12)
IF EXISTS (SELECT * FROM system.triggers
WHERE (NAME = 'OHRPTUPDATE_AUDIT')) Then
DROP TRIGGER OHRPTOLD.OHRPTUPDATE_AUDIT;
ENDIF;
IF EXISTS (SELECT * FROM system.triggers
WHERE (NAME = 'OHRPTDELETE_AUDIT')) Then
DROP TRIGGER OHRPTOLD.OHRPTDELETE_AUDIT;
ENDIF;
IF EXISTS (SELECT * FROM system.triggers
WHERE (NAME = 'OHRPTINSERT_AUDIT')) Then
DROP TRIGGER OHRPTOLD.OHRPTINSERT_AUDIT;
ENDIF;
Updating OHRPTOLD table failed.
Conversion had errors.
Conversion finished at: 5/29/2015 12:52:53 PM
----------------------------------------------------------------------------------
Any help on converting v12sp2 data to v20 would be appreciated. I assume there is a few steps in the conversion process I am missing. Is assume based on the first error there is a table that is in v12 OH data that is not in newer versions. I just do not know what data to remove so the conversion will complete.