Mekorma has scheduled monthly service maintenance at 10 PM on Friday, October 31st . During this time, all quotes, new order requests, renewal processing and key services will be unavailable. All Sales and Support-related requests will be handled in the order they were received on Monday, November 3rd . Thank you for your valued business!
How can I resolve the error: ME_Threshold_Approval_WORK cannot find the table
If it is the case you are receiving the error:
A range copy operation on table 'ME_Threshold_Approval_WORK', cannot find the table it is likely the case you will require upgrade to the most current build of Mekorma as this issue has been addressed as of build x86.
This error has been known to occur at different points in processing Mekorma payments or attempting to grant approval on payments using the workflow system. You may also see a related error:
"Cannot insert the value NULL into column 'INDEX1'. table 'SG1.dbo.meThresholdAppvlWorkDtl'. Column does not allow nulls. INSERT fails" when processing Mekorma payments or when running Mekorma Table Maintenance.
This too is known to be resolved in build x86 or in current Mekorma builds. If you continue to have the issue with the current build applied, please contact Mekorma Support.
You may also receive the following error when logging into GP. The same fix applies as to the above items:
[SQL Server] Violation of PRIMARY KEY contrant 'PKmeThresholdAppvlWorkDtl'. Cannot insert duplicate key in object 'dbo.meThresholdAppvlWorkDtl'. The duplicate key value is (052721CKS2. ,XPM_Cchecks. ,0000