System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_QuoteToUpload'. Cannot insert duplicate key in object 'dbo.QuoteToUpload'. The duplicate key value is (0776320250724115440265bb). The statement has been terminated.
System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_QuoteToUpload'. Cannot insert duplicate key in object 'dbo.QuoteToUpload'. The duplicate key value is (0776320250724115440265bb). The statement has been terminated. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<>c.<NonQuery>b__4_0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.<>c.<Update>b__21_0(UpdateTranslator ut) at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update[T](T noChangesResult, Func`2 updateFunction) at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update() at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesToStore>b__153_0() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass148_0.<SaveChangesInternal>b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() --- End of inner exception stack trace --- at System.Data.Entity.Internal.InternalContext.SaveChanges() at System.Data.Entity.Internal.LazyInternalContext.SaveChanges() at System.Data.Entity.DbContext.SaveChanges() at Unisoft.PFC.Data.Companies.PFC.DataAccess.Quotes.QuotePersist.Unisoft.PFC.Data.Interfaces.IPFCQuoteDAO.UploadContract(List`1 quotes, String CompanyInitial, Int32& RowsAffected) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Data\Companies\PFC\DataAccess\Quotes\QuotePersist.cs:line 622 at Unisoft.PFC.Data.Companies.PFC.DataAccess.Quotes.ContractsPersist.UploadContract(List`1 Contracts, String CompanyInitials) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.PFC.Data\Companies\PFC\DataAccess\Quotes\ContractsPersist.cs:line 52 at Unisoft.EFinance.CFinanceContractsSystem.UploadContract(List`1 Contracts, String CompanyInitials) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.EFinance.Facade\Contracts\CFinanceContractsSystem.vb:line 3511 at Unisoft.EFinance.Presentation.Helpers.FinanceRepository.UploadContracts(List`1 Contracts, String CompanyInitials) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.Efinance.Presentation\Helpers\FinanceRepository.cs:line 336 at Unisoft.EFinance.Presentation.Helpers.FinanceProcessing.UploadContracts(List`1 Contracts, String CompanyInitials) in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.Efinance.Presentation\Helpers\FinanceProcessing.cs:line 114 at Unisoft.EFinance.Presentation.Controllers.FinanceController.<UploadContracts>d__5.MoveNext() in C:\Projects\VS2022\FinanceComponents\Unisoft.PFC.Inquiry\Unisoft.Efinance.Presentation\Controllers\FinanceController.cs:line 74 --- 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.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass8_0.<BeginInvokeAsynchronousActionMethod>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.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)
Logged on Thursday, July 24, 2025 at 3:45:43 PM
See also:
Server Variables
Name | Value |
---|---|
ALL_HTTP | HTTP_CACHE_CONTROL:max-age=0 HTTP_CONNECTION:close HTTP_CONTENT_LENGTH:56357 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.547709012.1753101030; ASP.NET_SessionId=n3yhdq3dg3icbrrutngavdts; _gat_gtag_UA_123756894_2=1; .ASPXAUTH=2B80B7B4E22E65F5691D24F5912E1A38115DC459FB8C876ADA5F81F336384CFBEBB85C27A194FCA55E91974F2A1D0106B272297C6A6F5EF98EE60F8E134DC04DEBD39AA469B5CF0AA387F8AFA583F355D63323F62C23AC3F36EA082240785D9E; _ga_C9J6ENXM06=GS2.1.s1753384325$o6$g1$t1753386316$j43$l0$h0; _ga=GA1.1.199517533.1752266500 HTTP_HOST:www.etifinance.com HTTP_REFERER:https://www.etifinance.com/Finance/ContractsToUpload HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36 HTTP_SEC_CH_UA:"Not)A;Brand";v="8", "Chromium";v="138", "Google Chrome";v="138" HTTP_SEC_CH_UA_MOBILE:?0 HTTP_SEC_CH_UA_PLATFORM:"Windows" HTTP_ORIGIN:https://www.etifinance.com 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_RAW | Cache-Control: max-age=0 Connection: close Content-Length: 56357 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.547709012.1753101030; ASP.NET_SessionId=n3yhdq3dg3icbrrutngavdts; _gat_gtag_UA_123756894_2=1; .ASPXAUTH=2B80B7B4E22E65F5691D24F5912E1A38115DC459FB8C876ADA5F81F336384CFBEBB85C27A194FCA55E91974F2A1D0106B272297C6A6F5EF98EE60F8E134DC04DEBD39AA469B5CF0AA387F8AFA583F355D63323F62C23AC3F36EA082240785D9E; _ga_C9J6ENXM06=GS2.1.s1753384325$o6$g1$t1753386316$j43$l0$h0; _ga=GA1.1.199517533.1752266500 Host: www.etifinance.com Referer: https://www.etifinance.com/Finance/ContractsToUpload User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36 sec-ch-ua: "Not)A;Brand";v="8", "Chromium";v="138", "Google Chrome";v="138" sec-ch-ua-mobile: ?0 sec-ch-ua-platform: "Windows" origin: https://www.etifinance.com 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_TYPE | Forms |
AUTH_USER | CGONZALEZ |
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 | 56357 |
CONTENT_TYPE | application/x-www-form-urlencoded |
GATEWAY_INTERFACE | CGI/1.1 |
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_CACHE_CONTROL | max-age=0 |
HTTP_CONNECTION | close |
HTTP_CONTENT_LENGTH | 56357 |
HTTP_CONTENT_TYPE | application/x-www-form-urlencoded |
HTTP_COOKIE | _gid=GA1.2.547709012.1753101030; ASP.NET_SessionId=n3yhdq3dg3icbrrutngavdts; _gat_gtag_UA_123756894_2=1; .ASPXAUTH=2B80B7B4E22E65F5691D24F5912E1A38115DC459FB8C876ADA5F81F336384CFBEBB85C27A194FCA55E91974F2A1D0106B272297C6A6F5EF98EE60F8E134DC04DEBD39AA469B5CF0AA387F8AFA583F355D63323F62C23AC3F36EA082240785D9E; _ga_C9J6ENXM06=GS2.1.s1753384325$o6$g1$t1753386316$j43$l0$h0; _ga=GA1.1.199517533.1752266500 |
HTTP_HOST | www.etifinance.com |
HTTP_ORIGIN | https://www.etifinance.com |
HTTP_PRIORITY | u=0, i |
HTTP_REFERER | https://www.etifinance.com/Finance/ContractsToUpload |
HTTP_SEC_CH_UA | "Not)A;Brand";v="8", "Chromium";v="138", "Google Chrome";v="138" |
HTTP_SEC_CH_UA_MOBILE | ?0 |
HTTP_SEC_CH_UA_PLATFORM | "Windows" |
HTTP_SEC_FETCH_DEST | document |
HTTP_SEC_FETCH_MODE | navigate |
HTTP_SEC_FETCH_SITE | same-origin |
HTTP_SEC_FETCH_USER | ?1 |
HTTP_UPGRADE_INSECURE_REQUESTS | 1 |
HTTP_USER_AGENT | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36 |
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 | CGONZALEZ |
PATH_INFO | /Finance/UploadContracts |
PATH_TRANSLATED | \\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\Finance\UploadContracts |
QUERY_STRING | |
REMOTE_ADDR | 170.55.25.154 |
REMOTE_HOST | 170.55.25.154 |
REMOTE_PORT | 61398 |
REMOTE_USER | CGONZALEZ |
REQUEST_METHOD | POST |
SCRIPT_NAME | /Finance/UploadContracts |
SERVER_NAME | www.etifinance.com |
SERVER_PORT | 443 |
SERVER_PORT_SECURE | 1 |
SERVER_PROTOCOL | HTTP/1.1 |
SERVER_SOFTWARE | Microsoft-IIS/10.0 |
URL | /Finance/UploadContracts |