question

mcprakash avatar image
0 Votes"
mcprakash asked RahulMetangale-9479 answered

Azure Analysis services Processing failed

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.

azure-analysis-services
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

hello @mcprakash ,

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

0 Votes 0 ·

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


0 Votes 0 ·

Hello @mcprakash ,

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

0 Votes 0 ·

1 Answer

RahulMetangale-9479 avatar image
0 Votes"
RahulMetangale-9479 answered

Hi @mcprakash,

You can try following and see if this helps:
1. Connect to Analysis service from SQL Server Management Studio
2. 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
3. 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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.