Duplicate Transactions Created in WIP tables

Products

• Clarity PPM On Premise

Issue/Introduction

There are duplicate transactions observed in the following Clarity pages:
1. Home > Financial Management > Transactions
2. Home > Financial Management > Posted Transactions Review 

Environment

All Clarity versions

Cause

The job can be run from the Clarity locations:
a. Home > Financial Management > Post to WIP
b. Home > Report and Jobs > Available jobs
c. From a process

The root cause is unknown, however when reported it is likely due to a non-reproducible environment which may involve one or more of the following symptoms:
1. Multicast issue
2. Disruption in the background service
3. Issue with Post Timesheets job

 

Resolution

Run the following query to determine how widespread the issue is:

Please complete and run the following SQL
NOTE: Export the results to an .XLS file with column header names.
===========================================================
SELECT
COUNT(transno),
EXTERNALBATCHID,
EXTERNAL_ID, TRANSDATE, QUANTITY, TASK_ID, RESOURCE_ID,
CHARGE_CODE, INPUT_TYPE
FROM ppa_wip
WHERE sourcemodule = 51
AND status = 0
GROUP BY
EXTERNALBATCHID, EXTERNAL_ID, TRANSDATE, QUANTITY, TASK_ID, RESOURCE_ID, CHARGE_CODE, INPUT_TYPE
HAVING COUNT(transno)>1

Please contact the Support team to review the results.