Upgrading from 7.0 to 12.1 fails with ORA-01017 part way through

Document ID : KB000050268
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When using the hdbsetup UR option to upgrade the repository from Harvest 7.0 to SCM 12.1 it fails part way through. The updateschema.log file shows the following information at the end:

INDEX HARLINKEDPROCESS_POBJID ON HARLINKEDPROCESS (PROCESSOBJID) CREATED
INDEX HARSTATE_ENVOBJID ON HARSTATE (ENVOBJID) CREATED
Upgrade to R7.1 Complete
PL/SQL procedure successfully completed.
ERROR:
ORA-01017: invalid username/password; logon denied

Solution:

When upgrading the repository from 7.0 to 12.1 using the hdbsetup UR option the upgrade is performed in two separate phases. The first phase from 7.0 to 7.1 uses a sql script and the second phase from 7.1 to 12.x uses the hserver executable internal upgrade feature.

These different phases use separate database connections and it has been seen in some situations that after the first phase has completed it fails to connect correctly to begin the second phase.

In this situation as long as the updateschema.log shows the following sequence:

...
PL/SQL procedure successfully completed.
Upgrade to R7.1 ...
...
..
Upgrade to R7.1 Complete
PL/SQL procedure successfully completed.
ERROR:
ORA-01017: invalid username/password; logon denied

Then the solution is simply to close hdbsetup and then restart it and select the UR option again. It will then continue the upgrade from the second phase.