SYMPTOM
In Strategy Enterprise Manager 9.4.x, the report "4010. User Session Activity" does not return any data even though the statistics repository shows user session information logging successfully.
CAUSE
This is a known issue with report "4010. User Session Activity" in the Strategy Enterprise Manager 9.4.x project. This issue is seen due to a join with the empty table IS_ATT_ATT_FORM and therefore, returns no data.
ACTION
This issue has been resolved in Strategy 10.0 and higher versions. Upgrade to the latest Strategy platform release or feature release version to take advantage of the fix.
WORKAROUND
Users can modify the schema relationship between the project and session attributes from "Many to Many" to "One to Many" as shown below.
After the schema modification, users will need to update the schema for the relationship to take effect. The Enterprise Manager report 4010 should not be accessing the IS_ATT_ATT_FORM table after the change.
Metadata Modification:WARNING:
Manually editing values in the Strategy Metadata incorrectly may cause serious, project-wide problems that may make your project unusable. Since these are user-initiated changes, they are not covered by any Strategy warranty. Users are strongly encouraged to backup Metadata prior to any alteration.
