OBIEE 11g Installation error : One or more entries are found in HSS_COMPONENT table

 

Oct24by Gaurav Chaudhary

Issue:
While installing OBIEE 11g in a system where OBIEE was previously installed, then uninstalled for any reasons with the same RCU schema, then we got this error. One or more entries are found in HSS_COMPONENT table
Cause:
While installing RCU, two RCU schemas are created BIPLATFORM,MDS. These schemas contain all the configuration tables. OBIEE 11g installation always inserts some data in HSS_COMPONET table. As the data is already present for the previous installation , it is showing this error.
Resolution:
There is no need to delete/uninstall RCU schemas. We can continue OBIEE 11g installation again with the same schema which we have already installed.
Step 1:
Login into SQLPLUS and connect BIPLATFORM Schema with the same credentials which we have given when we installed.
SQL> conn DEV_BIPLATFORM/password@connection_string
Step 2:
Once we connected with BIPLATFORM Schema delete the entry which is available in the HSS_COMPONENT table and commit the table.
SQL> DELETE FROM HSS_COMPONENT;
7-8 entries will deleted.
SQL> COMMIT;
Commit Complete;

Now start the installation and give the BIPLATFORM AND MDS schema details in its related steps. The error will no more exist.

N.B.: Do not forget to ‘COMMIT’ once we deleted the entry from HSS_COMPONENT table because ‘DELETE’ command will not be updated without commit.