Hi @MandeepGupta,

Last week, we ran the "Synchronize Hierarchy" process to update the CMP_CWB_HRCHY_CF_DN table. After this activity, the report was functioning correctly for the processed plan and period, and the data was present in the table.

However, since yesterday, something is not working anymore, and the data for the processed period is no longer available in the table. We tried to rerun the "Synchronize Hierarchy" process, which had not been executed again.

The first time, we ran it without checking the "Force refresh to rebuild the hierarchy even though the synchronization process was run" option, and the logs indicated that the data was processed, but there was no trace of it in the table. On the second run, we used the 'Force refresh to rebuild the hierarchy even though the synchronization process was run' option, and the data was extracted into the table, allowing the report to retrieve them.

Additionally, we are encountering a strange error that we have never seen before: "Failed to load SQL." This occurs when we try to create a Data Model with a simple query like "SELECT DISTINCT TOP_PERIOD_ID FROM CMP_CWB_HRCHY_CF_DN" or "SELECT DISTINCT TOP_PLAN_ID FROM CMP_CWB_HRCHY_CF_DN."

Have you ever encountered a similar issue?

Is there any other process that could affect the loading of the CMP_CWB_HRCHY_CF_DN table?

Thank you very much in advance!

Hi @MandeepGupta,

Thank you for your response.

I have conducted several tests, and I am encountering the error exclusively with the CMP_CWB_HRCHY_CF_DN table. Specifically, the error arises when I use fields that start with "TOP_", such as TOP_MGR_PERSON_ID, TOP_MGR_PERSON_EVENT_ID, TOP_PLAN_ID, or TOP_PERIOD_ID.

I can create a Data Model without any issues using queries like "SELECT * FROM PER_ALL_PEOPLE_F" or "SELECT * FROM CMP_CWB_HRCHY_CF_DN." However, when I attempt to create a Data Model with a SELECT query that includes any of the TOP_ fields (e.g., "SELECT TOP_PERIOD_ID, PERSON_ID FROM CMP_CWB_HRCHY_CF_DN"), I receive the error "Failed to load SQL." In contrast, if I use a query like "SELECT PERSON_ID, HRCHY_CF_DN_ID, ASSIGNMENT_ID FROM CMP_CWB_HRCHY_CF_DN," no error occurs.

Once I receive the error, after the click on the OK button in the DataSet, the Data Model becomes unusable, and I have to reload the page.

Do you have any idea what the problem might be?

If you can run a test, are you experiencing the same problem?

Thanks