Resolution:
Description:
============
We use ADB adapter and Oracle database with Clob/Blob datatypes.  We've observed that if the size of the data to be published by ADB adapter is greater than 1 MB then the adapter publishes only 1MB of data. Is this a limitation or configuration for the adapter?

Environment:
===========
ADB 5.3.0/ADB5.4.0/ADB5.5.0/ADB6.0.0

Cause:
=====
When dealing with CLOB/BLOB data, the parameter "adb.maxLongLen" needs to be set in the adapter properties(.tra) file.

The default value for this is:
adb.maxLongLen 1048576
ie., 1MB

Resolution:
==========
Please check and if need be set this to larger value(for example 4MB), set "adb.maxLongLen 4194304" in the adapter properties(.tra) file to enable the adapter to handle CLOB/BLOB data upto a size of 4MB. ADB can handle 64MB message for ADB 5.2.2 or later version, but for ADB5.3.0, it can only process message up to 4MB.  This was fixed ADB 5.3.0 HF2.

Once the application is deployed in Administrator GUI go to:
Application Management --> &ltapp_name> --> Configuration --> Advanced(tab) --> Adapter SDK Properties.

The adapter's "adb.xxx" properties can be changed just before the application is deployed in Administrator and the values given here will be reflected in the application properties(.tra) file created during deployment.Attachments:

Is there any limitation or configuration for publishing a messages size?