Enable To 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.