TDM Portal 4.9.256.0 Data Model Scans are not getting canceled

book

Article ID: 209471

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are experiencing an issue where a long-running Data Modeling scan is not getting canceled. The message in TDM Portal indicates the cancellation was successful, but the message appears to be misleading.

Cause

Sustaining Engineering said that the message should state the cancel request was successfully received and agrees it is a bit misleading. The issue could be due to not having a listener in one of the microservices codes, so the service doesn't know about the cancel request. Engineering will need to take a closer look into the issue and requested a copy of the TDM Portal Debug logs.

Environment

Release : 4.9.1

Component : CA Test Data Manager

Resolution

 

An analysis of the debug logs show a DB related error, which is related to datatype. The two SQL queries in question are:

  • select count(*) as total_rows from [DSIM0_CMBAS_AFTMASKDEV].[dbo].[Hires_and_Termination_Report_v2]

  • select count(*) as total_rows from [DSIM0_CMBAS_AFTMASKDEV].[dbo].[Hires_and_Termination_Report_v3]

The customer contacted their vendor in an effort to get more information about these two queries and found out from their vendor that these are "orphan views that are not meant to be there, hold-overs from version upgrades." 

The vendor is providing a patch to remove the two orphan views. This does not appear to be a TDM related issue.