database error when posting an eligibility transaction
Has anyone encountered issues upgrading to 2021.1? The issue we are having is related to a database error when posting an eligibility transaction. These are the steps we followed in our latest attempt.
Restored Production to our Test environment
Verified that we are able to post eligibility transactions in the Test environment to verify successful restore.
Upgraded to 2021.1
Attempted to post eligibility and receive error.
The front end error is just a generic Database write error, but digging further, we believe it is related to an issue with a table post-upgrade
2021-12-14 16:34:58.032|ERROR||xxxxxx\xxxx.xxxxxx|[1]|WriteEigData.EligHist|Oracle.DataAccess.Client.OracleException ORA-00904: "LTPTENTDATE": invalid identifier at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Relius.Admin.Base.DataAccess.RABulkInserter.ExecuteNonQuery()
at Relius.Admin.Base.DataAccess.RABulkInserter.LoadDataAndExecute(DataTable Data, Int32 StartRow, Int32 EndRow)
at Relius.Admin.Base.DataAccess.RABulkInserter.LoadDataAndExecuteInChunks(DataTable Data, Int32 ChunkSize)
at Relius.Admin.Bus.Transaction.EligTransVb6.WriteEigData(String DatabaseNam, String& PlanId, DateTime& YrEndDate, Int32& TransId, DateTime& TransEffDate, Boolean ComputeComp, String PlanTypeCd, Recordset& rsEes, Recordset& rsPlanEeVest, Recordset& rsPlanPayrollHist, Recordset& rsPlanEeSrceElig, Recordset& rsPlanEeSrceYr, Recordset& rsPlanDyn, Recordset& rsPlanEeTermAutoEnroll, CensusHist& objCensusHist)
2021-12-14 16:34:58.095|ERROR||xxxxx\xxxxx.xxxxxx|[1]|WriteEigData|Oracle.DataAccess.Client.OracleException ORA-00904: "LTPTENTDATE": invalid identifier at Relius.Admin.Bus.Transaction.EligTransVb6.WriteEigData(String DatabaseNam, String& PlanId, DateTime& YrEndDate, Int32& TransId, DateTime& TransEffDate, Boolean ComputeComp, String PlanTypeCd, Recordset& rsEes, Recordset& rsPlanEeVest, Recordset& rsPlanPayrollHist, Recordset& rsPlanEeSrceElig, Recordset& rsPlanEeSrceYr, Recordset& rsPlanDyn, Recordset& rsPlanEeTermAutoEnroll, CensusHist& objCensusHist)
@Sanjoy Nath @ben.edester
Per @ben.edester, we solved this. You have to apply the SP1 prior to the 2021.1 so that it runs those scripts.