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.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:35:46 PM

See also:

Server Variables

NameValue
ALL_HTTPHTTP_CACHE_CONTROL:max-age=0 HTTP_CONNECTION:close HTTP_CONTENT_LENGTH:55205 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; .ASPXAUTH=39094300CFE60B9CFB46B770D0DC1869FB8A4C922F9C2A4D58963770974C6FC932C62E83555788615F8D97CC90B9A22FA464642E2D29988EB1A74D946CB8C404569081BF27C90B906138DF2F8B0AC38114C0E8F14795AC1F1F2B1DA84FB63B66; _ga_C9J6ENXM06=GS2.1.s1753384325$o6$g1$t1753385709$j3$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_RAWCache-Control: max-age=0 Connection: close Content-Length: 55205 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; .ASPXAUTH=39094300CFE60B9CFB46B770D0DC1869FB8A4C922F9C2A4D58963770974C6FC932C62E83555788615F8D97CC90B9A22FA464642E2D29988EB1A74D946CB8C404569081BF27C90B906138DF2F8B0AC38114C0E8F14795AC1F1F2B1DA84FB63B66; _ga_C9J6ENXM06=GS2.1.s1753384325$o6$g1$t1753385709$j3$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_TYPEForms
AUTH_USERCGONZALEZ
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_LENGTH55205
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_LENGTH55205
HTTP_CONTENT_TYPEapplication/x-www-form-urlencoded
HTTP_COOKIE_gid=GA1.2.547709012.1753101030; ASP.NET_SessionId=n3yhdq3dg3icbrrutngavdts; .ASPXAUTH=39094300CFE60B9CFB46B770D0DC1869FB8A4C922F9C2A4D58963770974C6FC932C62E83555788615F8D97CC90B9A22FA464642E2D29988EB1A74D946CB8C404569081BF27C90B906138DF2F8B0AC38114C0E8F14795AC1F1F2B1DA84FB63B66; _ga_C9J6ENXM06=GS2.1.s1753384325$o6$g1$t1753385709$j3$l0$h0; _ga=GA1.1.199517533.1752266500
HTTP_HOSTwww.etifinance.com
HTTP_ORIGINhttps://www.etifinance.com
HTTP_PRIORITYu=0, i
HTTP_REFERERhttps://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_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/138.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_USERCGONZALEZ
PATH_INFO/Finance/UploadContracts
PATH_TRANSLATED\\dsc03.unisoftonline.com\iis\content\inetpub\wwwroot\PFC\EtiFinance\Finance\UploadContracts
QUERY_STRING
REMOTE_ADDR170.55.25.154
REMOTE_HOST170.55.25.154
REMOTE_PORT61297
REMOTE_USERCGONZALEZ
REQUEST_METHODPOST
SCRIPT_NAME/Finance/UploadContracts
SERVER_NAMEwww.etifinance.com
SERVER_PORT443
SERVER_PORT_SECURE1
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/10.0
URL/Finance/UploadContracts