Skip to main content

  

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


 

Be the first to reply!

Reply