While attempting to upgrade Mekorma, during Table Maintenance I receive the error: “ SQL Error while renaming current table to ME240447_DELETE SQL (5074) = [Microsoft][SQL Server Native Client 11.0][SQL Server]The index 'idx_ME240447_Queue_ID_CHEKBKID_BACHNUMB_USERID_MESEQNUMBR_FA554' is dependent on column 'Field_Value'. ODBC = 37000”

December 28, 2024 8

Resolution:
  1. Launch MS-SQL Management Studio
  2. Go to the company databases that apply to the upgrade
  3. Go to table ME240447 and expand the indexes.
  4. Delete the Indexes with AK2ME240447...., idx_ME240447, idx_ME240447 as they correspond to the error message.
  5. Login to GP as ‘as’ to re-run Mekorma Table Maintenance.

 

NOTE:  The indexes deleted were used in older Mekorma builds, and are no longer required