VERIFIED SOLUTION i

EngageOne unable to search for template when search criteria exceeds 67 characters

Operating System: Linux
Database: Oracle 11g

 

Issue

Unable to search for template when search criteria exceeds 67 characters.

When using 67 or less characters in the “Template_Description” field, the search returns the template correctly.  When using Interactive Correspondent or when using the web service searchTemplates() using more than 67 characters, the search returns no templates.  

Cause

This is a defect in the Oracle database software.

Resolution

UPDATED: April 5, 2017
Apply Oracle patch 16042648 (ORACLE 11G 11.2.0.3 PATCH 15 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64) )