refresh of model doesn't finish with out any errors

Arthur Steijn 26

So let me try to describe the scenario.

We have a model, that is around 10 Gb.
Source is an oracle database.
A normal refresh takes somewhere between 40 and 50 minutes. We do a full refresh of the complete model.
The model is deployed on four environments with Azure pipelines. With the help of the Tabular Editor.

So far so good.

Recently we have troubles getting te model refreshed, sometimes...

At first I thought it had something to do with the TotalMemoryLimit, since it always was around 80% of the server capacity. Scaled up to S2 doesn't help.

Now I think it has something to do with adding new tables and new calculation groups.

If I don't 'pre-process' the new tables in SSMS the refresh keeps on running, without any timeout or error. I have now tried this a few times on my Acceptence and Test environment. See also the screenshot of the memory usage during this process!

Anyone reported this or seen this before?

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-07-23T00:59:23.783+00:00
Hi @ArthurSteijn-8111,

Welcome to Microsoft Q&A platform and thanks for your query.

This issue requires a deeper analysis. For deeper investigation and immediate assistance, If you have a support plan you may file a support ticket, else could you please send an email to AzCommunity@Microsoft.com with the below details, so that we can enable a one-time-free support for you to work closely on this matter.

Email subject: <Attn - Kranthi : MSDN Thread title>

Thread URL: <MSDN Thread>

Subscription ID: <your subscription id>

Please let us know here, once you have done the same.

Thank you
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-07-25T00:36:01.103+00:00

Hi @ArthurSteijn-8111,

Following up to see if you have got a chance to see my previous comment. If so could you please share the details as requested. In case if you have already found a resolution, please do consider to share it here with community as it would help others reading this thread.

Thank you
Arthur Steijn 26 Reputation points

2020-07-25T08:16:26.587+00:00

Hi,

I made a support ticket in the portal. No solution yet.

KR,
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-07-28T23:40:53.73+00:00

Hi @ArthurSteijn-8111,

Thanks for your response. Could you please share the SR# with me so that I can followup with the internal teams.

Thank you.
Arthur Steijn 26 Reputation points

2020-07-29T07:26:37.76+00:00

Hi, Sure

120072321000671
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-07-30T06:14:05.61+00:00

Thank you for sharing the details @Arthur Steijn . Seems like Support engineer has requested the gateway logs for deeper analysis. I will closely monitor this case and will followup with support engineer as needed.

Thank you for your patience.