Azure Analysis services Processing failed

Chandra Prakash Matam 21

Azure Analysis services Processing failed (in memory mode) with message
the remote server returned an error: (400) bad request.
we are using Azure Synapse workspace sql pool as data source

Please note..it is failing after loading after 40-50% data.

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-11-24T21:19:30.243+00:00

hello @Chandra Prakash Matam ,

Thanks for the ask and using the forum .

The error shared is very generic and is not helping much . Did you atleast tried again and did you faced the same issue ? Is the data being loaded is huge ?

Thanks
Himanshu
Chandra Prakash Matam 21 Reputation points

2020-11-25T06:18:46.41+00:00

Hi @HimanshuSinha-msft , thanks for replying
The error shared is very generic and is not helping much -- exactly, wish MS team throw better error message in next versions
Did you atleast tried again and did you faced the same issue ? - multiple times tried, this forum is last resort to find answer
Is the data being loaded is huge ? - of course, 76million
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2020-11-30T20:36:25.317+00:00

Hello @Chandra Prakash Matam ,

It needs someone who can work with you closely as it needs a deeper investigation .

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 create a one-time-free support ticket for you to work closely on this matter.

Thread URL:
Subscription ID:
Subject:Attention Himanshu
Please let me know once you have done the same

Thanks Himanshu

1 answer

Rahul Metangale 106 Reputation points

2021-03-19T08:09:20.377+00:00
Hi @Chandra Prakash Matam ,

You can try following and see if this helps:

Connect to Analysis service from SQL Server Management Studio

Try processing the cube, here in the new window that opens it will tell you which all tables, partitions analysis service is able to process and help you narrow down the issue to specific table or partition

Once you narrow down see if there are duplicate records and may be you were expecting only one record etc in such situations also analysis service refresh fails and it gives generic error

I hope this helps.

Thanks,
Rahul
Please sign in to rate this answer.

0 comments No comments
Sign in to comment