WI status in Portal won't get updated unless do a recycle on application pool

Xiaoqian_Li

Recently we upgrade Cireson Portal from version 2012 to 2016. Somehow the WI status won't get updated until I manually do a recycle on application pool. The cache builder service received an error on "DecisionID was null" and therefore unable to sync WORK ITEMS. Does anybody have this before? Thank you.

Brian_Wiest

Recommend you attempt to flush the Cireson database, could be you have a Review activity that is not in the database properly.

Stop the cachebuilder
In SQL

TRUNCATE TABLE ServiceOffering;

TRUNCATE TABLE RequestOffering;

TRUNCATE TABLE WorkItem;

TRUNCATE TABLE CI$User; 

Truncate Table GroupMembership_CI$DomainGroup_CI$User

DELETE CI$DomainGroup Where TeamGroup = '0';

DELETE DisplayString WHERE ElementID IN (SELECT EnumerationID FROM Enumeration WHERE CreatedBy = 'c6745a66-5ccc-4fbc-b1d8-ab9797cdea2d');

DELETE Enumeration WHERE CreatedBy = 'c6745a66-5ccc-4fbc-b1d8-ab9797cdea2d';

TRUNCATE TABLE LastModified;
Start the cachebuilder
Monitor the log. 

Xiaoqian_Li

Thank you for the instruction. I tried and received the same error "ReviewActivityId was null.";"Unable to sync WORK ITEMSWork Items". We recently upgraded to Portal V8.2.0.2016. Before that, we don't have the issue although null of reviewactityID does exist. Please help.

2017-11-13 08:01:56,827, INFO  [   4]:  ============== SYNCING WORK ITEMS ==============
2017-11-13 08:01:56,889, INFO  [   4]:  Updating work item parent -> child relationships lookup table
2017-11-13 08:01:56,920, INFO  [   4]:  Successfully updated work item parent -> child relationships lookup table
2017-11-13 08:01:56,920, INFO  [   4]:  Updating Incidents
2017-11-13 08:01:57,686, INFO  [  13]:  Updating Change Requests
2017-11-13 08:01:57,686, INFO  [  13]:  Support group table: , column:
2017-11-13 08:01:58,358, INFO  [   4]:  Updating Service Requests
2017-11-13 08:01:59,373, DEBUG [   4]:  Copied 500 rows.
2017-11-13 08:01:59,592, INFO  [   5]:  Updating Problems
2017-11-13 08:01:59,795, INFO  [  14]:  Updating Release Records
2017-11-13 08:01:59,998, INFO  [   5]:  Updating Manual Activities
2017-11-13 08:01:59,998, INFO  [   5]:  Support group table: , column:
2017-11-13 08:02:00,702, DEBUG [   5]:  Copied 500 rows.
2017-11-13 08:02:00,780, DEBUG [   5]:  Copied 1000 rows.
2017-11-13 08:02:00,842, DEBUG [   5]:  Copied 1500 rows.
2017-11-13 08:02:01,217, INFO  [   4]:  Updating Review Activities
2017-11-13 08:02:01,905, DEBUG [   4]:  Copied 500 rows.
2017-11-13 08:02:02,248, INFO  [   4]:  Updating affected configuration items
2017-11-13 08:02:02,592, DEBUG [   4]:  Copied 500 rows.
2017-11-13 08:02:02,655, INFO  [  15]:  Updating related configuration items
2017-11-13 08:02:02,842, DEBUG [  15]:  Copied 500 rows.
2017-11-13 08:02:02,967, DEBUG [  15]:  Copied 1000 rows.
2017-11-13 08:02:03,015, INFO  [   5]:  Updating reviewers
2017-11-13 08:02:03,639, DEBUG [   5]:  Copied 500 rows.
2017-11-13 08:02:03,670, INFO  [   5]:  Updating reviewers
2017-11-13 08:02:03,748, ERROR [   5]:  ReviewActivityId was null.
2017-11-13 08:02:03,748, ERROR [   4]:  Error:
System.NullReferenceException: ReviewActivityId was null.
   at Cireson.CacheBuilder.Service.Util.ServiceManagerUtil.GetColumnValue[T](ISqlDataReaderWrapper reader, String columnName)
   at Cireson.CacheBuilder.Service.Util.Readers.GetWorkitemReviewRow(ISqlDataReaderWrapper reader)
   at Cireson.CacheBuilder.Service.Util.ServiceManagerUtil.<Read>d__5`1.MoveNext()
   at System.Data.SqlClient.SqlBulkCopy.ReadFromRowSourceAsync(CancellationToken cts)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Cireson.ServiceManager.DAL.Database.<BulkCopyAsync>d__47`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Cireson.ServiceManager.DAL.Database.<UpsertAsync>d__20`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Cireson.CacheBuilder.Service.Commands.WorkItemCommand.<>c__DisplayClass7_0.<<Synchronize>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Cireson.ServiceManager.DAL.Database.<Retry>d__11.MoveNext()
2017-11-13 08:02:03,764, ERROR [   4]:  Unable to sync WORK ITEMS, the operation failed permanently. Please review the log for errors, correct them, then restart the cachebuilder service.