I have a geoportal 9.3.1 installation, with a year's worth of metadata loaded. Now I've installed geoportal 10 and I tried to use the Migration tool to move the data across. I get this error message:
========== Migration Status =========
Data Migration Started at =2011-03-22 18:11:20
Migrating user table data...
0 records migrated from user table
Migrating Harvesting_History table data...
0 records migrated from harvesting_history table
Migrating Search table data...
0 records migrated from search table
Migrating Harvesting table data...
Error occured while migrating data to GPT_harvesting table. ORA-00942: table or view does not exist
0 records migrated from harvesting table
Migrating admin and Metadata table data...
Error occured while migrating data to GPT_resource and GPT_resource_data table. ORA-00942: table or view does not exist
0 records migrated from admin and metadata table
========== Migration Summary =========
Total metadata record migrated =0
Total search table record migrated =0
Total user table record migrated =0
Data Migration Completed at =2011-03-22 18:11:20
The 9.3.1 installation has a GPT_Harvesting table. It does not have the GPT_resource and GPT_resource_data tables.
The 10 installation has a GPT_Harvesting table. It does not have the GPT_resource and GPT_resource_data tables.
Can anyone help me decipher the meaning of this message?
Bonus question: The Migration tool makes a distinction betrween Geoportal 9.3.1 and 9.3.1 SP1. This installation has had a number of players involved over the last year so I don't know which one I have.
Can anyone tell me how to know whether I have 9.3.1 SP 1 installed?
TIA,
Jim Dickerson
