{"cells":[{"cell_type":"markdown","execution_count":null,"metadata":{"tags":[]},"outputs":[],"source":["# TSG084 - Internal Query Processor Error\n","\n","## Description\n","\n","When running a Polybase query, the following error maybe returned:\n","\n","\u003e Msg 8680, Level 16, State 30, Line 1 Internal Query Processor Error:\n","\u003e The query processor encountered an unexpected error during the\n","\u003e processing of a remote query phase. OLE DB provider “MSOLEDBSQL” for\n","\u003e linked server “(null)” returned message “Unspecified error”. Msg 7421,\n","\u003e Level 16, State 2, Line 1 Cannot fetch the rowset from OLE DB provider\n","\u003e “MSOLEDBSQL” for linked server “(null)”. .\n","\n","To get more information, use the following DMV query. The `details`\n","column will contain more information. All the rows for a single\n","‘execution_id’ (QIDnnnnnn) are related to a single query execution.\n","\n","### Steps"]},{"cell_type":"code","execution_count":null,"metadata":{"tags":[]},"outputs":[],"source":["DECLARE @query NVARCHAR(max) = '\u003center query here\u003e'\n","\n","SELECT e.*\n","FROM sys.dm_exec_distributed_requests dr\n","CROSS APPLY sys.dm_exec_sql_text(sql_handle) st\n","JOIN sys.dm_exec_compute_node_errors e ON dr.execution_id = e.execution_id\n","WHERE st.text = @query\n","ORDER BY create_time DESC"]},{"cell_type":"code","execution_count":null,"metadata":{"tags":[]},"outputs":[],"source":["print 'Notebook execution is complete.'"]}],"nbformat":4,"nbformat_minor":5,"metadata":{"kernelspec":{"name":"sql","display_name":"SQL"},"pansop":{"related":"","test":{"strategy":"","types":null,"disable":{"reason":"","workitems":null,"types":null}},"target":{"current":"","final":""},"internal":{"parameters":null,"symlink":false},"timeout":"0"},"language_info":{"codemirror_mode":"{ Name: \"\", Version: \"\"}","file_extension":"","mimetype":"","name":"","nbconvert_exporter":"","pygments_lexer":"","version":""},"widgets":[]}}