In SAS Visual Data Builder, the following length limits apply:

Expression Type	Maximum Length
WHERE and HAVING clauses	4096
Data item expression	1024

 

SAS Visual Data Builder does not prevent you from creating WHERE clauses, HAVING clauses, or data item expressions that exceed the maximum length. If you exceed the maximum length, you might not be able to save the query. For example, here are some of the errors that SAS Visual Data Builder might display when you exceed the limits:

The request could not be completed successfully due to a server error. 
Please contact your system administrator.  
Server error: could not insert[com.sas.databuilder.domain.QueryColumn]

The request could not be completed successfully due to a server error. 
Please contact your system administrator. 
Server error: Could not execute JDBC batch update

In addition, the SAS Visual Data Builder log might contain errors that are similar to these:

ERROR [ST-134391-34954u4385-sasdemo] org.hibernate.util.JDBCExceptionReporter - ERROR: value too long for type character varying(1024) ERROR [ST-134391-34954u4385-sasdemo] org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session

There is no workaround that enables you to exceed these limits in SAS Visual Data Builder. The alternative is to prepare your data using a different software application such as SAS^® Enterprise Guide^® or SAS^® Data Integration Studio.

Note: You also see an error if you attempt to save the query to a metadata folder path that exceeds 128 characters. For example, the log might contain ERROR: value too long for type character varying(128). In that case, reduce the number of characters in the folder path.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Analytics	Microsoft® Windows® for x64	6.1		9.3 TS1M2
		Linux for x64	6.1		9.3 TS1M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Type:	Usage Note
Priority:

Date Modified:	2013-11-04 14:06:47
Date Created:	2013-11-04 13:46:51