Load Munis Items - Deposit Receipts error in Bank Reconciliation Manager processing partial matches

Owned by Knowledge Assistant
Last updated: Jul 14, 2021
1 min read
Description of Issue

Usually occurs after a Partial Match has been processed. On screen error that forces user to close program when filtering or attempting new matches: 

Load Munis Items - Deposit Receipts
{"data":{"Message":"An error has occurred."},"status":500,"config":{"method":"POST","transformRequest":[null],"transformResponse":[null],
"url":"https://SERVERNAME.tylertech.com/SITENAME//AppApi/BankReconciliation/BankMatch/GetMunisReceiptsByMatchId2","params"
:{"matchId":XXXX,"depositId":XXXXX},"cache":false,"headers":{"Accept":"application/json, text/plain, */*","Authorization":...

System Log error is for Program Id : GetMunisReceiptsByMatchId2

An error occurred in the Tyler business service.
Inner Exception Message: System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error for data type smallint, value = XXXXX.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()
ClientConnectionId:XXX-XXXX-XXXXXXX
Error Number:220,State:1,Class:16

Context
  • Bank Reconciliation Manager
  • Matching 
  • Reported in 2018.1.28, 2020.3
Cause


Resolution
  • MUN-410083 has been opened with Development to resolve the Load Munis Items - Deposit Receipts error occurring on the Match screen. 
  • Please report instances of this error to Munis General Ledger Support for tracking purposes. 
Additional Information