ABPServer.log

####<Feb 24, 2016 5:41:51 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <EXT<Tksmau5rlVCgVZOsY6h}Wdrhu7v{NHyUI{Tn}QE0;appId=UIF;>> <BEA1-02FECA6EB05D99F38352> <> <1456328511191> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 43 |String for entityPartition_key_set_condition_for_CL1_TREAT_ACT_HISTORY  AND ("T1".entity_id,"T1".entity_key) IN ((500000040,0) )
> 
####<Feb 24, 2016 5:41:51 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <EXT<Tksmau5rlVCgVZOsY6h}Wdrhu7v{NHyUI{Tn}QE0;appId=UIF;>> <BEA1-02FECA6EB05D99F38352> <> <1456328511192> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 43 |Inside execute()
> 
####<Feb 24, 2016 5:41:51 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <EXT<Tksmau5rlVCgVZOsY6h}Wdrhu7v{NHyUI{Tn}QE0;appId=UIF;>> <BEA1-02FECA6EB05D99F38352> <> <1456328511207> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 43 | SQLSTRING = SELECT /*+ leading ("T0" "T1") use_nl ("T0" "T1") */
	sum(decode("T1".ACTIVITY_CODE,?,1,0)) AS "f1",
	"T0".ENTITY_ID AS "f2", 
	sum(decode("T1".ACTIVITY_CODE,?,1,0)) AS "f3",
	RTRIM ("T0".PA_IND) AS "f4",
	sum(decode("T1".ACTIVITY_CODE,?,1,0)) AS "f5",
	RTRIM ("T0".TRIAL_PERIOD_IND) AS "f6",
	RTRIM ("T0".CATEGORY_CODE) AS "f7"
	FROM
	CL1_TREAT_ACT_HISTORY "T1",
	CL1_COLL_ENTITY "T0"
   WHERE
   "T1".ENTITY_ID(+)="T0".ENTITY_ID
   AND
   "T1".ENTITY_TYPE(+)="T0".ENTITY_TYPE
	AND
   "T1".ENTITY_KEY(+)="T0".ENTITY_KEY
   AND "T0".entity_type = ?
  AND ("T0".entity_id,"T0".entity_key) IN ((500000040,0) )
    GROUP BY
   "T0".ENTITY_ID,
   RTRIM ("T0".TRIAL_PERIOD_IND),
   RTRIM ("T0".PA_IND),
   RTRIM ("T0".CATEGORY_CODE)
   UNION
   SELECT /*+ leading ("T1" "T0") use_nl ("T1" "T0") */
   sum(decode("T1".ACTIVITY_CODE,?,1,0)) AS "f1",
   "T1".ENTITY_ID AS "f2",
   sum(decode("T1".ACTIVITY_CODE,?,1,0)) AS "f3",
   RTRIM ("T0".PA_IND) AS "f4",
   sum(decode("T1".ACTIVITY_CODE,?,1,0)) AS "f5",
   RTRIM ("T0".TRIAL_PERIOD_IND) AS "f6",   RTRIM ("T0".CATEGORY_CODE) AS "f7"
   FROM
   CL1_TREAT_ACT_HISTORY "T1",
   CL1_COLL_ENTITY "T0"
   WHERE
   "T1".ENTITY_ID="T0".ENTITY_ID(+)
   AND
   "T1".ENTITY_TYPE="T0".ENTITY_TYPE(+)
   AND
   "T1".ENTITY_KEY="T0".ENTITY_KEY(+)
   AND "T1".entity_type =?
  AND ("T1".entity_id,"T1".entity_key) IN ((500000040,0) )
    GROUP BY
   "T1".ENTITY_ID,
   RTRIM ("T0".TRIAL_PERIOD_IND),
   RTRIM ("T0".PA_IND), RTRIM ("T0".CATEGORY_CODE)

> 
####<Feb 24, 2016 5:41:51 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <EXT<Tksmau5rlVCgVZOsY6h}Wdrhu7v{NHyUI{Tn}QE0;appId=UIF;>> <BEA1-02FECA6EB05D99F38352> <> <1456328511267> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 43 |Inside releaseResultSet()
> 
####<Feb 24, 2016 5:41:51 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <EXT<Tksmau5rlVCgVZOsY6h}Wdrhu7v{NHyUI{Tn}QE0;appId=UIF;>> <BEA1-02FECA6EB05D99F38352> <> <1456328511269> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 43 |Inside cleanUp()
> 
####<Feb 24, 2016 5:42:46 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1456328566644> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 32 |@@@ - performScan bulkSize = 1000> 
####<Feb 24, 2016 5:42:46 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1456328566644> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 32 |@@@ isInTimeFrame 8:0 - 22:0> 
####<Feb 24, 2016 5:42:46 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1456328566644> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 32 |@@@ isInTimeFrame current time =17:42> 
####<Feb 24, 2016 5:42:46 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1456328566644> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 32 |@@@ isInTimeFrame return: true> 
####<Feb 24, 2016 5:42:47 PM IST> <Info> <APM> <eaasrt> <ABPServer> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1456328567644> <BEA-000000> <I |10/8/15 11:59:59 PM IDT |SID: 32 |@@@ - performScan bulkSize = 1000>