AR
Ali Ryder 🧑‍💼 Staff
7 months ago
Monitoring
RecentActivityDateTime is null

In HIFIS_Clients, a bunch of clients are having null values stored for RecentActivityModuleTypeID and RecentActivityDateTime​ , despite having actions in their file that constitute activity.

So far I cannot detect any commonality between the clients who do have a Recent Activity, and those who don't have any.

Affected software elements

  • Clients Approaching Inactivity report

  • Recent Inactivity report

  • Coordinated Access module

  • Any custom report that includes a "days since last activity" calculation

4
🚦Activity Status ♾️Coordinated Access 🐛Bug 4.0.60.5
👍 4 4
Comments
AR
Ali Ryder 🧑‍💼 Staff

Reported fixed in 4.0.61.1

Reply 8d ago
AR
Ali Ryder 🧑‍💼 Staff

Ryan: We upgraded to HIFIS 4.0.60.4.2 on 2024-10-09, which is when this issue was identified.

Reviewing the database, all clients with a value in the HIFIS_Clients.RecentActivityDateTime field have dates prior to the upgrade date.

Clients created after this date have NULL in both the RecentActivityDateTime and RecentActivityModuleTypeID fields.

Reply 8d ago
AR
Ali Ryder 🧑‍💼 Staff

Nancy: FYI - I logged the issue with HIFIS National back on October 2, 2025. Work Order #16034. The Client State process did not fix it. An example was sent on October 6, 2025 to the Dev Team.

Reply 8d ago
AR
Ali Ryder 🧑‍💼 Staff

Official reply: "Our Dev Team suggest that you should run the sp_CheckClientState stored procedure. Here is the screenshot to show how the stored procedure (with parameter values) should be executed." 

Reply 8d ago