KB210844: "The batch could not be analyzed because of compile errors" error message is encountered when editing an attribute through Developer in MicroStrategy 9.x

Salesforce Solutions Architect • Strategy

This document describes an error that is encountered when editing an attribute through Developer in MicroStrategy 9.x. The issue is encountered only when the metadata is located in Microsoft SQL Server and the database connection is using the Microsoft SQL Server Native Client 11.0 driver.

SUMMARY
This document describes an error that is encountered when editing an attribute through Developer in Strategy 9.x. The issue is encountered only when the metadata is located in Microsoft SQL Server and the database connection is using the Microsoft SQL Server Native Client 11.0 driver.

SYMPTOM
When editing an attribute in Developer/Desktop in Strategy 9.x, users may encounter the following error.


Database error <5>: Execute Parameterized Query failed.
Error type: Odbc error. Odbc operation attempted: SQLDescribeParam.
[42S02:.208: on SQLHANDLE] [Microsoft][SQL Server Native Client 11.0][SQL Server]
Invalid object name ‘#TP00530483B40484’.
[42000:11501: on SQLHANDLE][Microsoft][SQL Server Native Client 11.0][SQL Server]
The batch could not be analyzed because of compile errors.

The issue is encountered only when the metadata is located in a Microsoft SQL Server database and the DSN is using the Microsoft SQL Server Native Client 11.0 driver.

CAUSE
This issue is caused by a regression in the Microsoft SQL Server Native Client 11.0 ODBC driver. The issue is not encountered when using an earlier version of the Microsoft SQL Server Native Client driver.

ACTION
Contact Microsoft Technical Support for an update on the status of the issue.

WORKAROUND
Users can use a pre-11.0 version of the Microsoft SQL Server Native Client driver.

The Strategy Internal Reference Number for the issue discussed in this technical note is TQMS960638.

Third Party Software Installation: WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.

Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

July 17, 2017

Database error <5>: Execute Parameterized Query failed. Error type: Odbc error. Odbc operation attempted: SQLDescribeParam. [42S02:.208: on SQLHANDLE] [Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid object name ‘#TP00530483B40484’. [42000:11501: on SQLHANDLE][Microsoft][SQL Server Native Client 11.0][SQL Server] The batch could not be analyzed because of compile errors.