Exporting event data to Azure Blob is not working

Question

question

Kim Strasser asked Aug 19, '21

Exporting event data to Azure Blob is not working

I get no error message but Data moved by this export is 0.

In addition, no files were added to Azure Blob.

My custom query code:

['events.all']
| where Timestamp > ago(30d)
| where FullName_Name == 'player_executed_cloudscript'
| extend d=parse_json(EventData) 
| extend ExecutionResult = d.CloudScriptExecutionResult.Error
| where isnotempty(ExecutionResult)

The same code displays many events in Data Explorer (advanced) but exporting the events seems not to work because Data moved by this export is 0.

Is something wrong with my export settings? When exactly does PlayFab export the events when I choose Frequency 24 hours? Is it possible to export the events only sometimes and not at a specific date?

PlayStream

bildschirmfoto-2021-08-19-um-140114.png (126.5 KiB)

bildschirmfoto-2021-08-19-um-140406.png (230.2 KiB)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2021-08-20T06:43:12Z

Rick Chen answered Aug 20, '21

>> Is something wrong with my export settings?

It looks OK. When is your exporting events to Azure Blob set up? Could you please check your Azure Blob container and see if there is any exported event files?

>>When exactly does PlayFab export the events when I choose Frequency 24 hours?

You can check modified time of the exported event files in your Azure Blob container. It seems the time is not fixed.

>>Is it possible to export the events only sometimes and not at a specific date?

You can manually set the event export as active or inactive, but currently there is no config to set a schedule time to decide when it should export and when it should not.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kim Strasser commented · Aug 20, 2021 at 08:00 PM

It works now. The problem was that there were no new PlayStream events created after I created the Event Export.

I downloaded the json.gz files in Azure Blob but the files are not easy to read because they look like this:

Is it possible to open the downloaded .json files in Data Explorer (advanced) or another application where I can better read the events? In addition, I want to query and sort the events by PlayFabId or occurred error.

There are no files in my Azure Blob container:

0 ·

bildschirmfoto-2021-08-21-um-093822.png (460.8 KiB)

Rick Chen ♦ Kim Strasser commented · Aug 23, 2021 at 08:48 AM

Here is a document I found, about the data ingestion for Azure Data Explorer. Data ingestion is the process used to load data records from one or more sources to import data into a table in Azure Data Explorer. Once ingested, the data becomes available for query. However, it may require database ingestor or higher level permissions to do that. For this type of questions, please contact the Azure team for help.

0 ·

question