There have been several cases in which clients have raised a discrepancy whereby completed journeys display as in progress when queried through Advanced Reporting. This KBA provides useful links to past cases and outlines troubleshooting steps:
Troubleshooting:
First, check the SQL query being used by the client. It could be that the query is filtering out some in-progress journeys.
Ask the client for any examples of journeys that display as completed but that can be confirmed as having a status of in progress in Advanced Reporting (they may not have this information to hand because it is not possible to get an extract of the data of all in progress journey IDs directly from the journey/task dashboard). The following SQL query can be used to check this:
SELECT journey.id, journey.status
FROM journey
WHERE journey.id = ''
On the test tenant being used, open the main Fen-X dashboard. Click 'Load all' at the bottom of the journey/task dashboard. Filter the dashboard to only return 'In Progress' journeys. Observe the amount of journeys listed.
In Advanced Reporting, run the following SQL query:
SELECT status, COUNT(*)
FROM journey
GROUP BY status
Observe the amount of 'In Progress' journeys listed.
Expected: the number of journeys listed matches
Observed: There is a discrepancy
In previous cases, the root cause has been a syncing issue with Advanced Reporting.