Error 'One or more entries are found in HSS_COMPONENT table'

This post title is an error we are getting when are trying to install BI 11g system. How to resolve this error and can continue my Installation???

Reason:

When we are running RCU It will create two schemas called BIPLATFORM, MDS. This schemas are having all the necessary tables to run BI 11G system. So whenever we are installing BI 11g system It will make an entry in the HSS_COMPONENT table in BIPLATFORM Schema. 

But for any reasons you have uninstalled BI 11g system and trying to install again in the same machine with the same RCU schema which we already installed then we are getting this error.

Assumption:

There are number of assumptions I am getting from various links and site. In all the links I have referred are saying to delete RCU schemas and its related tablespaces from oracle database system and are telling to install it again.

Solution:

But there is no need to delete/uninstall RCU schemas. We can continue BI 11G installation again with the same schema which we have already installed.

Here is workaround:

Login into SQLPLUS and connect BIPLATFORM Schema with the same credentials which we have given when we installed.

syntax: conn BIPLATFORM/password@connectionstring

SQL> conn DEV_BIPLATFORM/Admin123@orcl

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;
One entry 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.

Note:

Do not forget to 'COMMIT' once we deleted the entry from HSS_COMPONENT table. because 'DELETE' command will not be updated without commit.

Happy Blogging,

Bose