Gateway performance monitoring broken with february update

[David_V]

Hello,

I used the monitoring to find the queries that took much time/cpu (cf. https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance)

It was working fine with december version of the gateway but today I've updated the gateway (february update) and this is not working anymore.

The problem is in the "QueryExecutionReport" log file. A few columns have been added and the format is not correct: there is some decimal numbers in the new columns and these numbers seems to be configured with commas (and not dot). As the format of the log file is as csv with comma as separators the file is incorrect.

I tried to change the separators in the windows language settings but it didn't worked.

[v-chuncz-msft]

@David_V 

Take a look at this post and create a support ticket for assistance if necessary.

[David_V]

Thanks for your response.

I already tried to change the region settings but it seems that the gateway in not taking these parameters into account. I think the problem could be seen with any language and can be reproduced easily:

• enable logging in gateway (follow my link to see the steps)
• restart gateway
• refresh some data using the gateway
• try to read generated logs using  the monitoring template (https://download.microsoft.com/download/D/A/1/DA1FDDB8-6DA8-4F50-B4D0-18019591E182/GatewayPerformanc...)
• the template failed to decode logs (problem in "QueryExecutionReport" log file)

[Anonymous]

@David_V 

Did you solve this issue? 

We are experiencing the same issue.

[David_V]

I didn't try recently but it seems that nothing as been done for this so I doubt that it works now...