Kusto queries are failing

[krishnc]

I have created a KQL database on top of a DataWarehouse and created a report using KQL queries.

It worked fine before. Today I am getting this error.

"Partial query failure: Unspecified error (message: 'PQV3:: LibErr: EOF: Expected to read 795378 bytes of page, read only 795377: ', details: 'StgError { kind: Generic("PQV3:: LibErr: EOF: Expected to read 795378 bytes of page, read only 795377"), source: None }')."

Anyone faced this issue? Please suggest a solution if so.

[Anonymous]

Hi all,

I apologize for the late reply. It looks like this is an internal error, but I wasn't able to reproduce your issue during testing in the meantime. 

I suggest you open a support ticket to get more detailed information and a dedicated Microsoft engineer will come to solve the problem for you.

The link of Fabric Support: Microsoft Fabric Support and Status | Microsoft Fabric

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Fabric Community

Best Regards,
Dino Tao

[mansivora]

Do you have any updates/recommendations? We are facing similar issues with a kusto query that used to run without any issues in Dec. Here's the error message:

UnderlyingErrorMessage=Partial query failure: Unspecified error (message: 'EOF: Expected to read 835811 bytes of page, read only 835808: ', details: 'StgError { kind: Generic("EOF: Expected to read 835811 bytes of page, read only 835808"), source: None }')

[Krumelur]

We just started seeing the same problem. KQL query always errors with this "partial query one-byte-off" error. Underlying Delta table and SQL endpoint are working fine. I have tries recreating the shortcut. No luck. 

[Anonymous]

Hi @krishnc ,

Judging from the error, it seems that there is a problem with the data integrity of your KQL database. Please check whether your KQL database has deleted some data or has any structural changes recently. If you have a recent backup of your data warehouse, consider restoring it to see if the problem persists. This can help determine if the problem is with the data itself.
Also sometimes rebuilding indexes can help resolve such issues. You can rebuild indexes on the affected tables.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[krishnc]

Thank you Dino Tao.. Appreciate your time for taking time to respond. Let me add more details. My setup is like this. I have a DW, EH (created on top it DW) and created ShortCuts to the tables in the DW. I have created 2 reports (one on the KQL and another on the DW using PowerBI. My PowerBI report is working fine. But KQL report is throwing this error. If the data integrity breaks, both reports will get effected. But Power BI report is running fine. 

If I retrospect, the changes I made off late is increasing Fabric Capacity to 64 and also CU to the Max (50) in the EventHouse. Any one from RTI team can throw some light on this issue. The error message is StgError { kind: Generic("PQV3:: LibErr: EOF: Expected to read 795378 bytes of page, read only 795377"), source: None }