The complete error is attached to the post. When I drill down or up on date column in a chart in an SAC story, I am getting this error. Please suggest what can be done to resolve this.
If you use HANA Calculation Views as data source for your SAC Story / Model, you may need to re-generate / activate the Calculation View in HANA then try / test again; it may resolve the issue. Error "306105: Invalid query" usually means there are missing things on HANA level as you triggered a sub query with filtering.
Hi Tuncay, Thank you for the response, however, we are using a CDS view for the model and not a calculation view, the datasource being SAP Hana. Any suggestions on the error given that we are using CDS view?
If your CDS View is a custom CDS View you can take look into the code and re-generate too.
If your CDS View is a standard view there might be issue on backend side for not only on CDS View itself but backend ABAP Pipeline. You can check recently updates SAP Notes and run CNV_NA_DI transaction (program CNV_NOTE_ANALYZER_DI) in your system to see if more notes need to be applied; see more information as an example: What’s New in SAP Datasphere Version 2024.6 — Mar 12, 2024
Also you can check your back runtime errors and system logs for more details for the error. I'm sure you can find more information regarding the error.
Have you checked the error on me.sap.com? There are many notes for "Error 306105: Invalid query" that might not be directly your case but it may give you an idea.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.