Tile taking 2hrs to complete, Data Maker did not respond when trying to repub

Products

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

Issue/Introduction

Tile named “IBX - Unenrolled KBBO Users” tile  takes long time (almost 2+ hrs) to complete the execution.

“DP_OBP_KBBO” is the Data pool which is used to mine Data from an oracle DB which takes almost 2 hrs to complete.

There are no external calls configured, so there is no delay by external processes.   To fix this issue, I tried to republish the Data Pool but unfortunately the Data Maker tool was not responding whenever I go for it. 

I tried to Publish from TDM portal  and received “Inconsistent table definitions” error and unable to publish it. 

 

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

Engineering reviewed the logs and found the issue is not TDM Portal. They suspect the issue could be with the queries. Specifically the queries using SEQLOV. What is happening is the database is being queried for each SEQLOV. Engineering recommends to make sure you use SEQLOV with a query like 'select * from table where ...' for all columns.

If the whole select expression string changes then a new list is generated from a database query, which is what we are seeing from the logs. Each Qxxxx represents a list

Line 1136: 2020-03-18 04:00:12.107 UTC [DEBUG] [taskExecutor-1 ] --- [U:][M:][P:] c.c.t.s.g.MetaFunctions: evalFunction: function sqllist evaluates to: "Q4966"
Line 1512: 2020-03-18 04:00:13.683 UTC [DEBUG] [taskExecutor-1 ] --- [U:][M:][P:] c.c.t.s.g.MetaFunctions: evalFunction: function sqllist evaluates to: "Q4967"
Line 1888: 2020-03-18 04:00:15.273 UTC [DEBUG] [taskExecutor-1 ] --- [U:][M:][P:] c.c.t.s.g.MetaFunctions: evalFunction: function sqllist evaluates to: "Q4968"
Line 2271: 2020-03-18 04:00:15.276 UTC [DEBUG] [taskExecutor-1 ] --- [U:][M:][P:] c.c.t.s.g.MetaFunctions: evalFunction: function sqllist evaluates to: "Q4969"
Line 2647: 2020-03-18 04:00:15.279 UTC [DEBUG] [taskExecutor-1 ] --- [U:][M:][P:] c.c.t.s.g.MetaFunctions: evalFunction: function sqllist evaluates to: "Q4970"
Line 2747: 2020-03-18 04:00:15.291 UTC [DEBUG] [taskExecutor-1 ] --- [U:][M:][P:] c.c.t.s.g.MetaFunctions: evalFunction: function sqllist evaluates to: "Q4971"