Error on restart of the service

Error on restart of the service

Postby m.overeem » Wed 23 Aug 2017 06:53

We receive an error, every time the service is restarted. Is there something wrong in our configuration, or is this a known issue?

Review Assistant 3.6.445.

If you can not resolve this error, please contact Devart support team: https://www.devart.com/company/contactform.html?product=review-assistant

Error occurred in Perform at 23-8-2017 8:49:52:

Message: An error occurred while updating the entries. See the inner exception for details.
Source: EntityFramework
TargetSite: Int32 SaveChanges()
HelpLink:
Type: System.Data.Entity.Infrastructure.DbUpdateException
Entries: System.Linq.Enumerable+WhereSelectEnumerableIterator`2[System.Data.Entity.Core.Objects.ObjectStateEntry,System.Data.Entity.Infrastructure.DbEntityEntry]
HResult: -2146233087
Stack:
at System.Data.Entity.Internal.InternalContext.SaveChanges()
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=qf9ScyHL_Xvd5YLYMjiLNMAmnjuJrkKhN2iMiAm2PQ9s=(ReviewAssistantContext #=qtdjdisi5IbnKHHSCTQylzQ==)
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=q578LYKxADmwJBaEcWDZ5qvdj2TRsuo_MIgmI$MGdfmQ=(String #=q4aHVyYp7b$tfZP$eL6Xa9w==, ReviewAssistantContext #=qTXBbLCsp8sASSNBJDvqUcA==)
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=qOULoTP$DZcyAbN4W42ngHPJLltQFqo1OApYyNA13WEc=.#=qAS5E_ZKWza5hQMyYyylhuSzpm0VgHbPNur4aebmXx2c=(ReviewAssistantContext #=qPWTpqRPnZqUsR2juHKYGig==)
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=qpdh1fzDu9ALSrEO_btDzVA==(Action`1 #=qOqsbEQoy5wc7lGzHfgIhfQ==)

Message: An error occurred while updating the entries. See the inner exception for details.
Source: EntityFramework
TargetSite: Int32 Update()
HelpLink:
Type: System.Data.Entity.Core.UpdateException
StateEntries: System.Collections.ObjectModel.ReadOnlyCollection`1[System.Data.Entity.Core.Objects.ObjectStateEntry]
HResult: -2146233087
Stack:
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
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.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
at System.Data.Entity.Internal.InternalContext.SaveChanges()

Message: Violation of PRIMARY KEY constraint 'PK_dbo.Users'. Cannot insert duplicate key in object 'dbo.Users'. The duplicate key value is (93ddfe40-3d5f-45a1-930f-6f8c1ba81d93).
The statement has been terminated.
Source: .Net SqlClient Data Provider
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
HelpLink:
Type: System.Data.SqlClient.SqlException
Data:
HelpLink.ProdName: Microsoft SQL Server
HelpLink.ProdVer: 12.00.5553
HelpLink.EvtSrc: MSSQLServer
HelpLink.EvtID: 2627
HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink
HelpLink.LinkId: 20476
Errors: System.Data.SqlClient.SqlErrorCollection
ClientConnectionId: 42b5edc6-c989-435c-8a72-52df1d5aa029
Class: 14
LineNumber: 1
Number: 2627
Procedure:
Server: .\SQLEXPRESS
State: 1
ErrorCode: -2146232060
HResult: -2146232060
Stack:
at System.Data.SqlClient.SqlConnection.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)
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.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.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues)
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
m.overeem
 
Posts: 8
Joined: Fri 18 Aug 2017 11:40

Re: Error on restart of the service

Postby mstislavs » Wed 23 Aug 2017 09:51

m.overeem wrote:We receive an error, every time the service is restarted. Is there something wrong in our configuration, or is this a known issue?

Review Assistant 3.6.445.

If you can not resolve this error, please contact Devart support team: https://www.devart.com/company/contactform.html?product=review-assistant

Error occurred in Perform at 23-8-2017 8:49:52:

Message: An error occurred while updating the entries. See the inner exception for details.
Source: EntityFramework
TargetSite: Int32 SaveChanges()
HelpLink:
Type: System.Data.Entity.Infrastructure.DbUpdateException
Entries: System.Linq.Enumerable+WhereSelectEnumerableIterator`2[System.Data.Entity.Core.Objects.ObjectStateEntry,System.Data.Entity.Infrastructure.DbEntityEntry]
HResult: -2146233087
Stack:
at System.Data.Entity.Internal.InternalContext.SaveChanges()
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=qf9ScyHL_Xvd5YLYMjiLNMAmnjuJrkKhN2iMiAm2PQ9s=(ReviewAssistantContext #=qtdjdisi5IbnKHHSCTQylzQ==)
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=q578LYKxADmwJBaEcWDZ5qvdj2TRsuo_MIgmI$MGdfmQ=(String #=q4aHVyYp7b$tfZP$eL6Xa9w==, ReviewAssistantContext #=qTXBbLCsp8sASSNBJDvqUcA==)
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=qOULoTP$DZcyAbN4W42ngHPJLltQFqo1OApYyNA13WEc=.#=qAS5E_ZKWza5hQMyYyylhuSzpm0VgHbPNur4aebmXx2c=(ReviewAssistantContext #=qPWTpqRPnZqUsR2juHKYGig==)
at #=q0zB02JdhY9yufZUE8iv_o7FpOUUFfk3z$MrWvSntjWE8SejNXNXEecTGC5bqEjva.#=qpdh1fzDu9ALSrEO_btDzVA==(Action`1 #=qOqsbEQoy5wc7lGzHfgIhfQ==)



Hello,

Thank you for reporting the problem. Does this error occur after every start of the Review Assistant Server and you cannot use Review Assistant?
Please provide us with the Event Viewer log of Review Assistant and the server settings file (the default location is C:\ProgramData\Devart\Review Assistant\settings.xml). You can get the Event Viewer log from 'Control Panel -> Event Viewer -> Applications and Services logs -> Devart Review Assistant -> Save All Events As...'

As a workaround, try to set the following option
<CommandTimeout>180</CommandTimeout>
in the server settings file (the default location is C:\ProgramData\Devart\Review Assistant\settings.xml).

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48

Re: Error on restart of the service

Postby m.overeem » Wed 23 Aug 2017 17:27

Hi Mstislav,

Can I send that through e-mail? I'm not really sure I can attach those files here (regarding security & privacy).
m.overeem
 
Posts: 8
Joined: Fri 18 Aug 2017 11:40

Re: Error on restart of the service

Postby mstislavs » Fri 25 Aug 2017 11:47

m.overeem wrote:Hi Mstislav,

Can I send that through e-mail? I'm not really sure I can attach those files here (regarding security & privacy).


Hi,

We recommend you to use the following form:
https://www.devart.com/company/contactform.html?product=review-assistant

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48

Re: Error on restart of the service

Postby m.overeem » Wed 06 Sep 2017 13:54

I've mailed everything, but haven't heard anything back yet. Can you give a status update?
m.overeem
 
Posts: 8
Joined: Fri 18 Aug 2017 11:40

Re: Error on restart of the service

Postby mstislavs » Tue 19 Sep 2017 10:15

m.overeem wrote:I've mailed everything, but haven't heard anything back yet. Can you give a status update?

We apologize for a late reply. Unfortunately, we did not get the request from you. Please upload the Event Viewer log of Review Assistant and the server settings file into our shared folder
https://1drv.ms/f/s!AuZUJhfybjtRgawC0fWvOKtRVnV9OA

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48

Re: Error on restart of the service

Postby m.overeem » Mon 25 Sep 2017 18:29

I submitted a request once again, but I'm not sure if the form even works. Is there a direct e-mailaddress that I can use?
m.overeem
 
Posts: 8
Joined: Fri 18 Aug 2017 11:40

Re: Error on restart of the service

Postby mstislavs » Tue 26 Sep 2017 07:28

m.overeem wrote:I submitted a request once again, but I'm not sure if the form even works. Is there a direct e-mailaddress that I can use?

Please send a mail to my mailbox: mstislavs@devart.com. Also you can upload the Event Viewer log of Review Assistant and the server settings file into our shared folder
https://1drv.ms/f/s!AuZUJhfybjtRgawC0fWvOKtRVnV9OA

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48

Re: Error on restart of the service

Postby mstislavs » Wed 27 Sep 2017 04:34

Thank you for the email, I have received it. We are investigating this problem.

Best regards,
Mstislav Sakidon
Devart Team
www.devart.com
mstislavs
 
Posts: 39
Joined: Mon 16 Jan 2017 12:48


Return to Review Assistant