Harvest HDBSETUP -UR - Database Error

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

Issue: 

When upgrading Harvest and running HDBSETUP -UR option, one of the following error occurs:

E03020003: Database error [Oracle] [ODBC] [Ora] ORA-00942: table or view does not exist

 or

E03020003: Database error [Oracle] [ODBC] [Ora] ORA-01652: 128 can not extend the temporary segment table space in TEMP.

or

E03020003: Database error [Oracle] [ODBC] [Ora] ORA-00904: "VERSIONOBJID": invalid identifier

 

Environment:  

Harvest 12.x on Windows, UNIX, Linux.

 

Cause: 

These errors indicate that there is not enough space on the Oracle database server.

 

Resolution:

The space issue on the Oracle database server needs to be rectified and the upgrade needs to be re-run. Please investigate the database issue with your DBA. The segments might have reached the higher limit and the DBA needs to extend the table space.