Hi, I have three entries in the logs today that look like this:

---
An error has occured at /Admin/Orders/AuthorizePayment?paymentId=54722&X-Requested-With=XMLHttpRequest&_=1679769633467
Exception: String or binary data would be truncated. The statement has been terminated. Stack Trace: 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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Id.IdentityGenerator.InsertSelectDelegate.ExecuteAndExtract(DbCommand insert, ISessionImplementor session) at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)
---

I don't recall seeing this before.

Please advise,
Thanks.

EDIT: The number at the end of the first line differs across the entries.

Edited by user Monday, March 27, 2023 2:04:49 PM(UTC)  | Reason: Not specified

We use Authorize.Net CIM.

The three entries are for the same payment id, which points to one order with a Visa payment for $1 that did complete.

Sometimes these smaller ones are processed offline, from AC's perspective. I can't tell if this one went through A.NET CIM or was offline.

Shouldn't there be another error recorded if the payment failed?

Can we get additional logging captured with errors, aside from the exception? As you aptly stated, not much info is shown in the error.

Also, if I read the exception correct, the transaction was not truncated; it was terminated:

---
Exception: String or binary data would be truncated. The statement has been terminated.
---

Thanks,
Charles

Edited by user Tuesday, March 28, 2023 10:48:34 AM(UTC)  | Reason: Not specified

Hi, it's complicated.

Suffice it to say we use AC for onsite transactions as well, which may or may not be with a card swiper directly through authorize.net, and then we record the transaction "offline" in AC.

I think one was one of those with a payment recorded offline.

Thanks for the followup.

I don't see Authorize.Net transaction data on the payment, so I think this was an "offline" one.

I'm reaching out to the onsite user who would have encountered the error to see what she says.

Charles