Resolving the problem with INDEX(Oracle) in Geoportal

Document created by eriklimaimg on Mar 25, 2015Last modified by eriklimaimg on Mar 25, 2015
Version 2Show Document
  • View in full screen mode

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

Attachments

Outcomes