Intermittent issue with MID function publish

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

TDM Portal: 4.10.30.0

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

 

 

Environment

Release : 4.10

Component : Web Portal - Publishing

Cause

This is an environment/data specific issue.

Resolution

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.