SSRS 2025.2.3 Public Cloud - Epicor reporting not seeing uploaded RDL

I believe there’s an underlying issue that first showed up around 2024.x and has become much more common in 2025.2, where custom reports fail with a “/SaaS####PilotSSRS_######/reports/customreports/Tenants/######/… cannot be found” error. From what I can tell, it’s related to how the SystemFlag is set in the Ice.ReportStore view. The function that drives this flag passes the print program path as a 100-character parameter and checks for an exact match in Ice.CustomReportStore. If it doesn’t find one, it marks the report as a system report (SystemFlag = 1), which seems to prevent the report from running, even when the RDLs exist on the server.

A good sign that you’re hitting this problem is if the error message includes a very long full path that starts with something like /SaaS####PilotSSRS_######/reports/customreports/Tenants/######/… the bolded portion adds about 40–41 characters to the path for cloud customers, which pushes many print program values past the 100-character limit on that SystemFlag function. Earlier versions only recorded relative paths to the CustomReportStore table, so this wasn’t as noticeable, but now that it records the full path, the function truncates it and can’t match correctly.

Based on testing, the only reliable fix I have found is to make sure your full print program path, including the tenant prefix, folders, and report name, stays under 101 characters. The Copy function in Report Style Maintenance can still work as a temporary workaround (since it skips the upload process that writes a record to the CustomReportStore table), but once you re-upload, the issue returns if the path is too long. Since the full path adds about 40 characters, keeping your report style name around 50-55 characters or less seems to prevent the problem. I’ve shared these findings with Epicor Support, and it’s currently under review.

4 Likes

Wow Jennifer! Thank you for the info!

To follow up on Jennifer’s findings, we finally got a PRB on this issue… nothing mentioned about 2024.2 on it.
PRB0308049 Submitted to Development 2 - Defect, no workaround

Description

PROBLEM DESCRIPTION: Custom SSRS Report records on the Ice.CustomReportStore table with a PrintProgram value length greater than 100 always incorrectly shows as having SystemFlag=1/true in the results of the Ice.ReportStore view, when it should always show as having SystemFlag=0/false.

EXPECTED BEHAVIOR: All custom SSRS report styles should always return a SystemFlag =0/false in the Ice.ReportStore view.

SOFTWARE AND DATABASE INFO: 2025.1.11 | 2025.2.5
ABLE TO RECREATE IN TRAINING db: yes

1 Like