HPE NonStop SQL/MX Error – 2108 Statement was compiled as if query plan caching were off.

In this blog post, let’s learn about the error message “2108 Statement was compiled as if query plan caching were off.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

2108 Statement was compiled as if query plan caching were off.

Reason for the Error

The SQL/MX compiler attempted to compile this query with query caching on but failed. It then successfully compiled this query with caching turned off.

Solution

This is an informational message. To prevent this warning, turn off query caching before query preparation

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, let’s learn about the client error message “EngineNotSupported with HTTP Status 400” when working with PolarDB...
  • Data
  • December 15, 2022
In this blog post, let’s learn about the client error message “EngineVersionNotSupported with HTTP Status 400” when working with PolarDB...
  • Data
  • December 15, 2022
In this blog post, let’s learn about the client error message “IncorrectDBClusterLockMode with HTTP Status 400” when working with PolarDB...
  • Data
  • December 15, 2022