TDM Portal: 22.214.171.124
We have an ongoing stress test of the publishing a specific data pool from Portal. Stress is running with a fixed set of variables.
During stress test we continuously publish the data pool after making sure that previous run has completed.
During this this test we have found that the publish jobs fail intermittently mostly with below error.
2022-06-23 13:14:55.170 UTC [ERROR] [taskExecutor-66 ] --- [U:][M:][P:] c.c.t.p.l.TDMPublishLog: com.ca.tdm.servicecommon.TDMServiceException: resolve_meta_data_item: TDMServiceException: mid: function mid called with 1 arguments but 2 or 3 are required
Release : 4.10
Component : Web Portal - Publishing
This is an environment/data specific issue.
The error was coming from the MID function specifically when the parameters passed were NULL.
Local testing didn't show any issues.
However the suggestion was given to insert ifnull before the first parameter(column references) of mid function. This helped to resolve the issue.