Workspaces using a Web Service or Queue connector has unhealthy run

Workspaces using a Web Service or Queue connector deploy successfully but jobs (runs) are unhealthy. The following error is in the Streams log. ERROR :::PEC.StartPE M[PECServer.cpp:runPE:207] P[5] - Could not load dll for PE 5 from /home/streamsadmin/OpDetection/deploy/ 2218dfd2-5a59-417b-bd5c-a17e07f6fd78/6/output/ com.ibm.unica.engine.UnicaEngine/Distributed/bin/ com.ibm.unica.engine.UnicaEngine-a.dpe because of /data/databaseserver/DB210.1/lib64/libdb2.so.1: undefined symbol: sqlnlsFreeCpCvResources

Procedure

  1. Execute printenv LD_LIBRARY_PATH command as root and verify that the correct LD_LIBRARY_PATH value is set. If necessary, correct the value as described in the HCL® Opportunity Detect and Interact Advanced Patterns Installation Guide, in the topic titled "Configuring the Streams database adapter for DB2" or "Configuring the Streams database adapter for Oracle."
  2. Check the .bashrc file for both root and the Streamsadmin user to verify that the Db2Instance variable points to your database.
  3. Restart the Streams instance and the Streams RCS Service.