Error converting data type nvarchar to numeric.

System.Data.SqlClient.SqlException: Error converting data type nvarchar to numeric.

System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to numeric.
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__180_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Core.Objects.ObjectContext.<ExecuteStoreQueryInternalAsync>d__73`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Utilities.TaskExtensions.CultureAwaiter`1.GetResult()
   at System.Data.Entity.Core.Objects.ObjectContext.<ExecuteInTransactionAsync>d__3d`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<ExecuteAsyncImplementation>d__9`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Utilities.TaskExtensions.CultureAwaiter`1.GetResult()
   at System.Data.Entity.Core.Objects.ObjectContext.<ExecuteStoreQueryReliablyAsync>d__70`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Utilities.TaskExtensions.CultureAwaiter`1.GetResult()
   at System.Data.Entity.Internal.LazyAsyncEnumerator`1.<FirstMoveNextAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Data.Entity.Infrastructure.IDbAsyncEnumerableExtensions.<ForEachAsync>d__5`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at OOPRepository.report.OopReport.<GetGoodsReturnReport>d__38.MoveNext() in D:\Source\Git\OOP\OOP\OOPRepository\report\OopReport.cs:line 1125
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at OOP.Report.ResourceServer.Controllers.OopReportController.<GetGoodsReturnReport>d__35.MoveNext() in D:\Source\Git\OOP\OOP\OOP.Report.ResourceServer\Controllers\OopReportController.cs:line 591
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()
ClientConnectionId:83c99780-59dc-49f2-949e-b8bf03924e7a
Error Number:8114,State:5,Class:16

Logged on Monday, September 8, 2025 at 8:39:25 PM

See also:

Server Variables

NameValue
ALL_HTTPHTTP_CONNECTION:close HTTP_CONTENT_LENGTH:130 HTTP_CONTENT_TYPE:application/json; charset=UTF-8 HTTP_ACCEPT:application/json, text/javascript, */*; q=0.01 HTTP_ACCEPT_ENCODING:gzip, deflate, br, zstd HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.9 HTTP_AUTHORIZATION:Bearer cI4QOmnzMqw2eiShGE5IIMFceRZYvLXqwOFn825YHfgdzEEGy_cBchbjwPOPyUK53kHlFq0FBGpUsDSbMrKwa6n_e23ggraLqIi7z-zeNrJmAb9PSrnj3Ny7WxEHuaRjn5SHjb_uyRvki4n7ETk0yWgZos6z5MbXqPtQTUcSzHtL3rjP-S89KwlYY3z4DJBPFHp7zH7xgodUHYiuegT7QsoD6WHgx6n7IHm6To__FM_TDER2HZTUk44-hoSemCzzwF8HN5fN2qNjfFsbqcZkqrokgxhIGI7GWSbMimIXTaWssnKTqqHoKBMl51xyl56CeYGX28mSN3m6X0OVj5JU6Ki_7M6i2wUzS98HxQd6twubphtR_l77goE4sNADx0c9QsPxUiSMo-wd4logOtfPHO1kgvdLKBuwvT8djCo7-Tpq-kLI5Kp7NF-QAE6aY8s3UnHUQZtONXsYiEOrAfSqoT8k3Ck HTTP_HOST:oopreport.ramrajcotton.net HTTP_REFERER:https://portal.ramrajcotton.net/ HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36 HTTP_SEC_CH_UA_PLATFORM:"Windows" HTTP_SEC_CH_UA:"Not;A=Brand";v="99", "Google Chrome";v="139", "Chromium";v="139" HTTP_SEC_CH_UA_MOBILE:?0 HTTP_SELECTEDDIVISIONID:1,4,3,7,6,2,5,8 HTTP_APPCLIENT:OOP HTTP_SELECTEDBPID:52159 HTTP_ORIGIN:https://portal.ramrajcotton.net HTTP_SEC_FETCH_SITE:same-site HTTP_SEC_FETCH_MODE:cors HTTP_SEC_FETCH_DEST:empty HTTP_PRIORITY:u=1, i
ALL_RAWConnection: close Content-Length: 130 Content-Type: application/json; charset=UTF-8 Accept: application/json, text/javascript, */*; q=0.01 Accept-Encoding: gzip, deflate, br, zstd Accept-Language: en-US,en;q=0.9 Authorization: Bearer cI4QOmnzMqw2eiShGE5IIMFceRZYvLXqwOFn825YHfgdzEEGy_cBchbjwPOPyUK53kHlFq0FBGpUsDSbMrKwa6n_e23ggraLqIi7z-zeNrJmAb9PSrnj3Ny7WxEHuaRjn5SHjb_uyRvki4n7ETk0yWgZos6z5MbXqPtQTUcSzHtL3rjP-S89KwlYY3z4DJBPFHp7zH7xgodUHYiuegT7QsoD6WHgx6n7IHm6To__FM_TDER2HZTUk44-hoSemCzzwF8HN5fN2qNjfFsbqcZkqrokgxhIGI7GWSbMimIXTaWssnKTqqHoKBMl51xyl56CeYGX28mSN3m6X0OVj5JU6Ki_7M6i2wUzS98HxQd6twubphtR_l77goE4sNADx0c9QsPxUiSMo-wd4logOtfPHO1kgvdLKBuwvT8djCo7-Tpq-kLI5Kp7NF-QAE6aY8s3UnHUQZtONXsYiEOrAfSqoT8k3Ck Host: oopreport.ramrajcotton.net Referer: https://portal.ramrajcotton.net/ User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36 sec-ch-ua-platform: "Windows" sec-ch-ua: "Not;A=Brand";v="99", "Google Chrome";v="139", "Chromium";v="139" sec-ch-ua-mobile: ?0 selecteddivisionid: 1,4,3,7,6,2,5,8 appclient: OOP selectedbpid: 52159 origin: https://portal.ramrajcotton.net sec-fetch-site: same-site sec-fetch-mode: cors sec-fetch-dest: empty priority: u=1, i
APPL_MD_PATH/LM/W3SVC/20/ROOT
APPL_PHYSICAL_PATHD:\IIS\OOP\Resources\Report\
AUTH_PASSWORD*****
AUTH_TYPEBearer
AUTH_USERC053407
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE256
CERT_SECRETKEYSIZE2048
CERT_SERIALNUMBER
CERT_SERVER_ISSUERC=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECTCN=*.ramrajcotton.net
CERT_SUBJECT
CONTENT_LENGTH130
CONTENT_TYPEapplication/json; charset=UTF-8
GATEWAY_INTERFACECGI/1.1
HTTP_ACCEPTapplication/json, text/javascript, */*; q=0.01
HTTP_ACCEPT_ENCODINGgzip, deflate, br, zstd
HTTP_ACCEPT_LANGUAGEen-US,en;q=0.9
HTTP_APPCLIENTOOP
HTTP_APPLICATIONINSIGHTS_REQUESTTRACKINGTELEMETRYMODULE_ROOTREQUEST_ID1ba8776f-0ee8-49ff-8b69-74b5703dd361
HTTP_AUTHORIZATIONBearer cI4QOmnzMqw2eiShGE5IIMFceRZYvLXqwOFn825YHfgdzEEGy_cBchbjwPOPyUK53kHlFq0FBGpUsDSbMrKwa6n_e23ggraLqIi7z-zeNrJmAb9PSrnj3Ny7WxEHuaRjn5SHjb_uyRvki4n7ETk0yWgZos6z5MbXqPtQTUcSzHtL3rjP-S89KwlYY3z4DJBPFHp7zH7xgodUHYiuegT7QsoD6WHgx6n7IHm6To__FM_TDER2HZTUk44-hoSemCzzwF8HN5fN2qNjfFsbqcZkqrokgxhIGI7GWSbMimIXTaWssnKTqqHoKBMl51xyl56CeYGX28mSN3m6X0OVj5JU6Ki_7M6i2wUzS98HxQd6twubphtR_l77goE4sNADx0c9QsPxUiSMo-wd4logOtfPHO1kgvdLKBuwvT8djCo7-Tpq-kLI5Kp7NF-QAE6aY8s3UnHUQZtONXsYiEOrAfSqoT8k3Ck
HTTP_CONNECTIONclose
HTTP_CONTENT_LENGTH130
HTTP_CONTENT_TYPEapplication/json; charset=UTF-8
HTTP_HOSToopreport.ramrajcotton.net
HTTP_ORIGINhttps://portal.ramrajcotton.net
HTTP_PRIORITYu=1, i
HTTP_REFERERhttps://portal.ramrajcotton.net/
HTTP_SEC_CH_UA"Not;A=Brand";v="99", "Google Chrome";v="139", "Chromium";v="139"
HTTP_SEC_CH_UA_MOBILE?0
HTTP_SEC_CH_UA_PLATFORM"Windows"
HTTP_SEC_FETCH_DESTempty
HTTP_SEC_FETCH_MODEcors
HTTP_SEC_FETCH_SITEsame-site
HTTP_SELECTEDBPID52159
HTTP_SELECTEDDIVISIONID1,4,3,7,6,2,5,8
HTTP_USER_AGENTMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36
HTTPSon
HTTPS_KEYSIZE256
HTTPS_SECRETKEYSIZE2048
HTTPS_SERVER_ISSUERC=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECTCN=*.ramrajcotton.net
INSTANCE_ID20
INSTANCE_META_PATH/LM/W3SVC/20
LOCAL_ADDR10.0.0.198
LOGON_USERC053407
PATH_INFO/Api/OOPReport/GetGoodsReturnReport
PATH_TRANSLATEDD:\IIS\OOP\Resources\Report\Api\OOPReport\GetGoodsReturnReport
QUERY_STRING
REMOTE_ADDR106.222.228.23
REMOTE_HOST106.222.228.23
REMOTE_PORT8822
REMOTE_USERC053407
REQUEST_METHODPOST
SCRIPT_NAME/Api/OOPReport/GetGoodsReturnReport
SERVER_NAMEoopreport.ramrajcotton.net
SERVER_PORT443
SERVER_PORT_SECURE1
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/Api/OOPReport/GetGoodsReturnReport