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
Release : 4.7
Component : CA Test Data Manager