Enable Expert Mode in Solution Explorer.
Right click on workflow name in solution explorer and choose Properties:
Enable Expert Mode in properties and save changes (Expert Mode can be already enabled):
After expert mode is enabled Preproc and Postproc panes will be available
(in the very bottom of IWS designer):
Switch to Preproc pane:
Click Edit on get_in_params data query shape (first shape on Preproc pane) and switch to Preview tab:
Change second row with text:
<CODE>IF Find(:FILE_NAME:, :corrIdSep = 1 AND Find(:FILE_NAME:, '', 2) != 1 AND Find(:FILE_NAME:, '') != -1 THEN [ :CorrelationId: := SubString(:FILE_NAME:, Find(:FILE_NAME:, '', 0, 2) + 1); :CorrelationId: := SubString(:CorrelationId:, 0, Find(:CorrelationId:, '')); ];</CODE> |
To:
<CODE>IF Stringlength(:CorrelationId = 0 THEN [ IF Find(:FILE_NAME:, :corrIdSep = 1 AND Find(:FILE_NAME:, '', 2) != 1 AND Find(:FILE_NAME:, '') != -1 THEN [ :CorrelationId: := SubString(:FILE_NAME:, Find(:FILE_NAME:, '', 0, 2) + 1); :CorrelationId: := SubString(:CorrelationId:, 0, Find(:CorrelationId:, '')); ]; ];</CODE> |
Close data query and save changes by clicking Save in right lower corner:
Publish task changes. After this change task will evaluate Correlation Id during MC2 profiled load execution correctly.