Error While a partition is processed: "The JSON DDL request failed with the following error: The server sent an unrecognizable response.;Root element is missing"

Irama Abello Moreno 0

We got this error when it was processing a tabular model partition in SSAS from an SSIS package. This is the JSON that process the partition: { "refresh": { "type": "full", "objects": [ { "database": "ClicksterToday", "table": "Clickster", "partition": "CLICKSTER Today 0" }] } }

Note: The partition is processed every 10 seconds and sometimes this error is shown. Could you help me, please? How Can I fix it? Thanks

Greg Low 1,495 Reputation points Microsoft Regional Director

2024-02-12T10:47:41.44+00:00

When I've seen similar messages in the past, it's because what has come back is a warning message rather than a standard processing response.

How are you catching the response? Are you assuming it can be converted to JSON?

As an example, one possible cause of a message coming back would be if the previous processing was still running.
You might be able to see it by executing the JSON manually in SSMS every ten seconds, and see what comes back.

Share via

Error While a partition is processed: "The JSON DDL request failed with the following error: The server sent an unrecognizable response.;Root element is missing"