Search This Blog

Thursday, December 10, 2015

Container feeds fail to run successfully

Symptom:
BPMC feeds in a Container Feed fail to run successfully for the following combinations:
  • Process = IN
  • Command Type = BPMC
The following errors are generated in the DPC Log and Event Viewer:
DPC Log
----------------------------------------------------------------------------------------------------------------------------------------
Failure external process execution. Please reference SQLISPackage100 errors on the SQL server application event log more detail

Event Viewer Log
----------------------------------------------------------------------------------------------------------------------------------------
Event Name: OnError

Message: Executing the query "exec p_ETL_CMD_INPROCESS ?, 'POSTDEPLOY',1" failed with the following error: "BPMC command error :cd.. && "C:\Program Files\Breakaway Technologies\BPM Connect\\TM1Engine\x86\BPMC_ETL_Engine_TM1_x86.exe" "CS:Provider=SQLNCLI11;Server=NAHAS62695\MSS10493;Database=BPMC_PEOPLE;Trusted_Connection=yes;" "TestFeed" "25"". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Cause:
This is due to an issue in Container Feeds when it attempts to execute a BPMC Feed (Process = IN). The wrong Engine is called. The TM1 Engine is called as opposed to the SSIS Engine.This issue affects pack 323.


Solution:
Run the following SQL script on the BPM Connect staging database.
p_ETL_CMD_INPROCESS_v2.5.sql.


This issue is solved on the 324 pack of BPM Connect.

No comments:

Post a Comment