Auto dim failure - p_ETL_CR_DIM_FILES

Symptom:
Message: Executing the query "exec p_ETL_CR_DIM_FILES ?, 0,0" failed with the following error: "Invalid object name 'FEEDNAME'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Issue:

The Auto dim feed is truncating a character in one of the Stored Procedures. Dimension is less than 20 characters, and stored procedure is setting it to MBR + DIMNAME, but truncating on execution the last character. It counts the MBR as part of the 20 max characters.

  

Solution:

Apply the following SQL script patch to the symptomatic BPM Connect database:

p_ETL_CR_DIM_FILES_v2.5

This issue is solved in BPM Connect 325 pack.