search cancel

FindValues Service doesn't show how many rows were returned in the log files and Actor doesn't capture which user it is retrieving data for?

book

Article ID: 189116

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Hello,

Build 4.7.114 (still)

I have logging turned on for DataReservation service only. I am trying to write a log of user shopping for find and reserve. I have noticed two types of data access.  The log doesn't show rows returned (in this case 1). 

My initial assumption was the Path Actor query was issued each time and that it was associated with last user id before it in the log doing there current activity.  But then I noticed a situation a user is doing multiple selects on a tile with specific criteria, but you don't get a count back for those. Is this possible in a 4.9 patch? 

One is 2020-04-10 15:23:55.074 UTC [DEBUG] [https-jsse-nio-8443-exec-10] --- [U:guralr5][M:POST][P:/api/ca/v1/testDataModels/1054/fields/1156/actions/findValues]                             c.c.t.d.s.FindService:  Executing query SELECT TOP 100 [SSN] FROM (select distinct [SSN] from [dbo].[usdp_FINAL] where  [SSN] like ? ) [usdp_FINAL] ORDER BY [SSN] ASC

There is no line below this saying 1 record found zero record found.

The second type of data access is 

020-04-10 15:22:46.096 UTC [DEBUG] [DataFind-akka.actor.default-dispatcher-883] --- [U:][M:][P:]                     c.c.t.d.f.a.AbstractFindActor:  Executing query In Path Actor -->SELECT TOP 100 [CC_ACCT_TY],[SIGNON_ID],[ML_ACCT_TY],[AL_STATUS],[ML_BAL],[AL_EXISTS],[IM_ACCT_DESC],[CC_STATUS],[CC_EXISTS],[LL_ACCT_DESC],[LL_IB_STATUS],[AL_BAL],[IM_ACCT_TY],[LL_BAL],[ST_ACCT_TY],[LL_EXISTS],[IM_BAL],[AL_ACCT_DESC],[IM_MMD_IND],[ML_STATUS],[RF_ACCT_NUM],[IM_EXISTS],[CUST_NUM],[ACCT_NUM],[AL_ACCT_TY],[ST_IB_STATUS],[LL_ACCT_TY],[CC_BAL],[ST_EXISTS],[CC_ACCT_DESC],[CC_IB_STATUS],[ACTIVE_ENV],[ML_ACCT_DESC],[ML_IB_STATUS],[ST_CMOD_IND],[TYP_CD],[CUST_ADDR],[IB_CUST_IND],[IM_CMOD_IND],[ST_BAL],[IM_STATUS],[RELATION],[IM_SYS_TYP],[AL_IB_STATUS],[IM_IB_STATUS],[LL_STATUS],[ML_EXISTS],[SSN],[ST_STATUS],[APPL],[ORGI_LN],[ST_ACCT_DESC],[CUST_STATUS],[CUST_NAME] FROM [dbo].[usdp_FINAL] ORDER BY [ACCT_NUM] ASC, [AL_ACCT_DESC] ASC, [AL_ACCT_TY] ASC, [AL_BAL] ASC, [AL_EXISTS] ASC, [AL_IB_STATUS] ASC, [AL_STATUS] ASC, [APPL] ASC, [CC_ACCT_DESC] ASC, [CC_ACCT_TY] ASC, [CC_BAL] ASC, [CC_EXISTS] ASC, [CC_IB_STATUS] ASC, [CC_STATUS] ASC, [CUST_ADDR] ASC, [CUST_NAME] ASC, [CUST_NUM] ASC, [CUST_STATUS] ASC, [IM_ACCT_DESC] ASC, [IM_ACCT_TY] ASC, [IM_BAL] ASC, [IM_CMOD_IND] ASC, [IM_EXISTS] ASC, [IM_IB_STATUS] ASC, [IM_MMD_IND] ASC, [IM_STATUS] ASC, [IM_SYS_TYP] ASC, [LL_ACCT_DESC] ASC, [LL_ACCT_TY] ASC, [LL_BAL] ASC, [LL_EXISTS] ASC, [LL_IB_STATUS] ASC, [LL_STATUS] ASC, [ML_ACCT_DESC] ASC, [ML_ACCT_TY] ASC, [ML_BAL] ASC, [ML_EXISTS] ASC, [ML_IB_STATUS] ASC, [ML_STATUS] ASC, [ORGI_LN] ASC, [RELATION] ASC, [RF_ACCT_NUM] ASC, [ST_ACCT_DESC] ASC, [ST_ACCT_TY] ASC, [ST_BAL] ASC, [ST_CMOD_IND] ASC, [ST_EXISTS] ASC, [ST_IB_STATUS] ASC, [ST_STATUS] ASC, [TYP_CD] ASC

2020-04-10 15:22:46.498 UTC [DEBUG] [DataFind-akka.actor.default-dispatcher-883] --- [U:][M:][P:]                     c.c.t.d.f.a.AbstractFindActor:  Results In Path Actor -->40 records found

2020-04-10 15:22:46.844 UTC [DEBUG] [DataFind-akka.actor.default-dispatcher-876] --- [U:][M:][P:]                            c.c.t.d.s.FieldService:  Sorting the resource classes on field:id with order:ASC

2

Environment

Release : 4.7

Component : CA Test Data Manager

Resolution

TDMWeb-4.9.29.0.zip resolves this request.