Hi everyone,
I have encountered an error while working with the measurement for the object page, and I'm unsure about the meaning and generation of the "Activity Sequence number." Additionally, I have identified 19 records that are missing in the RESOURCE_ACTIVITY_tab
. I'm curious to know the relationship between the Measurement for Object page and the Resource Activity table. Moreover, I would like to understand how to resolve this error and determine its root cause.
To identify missing records I used the following query:
SELECT * FROM pm_resource_activity_tab t
WHERE NOT EXISTS (
SELECT 1 FROM RESOURCE_ACTIVITY_tab
WHERE RESOURCE_ACTIVITY_SEQ = t.RESOURCE_ACTIVITY_SEQ