webMethods Knowlegebase : JDBC Insert notification is creating errors nvarchar data types of SQL server (1771328)

Problem

Attempting to Create Insert notification on table which had int and nvarchar(max) as data types of SQL server types.

Using 'Microsoft SQL Server 2012 - 11.0.5343.0 (X64)' and the latest fix JDBC_9.0_Fix6.

Table details:

CREATE TABLE TestOutboundMSGTable

(

SequenceID int identity(1,1) PRIMARY KEY NOT NULL,

InterfaceName nvarchar(50) NOT NULL,

IDOCType nvarchar(50) NULL,

IDOCExt nvarchar(50) NULL,

MSGContent nvarchar(max)NOT NULL,

CreateDateTime DateTime NOT NULL,

UpdateDateTime DateTime NOT NULL,

Status nvarchar(50) NOT NULL

);

Receiving the following error:

"varchar(Max):

[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification aSandBox.rajupm:DeltaVoutbund.

[ADA.1.349] Execution of DDL query of Notification failed during enable/disable. Please check the datatypes of columns selected in notification.

The size (2147483647) given to the column 'MSGContent' exceeds the maximum allowed for any data type (8000)."

The value '2147483647' is being generated by the Adapter instead of passing 'max' as the column size when creating buffer table.