Edit

Error messages in Parallel Data Warehouse

  • Article

Parallel Data Warehouse (PDW) error messages report errors and problems encountered by the PDW components and can also include SQL Server errors surfaced through PDW. These error messages use a consistent syntax for presenting information. Understanding this syntax will allow you to identify and correct problems on SQL Server PDW.

Error Message Basics

Error messages that are returned follow the same syntax.

Error_Indicator [SQL_State_Code] [Driver_Details] [QueryID] Message_String

These are the potential values for each field:

Field Description Example
Error_Indicator The word "ERROR" or other text alerting the user to a problem. ERROR
SQL_State_Code The SQL state code, according to ODBC specification. The driver generates the appropriate SQL State code any time it returns a message to an application. The text "Microsoft" indicates the source of the error. 42000
Driver_Details Driver-dependent details, such as the type of driver used. ODBC SQL Server 2008 R2 Parallel Data Warehouse driver
QueryID The unique identifier for the query. Use this value to find additional information related to processing of the query. For example, the query execution details can be found in the Admin Console using the query ID. For more information, see Monitor the Appliance by Using the Admin Console.

If a QueryID is not applicable, the text "Internal" is returned to the user.		 QID2377
Message_String A human-readable description of the error or problem. When returning SQL Server errors, this is the SQL Server message text. Only equal assignment can appear in the set list of an UPDATE statement.

These example values would be presented to the user like this:

ERROR [42000] [Microsoft][ODBC SQL Server 2008 R2 Parallel Data Warehouse driver][QID2380]Only equal assignment can appear in the set list of an UPDATE statement.

Related content