Conversion from v12 to v20 problems
-
- Posts: 42
- Joined: Fri May 29, 2015 1:50 pm
Conversion from v12 to v20 problems
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.
-
- Posts: 153
- Joined: Tue Mar 19, 2013 3:24 pm
- Location: Springfield, MO
- Contact:
Re: Conversion from v12 to v20 problems
Support Team
MedTech Medical Management Systems
3058 S Delaware Ave
Springfield, MO 65804
Ph: 417.890.6777 | Fax: 417.890.6788
-
- Posts: 42
- Joined: Fri May 29, 2015 1:50 pm
Re: Conversion from v12 to v20 problems
-
- Posts: 153
- Joined: Tue Mar 19, 2013 3:24 pm
- Location: Springfield, MO
- Contact:
Re: Conversion from v12 to v20 problems
Support Team
MedTech Medical Management Systems
3058 S Delaware Ave
Springfield, MO 65804
Ph: 417.890.6777 | Fax: 417.890.6788
-
- Posts: 42
- Joined: Fri May 29, 2015 1:50 pm
Re: Conversion from v12 to v20 problems
Lastly, is it necessary to perform the Audit Records conversion?
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
Re: Conversion from v12 to v20 problems
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386
-
- Posts: 12
- Joined: Wed Jul 20, 2016 2:29 pm
Re: Conversion from v12 to v20 problems
-
- Posts: 153
- Joined: Tue Mar 19, 2013 3:24 pm
- Location: Springfield, MO
- Contact:
Re: Conversion from v12 to v20 problems
Support Team
MedTech Medical Management Systems
3058 S Delaware Ave
Springfield, MO 65804
Ph: 417.890.6777 | Fax: 417.890.6788
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
Re: Conversion from v12 to v20 problems
-
- Posts: 12
- Joined: Wed Jul 20, 2016 2:29 pm
Re: Conversion from v12 to v20 problems
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact: