NewCrop Error When transmitting/printing

Support
1

Situation
When transmitting prescriptions or trying to print them i get this error

Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred. It worked during the morning and just stopped mid morning without any code changes to the system or DB.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at RX.Common.DataLayer.OpenHack.DBHelper.ExecuteNonQuery(SqlConnection cn, SqlTransaction tr, String sqlStoredProcedureName, SqlParameter dbParameters) at RX.Common.DataLayer.OpenHack.DBHelper.ExecuteNonQuery(String sqlStoredProcedureName, SqlParameter dbParameters) at RX.Common.DataLayer.Access.ProcUpdateRXTransactionDetail2(Guid accountGuid, Guid locationGuid, Guid orderGuid, Char userType, Guid userGuid, Int32 destinationType, String destinationValue, Guid destinationGuid, Int32 statusType, Int32 statusValueType, String statusDetail, Int32& rowCount, Guid& rxTransactionDetailGuid, String& statusMessage) at RX.Standard.Data.Legacy.Repos.RxTransactionDetailRepo.AddRXTransaction(Guid accountGuid, Guid locationGuid, Guid orderGuid, UserType userType, Guid userGuid, DestinationType destinationType, String destinationValue, Guid destinationGuid, StatusType statusType, Int32 statusValueType, String statusDetail) at RX.Web.App.Services.TransmitRxService.addRxTransaction(Guid accountGuid, Guid locationGuid, Guid userGuid, UserType userType, Guid orderGuid, DestinationType destinationType, String destinationValue, Guid destinationGuid, StatusType statusType) in /home/vsts/work/1/s/src/RX.Web.App/Services/TransmitRxService.cs:line 801 at RX.Web.App.Services.TransmitRxService.AddOrderAndRxTransactionForPrinting(Guid accountGuid, Guid locationGuid, Guid userGuid, UserType userType, Guid prescriptionGuid, Boolean showLeafLet, Boolean showDiagnosis) in /home/vsts/work/1/s/src/RX.Web.App/Services/TransmitRxService.cs:line 126 at RX.Web.App.Services.TransmitRxService.AddOrderAndRxTransactionForPrinting(Guid accountGuid, Guid locationGuid, Guid prescriberGuid, Guid userGuid, UserType userType, IEnumerable1 prescriptions) in /home/vsts/work/1/s/src/RX.Web.App/Services/TransmitRxService.cs:line 113 at RX.Web.App.Controllers.TransmitRxController.savePrescriptionsAndRedirectAsync(List1 prescriptions, IEnumerable1 prescriptionGuidsToResend, Guid pharmacyGuid, DestinationType destinationType, String overrideFaxNumber, Boolean isPharmacy, Boolean isResend, Boolean scriptTransmitActive, Boolean faxTransmitActive, List1 alertInteractions) in /home/vsts/work/1/s/src/RX.Web.App/Controllers/TransmitRxController.cs:line 826 at RX.Web.App.Controllers.TransmitRxController.TransmitRx(TransmitRxPostModel model) in /home/vsts/work/1/s/src/RX.Web.App/Controllers/TransmitRxController.cs:line 480 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) at RX.Web.App.Middleware.RedirectStaffUserMiddleware.InvokeAsync(HttpContext context, RedirectStaffUserService redirectStaffUserService, LinkGenerator linkGenerator) in /home/vsts/work/1/s/src/RX.Web.App/Middleware/RedirectStaffUserMiddleware.cs:line 42 at RX.Web.App.Middleware.RequireLocationMiddleware.InvokeAsync(HttpContext context, SessionSettingsService sessionSettingsService, ITempDataDictionaryFactory tempDataDictionaryFactory, LinkGenerator linkGenerator) in /home/vsts/work/1/s/src/RX.Web.App/Middleware/RequireLocationMiddleware.cs:line 28 at RX.Web.App.Middleware.RequireSelectedPatientMiddleware.InvokeAsync(HttpContext context, SessionSettingsService sessionSettingsService, ITempDataDictionaryFactory tempDataDictionaryFactory, LinkGenerator linkGenerator) in /home/vsts/work/1/s/src/RX.Web.App/Middleware/RequireSelectedPatientMiddleware.cs:line 28 at RX.Web.App.Middleware.RequireSelectedPrescriberMiddleware.InvokeAsync(HttpContext context, SessionSettingsService sessionSettingsService, ITempDataDictionaryFactory tempDataDictionaryFactory, LinkGenerator linkGenerator) in /home/vsts/work/1/s/src/RX.Web.App/Middleware/RequireSelectedPrescriberMiddleware.cs:line 50 at RX.Web.App.Middleware.RequireCurrentAccountMiddleware.InvokeAsync(HttpContext context, SessionSettingsService sessionSettingsService, LinkGenerator linkGenerator) in /home/vsts/work/1/s/src/RX.Web.App/Middleware/RequireCurrentAccountMiddleware.cs:line 40 at RX.Web.App.Middleware.RequestTimingMiddleware.Invoke(HttpContext context) in /home/vsts/work/1/s/src/RX.Web.App/Middleware/RequestTimingMiddleware.cs:line 33 at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Mindscape.Raygun4Net.ProfilingSupport.AspNetCoreInitializer.WrapAndInvokeRequest(RequestDelegate request, HttpContext httpContext) at Mindscape.Raygun4Net.AspNetCore.RaygunAspNetMiddleware.Invoke(HttpContext httpContext) at Mindscape.Raygun4Net.AspNetCore.RaygunAspNetMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
OpenEMR Version
I’m using OpenEMR version
7.0.2 patch 2
Browser:
I’m using:
Chrome
Operating System
I’m using:
Ubuntu 22 LTS
Search
Did you search the forum for similar questions?
Yes
Logs
Did you check the logs?

Error submitted above

Was there anything pertinent in them?
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

2

I see a newcrop message that they are investigating transmission issues so perhaps this is related to that. It would be nice to at least be able to print which I was not able to do when such errors occur and eventually had to manually write all rx’s on a pad paper.

Todd

3

Hi Dr Todd-
Your question is about a proprietary 3d party application so nobody here except the customer support of your NewCrop vendor would know about that.
As it happens, I am the vendor’s customer support for your NewCrop subscription so I have an answer for you: they have fixed it. Keep an eye on your emails, a bulletin to our NewCrop customers is coming out momentarily.
For future NewCrop questions please email us at the MI2 helpdesk (helpdesk at mi-squared dot com) - it’ll save you a lot of time.
Best- Harley

4

Will do. I had recently applied the patch and was confused early the saw the popup with the newcrop message.

Todd