I am using kqlmagic to connect to Kusto and getting report from there.
Connect via: The Microsoft Entra code method prompts MSAL interactive sign-in. You'll receive a code to enter for authentication.
%kql AzureDataExplorer://code;cluster='';database=''
Issue: Same script works maybe a few hour go, but later got stuck in something like this forever.
General_BadRequest: Request is invalid and cannot be executed.
Error details:
ClientRequestId='Kqlmagic.execute;c6dde4f8-e13e-44eb-af97-14450b6cbf1e/521e9d08-1103-41fe-99db-621b16bc364a/AzureDataExplorer', ActivityId='f7c01a92-7e13-41d8-8f3e-6112aaae0faa', Timestamp='2024-03-15T00:23:07.0500300Z'.
No issues to run the same query in Kusto directly.
Tried to run Jupyter notebook locally and in Azure ML workspace. Same thing happened.
Restarted kennel, add -!se and generate bug report:
{
"Kqlmagic_last_execution": {
"args": {
"cell": null,
"line": " -!se -query experiment_id_query",
"override_connection": null,
"override_options": null,
"override_query_properties": null,
"override_result_set": null,
"override_vars": null
},
"connection": "TestMetrics_Prod@...._westus2",
"log": [
"Kqlmagic_core::execute - input: \n\rline: -!se -query experiment_id_query\n\rcell:\n\rNone",
"Kqlmagic_core::execute - parsed_queries: [{'connection_string': '', 'query': '\nExecutionTelemetryIngestionProd01\n| extend experiment = customDimensions.experimentn\n| extend experimentId = tostring(experiment.id)\n| extend executionGoal = tostring(experiment.metadata.executionGoal)\n| extend experimentStatus = tostring(experiment.status)\n| where executionGoal in (\'local-disk-single-0312\', \'local-disk-multi-0313\')\n| where experimentStatus in ("Succeeded", "InProgress")\n| distinct executionGoal, experimentId, experimentStatus\n| order by executionGoal\n', 'options': {'auto_dataframe': False, 'short_errors': False, 'feedback': True, 'show_conn_info': None, 'columns_to_local_vars': False, 'show_query_time': False, 'show_query': False, 'show_query_link': False, 'query_link_destination': 'Kusto.WebExplorer', 'enable_suppress_result': True, 'plotly_fs_includejs': False, 'popup_window': False, 'auto_limit': 0, 'display_limit': None, 'timeout': None, 'prettytable_style': 'DEFAULT', 'last_raw_result_var': 'kql_raw_result', 'table_package': 'prettytable', 'plot_package': 'plotly', 'dsn_filename': 'odbc.ini', 'validate_connection_string': True, 'auto_popup_schema': True, 'json_display': 'formatted', 'schema_json_display': 'auto', 'palette_desaturation': 1.0, 'params_dict': None, 'palette_name': 'tab10', 'cache': None, 'use_cache': None, 'temp_folder_name': 'temp_files', 'cache_folder_name': 'cache_files', 'export_folder_name': 'exported_files', 'add_kql_ref_to_help': True, 'add_schema_to_help': True, 'enable_add_items_to_help': True, 'notebook_app': 'visualstudiocode', 'debug': False, 'check_magic_version': True, 'show_what_new': True, 'show_init_banner': True, 'is_kernel_intializtion': False, 'warn_missing_dependencies': True, 'warn_missing_env_variables': True, 'allow_single_line_cell': True, 'allow_py_comments_before_cell': True, 'kqlmagic_kernel': False, 'extras_require': 'default', 'test_notebook_app': 'none', 'cloud': 'public', 'enable_sso': False, 'sso_db_gc_interval': 168, 'auth_use_http_client': False, 'try_azcli_login': False, 'try_azcli_login_by_profile': False, 'try_vscode_login': False, 'try_azcli_login_subscription': None, 'try_token': None, 'try_msi': None, 'request_id_tag': None, 'request_app_tag': None, 'request_user_tag': None, 'request_user_agent_tag': None, 'request_cache_max_age': 0, 'device_code_login_notification': 'auto', 'device_code_notification_email': '', 'save_as': None, 'save_to': None, 'query_properties': {}, 'palette_colors': 10, 'palette_reverse': False, 'popup_schema': False, 'display_id': False, 'display_handlers': {'acquire_token': None}, 'popup_interaction': 'auto', 'temp_files_server': 'auto', 'temp_files_server_address': 'http://127.0.0.1:49589', 'kernel_location': 'local', 'kernel_id': 'v2-5404JMa8IncvBvt8', 'notebook_service_address': None, 'dynamic_to_dataframe': 'object', 'temp_folder_location': 'user_dir', 'plotly_layout': None, 'auth_token_warnings': False, 'enable_curly_brackets_params': False, 'nop': False, 'assign_var': None, 'cursor_var': None, 'is_magic': True, 'code_auth_interactive_mode': 'device_code'}, 'command': {}, 'last_query': True}]",
"Account(s) exists in cache, probably with token too. Let's try.",
"Account(s) exists in cache, probably with token too. Let's try.",
"KustoClient::execute - POST request - url: https://....westus2.kusto.windows.net/v2/rest/query, headers: {'User-Agent': 'Kqlmagic/0.1.114.post22', 'x-ms-client-version': 'Kqlmagic.Python.Client:0.1.114.post22', 'x-ms-client-request-id': 'Kqlmagic.execute;02ffc0ef-5c23-4801-82fb-e5975dfabb6f/39c93ea0-580e-49b2-8d6e-8187ec8862ab/AzureDataExplorer', 'x-ms-app': 'Kqlmagic;visualstudiocode', 'Authorization': '...', 'Fed': 'True', 'Cache-Control': 'no-cache'}, payload: {'db': 'TestMetrics_Prod', 'csl': 'ExecutionTelemetryIngestionProd01\n| extend experiment = customDimensions.experimentn\n| extend experimentId = tostring(experiment.id)\n| extend executionGoal = tostring(experiment.metadata.executionGoal)\n| extend experimentStatus = tostring(experiment.status)\n| where executionGoal in (\'local-disk-single-0312\', \'local-disk-multi-0313\')\n| where experimentStatus in ("Succeeded", "InProgress")\n| distinct executionGoal, experimentId, experimentStatus\n| order by executionGoal'}, timeout: None",
"POST Request: https://.........westus2.kusto.windows.net/v2/rest/query, params: None, payload: {'db': 'TestMetrics_Prod', 'csl': 'ExecutionTelemetryIngestionProd01\n| extend experiment = customDimensions.experimentn\n| extend experimentId = tostring(experiment.id)\n| extend executionGoal = tostring(experiment.metadata.executionGoal)\n| extend experimentStatus = tostring(experiment.status)\n| where executionGoal in (\'local-disk-single-0312\', \'local-disk-multi-0313\')\n| where experimentStatus in ("Succeeded", "InProgress")\n| distinct executionGoal, experimentId, experimentStatus\n| order by executionGoal'}, headers: {'User-Agent': 'Kqlmagic/0.1.114.post22', 'x-ms-client-version': 'Kqlmagic.Python.Client:0.1.114.post22', 'x-ms-client-request-id': 'Kqlmagic.execute;02ffc0ef-5c23-4801-82fb-e5975dfabb6f/39c93ea0-580e-49b2-8d6e-8187ec8862ab/AzureDataExplorer', 'x-ms-app': 'Kqlmagic;visualstudiocode', 'Authorization': 'Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IlhSdmtvOFA3QTNVYVdTblU3Yk05blQwTWpoQSIsImtp.......', 'Fed': 'True', 'Cache-Control': 'no-cache', 'Content-Type': 'application/json'}",
"POST Response: 400 b"General_BadRequest: Request is invalid and cannot be executed.\r\nError details:\r\nClientRequestId='Kqlmagic.execute;02ffc0ef-5c23-4801-82fb-e5975dfabb6f/39c93ea0-580e-49b2-8d6e-8187ec8862ab/AzureDataExplorer', ActivityId='41a6cc0f-bba7-48b9-bbd6-b36b3222eba1', Timestamp='2024-03-18T17:14:00.4438221Z'."",
"KustoClient::execute - response - status: 400, headers: {'Date': 'Mon, 18 Mar 2024 17:14:00 GMT', 'Content-Type': 'text/plain', 'Server': 'Kestrel', 'Cache-Control': 'no-cache', 'Pragma': 'no-cache', 'Transfer-Encoding': 'chunked', 'Content-Encoding': 'gzip', 'Expires': '-1', 'Vary': 'Accept-Encoding', 'Strict-Transport-Security': 'max-age=2592000; includeSubDomains', 'x-ms-client-request-id': 'Kqlmagic.execute...'}, payload: General_BadRequest: Request is invalid and cannot be executed.\r\nError details:\r\nClientRequestId='Kqlmagic.execute.../AzureDataExplorer', ActivityId='...', Timestamp='2024-03-18T17:14:00.4438221Z'."
],
"query": {
"request": {
"endpoint": "https://..........westus2.kusto.windows.net/v2/rest/query",
...
"branch": "",
"name": "CPython",
"version": "3.11.0"
}
}