VERIFIED SOLUTION i

TemplateService and Solr problems with simultaneous import threads in EngageOne Server V4.4

Product Feature: Administration - Legacy UI
Versions affected: all 4.4
 

Issue

Problem with GEN2 TemplateService and ImportActiveContent methods.

User attempted to run simultaneous imports creating more than 2 threads which fails and results in Solr becoming unavailable, with the following errors being thrown:

Oracle DB constraint issues: 
ORA-02291: integrity constraint (ENGAGEONE.FK_OCM_DEVICE_RES_OCM_RES) violated - parent key not found. 
ORA-02292: integrity constraint (ENGAGEONE.FK_OCM_RESOURCE_ATTRIBUTE) violated - child record found. 

EngageOne® SOAP WS becomes unavailable. 

Error in SOAP response observed when the user tries to generate > 2 import threads:

fault.detail.code 
-1 
fault.detail.message 
Failed to import active content. 
fault.faultactor 
fault.faultcode 
soap:Server 
fault.faultstring 
Error opening new searcher. exceeded limit of maxWarmingSearchers=3, try again later. 

Cause

Currently only linear import is supported, not parallel.

Resolution

UPDATED: July 23, 2018
Do not submit import requests in a parallel manner, submit in a linear manner (one at a time not simultaneously).