Scenery
Geoportal Server 1.2.5
SO: Oracle Linux Server 6.5
DB: Oracle 11g
Problem: make the Haversting with others node, when executing the action "Set as Approved" the page remains loading eternally.
I had a problem to run the script for Oracle, within the folder "geoportal-1.2.5/Database Scripts/Oracle". The script "grants_linuxoracle.sh" was perfomed successfuly, however the second script "create_schema_linuxoracle.sh" had problmes to create the INDEXs:
CREATE INDEX GPT_RESOURCE_DATA_IDX1 ON GPT_RESOURCE_DATA(ID);
CREATE INDEX GPT_COLLECTION_IDX1 ON GPT_COLLECTION(SHORTNAME);
The SQL script is attached.
This problem occured because before the line to create each INDEX, were created the tables with the fileds ID and SHORTNAME with the property UNIQUE, that the Oracle create automatically a INDEX for each one.
So, when the script try to create a new INDEX to the same field, we get the error.
To solve this problem I searched for the INDEXs created by Oracle to the fields ID (table GPT_RESOURCE_DATA) and SHORTNAME(table GPT_COLLECTION) and renamed to the correct names: GPT_RESOURCE_DATA_IDX1 and GPT_COLLECTION_IDX1, respectively.
Sorry my English, people!
Erik Lima
Systems Analist
