Assigned user (on team work) is empty

Ozgur_Sahin

Hello Dear All
I assign a request to an analyst,


but the request is shown on Team works like 



when ı have this problem, I do that, (it helps me)

Stop the cachebuilder service
Run this SQL query against ServiceManagement: TRUNCATE TABLE LastModified
Start the cachebuilder service

but this problem repeats very often.

Brett_Moffett

This is an older version of the portal and my suggestion would be that if you have a valid maintenance agreement, to upgrade to a newer version as this may have been a bug in this version.
The current version is 7.2 so there have been a lot of fixes and improvements since v5.

If you do have a support agreement and are unable to the latest version, I'd suggest logging a support case to investigate if this is a known bug, a configuration or user rights issue.

Ozgur_Sahin

There are a lot of error like this on Cireson Server ;

System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

   at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.BeginExecuteNonQueryInternal(AsyncCallback callback, Object stateObject, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.BeginExecuteNonQueryAsync(AsyncCallback callback, Object stateObject)

   at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl(Func`3 beginMethod, Func`2 endFunction, Action`1 endAction, Object state, TaskCreationOptions creationOptions)

   at System.Threading.Tasks.TaskFactory`1.FromAsync(Func`3 beginMethod, Func`2 endMethod, Object state)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)

--- 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.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

   at Cireson.ServiceManager.DAL.Database.<ExecuteStoredProcedureNonQueryAsync>d__50.MoveNext()

--- 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.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

   at Cireson.ServiceManager.Services.Implementations.ProjectionPersistenceService.<UpdateCacheWithNewWorkItemAsync>d__64.MoveNext()

--- 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 Cireson.ServiceManager.Services.Implementations.ProjectionPersistenceService.<UpdateCacheAsync>d__52.MoveNext()

--- 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 Cireson.ServiceManager.Services.Implementations.ProjectionPersistenceService.<CommitSaveAsync>d__33.MoveNext()

Brett_Moffett

Hi @Ozgur_Sahin
What version of the portal are you running?

Ozgur_Sahin

Hi @Brett_Moffett
Current Portal Version: 5.0.2.1 
but at the last week, we did not have such problem

Brett_Moffett

This is an older version of the portal and my suggestion would be that if you have a valid maintenance agreement, to upgrade to a newer version as this may have been a bug in this version.
The current version is 7.2 so there have been a lot of fixes and improvements since v5.

If you do have a support agreement and are unable to the latest version, I'd suggest logging a support case to investigate if this is a known bug, a configuration or user rights issue.