System.Data.SqlClient.SqlException: Procedure or function 'usp_get_AgentStatementsList' expects parameter '@Agent', which was not supplied.
System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'usp_get_AgentStatementsList' 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.GetAgentStatementsList(String Agent) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Inquiry.DataAccess\AgentStatementsDA.vb:line 115 at Unisoft.PFC.Inquiry.CAgentStatementSystem.GetAgentStatementsList(String Agent) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Inquiry.Facade\CAgentStatementSystem.vb:line 31 at Unisoft.PFC.Agencies.Presentation.Helpers.AgencyRepository.GetAgentStatements() in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies.Presentation\Helpers\AgencyRepository.cs:line 637 at Unisoft.PFC.Agencies.Presentation.Controllers.AgentsController.AgentStatements() in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies.Presentation\Controllers\AgencyController.cs:line 329 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:20c93f8b-13b9-4374-ad7e-12bfaef8b9d5 Error Number:201,State:4,Class:16
Logged on Saturday, November 1, 2025 at 2:24:32 PM
See also:
Server Variables
| Name | Value |
|---|---|
| ALL_HTTP | HTTP_CONNECTION:close HTTP_ACCEPT:*/* HTTP_ACCEPT_ENCODING:gzip, deflate, br HTTP_FROM:bingbot(at)microsoft.com HTTP_HOST:www.etifinance.com HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.68 |
| ALL_RAW | Connection: close Accept: */* Accept-Encoding: gzip, deflate, br From: bingbot(at)microsoft.com Host: www.etifinance.com User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.68 |
| APPL_MD_PATH | /LM/W3SVC/4/ROOT |
| APPL_PHYSICAL_PATH | \\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\ |
| AUTH_PASSWORD | ***** |
| AUTH_TYPE | |
| AUTH_USER | |
| CERT_COOKIE | |
| CERT_FLAGS | |
| CERT_ISSUER | |
| CERT_KEYSIZE | 256 |
| CERT_SECRETKEYSIZE | 2048 |
| CERT_SERIALNUMBER | |
| CERT_SERVER_ISSUER | C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2 |
| CERT_SERVER_SUBJECT | OID.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_LENGTH | 0 |
| CONTENT_TYPE | |
| GATEWAY_INTERFACE | CGI/1.1 |
| HTTP_ACCEPT | */* |
| HTTP_ACCEPT_ENCODING | gzip, deflate, br |
| HTTP_CONNECTION | close |
| HTTP_FROM | bingbot(at)microsoft.com |
| HTTP_HOST | www.etifinance.com |
| HTTP_USER_AGENT | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.68 |
| HTTPS | on |
| HTTPS_KEYSIZE | 256 |
| HTTPS_SECRETKEYSIZE | 2048 |
| HTTPS_SERVER_ISSUER | C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2 |
| HTTPS_SERVER_SUBJECT | OID.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_ID | 4 |
| INSTANCE_META_PATH | /LM/W3SVC/4 |
| LOCAL_ADDR | 10.10.0.24 |
| LOGON_USER | |
| PATH_INFO | /Agents/AgentStatements |
| PATH_TRANSLATED | \\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\Agents\AgentStatements |
| QUERY_STRING | |
| REMOTE_ADDR | 52.167.144.172 |
| REMOTE_HOST | 52.167.144.172 |
| REMOTE_PORT | 46314 |
| REMOTE_USER | |
| REQUEST_METHOD | GET |
| SCRIPT_NAME | /Agents/AgentStatements |
| SERVER_NAME | www.etifinance.com |
| SERVER_PORT | 443 |
| SERVER_PORT_SECURE | 1 |
| SERVER_PROTOCOL | HTTP/1.1 |
| SERVER_SOFTWARE | Microsoft-IIS/10.0 |
| URL | /Agents/AgentStatements |