Upgrade to Version 2.9-GA-6.0-6.4 resulted in existing approval settings not working

[Colleen Vollmer]

Good evening,

We recently upgraded to Herzum Version 2.9-GA-6.0-6.4 and now all of the tasks linked to existing approval workflows are no longer working.  The approval request button is never enabled, the only way to get it to show up is to manually edit each task and set the approval workflow.   Please advise as to whether this issue has been reported and the estimated date that a fix will be available.

Thank you,

Colleen

[Colleen Vollmer]

Thanks Antonella. The immediate fix that you provided worked for us.  The additional information you requested is below:

1. Values stored in the fields IS_LOCKED and IS_DRAFT belonging to the table AO_D195E9_APPROVAL_MAPPING table? NULL or 0

2. Database Used SQL Server 2008

3. Database Collation SQL_Latin1_General_CP1_CI_AS

[Antonella Capalbo]

Colleen,

we have reproduced the issue by forcing an unexpected value Null (expected 0) stored on the Database for the field IS_LOCKED belonging to the table AO_D195E9_APPROVAL_MAPPING.

I need you validate this scenario to fix that.

Can you please have a check on values stored in the fields IS_LOCKED and IS_DRAFT belonging to the table AO_D195E9_APPROVAL_MAPPING table?

Additional helpful information consist of: used Database and Database Collation.

If it is the scenario you are encountering, it can be immediately fixed by following the steps below:

1. On the Approval Mapping Administration screen, click edit on the right of the affected mapping
2. On the Edit Approval Mapping screen just un-check and check again the AWT box
3. Click save and update data
4. If the mapping status become locked, just wait few seconds (depending by the number of issues needing to be made consistent) and then click Refresh.

When the mapping status turn to be Valid, review the approvals on the already existing defected issue and on the new one created associated to the specific mapping, we expect that them should be displayed as expected.

Please, let me have your feedback.

Regards

[Colleen Vollmer]

Antonella,

I have done additional testing and I'm finding that this issue is occurring across both issues that were in progress at the time of the upgrade as well as newly created issues.

I've attached a copy of a document with screen shots that illustrates the issue that I'm encountering.

Thank you,

Colleen

[Antonella Capalbo]

Hi Collen,

until now any attempt to reproduce the bug has not been successful.

On your last comment you said that 'this is only happening on work items in flight', can you please better explicate? 

We need further information to be able to reproduce it.

As first, we need the screenshots of an issue were the bug is reproduced, the associated mapping and the approval configuration.

Additional helpful information consist of: used Database, Database Collation setting, Approval Logs when displaying the affected issue.

Regards

[Colleen Vollmer]

Antonella,

Following up with you regarding this issue.  Has the team been able to recreate the problem that I am reporting and if so, do you have a rough estimate on when a fix may be available?

Thank you,

Colleen

[Colleen Vollmer]

Antonella,

The status of the approval workflow is active, yet when work items enter the defined status, the approval feature does not enable.  I will mention, this is only happening on work items in flight when we upgraded.  Newly created work items are not experiencing the same problem.

Thank you,

Colleen

[Antonella Capalbo]

Can you please check the Status of your Approval Mappings?
If you don't display the green icon as showed on the following screenshot you can fix the issue by following the guide lines illustrated on https://chicago.herzum.com/confluence/display/HAP/Configure+an+overall+Approval+Mapping
ApprovalMappingAdministration.PNG
Please, let me have your feedback.
Regards