While deploying Inputmaps or uploading data source files,We may get below exceptions and unable to proceed with the activity.

SQL-8202: Failed while executing SQL statement. SQL state S0002. Database specific error code (if any) was 2717. Database error message (if any) was: com.microsoft.sqlserver.jdbc.SQLServerException: The size (8000) given to the parameter 'JOIN__KEY' exceeds the maximum allowed (4000).
 

MDM + SQL SERVER

This will occur if we have given the com.tibco.cim.catalog.string.maxlength parameter value to more than 4000.

The Maximum length of a String attribute for repositories, data sources, and catalog formats should not be more than '4000' characters.So,it should be set to '4000' as below.

<ConfValue description="Maximum length of a String attribute for repositories, data sources, and catalog formats. Length is specified in number of characters." isHidden="false" isHotDeployable="true" name="Maximum Attribute Length" propname="com.tibco.cim.catalog.string.maxlength" sinceVersion="7.0" visibility="Advanced">
                <ConfNum default="4000" value="4000"/>

SQL exceptions while deploying Input maps or data sources while using SQL SERVER as Database type

https://docs.tibco.com/pub/bstudio-mdm/5.1.0/doc/html/GUID-019E0E3F-EB18-45E2-99E8-F14DCC42C44A.html