The exception was raised by the IDataReader interface | AAS Error

The exception was raised by the IDataReader interface: Previously, the ExternalCommandTimeout property in Analysis Services was not correctly handled by the connector. The new implementation now properly enforces this timeout (conceptually from the AS side), explaining the change in behavior.

Error

Failed to save modifications to the server. Error returned: ‘<ccon>The command has been canceled.</ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

Technical Details:

RootActivityId: 86gh6124-6ewq7-4bb0-a52a-50f14bf52eywe31

Date (UTC): 12/4/2024 2:45:13 PM

When/Why Happened?

• AAS model refresh intermittently fails when triggered from ADF or SSMS or Any other automation task. The error message is set in the callback request body.
• Intermittent AAS model refresh failure triggered from ADF or SSMS or SSIS.
• There is some backend updates happened in the month of November and this is impacting most of the AAS servers located in different regions.

Resolution

Step 1: Connect to your azure analysis services (AAS), make sure you have admin access to the server from the account/service principal you are trying to access.

Step 2: Right click and go to server properties, then click on “General” tab and check the box “Show Advanced (All) Properties”

Step 3: Look for “ExternalCommandTimeout” and change the value as required, In my case  the process will take about 80 minutes, so I changes it to 7200 second which is more than my process completion.

Note: The value you enter is in second, so make sure to calculate the value in second, for the time which AAS takes to complete process for model/partitions.

For more about AAS server properties check this doc https://learn.microsoft.com/en-us/analysis-services/server-properties/server-properties-in-analysis-services?view=asallproducts-allversions

Conclusion

Going forward, it was told/advised, whoever is experiencing this issue/problem to increase the ExternalCommandTimeout value based on their refresh duration (as you have been doing) and avoid changing the DataReadingCancellationEnabled setting through XMLA.

TSG’s

1. The Job Failed. Unable To Determine If The Owner (KTTsvc_ssrs19) Of Job
2. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
3. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
4. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
5. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
6. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
7. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
8. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
9. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
10. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
11. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
12. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
13. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
14. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
15. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
16. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)