Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Open Service Cases are not populated for the interactions



Open Service Cases are not populated in the history tab, even though developer have open service cases for interactions.

Error Messages

Not applicable

Steps to Reproduce

1. Log into the system and launch interaction portal.
2. Start the interaction and then go to history tab which is in composite view.
3. Observe that open service cases are not populated for the interaction.

Root Cause

Developer is getting zero results from the database when he is running the particular query regarding 'HCServiceItemsByMember' report definition.

This is because there are no entries of member Id column in the 'MEMBER', 'SUBSCRIBER' tables and having this column entry only in 'WORK' table. 

But user is performing inner join on this MEMBER, SUBSCRIBER and WORK tables with member Id column.

It is expected that the member information to be present in all these tables as developer does not have these entries in the other two tables, that inner-join query fails to fetch results. Hence they does not see any service cases in UI.


User is suggested to remove the class joins  of 'HCServiceItemsByMember' report definition  which are under Data Access tab.

Performing the above mentioned local-change will solve the issue.


Published January 12, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us