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

Xiaoqian_LiXiaoqian_Li Customer IT Monkey ✭
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.

Answers

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    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_LiXiaoqian_Li Customer IT Monkey ✭

    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.

Sign In or Register to comment.