Procedure or function 'usp_get_AgentStatementsHeader' expects parameter '@Agent', which was not supplied.

System.Data.SqlClient.SqlException: Procedure or function 'usp_get_AgentStatementsHeader' expects parameter '@Agent', which was not supplied.

System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'usp_get_AgentStatementsHeader' expects parameter '@Agent', which was not supplied.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.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 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Unisoft.PFC.Inquiry.DataAccess.AgentStatementsDA.GetAgentStatementHeader(String Agent, String TDate) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Inquiry.DataAccess\AgentStatementsDA.vb:line 218
   at Unisoft.PFC.Inquiry.CAgentStatementSystem.GetStatementsHeader(String Agent, String TDate) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Inquiry.Facade\CAgentStatementSystem.vb:line 43
   at Unisoft.PFC.Agencies.Presentation.Controllers.AgentsController.GetAgentStatement(String transactionDate) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies.Presentation\Controllers\AgencyController.cs:line 336
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass7_0.<BeginInvokeActionMethodWithFilters>b__1(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_6.<BeginInvokeAction>b__4()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult)
ClientConnectionId:bbd90d63-9ac4-4f5c-b85d-071cbd6c1f9a
Error Number:201,State:4,Class:16

Logged on Tuesday, November 4, 2025 at 12:33:15 PM

See also:

Server Variables

NameValue
ALL_HTTPHTTP_CONNECTION:close HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 HTTP_ACCEPT_ENCODING:gzip, deflate, br, zstd HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.9 HTTP_COOKIE:_gid=GA1.2.905182865.1762185762; ASP.NET_SessionId=j3y4jtzflpgsc201h3ozn2ro; _ga_C9J6ENXM06=GS2.1.s1762274701$o506$g1$t1762275466$j60$l0$h0; _ga=GA1.2.2059485101.1721655764; .ASPXAUTH=6E666999AF3227BD905EE9F94F9C8BF0FA07A292AEAEC060270B3E8F0F82EC48A7A0C1282ECFA44CBD7410644CD6E7724BF5CE61C9EF5993CD38A14DC4B3E715BF22DD80820A60874C73518A4527F28B8399CF63E493B5F0EE5A0E3BD68A7D03 HTTP_HOST:www.etifinance.com HTTP_REFERER:https://www.etifinance.com/Agents/AgentStatements HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 HTTP_SEC_CH_UA:"Chromium";v="142", "Google Chrome";v="142", "Not_A Brand";v="99" HTTP_SEC_CH_UA_MOBILE:?0 HTTP_SEC_CH_UA_PLATFORM:"Windows" HTTP_UPGRADE_INSECURE_REQUESTS:1 HTTP_SEC_FETCH_SITE:same-origin HTTP_SEC_FETCH_MODE:navigate HTTP_SEC_FETCH_USER:?1 HTTP_SEC_FETCH_DEST:document HTTP_PRIORITY:u=0, i
ALL_RAWConnection: close Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Accept-Encoding: gzip, deflate, br, zstd Accept-Language: en-US,en;q=0.9 Cookie: _gid=GA1.2.905182865.1762185762; ASP.NET_SessionId=j3y4jtzflpgsc201h3ozn2ro; _ga_C9J6ENXM06=GS2.1.s1762274701$o506$g1$t1762275466$j60$l0$h0; _ga=GA1.2.2059485101.1721655764; .ASPXAUTH=6E666999AF3227BD905EE9F94F9C8BF0FA07A292AEAEC060270B3E8F0F82EC48A7A0C1282ECFA44CBD7410644CD6E7724BF5CE61C9EF5993CD38A14DC4B3E715BF22DD80820A60874C73518A4527F28B8399CF63E493B5F0EE5A0E3BD68A7D03 Host: www.etifinance.com Referer: https://www.etifinance.com/Agents/AgentStatements User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36 sec-ch-ua: "Chromium";v="142", "Google Chrome";v="142", "Not_A Brand";v="99" sec-ch-ua-mobile: ?0 sec-ch-ua-platform: "Windows" upgrade-insecure-requests: 1 sec-fetch-site: same-origin sec-fetch-mode: navigate sec-fetch-user: ?1 sec-fetch-dest: document priority: u=0, i
APPL_MD_PATH/LM/W3SVC/4/ROOT
APPL_PHYSICAL_PATH\\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\
AUTH_PASSWORD*****
AUTH_TYPEForms
AUTH_USER32006
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_SUBJECTOID.1.3.6.1.4.1.311.60.2.1.3=US, OID.1.3.6.1.4.1.311.60.2.1.2=Florida, OID.2.5.4.15=Private Organization, SERIALNUMBER=P96000055531, C=US, S=Florida, L=Miami, O="Unisoft Communications, Inc.", CN=www.etifinance.com
CERT_SUBJECT
CONTENT_LENGTH0
CONTENT_TYPE
GATEWAY_INTERFACECGI/1.1
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
HTTP_ACCEPT_ENCODINGgzip, deflate, br, zstd
HTTP_ACCEPT_LANGUAGEen-US,en;q=0.9
HTTP_CONNECTIONclose
HTTP_COOKIE_gid=GA1.2.905182865.1762185762; ASP.NET_SessionId=j3y4jtzflpgsc201h3ozn2ro; _ga_C9J6ENXM06=GS2.1.s1762274701$o506$g1$t1762275466$j60$l0$h0; _ga=GA1.2.2059485101.1721655764; .ASPXAUTH=6E666999AF3227BD905EE9F94F9C8BF0FA07A292AEAEC060270B3E8F0F82EC48A7A0C1282ECFA44CBD7410644CD6E7724BF5CE61C9EF5993CD38A14DC4B3E715BF22DD80820A60874C73518A4527F28B8399CF63E493B5F0EE5A0E3BD68A7D03
HTTP_HOSTwww.etifinance.com
HTTP_PRIORITYu=0, i
HTTP_REFERERhttps://www.etifinance.com/Agents/AgentStatements
HTTP_SEC_CH_UA"Chromium";v="142", "Google Chrome";v="142", "Not_A Brand";v="99"
HTTP_SEC_CH_UA_MOBILE?0
HTTP_SEC_CH_UA_PLATFORM"Windows"
HTTP_SEC_FETCH_DESTdocument
HTTP_SEC_FETCH_MODEnavigate
HTTP_SEC_FETCH_SITEsame-origin
HTTP_SEC_FETCH_USER?1
HTTP_UPGRADE_INSECURE_REQUESTS1
HTTP_USER_AGENTMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.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_SUBJECTOID.1.3.6.1.4.1.311.60.2.1.3=US, OID.1.3.6.1.4.1.311.60.2.1.2=Florida, OID.2.5.4.15=Private Organization, SERIALNUMBER=P96000055531, C=US, S=Florida, L=Miami, O="Unisoft Communications, Inc.", CN=www.etifinance.com
INSTANCE_ID4
INSTANCE_META_PATH/LM/W3SVC/4
LOCAL_ADDR10.10.0.24
LOGON_USER32006
PATH_INFO/Agents/GetAgentStatement
PATH_TRANSLATED\\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\Agents\GetAgentStatement
QUERY_STRINGtransactionDate=20251031
REMOTE_ADDR174.48.231.142
REMOTE_HOST174.48.231.142
REMOTE_PORT59425
REMOTE_USER32006
REQUEST_METHODGET
SCRIPT_NAME/Agents/GetAgentStatement
SERVER_NAMEwww.etifinance.com
SERVER_PORT443
SERVER_PORT_SECURE1
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/Agents/GetAgentStatement