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.