WEBI Report that has been there suddenly stopped working

building reports webintelligence legacy
1

I have a report that runs daily and pulls MTD & YTD data within 3 sec. it stopped working this week. It runs for 40 mins and times out and shows partial data(please see attached). There were no changes besides new data being loaded into the data mart. We ran schema stats but no difference. DBA ruled out that it is not a database issue. There are other WEBI reports against the same db, they are running fine. no changes made to the report. Has anyone seen this issue? Thanks for your help
Score Card - Please check.PDF (44.0 KB)

Vije (BOB member since 2011-05-16)

2

Or to put in another way, there were changes. Surely this is the first thing to investigate?

Nick Daniels :uk: (BOB member since 2002-08-15)

3

No changes to table structures or fields. I strictly meant records being added with daily load. Strangely other reports using the same table run fine. you can see in the attachment, it is pulling daily column. it’s the same data for res of the columns except date range is different

Vije (BOB member since 2011-05-16)