Form data not visible after upgrading the SCM database
Article ID: 76862
Updated On:
Products
Issue/Introduction
After upgrading Harvest, and moving the Harvest database to a new server, when we try to open a form for our package, we see an error similar to this:
E0302006d: A form with the object ID 2 no longer exists.
E03080003: Requested Message Key Not Found: E0302006d: A form with the object ID 2 no longer exists.
E0302006d: A form with the object ID 2 no longer exists.
The form opens but we see no data:
Environment
Harvest Software Change Manager v13.x and higher
Cause
Increasing the Harvest logging level to 5 and reproducing the problem shows this error in the HServer log files:
-- BindInteger 1: 2
-- START: 2026-02-02 19:53:27 480 DB Connect#: 6 SINCE LAST SQL: 0
SELECT *
FROM harComment
WHERE FORMOBJID = ?
-- RETURN CODE: DB_FAIL
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'harComment'.
SQLSTATE=S0002
-- END: 2026-02-02 19:53:27 481 **** SQL Milliseconds: 1
-- SQLFreeStmt(SQL_CLOSE)
-- ROLLBACK (usually part of Database connection cleanup)
-- SEND ERROR: HSRV_E_FORM_NOT_EXIST 2
-- SINCE LAST SQL: 0
2026-02-02 19:53:27 481 | End QUERY_FORM TRANSACTION TIME: 3
This error indicates that the form type's data file is missing from the Harvest database.
Investigating the method that was used to move the Harvest database to the new server revealed that the DBA only moved a specific list of tables and indexes. The table for this form type was not included in the list of tables and indexes moved to the new server.
Resolution
When moving the Harvest database to a new server, it is important to move the entire schema for an Oracle database, or the entire database for a SQL Server database. Restoring the missing table from the previous server resolved the problem.
Additional Information
Feedback
