Error Loading Migrated r11 Extract to a New r11 Install
To discuss or ask questions about this article, select the discussion tab above.
Overview
Running a pdm_load of data coming from a migrated 6.x->r11.x system could pose problems. In particular, a problem will occur if the extracted data was obtained via the pdm_extract All command
In a migrated installation, the Computer_Extension and Software_Extension tables exist from earlier releases of Service Desk. In r11.x these tables no longer exist and are not included in a fresh installation. While running the pdm_load, the following error will appear:
** EXIT: Invalid table name : Computer_Extension : Correct table name and rerun from error point.
Procedures
The easiest solution is to have a DBA do a direct database to database move of data. But if a pdm_load is your only realistic solution, then here's how you proceed.
- Run your pdm_load until it fails.
- Download a third party file splitter such as MaxSplitter.
- Break the text file into manageable pieces
- Search the pieces for TABLE Computer_Extension.
- Delete the Computer_Extension section and everything that has already been loaded.
- User the file splitter to piece the remaining pieces back together.
- Run the pdm_load on your newly compiled file until it fails again.
- Use your file splitter to break the file into manageable pieces again.
- Search the pieces for TABLE Software_Extension.
- Delete the Sofware_Extension section and everything that has already been loaded.
- User the file splitter to piece the remaining pieces back together.
- Run the pdm_load on your newly compiled file.
Currently there is no solution provided by CA. But I don't see how having the load stop if a table is missing is acceptable behavior. In my opinion an error log should be created, but the load should continue (as it does when a column is missing)
