The UseXViews Connection String Atribute is set to true by default. When a connection is made to the Entity Provider, the X version of the views in the Teradata Data Dictionary are used to retrieve the information of the store schemas. However, when this attribute is set to true the Entity Provider can create a SQL query that is to complex to parse by the Teradata Database. If this occurs the following error message will be thrown:
[Teradata Database] [3710] Insufficient memory to parse this request, during QueryRewrite phase.
The following are recommendations that can be performed to workaround this limitation:
Set the Connection setting UseXViews=false.
Increase the DBS Control Record field MaxParseTreeSegs. Refer to Performance Management in the Teradata manuals for information on setting DBS Control fields.
The View and ViewColumns store schemas are only supported starting from .NET Data Provider for Teradata 13.11. Refer to Mapping Views and ViewColumns to Tables for more information.