Update analysis view timeout on SAAS BC

leegeorge@taigsolutions.co.uk

Hello,

We have a large customer running SAAS for the last 10 months and until 4 weeks ago update analysis views was working fine.

All of a sudden, the job queue running the update analysis views process (report 84) kept timing out after 30 minutes. (standard SQL timeout on SAAS)

Copied the live environment to a sandbox to investigate the issue and running the process completes in 7 minutes!!

I have tried copying the database a dozen times and each time the process runs flawlessly in the sandbox.

I have ran the performance profiler in live and you can see that the process doesn't get past the select statement for GL Entry.

I have tried to run multiple times in Live out of hours with no users logged in and no job queue processes active and get the same error every single time.

Raised a ticket with Microsoft to investigate. I thought that it may be that the index on GL Entry table is fragmented - my logic is that the SQL indexes would be rebuilt when restoring the database into the sandbox and that would explain why it works every time in sandbox.

Microsoft are saying its not that - the ticket is still with them since 18/08 and they still don't have a solution.

The customer is doing their nut (understandably)

Does anyone have any ideas or have similar experience?

many thanks