question

Chinna100-7725 avatar image
0 Votes"
Chinna100-7725 asked AnuragSingh-MSFT commented

Azure Log Analytics.

We have been useing Log Analytics to track all events/Opernatins of SSAS every thing is working fine but since few days the below operations.

But some how some of the Operations are not logging like 'Syncdatabase' and 'memory_metric'


name_s == ""memory_metric""

OperationName == ""SyncDatabase""

Need some help someone who knows how to fix this.

I did not find much forum discussions on Log Analytics.

From all above discussions ,i got that nothing looging for your case.But we are missing only few events/Opernatins.

Thanks....

azure-monitorazure-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.

Please provide more details. It is not clear on how or what is writing to the workspace. Once a connection is established, missing data can usually be tracked back to the source or integration method.

0 Votes 0 ·
Chinna100-7725 avatar image Chinna100-7725 AndrewBlumhardt-1137 ·

We have been useing Log Analytics to track all events/Opernatins of SSAS CUBE every thing is working fine but since few days the below operations.

name_s == ""memory_metric""

OperationName == ""SyncDatabase""


But some how some of the Operations are not logging like 'Syncdatabase' and 'memory_metric'.


0 Votes 0 ·
Chinna100-7725 avatar image Chinna100-7725 AndrewBlumhardt-1137 ·

![197229-image.png][2]


Useing below query to get ssas Cube Sync status. It has been running success fully since long time.
But suddenly stopped to get sync details since 10 days.


//Azure Analysis Service Sync Report
let window = AzureDiagnostics
| where Resource =~ "XXXXXXX" and OperationName == "SyncDatabase"
| where TimeGenerated > ago(7d);
window
| project Resource,OperationName,RootActivityId_g, ResultType,User_s,TimeGenerated

we are getting data if we comment OperationName == "SyncDatabase" .i.e SyncDatabase operation is not captured in logs.

197277-image.png

i am blocked here how to resolve it.

Thanks.


[2]: /answers/storage/attachments/197228-image.png

0 Votes 0 ·
image.png (23.9 KiB)
image.png (68.3 KiB)
AndrewBlumhardt-1137 avatar image
0 Votes"
AndrewBlumhardt-1137 answered

I am not familiar with the specific diagnostic. I assume you followed steps similar to the link below to set this up. Is that correct?

Please verify the diagnostic setting that is not producing the expected result. It sounds like your setting may have changed or there may be a bug in that particular diagnostic.

https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure

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.

AnuragSingh-MSFT avatar image
0 Votes"
AnuragSingh-MSFT answered AnuragSingh-MSFT commented

Hi @Chinna100-7725,

Welcome to Microsoft Q&A! Thanks for posting the question.

I understand that you are not seeing SyncDatabase operations logged in the LogAnalytics workspace from Azure Analysis Service, but other data are coming in. I agree with @AndrewBlumhardt-1137 that it seems to be related to source or integration method. The source would be the "Analysis Service" and integration means steps & settings used to enable the log forwarding to Log Analytics.

In order to narrow down the issue, you may configure one more diagnostic setting, to forward logs to "Azure Storage Account" and examine if you see SyncDatabase operations in there.
Also, based on Synchronize Analysis Services Databases document - "Synchronization is a one-way, one-time operation that concludes once the database is copied. It does not provide real-time parity between the databases.
You can re-sync databases that already exist on source and destination servers to pull the latest changes from a staging server into a production database.
". It might also be possible that SyncOperation are not even happening?

In case you are still facing this issue, I would suggest reaching out to Microsoft Support to investigate this issue 1:1. In case you are facing issue opening the support ticket, please let me know.

Please let me know if you have any questions.


Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

· 4
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.

Hi


197740-image.png





Above are the settings . And we do Cube sync on daily .



0 Votes 0 ·
image.png (122.5 KiB)

We do Sync on daily basis.

0 Votes 0 ·

@Chinna100-7725, I am sorry for the delay in getting back to this thread.
After creating the test diagnostic settings, we you able to see those events in Storage account? Also, I wanted to check if you had a chance to open a ticket with Microsoft Support for it. In case you are facing an issue opening the support ticket, please let me know.

Please let me know if you have any questions.

0 Votes 0 ·