The cast to value type 'System.Decimal' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type.

System.InvalidOperationException: The cast to value type 'System.Decimal' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type.

System.InvalidOperationException: The cast to value type 'System.Decimal' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type.
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
   at lambda_method(Closure , Shaper )
   at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
   at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.<MoveNextAsync>d__4.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.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.<GetInvoiceSummary_Mob>d__16.MoveNext() in D:\Source\Git\OOP\OOP\OOPRepository\report\OopReport.cs:line 576
--- 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.<GetInvoiceSummary_Mob>d__13.MoveNext() in D:\Source\Git\OOP\OOP\OOP.Report.ResourceServer\Controllers\OopReportController.cs:line 237
--- 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.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()

Logged on Thursday, September 4, 2025 at 5:49:19 PM

See also:

Server Variables

NameValue
ALL_HTTPHTTP_CONNECTION:close HTTP_CONTENT_TYPE:application/json; charset=utf-8 HTTP_ACCEPT:application/json, text/javascript, */*; q=0.01 HTTP_ACCEPT_ENCODING:gzip, deflate, br HTTP_ACCEPT_LANGUAGE:en-IN,en-GB;q=0.9,en;q=0.8 HTTP_AUTHORIZATION:Bearer bOsTxEqlAzyp3LJOChOWKgFs7RqHUUy2W1HsLD3LUWsbh1mMLwNwzNGljnx0PGGQLSJ_Xfr2HaPl6hE9OLdwTldp9angTuyrRNyBSTBx1Gm8nzoIyWvRVmwTwcgyNF1O2JpIMI4kSU15BkXceUn6d2bS_HP6f6cVJu2JQWWI_WyzK6Al1s7vXwmoWb6XXw00-I__aMMNCfn051GrsFtVt3Khgn42WbvBBIDPhiOt9A78d9BW3cstBk-XvyzvZRZOaAbm4ye9SizqWip2jDnSk06Yx0WnPIleNhWUPnBj9vzD-LnmdSzLKaqxnacjq46DkUq-ThRyLrRC2YAwUz3ADhtao4QV-Rl1BsydHV11KhXTjLf0kQnbyIDq3H_-bxfbVuX0-6HqibN1MlF48TqzRcIg7OauuXPe-XfVoHZnYcAw_dTfyH1oM0x0Mw2WEhEKMjUT3kwz8i9F0UdaZya-uxY91t6QobjN7LIZEJei72x8vdOP HTTP_HOST:oopreport.ramrajcotton.net HTTP_REFERER:https://portal.ramrajcotton.net/ HTTP_USER_AGENT:Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Mobile/15E148 Safari/604.1 HTTP_SEC_FETCH_SITE:same-site HTTP_APPCLIENT:OOP HTTP_SELECTEDBPID:44214 HTTP_SELECTEDDIVISIONID:4 HTTP_SEC_FETCH_MODE:cors HTTP_ORIGIN:https://portal.ramrajcotton.net HTTP_SEC_FETCH_DEST:empty HTTP_PRIORITY:u=3, i
ALL_RAWConnection: close Content-Type: application/json; charset=utf-8 Accept: application/json, text/javascript, */*; q=0.01 Accept-Encoding: gzip, deflate, br Accept-Language: en-IN,en-GB;q=0.9,en;q=0.8 Authorization: Bearer bOsTxEqlAzyp3LJOChOWKgFs7RqHUUy2W1HsLD3LUWsbh1mMLwNwzNGljnx0PGGQLSJ_Xfr2HaPl6hE9OLdwTldp9angTuyrRNyBSTBx1Gm8nzoIyWvRVmwTwcgyNF1O2JpIMI4kSU15BkXceUn6d2bS_HP6f6cVJu2JQWWI_WyzK6Al1s7vXwmoWb6XXw00-I__aMMNCfn051GrsFtVt3Khgn42WbvBBIDPhiOt9A78d9BW3cstBk-XvyzvZRZOaAbm4ye9SizqWip2jDnSk06Yx0WnPIleNhWUPnBj9vzD-LnmdSzLKaqxnacjq46DkUq-ThRyLrRC2YAwUz3ADhtao4QV-Rl1BsydHV11KhXTjLf0kQnbyIDq3H_-bxfbVuX0-6HqibN1MlF48TqzRcIg7OauuXPe-XfVoHZnYcAw_dTfyH1oM0x0Mw2WEhEKMjUT3kwz8i9F0UdaZya-uxY91t6QobjN7LIZEJei72x8vdOP Host: oopreport.ramrajcotton.net Referer: https://portal.ramrajcotton.net/ User-Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Mobile/15E148 Safari/604.1 sec-fetch-site: same-site appclient: OOP selectedbpid: 44214 selecteddivisionid: 4 sec-fetch-mode: cors origin: https://portal.ramrajcotton.net sec-fetch-dest: empty priority: u=3, i
APPL_MD_PATH/LM/W3SVC/20/ROOT
APPL_PHYSICAL_PATHD:\IIS\OOP\Resources\Report\
AUTH_PASSWORD*****
AUTH_TYPEBearer
AUTH_USERE23-04996
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_LENGTH0
CONTENT_TYPEapplication/json; charset=utf-8
GATEWAY_INTERFACECGI/1.1
HTTP_ACCEPTapplication/json, text/javascript, */*; q=0.01
HTTP_ACCEPT_ENCODINGgzip, deflate, br
HTTP_ACCEPT_LANGUAGEen-IN,en-GB;q=0.9,en;q=0.8
HTTP_APPCLIENTOOP
HTTP_APPLICATIONINSIGHTS_REQUESTTRACKINGTELEMETRYMODULE_ROOTREQUEST_ID4d687392-f19c-4465-a5b9-0841b0a8001a
HTTP_AUTHORIZATIONBearer bOsTxEqlAzyp3LJOChOWKgFs7RqHUUy2W1HsLD3LUWsbh1mMLwNwzNGljnx0PGGQLSJ_Xfr2HaPl6hE9OLdwTldp9angTuyrRNyBSTBx1Gm8nzoIyWvRVmwTwcgyNF1O2JpIMI4kSU15BkXceUn6d2bS_HP6f6cVJu2JQWWI_WyzK6Al1s7vXwmoWb6XXw00-I__aMMNCfn051GrsFtVt3Khgn42WbvBBIDPhiOt9A78d9BW3cstBk-XvyzvZRZOaAbm4ye9SizqWip2jDnSk06Yx0WnPIleNhWUPnBj9vzD-LnmdSzLKaqxnacjq46DkUq-ThRyLrRC2YAwUz3ADhtao4QV-Rl1BsydHV11KhXTjLf0kQnbyIDq3H_-bxfbVuX0-6HqibN1MlF48TqzRcIg7OauuXPe-XfVoHZnYcAw_dTfyH1oM0x0Mw2WEhEKMjUT3kwz8i9F0UdaZya-uxY91t6QobjN7LIZEJei72x8vdOP
HTTP_CONNECTIONclose
HTTP_CONTENT_TYPEapplication/json; charset=utf-8
HTTP_HOSToopreport.ramrajcotton.net
HTTP_ORIGINhttps://portal.ramrajcotton.net
HTTP_PRIORITYu=3, i
HTTP_REFERERhttps://portal.ramrajcotton.net/
HTTP_SEC_FETCH_DESTempty
HTTP_SEC_FETCH_MODEcors
HTTP_SEC_FETCH_SITEsame-site
HTTP_SELECTEDBPID44214
HTTP_SELECTEDDIVISIONID4
HTTP_USER_AGENTMozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Mobile/15E148 Safari/604.1
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_USERE23-04996
PATH_INFO/Api/OOPReport/GetInvoiceSummary_Mob
PATH_TRANSLATEDD:\IIS\OOP\Resources\Report\Api\OOPReport\GetInvoiceSummary_Mob
QUERY_STRINGHeaderInvoiceID=290357&DivisionID=4&_=1756988216090
REMOTE_ADDR157.51.51.65
REMOTE_HOST157.51.51.65
REMOTE_PORT62163
REMOTE_USERE23-04996
REQUEST_METHODGET
SCRIPT_NAME/Api/OOPReport/GetInvoiceSummary_Mob
SERVER_NAMEoopreport.ramrajcotton.net
SERVER_PORT443
SERVER_PORT_SECURE1
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/Api/OOPReport/GetInvoiceSummary_Mob