Intermittent issue with MID function publish
search cancel

Intermittent issue with MID function publish


Article ID: 246659


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


TDM Portal:

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: 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.