Backlinks missing from user/group/position activities

Last update: 31 January 2018

Backlinks missing from user/group/position activities

Summary

In Fabasoft Folio/eGov-Suite 2012 to 2014, an issue is known with user/group/position activities, where the backlinks to assigned activities may not be correctly inserted. Due to this the affected activities might not be shown for the assigned user/group/position.

On the other side it is possible, that completed activities may be left over in the assigned activities, this may lead to longer load times if a high number of completed activities is present for a certain user/group/position/organisational unit.

The issue is fixed in current builds of the named product versions. If you do not use a current build or the latest Update Rollup, a hotfix is available from Fabasoft.

Information

Due to the nature of the issue any user/group/position may be affected but users/groups/positions that are involved in a high number of (parallel) activities are at an especially high risk of being affected. There is currently no known scenario where information on the activity backlink is lost, as only one the user/group/position side of the backlink is lost and may be restored with information stored in the affected activity.

Solution

A hotfix for this issue and all affected versions is available. Please contact Fabasoft Support including your current version and build number.

 

Due to the nature of the issue the hotfix will only apply to newly created backlinks, therefore the following scripts have been developed to analyse and if necessary fix the activity backlinks in your system.

These scripts are independent of the Hotfix mentioned above and you can run the Collect Activities script on your system now to see if it is affected by the issue.

For instructions on executing the following scripts please refer to the knowledge base article Executing Expressions without Expression Tester .If you need any further assistance please contact Fabasoft Support.

Scripts for missing activities

Instructions for Collect Activities v1 and Collect Activities 2012 v1:

The script Collect Activities v1 and Collect Activities 2012 v1 is used to find all affected activity backlinks and if necessary collect the corresponding activities in a predefined admin tool.

Variables:

  • @collect :
    • true : Broken activities will be collected in the @target admin tool.
    • false : Information on the affected activity backlinks will be printed to the tracer, but activities will not be added to @target.
  • @target : COO address of the admin tool where the identified broken backlinks will be added to.
  • @range :
    • false : All possibly affected activities in the system will be checked.
    • true : Only possibly affected activities in the date range between @start and @end will be checked.
  • @start : Beginning of the date range.
  • @end : End of date range. To ensure the correct analysis this should be set to at least 2 hours in the past.
  • @fetchsize : Number of objects to be fetched per search.

Downloads Collect Activities

  • For Fabasoft Folio or Fabasoft eGov-Suite 2013 and upwards use:  Collect_Activities_v1
    (SHA1: F1590359360D2C0631EDF7871C4D3A7869653730)
  • For Fabasoft eGov-Suite 2012 and Fabasoft eGov-Suite 2012 Sp1 use:  Collect_Activities_2012_v1
    (SHA1: 3CE84D78F6C565A8C1B12B5BFE9231CE8DCD7961)
Instructions for Fix Activities:

The script Fix Activities v4 is used to fix affected activity backlinks.
During the process the following rules apply:

  • Activities that reference ghosts have to be reassigned manually and will not be processed.
  • Activities where the automatic fix fails will remain in the @source admin tool. If the automatic reassignment fails multiple times, a manual check is necessary.
  • If an activity doesn't require any action it will be moved to the @oknc admin tool.
  • Activities that have been fixed sucessfully will be moved to the @ok admin tool.

Variables:

  • @change :
    • true : Commit changes to the activities from the @source admin tool.
    • false : Print proposed changes to the tracer.
  • @source : COO address of the source admin tool activities will be read from.
  • @ok : COO address of the admin tool fixed activities will be added to.
  • @oknc : COO address of the admin tool that uncanged, but correct activities will be added to.

Download Fix Activities

  • For all versions use: Fix_Activities_v4
    (SHA-1: DF46936301F0D23016622B33464BEE9055D295A2)

Script for leftover activities

Instructions for Remove Completed Activities:

The script Remove_Completed_Activities_v1 is used to remove activity backlinks that are left over from users/groups/positions/organisational units.

Variables:

  • @change :
    • true : Commit changes to the activities from the @source admin tool.
    • false : Print proposed changes to the tracer.
  • @userschk/@groupschk/@positionschk/@orunitschk :
    • true : Use the accordant query to check users/groups/positions/organisation units.
    • false : Do not check this type.
  • @verbose:
    • true : List unaffected but checked objects
    • false : List only affected objects.

Download Fix Activities

Applies to

  • Fabasoft Folio 2013 and Update Rollups 1-4
  • Fabasoft Folio 2014 and Update Rollups 1-4
  • Fabasoft eGov-Suite 2012
  • Fabasoft eGov-Suite 2012 SP1
  • Fabasoft eGov-Suite 2013 and Update Rollups 1-4
  • Fabasoft eGov-Suite 2014 and Update Rollups 1-4

Further questions?