Could not execute statement on remote server 'ETI'.

System.Data.SqlClient.SqlException: Could not execute statement on remote server 'ETI'.

System.Data.SqlClient.SqlException (0x80131904): Could not execute statement on remote server 'ETI'.
   at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at Unisoft.PFC.Agencies.DataAccess.AgentsDA.InsertAgentMGA(AgentData Agent, Int32 MGACode) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies\DA\AgentsDA.vb:line 1290
   at Unisoft.PFC.Agencies.BusinessRules.AgentBR.InsertMGA(AgentData Agent, Int32 MGACode, Int32& NewAgentNumber) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies\BusinessRules\AgentBR.vb:line 106
   at Unisoft.PFC.Agencies.CAgentSystem.CreateAgentMGA(Int32& Agent, String Name, String Name2, String Address, String Address2, String City, String State, String ZipCode, String Phone, String Fax, String EMail, String HoldDays, String SubCompany, String PymtFee, String CommercialTableId, String FlatIronUser, String FlatIronPassword, String AllowPayments, String AllowHolds, String AllowPointOfSale, String DefaultAPR, String AllowDraftAsPayee, String AllowAchAsPayee, String PrivateTableid, String AllowSaveAgentBankInfo, String AllowCourtesyHolds, String CourtesyHoldDays, String AllowACHDownPayment, String AllowAP, String AllowRenewals, String AllowEditContracts, String AllowEFtPayOption, String AllowTenInstallments, String InstallmentsApproval, Decimal MaxCreditLimit, Boolean AllowedToEnterAgencyFee, Boolean UnpaidBalanceRequired, Boolean ACHFundingRequired, Int32 Default6MonthDown, Int32 Default12MonthDown, String MarketingRep, Boolean WaiveServiceCharge, Decimal InitialPoints, Boolean CollectDownBankAccount, Boolean UseRevisionTables, Int32 MGACode, String CreatedBy, DateTime CreatedDate, Boolean AllowPrintTemp, Int32 MGAExternalCustomerId, AgentData& AgntData) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies\Facade\CAgentSystem.vb:line 1007
   at Unisoft.PFC.Agencies.Presentation.Helpers.AgencyRepository.CreateAgent(AgentViewModel model) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies.Presentation\Helpers\AgencyRepository.cs:line 185
   at Unisoft.PFC.Agencies.Presentation.Controllers.AgentsController.CreateAgent(AgentViewModel Agent) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Agencies.Presentation\Controllers\AgencyController.cs:line 99
   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:c2394671-2d60-4690-bb19-28d5d7ad6dc3
Error Number:7215,State:1,Class:17

Logged on Friday, May 30, 2025 at 2:46:31 PM

See also:

Server Variables

NameValue
ALL_HTTPHTTP_CACHE_CONTROL:max-age=0 HTTP_CONNECTION:close HTTP_CONTENT_LENGTH:220 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded 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.1550784998.1748628863; ASP.NET_SessionId=kuzv5jt00x03dcbjsr14ftaw; _gat_gtag_UA_123756894_2=1; .ASPXAUTH=30D5CE314B2EFDFAD1F0D8373E1D5FCEE6C92EBE26369620D5F6A01A77153156D9C634587C069D95F3B5E2347DAE4C80EFE71CE767AFDBE9DC8D995499ABBB1AE0895D3C3B04C286B91B0BF947D2113262CB2C186EA73E94D484B7F2879A0B9BDE6FE4236C39046A48F07A210868974D47E72D6DE641C0832B5CE35588860BE2CCB470309725BE39D7E9F17D8DC00430; _ga_C9J6ENXM06=GS2.1.s1748628862$o14$g1$t1748630761$j51$l0$h0; _ga=GA1.2.1403521554.1743622238 HTTP_HOST:www.honor.capital HTTP_REFERER:https://www.honor.capital/Agents/CreateAgent HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 HTTP_SEC_CH_UA:"Google Chrome";v="137", "Chromium";v="137", "Not/A)Brand";v="24" HTTP_SEC_CH_UA_MOBILE:?0 HTTP_SEC_CH_UA_PLATFORM:"Windows" HTTP_ORIGIN:https://www.honor.capital 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_RAWCache-Control: max-age=0 Connection: close Content-Length: 220 Content-Type: application/x-www-form-urlencoded 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.1550784998.1748628863; ASP.NET_SessionId=kuzv5jt00x03dcbjsr14ftaw; _gat_gtag_UA_123756894_2=1; .ASPXAUTH=30D5CE314B2EFDFAD1F0D8373E1D5FCEE6C92EBE26369620D5F6A01A77153156D9C634587C069D95F3B5E2347DAE4C80EFE71CE767AFDBE9DC8D995499ABBB1AE0895D3C3B04C286B91B0BF947D2113262CB2C186EA73E94D484B7F2879A0B9BDE6FE4236C39046A48F07A210868974D47E72D6DE641C0832B5CE35588860BE2CCB470309725BE39D7E9F17D8DC00430; _ga_C9J6ENXM06=GS2.1.s1748628862$o14$g1$t1748630761$j51$l0$h0; _ga=GA1.2.1403521554.1743622238 Host: www.honor.capital Referer: https://www.honor.capital/Agents/CreateAgent User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 sec-ch-ua: "Google Chrome";v="137", "Chromium";v="137", "Not/A)Brand";v="24" sec-ch-ua-mobile: ?0 sec-ch-ua-platform: "Windows" origin: https://www.honor.capital 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/40/ROOT
APPL_PHYSICAL_PATH\\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\
AUTH_PASSWORD*****
AUTH_TYPEForms
AUTH_USERmwebber@coniferinsurance.com
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=H75597, C=US, S=Florida, L=Sunrise, O=Honor Capital Corporation, CN=www.honor.capital
CERT_SUBJECT
CONTENT_LENGTH220
CONTENT_TYPEapplication/x-www-form-urlencoded
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_CACHE_CONTROLmax-age=0
HTTP_CONNECTIONclose
HTTP_CONTENT_LENGTH220
HTTP_CONTENT_TYPEapplication/x-www-form-urlencoded
HTTP_COOKIE_gid=GA1.2.1550784998.1748628863; ASP.NET_SessionId=kuzv5jt00x03dcbjsr14ftaw; _gat_gtag_UA_123756894_2=1; .ASPXAUTH=30D5CE314B2EFDFAD1F0D8373E1D5FCEE6C92EBE26369620D5F6A01A77153156D9C634587C069D95F3B5E2347DAE4C80EFE71CE767AFDBE9DC8D995499ABBB1AE0895D3C3B04C286B91B0BF947D2113262CB2C186EA73E94D484B7F2879A0B9BDE6FE4236C39046A48F07A210868974D47E72D6DE641C0832B5CE35588860BE2CCB470309725BE39D7E9F17D8DC00430; _ga_C9J6ENXM06=GS2.1.s1748628862$o14$g1$t1748630761$j51$l0$h0; _ga=GA1.2.1403521554.1743622238
HTTP_HOSTwww.honor.capital
HTTP_ORIGINhttps://www.honor.capital
HTTP_PRIORITYu=0, i
HTTP_REFERERhttps://www.honor.capital/Agents/CreateAgent
HTTP_SEC_CH_UA"Google Chrome";v="137", "Chromium";v="137", "Not/A)Brand";v="24"
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/137.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=H75597, C=US, S=Florida, L=Sunrise, O=Honor Capital Corporation, CN=www.honor.capital
INSTANCE_ID40
INSTANCE_META_PATH/LM/W3SVC/40
LOCAL_ADDR10.10.0.24
LOGON_USERmwebber@coniferinsurance.com
PATH_INFO/Agents/CreateAgent
PATH_TRANSLATED\\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\Agents\CreateAgent
QUERY_STRING
REMOTE_ADDR50.173.144.74
REMOTE_HOST50.173.144.74
REMOTE_PORT54857
REMOTE_USERmwebber@coniferinsurance.com
REQUEST_METHODPOST
SCRIPT_NAME/Agents/CreateAgent
SERVER_NAMEwww.honor.capital
SERVER_PORT443
SERVER_PORT_SECURE1
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/Agents/CreateAgent