AnsweredAssumed Answered

Route shape always goes to the default even if it should not

Question asked by rui.luo253472 on May 26, 2017
Latest reply on Jun 8, 2017 by jeff_chin

I have a Boomi process where I need to handle a database operation failure corresponding to the actual error. One anticipated error is "duplicate key" violation. I have a router shape that routes by document property "try/catch message". No matter how I play with the condition, it always goes to the default branch. The following is from the log:

 

Performing comparison: is ERROR: duplicate key value violates unique constraint "SurveyAnswerPKx"
Detail: Key (job, jobattempt, target, question, response)=(a0R610000041468EAA, a0O61000006YTt1EAG, , a0u610000024G5AAAU, No Items LOW/OSS in this Category) already exists. WILDCARD *duplicate key*?

 

I also tried regular expression such as: ".*key.*" or some variation of the patterns but none of them worked. It appears as if the route shape is ignoring the comparison result.

 

Any hint is appreciated.

Outcomes