Microsoft SQL Server query returns error: "SQL statement size 'xxxx' exceeds the max SQL size '8000' on Microsoft SQL Server 2008." in TIBCO Data Virtualization

Microsoft SQL Server query returns error: "SQL statement size 'xxxx' exceeds the max SQL size '8000' on Microsoft SQL Server 2008." in TIBCO Data Virtualization

book

Article ID: KB0076004

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Versions

Description

Description:
MS SQL Server query returns error: "SQL statement size 'xxxx' exceeds the max SQL size '8000' on Microsoft SQL Server 2008."
 
For example: "SQL statement size '15244' exceeds the max SQL size '8000' on Microsoft SQL Server 2008."

Issue/Introduction

Microsoft SQL Server query returns error: "SQL statement size 'xxxx' exceeds the max SQL size '8000' on Microsoft SQL Server 2008." in TIBCO Data Virtualization

Resolution

There is a configuration setting in the file <INSTALL>/apps/dlm/cis_ds_mssql/conf/microsoft_sql_server_2008_config_defs.xml that controls the maximum length of a SQL statement that a data source can accept. Locate the following XML block in the file from your environment.  
<common:attributeDef> 
    <common:name>/runtime/query/maxSqlLength</common:name> 
    <common:type>INTEGER</common:type> 
    <common:updateRule>READ_WRITE</common:updateRule> 
    <common:annotation>This value indicates the maximum length of a SQL statement that a data source can accept.</common:annotation> 
    <common:defaultValue>8000</common:defaultValue> 
    <common:displayName>Maximum SQL Length</common:displayName> 
    <common:configID>jdbcds.max_sql_length</common:configID> 
    <common:public>true</common:public> 
    <common:noImport>false</common:noImport> 
  </common:attributeDef>

You can change the value from 8000 to a larger value to accommodate the actual size of the SQL statement issued from the TDV view. Restart the TDV Server after making the changes
Powered by Wolken Software