P8kdej9m

104-06 15:09:01.102 738-761/? D/SensorService: [SO] 0.469 -0.099 9.674
2                                              
3                                              --------- beginning of system
404-06 15:09:01.633 738-2258/? D/SSRM:n: SIOP:: AP = 340, CUR = 287, LCD = 134
504-06 15:09:02.153 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.48 ] when=406362784000
604-06 15:09:02.153 738-795/? D/InputReader: lastThreadEndTime = 402732443845, currentThreadStartTime = 402732443845, diff = 0
704-06 15:09:02.153 738-794/? I/InputDispatcher: Delivering touch to (863): action: 0x4, toolType: 1
804-06 15:09:02.153 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
904-06 15:09:02.153 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
1004-06 15:09:02.153 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
1104-06 15:09:02.173 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
1204-06 15:09:02.173 4931-4931/? D/NeoActionsActivity: pc 0.060185187 isHideToolbarView true
1304-06 15:09:02.173 4931-4931/? D/NeoActionsActivity: pc 0.060185187 isHideToolbarView true
1404-06 15:09:02.194 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
1504-06 15:09:02.194 4931-4931/? D/NeoActionsActivity: pc 0.14814815 isHideToolbarView true
1604-06 15:09:02.194 4931-4931/? D/NeoActionsActivity: pc 0.14814815 isHideToolbarView true
1704-06 15:09:02.204 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
1804-06 15:09:02.204 4931-4931/? D/NeoActionsActivity: pc 0.2361111 isHideToolbarView true
1904-06 15:09:02.214 4931-4931/? D/NeoActionsActivity: pc 0.2361111 isHideToolbarView true
2004-06 15:09:02.224 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
2104-06 15:09:02.224 4931-4931/? D/NeoActionsActivity: pc 0.32407406 isHideToolbarView true
2204-06 15:09:02.224 4931-4931/? D/NeoActionsActivity: pc 0.32407406 isHideToolbarView true
2304-06 15:09:02.244 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
2404-06 15:09:02.244 4931-4931/? D/NeoActionsActivity: pc 0.39814815 isHideToolbarView true
2504-06 15:09:02.244 4931-4931/? D/NeoActionsActivity: pc 0.39814815 isHideToolbarView true
2604-06 15:09:02.254 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
2704-06 15:09:02.254 4931-4931/? D/NeoActionsActivity: pc 0.46296296 isHideToolbarView true
2804-06 15:09:02.254 4931-4931/? D/NeoActionsActivity: pc 0.46296296 isHideToolbarView true
2904-06 15:09:02.274 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
3004-06 15:09:02.274 4931-4931/? D/NeoActionsActivity: pc 0.5185185 isHideToolbarView true
3104-06 15:09:02.274 4931-4931/? D/NeoActionsActivity: pc 0.5185185 isHideToolbarView true
3204-06 15:09:02.294 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
3304-06 15:09:02.294 4931-4931/? D/NeoActionsActivity: pc 0.5740741 isHideToolbarView true
3404-06 15:09:02.294 4931-4931/? D/NeoActionsActivity: pc 0.5740741 isHideToolbarView true
3504-06 15:09:02.304 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
3604-06 15:09:02.304 4931-4931/? D/NeoActionsActivity: pc 0.625 isHideToolbarView true
3704-06 15:09:02.304 4931-4931/? D/NeoActionsActivity: pc 0.625 isHideToolbarView true
3804-06 15:09:02.324 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
3904-06 15:09:02.324 4931-4931/? D/NeoActionsActivity: pc 0.6666667 isHideToolbarView true
4004-06 15:09:02.324 4931-4931/? D/NeoActionsActivity: pc 0.6666667 isHideToolbarView true
4104-06 15:09:02.334 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
4204-06 15:09:02.344 4931-4931/? D/NeoActionsActivity: pc 0.6759259 isHideToolbarView true
4304-06 15:09:02.344 4931-4931/? D/NeoActionsActivity: pc 0.6759259 isHideToolbarView true
4404-06 15:09:02.354 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
4504-06 15:09:02.354 4931-4931/? D/NeoActionsActivity: pc 0.6851852 isHideToolbarView true
4604-06 15:09:02.354 4931-4931/? D/NeoActionsActivity: pc 0.6851852 isHideToolbarView true
4704-06 15:09:02.374 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
4804-06 15:09:02.374 4931-4931/? D/NeoActionsActivity: pc 0.6944444 isHideToolbarView true
4904-06 15:09:02.374 4931-4931/? D/NeoActionsActivity: pc 0.6944444 isHideToolbarView true
5004-06 15:09:02.384 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
5104-06 15:09:02.384 4931-4931/? D/NeoActionsActivity: pc 0.7083333 isHideToolbarView true
5204-06 15:09:02.394 4931-4931/? D/NeoActionsActivity: pc 0.7083333 isHideToolbarView true
5304-06 15:09:02.404 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
5404-06 15:09:02.404 4931-4931/? D/NeoActionsActivity: pc 0.7222222 isHideToolbarView true
5504-06 15:09:02.404 4931-4931/? D/NeoActionsActivity: pc 0.7222222 isHideToolbarView true
5604-06 15:09:02.424 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
5704-06 15:09:02.424 4931-4931/? D/NeoActionsActivity: pc 0.7314815 isHideToolbarView true
5804-06 15:09:02.424 4931-4931/? D/NeoActionsActivity: pc 0.7314815 isHideToolbarView true
5904-06 15:09:02.434 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
6004-06 15:09:02.434 4931-4931/? D/NeoActionsActivity: pc 0.7361111 isHideToolbarView true
6104-06 15:09:02.444 4931-4931/? D/NeoActionsActivity: pc 0.7361111 isHideToolbarView true
6204-06 15:09:02.524 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=406732016000
6304-06 15:09:02.524 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x1, toolType: 1
6404-06 15:09:02.524 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
6504-06 15:09:02.534 4931-4931/? D/NeoActionsActivity: pc 0.7407407 isHideToolbarView true
6604-06 15:09:02.534 4931-4931/? D/NeoActionsActivity: pc 0.7407407 isHideToolbarView true
6704-06 15:09:02.574 4931-4931/? D/NeoActionsActivity: pc 0.7453704 isHideToolbarView true
6804-06 15:09:02.574 4931-4931/? D/NeoActionsActivity: pc 0.7453704 isHideToolbarView true
6904-06 15:09:03.014 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.49 ] when=407220419000
7004-06 15:09:03.014 738-795/? D/InputReader: lastThreadEndTime = 406732321775, currentThreadStartTime = 406732321775, diff = 0
7104-06 15:09:03.014 738-794/? I/InputDispatcher: Delivering touch to (863): action: 0x4, toolType: 1
7204-06 15:09:03.014 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
7304-06 15:09:03.014 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
7404-06 15:09:03.014 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
7504-06 15:09:03.064 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=407277701000
7604-06 15:09:03.064 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x1, toolType: 1
7704-06 15:09:03.064 4931-4931/? D/RecyclerTouchListener: onInterceptTouchEvent
7804-06 15:09:03.064 4931-4931/? D/RecyclerTouchListener: onSingleTapUp
7904-06 15:09:03.074 4931-4931/? D/NeoActionsActivity: onSelectItem   4
8004-06 15:09:03.074 738-1403/? D/InputDispatcher: Focused application set to: xxxx
8104-06 15:09:03.084 738-972/? D/CustomFrequencyManagerService: acquireDVFSLockLocked : type : DVFS_MIN_LIMIT  frequency : 1200000  uid : 1000  pid : 738  pkgName : ACTIVITY_RESUME_BOOSTER@6
8204-06 15:09:03.084 738-972/? D/ActivityManager: mDVFSHelper.acquire()
8304-06 15:09:03.084 738-972/? D/PowerManagerService: setKeyboardVisibility: false
8404-06 15:09:03.104 4931-4931/? D/_MControl: onActivityResult. @@ 4554 ms (chw main) 
8504-06 15:09:03.104 4931-4931/? D/_MControl: data != null: true
8604-06 15:09:03.104 4931-4931/? D/_MControl: onActivityResult :: signal = 460e8f17-fa63-4e56-a798-fb082a18925a
8704-06 15:09:03.104 4931-4931/? D/_MControl: onActivityResult :: currentActivity d7f0e2bc-b1cf-4a72-bc56-b5e2e51fcd3f
8804-06 15:09:03.104 4931-4931/? D/_MControl: onActivityResult :: currentActivity chw main (ACTIONS)
8904-06 15:09:03.104 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993before responding..--- stack size = 2
9004-06 15:09:03.104 4931-4931/? D/_MControlStack: before responding.. Stack: 2. Activity = chw main
9104-06 15:09:03.104 4931-4931/? D/_MControlStack: before responding.. Stack: 1. Activity = Login
9204-06 15:09:03.104 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993before responding..--- /stack
9304-06 15:09:03.104 4931-4931/? D/_MControlRespond: -- RESPOND to signal [460e8f17-fa63-4e56-a798-fb082a18925a] stack size [2] sourceActivity [chw main (ACTIONS)]
9404-06 15:09:03.104 4931-4931/? D/_MControlRespond: respond 460e8f17-fa63-4e56-a798-fb082a18925a
9504-06 15:09:03.104 4931-4931/? D/_MControlRespond: nextActUuid 460e8f17-fa63-4e56-a798-fb082a18925a
9604-06 15:09:03.104 4931-4931/? D/_MControlRespond: nextActivity Performance (DATA_TABLE_PERIOD)
9704-06 15:09:03.104 4931-4931/? D/_MControlRespond: -- nextActivity [Performance (DATA_TABLE_PERIOD)] from signal [460e8f17-fa63-4e56-a798-fb082a18925a]   
9804-06 15:09:03.104 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993before rendering..--- stack size = 2
9904-06 15:09:03.104 4931-4931/? D/_MControlStack: before rendering.. Stack: 2. Activity = chw main
10004-06 15:09:03.104 4931-4931/? D/_MControlStack: before rendering.. Stack: 1. Activity = Login
10104-06 15:09:03.104 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993before rendering..--- /stack
10204-06 15:09:03.104 4931-4931/? D/ControllerRender: rendering activity: [Performance] template [DATA_TABLE_PERIOD] object [null] type [null]
10304-06 15:09:03.104 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993Pushing Performance LASTTAB null
10404-06 15:09:03.104 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993after push--- stack size = 3
10504-06 15:09:03.104 4931-4931/? D/_MControlStack: after push Stack: 3. Activity = Performance
10604-06 15:09:03.104 4931-4931/? D/_MControlStack: after push Stack: 2. Activity = chw main
10704-06 15:09:03.104 4931-4931/? D/_MControlStack: after push Stack: 1. Activity = Login
10804-06 15:09:03.104 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993after push--- /stack
10904-06 15:09:03.104 4931-4931/? D/_MControlInit: LANG: en
11004-06 15:09:03.104 4931-4931/? D/_MControlInit: COUNTRY: 
11104-06 15:09:03.104 4931-4931/? D/_MControlInit: LOCALE SET: en
11204-06 15:09:03.104 4931-4931/? D/ControllerRender: @@ 2 ms time required in RENDER before starting activity: DATA_TABLE_PERIOD 
11304-06 15:09:03.104 4931-4931/? D/ControllerRender: startActivityForResult .. by com.tp.mangoneo.app.controller.ControllerActivity@25ceda62
11404-06 15:09:03.104 4931-4931/? I/Timeline: Timeline: Activity_launch_request id:com.tp.mangoandroid time:407316
11504-06 15:09:03.114 738-751/? D/CustomFrequencyManagerService: releaseDVFSLockLocked : Getting Lock type frm List : DVFS_MIN_LIMIT  frequency : 1200000  uid : 1000  pid : 738  tag : ACTIVITY_RESUME_BOOSTER@6
11604-06 15:09:03.114 738-751/? D/CustomFrequencyManagerService: acquireDVFSLockLocked : type : DVFS_MIN_LIMIT  frequency : 1200000  uid : 1000  pid : 738  pkgName : ACTIVITY_RESUME_BOOSTER@6
11704-06 15:09:03.114 738-751/? D/ActivityManager: mDVFSHelper.acquire()
11804-06 15:09:03.114 738-751/? D/InputDispatcher: Focus left window: 4931
11904-06 15:09:03.114 738-768/? D/PointerIcon: setMouseIconStyle1 pointerType: 1001 iconType:101 flag:0 pid:738 uid:1000
12004-06 15:09:03.114 738-768/? D/PointerIcon: setMouseCustomIcon IconType is same.101
12104-06 15:09:03.114 738-751/? V/WindowManager: addAppToken: AppWindowToken{4331924 token=Token{2fb89db7 ActivityRecord{2453dcb6 u0 com.tp.mangoandroid/com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity t592}}} to stack=1 task=592 at 2
12204-06 15:09:03.134 738-751/? D/InputDispatcher: Focused application set to: xxxx
12304-06 15:09:03.134 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993after rendering..--- stack size = 3
12404-06 15:09:03.134 4931-4931/? D/_MControlStack: after rendering.. Stack: 3. Activity = Performance
12504-06 15:09:03.134 4931-4931/? D/_MControlStack: after rendering.. Stack: 2. Activity = chw main
12604-06 15:09:03.134 4931-4931/? D/_MControlStack: after rendering.. Stack: 1. Activity = Login
12704-06 15:09:03.134 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993after rendering..--- /stack
12804-06 15:09:03.134 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993after responding..--- stack size = 3
12904-06 15:09:03.134 4931-4931/? D/_MControlStack: after responding.. Stack: 3. Activity = Performance
13004-06 15:09:03.134 4931-4931/? D/_MControlStack: after responding.. Stack: 2. Activity = chw main
13104-06 15:09:03.134 4931-4931/? D/_MControlStack: after responding.. Stack: 1. Activity = Login
13204-06 15:09:03.134 4931-4931/? D/_MControlStack: a73e8b8e-4f5e-41bb-88b3-042495418993after responding..--- /stack
13304-06 15:09:03.134 4931-4931/? D/_MControl: @@ com.tp.mangoneo.app.controller responded in  31 ms
13404-06 15:09:03.134 4931-4931/? D/_MControl: onRestart
13504-06 15:09:03.134 4931-4931/? D/_MControl: onResume
13604-06 15:09:03.134 4931-4931/? W/Settings: Setting auto_time has moved from android.provider.Settings.System to android.provider.Settings.Global, returning read-only value.
13704-06 15:09:03.134 4931-4931/? D/TIME: autoSettingOk true
13804-06 15:09:03.144 738-763/? V/BroadcastQueue: [background] Process cur broadcast BroadcastRecord{3142dc8d u0 com.google.android.gms.gcm.ACTION_SCHEDULE qIdx=4} DELIVERED for app ProcessRecord{6181be7 1203:com.google.android.gms.persistent/u0a6}
13904-06 15:09:03.144 170-170/? E/BufferQueueCore: [com.tp.mangoandroid/com.tp.mangoneo.app.controller.ControllerActivity] setDefaultMaxBufferCount: setting count to 3, previous is 2 
14004-06 15:09:03.144 170-170/? I/SurfaceFlinger: id=103 createSurf (480x800),1 flag=404, DontrollerA
14104-06 15:09:03.164 738-1403/? D/PowerManagerService: setKeyboardVisibility: false
14204-06 15:09:03.184 738-1269/? V/WindowStateAnimator: Finishing drawing window Window{2c1fdad0 u0 d0 com.tp.mangoandroid/com.tp.mangoneo.app.controller.ControllerActivity}: mDrawState=DRAW_PENDING
14304-06 15:09:03.184 4931-4931/? W/ResourcesManager: getTopLevelResources: /data/app/com.tp.mangoandroid-1/base.apk / 1.0 running in com.tp.mangoandroid rsrc of package null
14404-06 15:09:03.194 4931-4931/? D/MangoRealmModule: (mango) Realm instance count 2
14504-06 15:09:03.194 4931-4931/? D/NeoTempl: dbName 66baf300-63e2-4621-be8d-443b620c1a16614d89fd-2ab4-44a5-a458-de28ef251004en
14604-06 15:09:03.204 4931-4931/? D/MangoRealmModule: (deployment) Realm instance count 2
14704-06 15:09:03.204 4931-4931/? D/NeoTempl: class com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity onCreate: Performance
14804-06 15:09:03.204 4931-4931/? D/DataTablePeriodActivity: onCreate
14904-06 15:09:03.204 4931-4931/? D/PhoneWindow: *FMB* installDecor mIsFloating : false
15004-06 15:09:03.204 4931-4931/? D/PhoneWindow: *FMB* installDecor flags : -2139029248
15104-06 15:09:03.214 738-763/? V/BroadcastQueue: [background] Process cur broadcast BroadcastRecord{3ab90e42 u0 com.google.android.gms.gcm.ACTION_SCHEDULE qIdx=4} DELIVERED for app ProcessRecord{6181be7 1203:com.google.android.gms.persistent/u0a6}
15204-06 15:09:03.214 4931-4931/? I/ToolbarWidgetWrapper: Progress display unsupported
15304-06 15:09:03.225 4931-4931/? D/TextView: setTypeface with style : 0
15404-06 15:09:03.225 4931-4931/? D/TextView: setTypeface with style : 0
15504-06 15:09:03.225 4931-4931/? D/MangoRealmModule: (deployment) Realm instance count 2
15604-06 15:09:03.225 4931-4931/? D/LIU: found slot with slotUuid = a0165c7c-b1e2-4462-925d-ba6d48345aaa and userUuid 6eaaabc9-fc26-4823-824c-de947a20b633
15704-06 15:09:03.225 4931-4931/? D/NeoTempl: setting subtitle from activity: Performance
15804-06 15:09:03.225 4931-4931/? D/TextView: setTypeface with style : 0
15904-06 15:09:03.235 4931-4931/? D/TextView: setTypeface with style : 0
16004-06 15:09:03.235 4931-4931/? D/NeoTempl: activity null
16104-06 15:09:03.235 738-750/? V/WindowManager: Adding window Window{61aa390 u0 d0 com.tp.mangoandroid/com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity} at 4 of 8 (after Window{3baebea u0 d0 com.tp.mangoandroid/com.tp.mangoneo.app.templates.NeoActionsActivity})
16204-06 15:09:03.245 4931-4931/? D/PhoneWindow: *FMB* isFloatingMenuEnabled mFloatingMenuBtn : null
16304-06 15:09:03.245 4931-4931/? D/PhoneWindow: *FMB* isFloatingMenuEnabled return false
16404-06 15:09:03.255 4931-4931/? D/PeriodPagerAdapter: getItem 0
16504-06 15:09:03.255 4931-4931/? D/PeriodPagerAdapter: getItem 1
16604-06 15:09:03.255 4931-4931/? D/DATATABLE:  config com.tp.mangoneo.model.app.MQueryConfigForDataTable@289ae3f0
16704-06 15:09:03.265 4931-4931/? D/DATATABLE:  config com.tp.mangoneo.model.app.MQueryConfigForDataTable@37065d69
16804-06 15:09:03.265 4931-4931/? D/TextView: setTypeface with style : 0
16904-06 15:09:03.265 4931-4931/? D/PERIOD:  period: 24220
17004-06 15:09:03.265 4931-4931/? D/DataTableCreator: Not a supervisory activity.  ObjectType is null
17104-06 15:09:03.265 4931-4931/? D/DeploymentSQLiteHelper: DataTableFragment - get - 66baf30063e24621be8d443b620c1a16614d89fd2ab444a5a458de28ef251004en
17204-06 15:09:03.275 4931-4931/? D/DataQueryExecutor:  CREATE temporary table client_count   AS 
173                                                    SELECT count(*) as val FROM client WHERE (created > 1522530000000 AND created <= 1525121999999)
17404-06 15:09:03.275 4931-4931/? D/DataQueryExecutor: CREATE temporary table scheduled_count  AS 
175                                                    SELECT count(*) as val FROM visit v 
176                                                    WHERE  (v.nextvisitdate > 1522530000000 AND v.nextvisitdate <= 1525121999999)
17704-06 15:09:03.275 4931-4931/? D/DataQueryExecutor: CREATE temporary table non_registration_visit_count  AS 
178                                                    SELECT count(*) as val FROM visit v 
179                                                    WHERE  (created > 1522530000000 AND created <= 1525121999999)
180                                                    AND not(registration)
18104-06 15:09:03.275 4931-4931/? D/DataQueryExecutor: CREATE temporary table percent_complete  AS 
182                                                    SELECT (CASE WHEN (s = 0) THEN 0 
183                                                                 WHEN (s > 0) THEN (n*100)/s
184                                                            END) as val 
185                                                            FROM 
186                                                                (SELECT val as s FROM scheduled_count) x 
187                                                                JOIN 
188                                                                (SELECT val as n from non_registration_visit_count) y
18904-06 15:09:03.275 4931-4931/? D/DataQueryExecutor: CREATE temporary table stipend_registrations  AS 
190                                                    SELECT 
191                                                     (CASE WHEN (clientsRegistered < 2) THEN 0
192                                                              WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
193                                                              WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
194                                                             WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
195                                                      FROM 
196                                                            (SELECT val as clientsRegistered FROM client_count) x 
19704-06 15:09:03.275 4931-4931/? E/SQLiteLog: (1) table stipend_registrations already exists
19804-06 15:09:03.275 4931-4931/? W/System.err: android.database.sqlite.SQLiteException: table stipend_registrations already exists (code 1): , while compiling: CREATE temporary table stipend_registrations  AS 
19904-06 15:09:03.275 4931-4931/? W/System.err: SELECT 
20004-06 15:09:03.275 4931-4931/? W/System.err:  (CASE WHEN (clientsRegistered < 2) THEN 0
20104-06 15:09:03.275 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
20204-06 15:09:03.275 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
20304-06 15:09:03.275 4931-4931/? W/System.err:          WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
20404-06 15:09:03.275 4931-4931/? W/System.err:   FROM 
20504-06 15:09:03.275 4931-4931/? W/System.err:         (SELECT val as clientsRegistered FROM client_count) x
20604-06 15:09:03.275 4931-4931/? W/System.err: #################################################################
20704-06 15:09:03.285 4931-4931/? W/System.err: Error Code : 1 (SQLITE_ERROR)
20804-06 15:09:03.285 4931-4931/? W/System.err: Caused By : SQL(query) error or missing database.
20904-06 15:09:03.285 4931-4931/? W/System.err: 	(table stipend_registrations already exists (code 1): , while compiling: CREATE temporary table stipend_registrations  AS 
21004-06 15:09:03.285 4931-4931/? W/System.err: SELECT 
21104-06 15:09:03.285 4931-4931/? W/System.err:  (CASE WHEN (clientsRegistered < 2) THEN 0
21204-06 15:09:03.285 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
21304-06 15:09:03.285 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
21404-06 15:09:03.285 4931-4931/? W/System.err:          WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
21504-06 15:09:03.285 4931-4931/? W/System.err:   FROM 
21604-06 15:09:03.285 4931-4931/? W/System.err:         (SELECT val as clientsRegistered FROM client_count) x)
21704-06 15:09:03.285 4931-4931/? W/System.err: #################################################################
21804-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
21904-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1067)
22004-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:644)
22104-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
22204-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
22304-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
22404-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812)
22504-06 15:09:03.285 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743)
22604-06 15:09:03.285 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataQueryExecutor.executeCommands(DataQueryExecutor.java:88)
22704-06 15:09:03.285 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableCreator.<init>(DataTableCreator.java:49)
22804-06 15:09:03.285 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableFragment.onActivityCreated(DataTableFragment.java:128)
22904-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.Fragment.performActivityCreated(Fragment.java:2270)
23004-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1442)
23104-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveFragmentToExpectedState(FragmentManager.java:1750)
23204-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1819)
23304-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.executeOps(BackStackRecord.java:797)
23404-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOps(FragmentManager.java:2590)
23504-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOpsTogether(FragmentManager.java:2377)
23604-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.removeRedundantOperationsAndExecute(FragmentManager.java:2332)
23704-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.execSingleAction(FragmentManager.java:2209)
23804-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.commitNowAllowingStateLoss(BackStackRecord.java:649)
23904-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.app.FragmentStatePagerAdapter.finishUpdate(FragmentStatePagerAdapter.java:167)
24004-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1238)
24104-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1086)
24204-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.onMeasure(ViewPager.java:1616)
24304-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
24404-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
24504-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
24604-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
24704-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
24804-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
24904-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
25004-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
25104-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v7.widget.ContentFrameLayout.onMeasure(ContentFrameLayout.java:139)
25204-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
25304-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
25404-06 15:09:03.285 4931-4931/? W/System.err:     at android.support.v7.widget.ActionBarOverlayLayout.onMeasure(ActionBarOverlayLayout.java:400)
25504-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
25604-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
25704-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
25804-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
25904-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
26004-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
26104-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
26204-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
26304-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
26404-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
26504-06 15:09:03.285 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
26604-06 15:09:03.285 4931-4931/? W/System.err:     at com.android.internal.policy.impl.PhoneWindow$DecorView.onMeasure(PhoneWindow.java:3076)
26704-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
26804-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performMeasure(ViewRootImpl.java:2411)
26904-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewRootImpl.measureHierarchy(ViewRootImpl.java:1429)
27004-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1677)
27104-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1314)
27204-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:7057)
27304-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.Choreographer$CallbackRecord.run(Choreographer.java:829)
27404-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.Choreographer.doCallbacks(Choreographer.java:606)
27504-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.Choreographer.doFrame(Choreographer.java:576)
27604-06 15:09:03.285 4931-4931/? W/System.err:     at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:815)
27704-06 15:09:03.285 4931-4931/? W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
27804-06 15:09:03.295 738-763/? V/BroadcastQueue: [background] Process cur broadcast BroadcastRecord{88db489 u0 com.google.android.gms.gcm.ACTION_SCHEDULE qIdx=4} DELIVERED for app ProcessRecord{6181be7 1203:com.google.android.gms.persistent/u0a6}
27904-06 15:09:03.285 4931-4931/? W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
28004-06 15:09:03.285 4931-4931/? W/System.err:     at android.os.Looper.loop(Looper.java:145)
28104-06 15:09:03.285 4931-4931/? W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:6934)
28204-06 15:09:03.285 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
28304-06 15:09:03.285 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
28404-06 15:09:03.285 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
28504-06 15:09:03.285 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
28604-06 15:09:03.285 738-1399/? D/SecContentProvider2: query(), uri = 15 selection = getToastGravityEnabledState
28704-06 15:09:03.285 4931-4931/? D/TextView: setTypeface with style : 0
28804-06 15:09:03.285 738-2900/? D/SecContentProvider2: query(), uri = 15 selection = getToastEnabledState
28904-06 15:09:03.295 738-1179/? D/SecContentProvider2: query(), uri = 15 selection = getToastShowPackageNameState
29004-06 15:09:03.305 4931-4931/? D/DataQueryExecutor:          
291                                                   
292                                                   CREATE temporary table stipend_visits  AS 
293                                                   
294                                                   SELECT 
295                                                       (CASE WHEN pc < 25 THEN 0
296                                                             WHEN (pc >= 25 AND pc < 50) THEN 5000
297                                                             WHEN (pc >= 50  AND pc < 75) THEN 10000
298                                                            WHEN  (pc >= 75) THEN 15000 END)
299                                                   as val 
300                                                       FROM 
301                                                           (SELECT val as pc from percent_complete) y
30204-06 15:09:03.305 4931-4931/? E/SQLiteLog: (1) table stipend_visits already exists
30304-06 15:09:03.305 4931-4931/? W/System.err: android.database.sqlite.SQLiteException: table stipend_visits already exists (code 1): , while compiling: CREATE temporary table stipend_visits  AS 
30404-06 15:09:03.305 4931-4931/? W/System.err: SELECT 
30504-06 15:09:03.305 4931-4931/? W/System.err:     (CASE WHEN pc < 25 THEN 0
30604-06 15:09:03.305 4931-4931/? W/System.err:           WHEN (pc >= 25 AND pc < 50) THEN 5000
30704-06 15:09:03.305 4931-4931/? W/System.err:           WHEN (pc >= 50  AND pc < 75) THEN 10000
30804-06 15:09:03.305 4931-4931/? W/System.err:          WHEN  (pc >= 75) THEN 15000 END)
30904-06 15:09:03.305 4931-4931/? W/System.err: as val 
31004-06 15:09:03.305 4931-4931/? W/System.err:     FROM 
31104-06 15:09:03.305 4931-4931/? W/System.err:         (SELECT val as pc from percent_complete) y
31204-06 15:09:03.305 4931-4931/? W/System.err: #################################################################
31304-06 15:09:03.305 4931-4931/? W/System.err: Error Code : 1 (SQLITE_ERROR)
31404-06 15:09:03.305 4931-4931/? W/System.err: Caused By : SQL(query) error or missing database.
31504-06 15:09:03.305 4931-4931/? W/System.err: 	(table stipend_visits already exists (code 1): , while compiling: CREATE temporary table stipend_visits  AS 
31604-06 15:09:03.305 4931-4931/? W/System.err: SELECT 
31704-06 15:09:03.305 4931-4931/? W/System.err:     (CASE WHEN pc < 25 THEN 0
31804-06 15:09:03.305 4931-4931/? W/System.err:           WHEN (pc >= 25 AND pc < 50) THEN 5000
31904-06 15:09:03.305 4931-4931/? W/System.err:           WHEN (pc >= 50  AND pc < 75) THEN 10000
32004-06 15:09:03.305 4931-4931/? W/System.err:          WHEN  (pc >= 75) THEN 15000 END)
32104-06 15:09:03.305 4931-4931/? W/System.err: as val 
32204-06 15:09:03.305 4931-4931/? W/System.err:     FROM 
32304-06 15:09:03.305 4931-4931/? W/System.err:         (SELECT val as pc from percent_complete) y)
32404-06 15:09:03.305 4931-4931/? W/System.err: #################################################################
32504-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
32604-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1067)
32704-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:644)
32804-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
32904-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
33004-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
33104-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812)
33204-06 15:09:03.305 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743)
33304-06 15:09:03.305 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataQueryExecutor.executeCommands(DataQueryExecutor.java:88)
33404-06 15:09:03.305 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableCreator.<init>(DataTableCreator.java:49)
33504-06 15:09:03.305 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableFragment.onActivityCreated(DataTableFragment.java:128)
33604-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.Fragment.performActivityCreated(Fragment.java:2270)
33704-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1442)
33804-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveFragmentToExpectedState(FragmentManager.java:1750)
33904-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1819)
34004-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.executeOps(BackStackRecord.java:797)
34104-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOps(FragmentManager.java:2590)
34204-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOpsTogether(FragmentManager.java:2377)
34304-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.removeRedundantOperationsAndExecute(FragmentManager.java:2332)
34404-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.execSingleAction(FragmentManager.java:2209)
34504-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.commitNowAllowingStateLoss(BackStackRecord.java:649)
34604-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.app.FragmentStatePagerAdapter.finishUpdate(FragmentStatePagerAdapter.java:167)
34704-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1238)
34804-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1086)
34904-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.onMeasure(ViewPager.java:1616)
35004-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
35104-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
35204-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
35304-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
35404-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
35504-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
35604-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
35704-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
35804-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v7.widget.ContentFrameLayout.onMeasure(ContentFrameLayout.java:139)
35904-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
36004-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
36104-06 15:09:03.305 4931-4931/? W/System.err:     at android.support.v7.widget.ActionBarOverlayLayout.onMeasure(ActionBarOverlayLayout.java:400)
36204-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
36304-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
36404-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
36504-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
36604-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
36704-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
36804-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
36904-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
37004-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
37104-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
37204-06 15:09:03.305 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
37304-06 15:09:03.305 4931-4931/? W/System.err:     at com.android.internal.policy.impl.PhoneWindow$DecorView.onMeasure(PhoneWindow.java:3076)
37404-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
37504-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performMeasure(ViewRootImpl.java:2411)
37604-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewRootImpl.measureHierarchy(ViewRootImpl.java:1429)
37704-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1677)
37804-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1314)
37904-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:7057)
38004-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.Choreographer$CallbackRecord.run(Choreographer.java:829)
38104-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.Choreographer.doCallbacks(Choreographer.java:606)
38204-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.Choreographer.doFrame(Choreographer.java:576)
38304-06 15:09:03.305 4931-4931/? W/System.err:     at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:815)
38404-06 15:09:03.305 4931-4931/? W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
38504-06 15:09:03.305 4931-4931/? W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
38604-06 15:09:03.305 4931-4931/? W/System.err:     at android.os.Looper.loop(Looper.java:145)
38704-06 15:09:03.305 4931-4931/? W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:6934)
38804-06 15:09:03.305 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
38904-06 15:09:03.305 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
39004-06 15:09:03.305 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
39104-06 15:09:03.305 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
39204-06 15:09:03.305 738-1268/? D/SecContentProvider2: query(), uri = 15 selection = getToastGravityEnabledState
39304-06 15:09:03.305 4931-4931/? D/TextView: setTypeface with style : 0
39404-06 15:09:03.315 738-1179/? D/SecContentProvider2: query(), uri = 15 selection = getToastEnabledState
39504-06 15:09:03.315 738-1398/? D/SecContentProvider2: query(), uri = 15 selection = getToastShowPackageNameState
39604-06 15:09:03.315 4931-4931/? D/DataQueryExecutor:         
397                                                   CREATE temporary table stipend  AS 
398                                                    SELECT 5000+r+v as val 
399                                                       FROM 
400                                                           (SELECT val as r from stipend_registrations) x  
401                                                           JOIN (SELECT val as v from stipend_visits) y
40204-06 15:09:03.325 4931-4931/? D/DataTableCreator: table:stipend_registrations
40304-06 15:09:03.325 4931-4931/? D/DataTableCreator: table:stipend_visits
40404-06 15:09:03.325 4931-4931/? D/DataTableCreator: table:client_count
40504-06 15:09:03.325 4931-4931/? D/DataTableCreator: table:scheduled_count
40604-06 15:09:03.325 4931-4931/? D/DataTableCreator: table:non_registration_visit_count
40704-06 15:09:03.325 4931-4931/? D/DataTableCreator: table:percent_complete
40804-06 15:09:03.325 4931-4931/? D/DataTableCreator: table:stipend
40904-06 15:09:03.325 4931-4931/? D/PERIOD:  periodCondition: (created > 1522530000000 AND created <= 1525121999999)
41004-06 15:09:03.325 4931-4931/? D/DataQueryExecutor:  query sql [ SELECT "1. Base Pay" as "Category", 5000  as "Value" FROM client_count UNION
411                                                    SELECT "2. Clients" as "Category", val  as "Value" FROM client_count UNION
412                                                    SELECT "3. Stipend (TSh.)" as "Category",val as "Value" FROM stipend_registrations UNION
413                                                    SELECT "4. Scheduled"  as "Category",val  as "Value" FROM scheduled_count UNION
414                                                    SELECT "5. Completed"  as "Category", val  as "Value" FROM non_registration_visit_count UNION
415                                                    SELECT "6. Visits: (%)" as "Category", val as "Value" FROM percent_complete UNION
416                                                    SELECT "7. Stipend  (TSh.)" as "Category",val as "Value" FROM stipend_visits UNION
417                                                    SELECT "8. Total Stipend  (TSh.)" as "Category",val as "Value" FROM stipend; ]
41804-06 15:09:03.325 4931-4931/? D/QUERY: row count 8
41904-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
42004-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 0,0 = 1. Base Pay
42104-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
42204-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 0,1 = 5000
42304-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
42404-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 1,0 = 2. Clients
42504-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
42604-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 1,1 = 0
42704-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
42804-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 2,0 = 3. Stipend (TSh.)
42904-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
43004-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 2,1 = 0
43104-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
43204-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 3,0 = 4. Scheduled
43304-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
43404-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 3,1 = 9
43504-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
43604-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 4,0 = 5. Completed
43704-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
43804-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 4,1 = 2
43904-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
44004-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 5,0 = 6. Visits: (%)
44104-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
44204-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 5,1 = 22
44304-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
44404-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 6,0 = 7. Stipend  (TSh.)
44504-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
44604-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 6,1 = 0
44704-06 15:09:03.325 4931-4931/? D/QUERY: col  = 0 col name Category
44804-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 7,0 = 8. Total Stipend  (TSh.)
44904-06 15:09:03.325 4931-4931/? D/QUERY: col  = 1 col name Value
45004-06 15:09:03.325 4931-4931/? D/QUERY: Query Value 7,1 = 5000
45104-06 15:09:03.325 4931-4931/? D/PERIOD:  periodCondition: (created > 1522530000000 AND created <= 1525121999999)
45204-06 15:09:03.325 4931-4931/? D/DataQueryExecutor: column headers 2
45304-06 15:09:03.325 4931-4931/? D/DataQueryExecutor:  header  Category
45404-06 15:09:03.325 4931-4931/? D/DataQueryExecutor:  header  Value
45504-06 15:09:03.325 4931-4931/? D/DataQueryExecutor: drop table IF EXISTS client_count
45604-06 15:09:03.335 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS scheduled_count
45704-06 15:09:03.335 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS non_registration_visit_count
45804-06 15:09:03.335 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS percent_complete
45904-06 15:09:03.335 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS stipend
46004-06 15:09:03.345 4931-4931/? D/AbsListView: Get MotionRecognitionManager
46104-06 15:09:03.345 4931-4931/? E/MotionRecognitionManager: mSContextService = null
46204-06 15:09:03.345 4931-4931/? E/MotionRecognitionManager: motionService = null
46304-06 15:09:03.345 4931-4931/? D/AbsListView: Get MotionRecognitionManager
46404-06 15:09:03.345 4931-4931/? D/values: 16
46504-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 0,0 = 1. Base Pay
46604-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 0,1 = 5000
46704-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 1,0 = 2. Clients
46804-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 1,1 = 0
46904-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 2,0 = 3. Stipend (TSh.)
47004-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 2,1 = 0
47104-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 3,0 = 4. Scheduled
47204-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 3,1 = 9
47304-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 4,0 = 5. Completed
47404-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 4,1 = 2
47504-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 5,0 = 6. Visits: (%)
47604-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 5,1 = 22
47704-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 6,0 = 7. Stipend  (TSh.)
47804-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 6,1 = 0
47904-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 7,0 = 8. Total Stipend  (TSh.)
48004-06 15:09:03.345 4931-4931/? V/ARRAYVALUES: 7,1 = 5000
48104-06 15:09:03.355 4931-4931/? D/DATATABLE: child views 1
48204-06 15:09:03.355 4931-4931/? D/TextView: setTypeface with style : 0
48304-06 15:09:03.355 4931-4931/? D/PERIOD:  period: 24219
48404-06 15:09:03.355 4931-4931/? D/DataTableCreator: Not a supervisory activity.  ObjectType is null
48504-06 15:09:03.355 4931-4931/? D/DeploymentSQLiteHelper: DataTableFragment - get - 66baf30063e24621be8d443b620c1a16614d89fd2ab444a5a458de28ef251004en
48604-06 15:09:03.355 4931-4931/? D/DataQueryExecutor:  CREATE temporary table client_count   AS 
487                                                    SELECT count(*) as val FROM client WHERE (created > 1519851600000 AND created <= 1522529999999)
48804-06 15:09:03.355 4931-4931/? D/DataQueryExecutor: CREATE temporary table scheduled_count  AS 
489                                                    SELECT count(*) as val FROM visit v 
490                                                    WHERE  (v.nextvisitdate > 1519851600000 AND v.nextvisitdate <= 1522529999999)
49104-06 15:09:03.355 4931-4931/? D/DataQueryExecutor: CREATE temporary table non_registration_visit_count  AS 
492                                                    SELECT count(*) as val FROM visit v 
493                                                    WHERE  (created > 1519851600000 AND created <= 1522529999999)
494                                                    AND not(registration)
49504-06 15:09:03.365 4931-4931/? D/DataQueryExecutor: CREATE temporary table percent_complete  AS 
496                                                    SELECT (CASE WHEN (s = 0) THEN 0 
497                                                                 WHEN (s > 0) THEN (n*100)/s
498                                                            END) as val 
499                                                            FROM 
500                                                                (SELECT val as s FROM scheduled_count) x 
501                                                                JOIN 
502                                                                (SELECT val as n from non_registration_visit_count) y
50304-06 15:09:03.365 4931-4931/? D/DataQueryExecutor: CREATE temporary table stipend_registrations  AS 
504                                                    SELECT 
505                                                     (CASE WHEN (clientsRegistered < 2) THEN 0
506                                                              WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
507                                                              WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
508                                                             WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
509                                                      FROM 
510                                                            (SELECT val as clientsRegistered FROM client_count) x 
51104-06 15:09:03.365 4931-4931/? E/SQLiteLog: (1) table stipend_registrations already exists
51204-06 15:09:03.365 4931-4931/? W/System.err: android.database.sqlite.SQLiteException: table stipend_registrations already exists (code 1): , while compiling: CREATE temporary table stipend_registrations  AS 
51304-06 15:09:03.365 4931-4931/? W/System.err: SELECT 
51404-06 15:09:03.365 4931-4931/? W/System.err:  (CASE WHEN (clientsRegistered < 2) THEN 0
51504-06 15:09:03.365 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
51604-06 15:09:03.365 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
51704-06 15:09:03.365 4931-4931/? W/System.err:          WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
51804-06 15:09:03.365 4931-4931/? W/System.err:   FROM 
51904-06 15:09:03.365 4931-4931/? W/System.err:         (SELECT val as clientsRegistered FROM client_count) x
52004-06 15:09:03.365 4931-4931/? W/System.err: #################################################################
52104-06 15:09:03.365 4931-4931/? W/System.err: Error Code : 1 (SQLITE_ERROR)
52204-06 15:09:03.365 4931-4931/? W/System.err: Caused By : SQL(query) error or missing database.
52304-06 15:09:03.365 4931-4931/? W/System.err: 	(table stipend_registrations already exists (code 1): , while compiling: CREATE temporary table stipend_registrations  AS 
52404-06 15:09:03.365 4931-4931/? W/System.err: SELECT 
52504-06 15:09:03.365 4931-4931/? W/System.err:  (CASE WHEN (clientsRegistered < 2) THEN 0
52604-06 15:09:03.365 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
52704-06 15:09:03.365 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
52804-06 15:09:03.365 4931-4931/? W/System.err:          WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
52904-06 15:09:03.365 4931-4931/? W/System.err:   FROM 
53004-06 15:09:03.365 4931-4931/? W/System.err:         (SELECT val as clientsRegistered FROM client_count) x)
53104-06 15:09:03.365 4931-4931/? W/System.err: #################################################################
53204-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
53304-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1067)
53404-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:644)
53504-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
53604-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
53704-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
53804-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812)
53904-06 15:09:03.365 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743)
54004-06 15:09:03.365 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataQueryExecutor.executeCommands(DataQueryExecutor.java:88)
54104-06 15:09:03.365 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableCreator.<init>(DataTableCreator.java:49)
54204-06 15:09:03.365 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableFragment.onActivityCreated(DataTableFragment.java:128)
54304-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.Fragment.performActivityCreated(Fragment.java:2270)
54404-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1442)
54504-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveFragmentToExpectedState(FragmentManager.java:1750)
54604-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1819)
54704-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.executeOps(BackStackRecord.java:797)
54804-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOps(FragmentManager.java:2590)
54904-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOpsTogether(FragmentManager.java:2377)
55004-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.removeRedundantOperationsAndExecute(FragmentManager.java:2332)
55104-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.execSingleAction(FragmentManager.java:2209)
55204-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.commitNowAllowingStateLoss(BackStackRecord.java:649)
55304-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.app.FragmentStatePagerAdapter.finishUpdate(FragmentStatePagerAdapter.java:167)
55404-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1238)
55504-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1086)
55604-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.onMeasure(ViewPager.java:1616)
55704-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
55804-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
55904-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
56004-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
56104-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
56204-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
56304-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
56404-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
56504-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v7.widget.ContentFrameLayout.onMeasure(ContentFrameLayout.java:139)
56604-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
56704-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
56804-06 15:09:03.365 4931-4931/? W/System.err:     at android.support.v7.widget.ActionBarOverlayLayout.onMeasure(ActionBarOverlayLayout.java:400)
56904-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
57004-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
57104-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
57204-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
57304-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
57404-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
57504-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
57604-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
57704-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
57804-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
57904-06 15:09:03.365 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
58004-06 15:09:03.365 4931-4931/? W/System.err:     at com.android.internal.policy.impl.PhoneWindow$DecorView.onMeasure(PhoneWindow.java:3076)
58104-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
58204-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performMeasure(ViewRootImpl.java:2411)
58304-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewRootImpl.measureHierarchy(ViewRootImpl.java:1429)
58404-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1677)
58504-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1314)
58604-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:7057)
58704-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.Choreographer$CallbackRecord.run(Choreographer.java:829)
58804-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.Choreographer.doCallbacks(Choreographer.java:606)
58904-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.Choreographer.doFrame(Choreographer.java:576)
59004-06 15:09:03.365 4931-4931/? W/System.err:     at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:815)
59104-06 15:09:03.365 4931-4931/? W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
59204-06 15:09:03.365 4931-4931/? W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
59304-06 15:09:03.365 4931-4931/? W/System.err:     at android.os.Looper.loop(Looper.java:145)
59404-06 15:09:03.365 4931-4931/? W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:6934)
59504-06 15:09:03.365 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
59604-06 15:09:03.365 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
59704-06 15:09:03.365 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
59804-06 15:09:03.365 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
59904-06 15:09:03.365 738-972/? D/SecContentProvider2: query(), uri = 15 selection = getToastGravityEnabledState
60004-06 15:09:03.375 4931-4931/? D/TextView: setTypeface with style : 0
60104-06 15:09:03.375 738-1179/? D/SecContentProvider2: query(), uri = 15 selection = getToastEnabledState
60204-06 15:09:03.375 738-811/? D/SecContentProvider2: query(), uri = 15 selection = getToastShowPackageNameState
60304-06 15:09:03.375 4931-4931/? D/DataQueryExecutor:          
604                                                   
605                                                   CREATE temporary table stipend_visits  AS 
606                                                   
607                                                   SELECT 
608                                                       (CASE WHEN pc < 25 THEN 0
609                                                             WHEN (pc >= 25 AND pc < 50) THEN 5000
610                                                             WHEN (pc >= 50  AND pc < 75) THEN 10000
611                                                            WHEN  (pc >= 75) THEN 15000 END)
612                                                   as val 
613                                                       FROM 
614                                                           (SELECT val as pc from percent_complete) y
61504-06 15:09:03.375 4931-4931/? E/SQLiteLog: (1) table stipend_visits already exists
61604-06 15:09:03.375 4931-4931/? W/System.err: android.database.sqlite.SQLiteException: table stipend_visits already exists (code 1): , while compiling: CREATE temporary table stipend_visits  AS 
61704-06 15:09:03.375 4931-4931/? W/System.err: SELECT 
61804-06 15:09:03.375 4931-4931/? W/System.err:     (CASE WHEN pc < 25 THEN 0
61904-06 15:09:03.375 4931-4931/? W/System.err:           WHEN (pc >= 25 AND pc < 50) THEN 5000
62004-06 15:09:03.375 4931-4931/? W/System.err:           WHEN (pc >= 50  AND pc < 75) THEN 10000
62104-06 15:09:03.375 4931-4931/? W/System.err:          WHEN  (pc >= 75) THEN 15000 END)
62204-06 15:09:03.375 4931-4931/? W/System.err: as val 
62304-06 15:09:03.375 4931-4931/? W/System.err:     FROM 
62404-06 15:09:03.375 4931-4931/? W/System.err:         (SELECT val as pc from percent_complete) y
62504-06 15:09:03.375 4931-4931/? W/System.err: #################################################################
62604-06 15:09:03.375 4931-4931/? W/System.err: Error Code : 1 (SQLITE_ERROR)
62704-06 15:09:03.375 4931-4931/? W/System.err: Caused By : SQL(query) error or missing database.
62804-06 15:09:03.375 4931-4931/? W/System.err: 	(table stipend_visits already exists (code 1): , while compiling: CREATE temporary table stipend_visits  AS 
62904-06 15:09:03.375 4931-4931/? W/System.err: SELECT 
63004-06 15:09:03.375 4931-4931/? W/System.err:     (CASE WHEN pc < 25 THEN 0
63104-06 15:09:03.375 4931-4931/? W/System.err:           WHEN (pc >= 25 AND pc < 50) THEN 5000
63204-06 15:09:03.375 4931-4931/? W/System.err:           WHEN (pc >= 50  AND pc < 75) THEN 10000
63304-06 15:09:03.375 4931-4931/? W/System.err:          WHEN  (pc >= 75) THEN 15000 END)
63404-06 15:09:03.375 4931-4931/? W/System.err: as val 
63504-06 15:09:03.375 4931-4931/? W/System.err:     FROM 
63604-06 15:09:03.375 4931-4931/? W/System.err:         (SELECT val as pc from percent_complete) y)
63704-06 15:09:03.375 4931-4931/? W/System.err: #################################################################
63804-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
63904-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1067)
64004-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:644)
64104-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
64204-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
64304-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
64404-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812)
64504-06 15:09:03.375 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743)
64604-06 15:09:03.375 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataQueryExecutor.executeCommands(DataQueryExecutor.java:88)
64704-06 15:09:03.375 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableCreator.<init>(DataTableCreator.java:49)
64804-06 15:09:03.375 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableFragment.onActivityCreated(DataTableFragment.java:128)
64904-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.Fragment.performActivityCreated(Fragment.java:2270)
65004-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1442)
65104-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveFragmentToExpectedState(FragmentManager.java:1750)
65204-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1819)
65304-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.executeOps(BackStackRecord.java:797)
65404-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOps(FragmentManager.java:2590)
65504-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOpsTogether(FragmentManager.java:2377)
65604-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.removeRedundantOperationsAndExecute(FragmentManager.java:2332)
65704-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.execSingleAction(FragmentManager.java:2209)
65804-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.commitNowAllowingStateLoss(BackStackRecord.java:649)
65904-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.app.FragmentStatePagerAdapter.finishUpdate(FragmentStatePagerAdapter.java:167)
66004-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1238)
66104-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1086)
66204-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.onMeasure(ViewPager.java:1616)
66304-06 15:09:03.375 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
66404-06 15:09:03.375 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
66504-06 15:09:03.375 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
66604-06 15:09:03.375 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
66704-06 15:09:03.375 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
66804-06 15:09:03.375 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
66904-06 15:09:03.375 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
67004-06 15:09:03.375 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
67104-06 15:09:03.375 4931-4931/? W/System.err:     at android.support.v7.widget.ContentFrameLayout.onMeasure(ContentFrameLayout.java:139)
67204-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
67304-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
67404-06 15:09:03.385 4931-4931/? W/System.err:     at android.support.v7.widget.ActionBarOverlayLayout.onMeasure(ActionBarOverlayLayout.java:400)
67504-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
67604-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
67704-06 15:09:03.385 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
67804-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
67904-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
68004-06 15:09:03.385 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1435)
68104-06 15:09:03.385 4931-4931/? W/System.err:     at android.widget.LinearLayout.measureVertical(LinearLayout.java:721)
68204-06 15:09:03.385 4931-4931/? W/System.err:     at android.widget.LinearLayout.onMeasure(LinearLayout.java:612)
68304-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
68404-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5908)
68504-06 15:09:03.385 4931-4931/? W/System.err:     at android.widget.FrameLayout.onMeasure(FrameLayout.java:436)
68604-06 15:09:03.385 4931-4931/? W/System.err:     at com.android.internal.policy.impl.PhoneWindow$DecorView.onMeasure(PhoneWindow.java:3076)
68704-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.View.measure(View.java:18926)
68804-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performMeasure(ViewRootImpl.java:2411)
68904-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewRootImpl.measureHierarchy(ViewRootImpl.java:1429)
69004-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1677)
69104-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1314)
69204-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:7057)
69304-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.Choreographer$CallbackRecord.run(Choreographer.java:829)
69404-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.Choreographer.doCallbacks(Choreographer.java:606)
69504-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.Choreographer.doFrame(Choreographer.java:576)
69604-06 15:09:03.385 4931-4931/? W/System.err:     at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:815)
69704-06 15:09:03.385 4931-4931/? W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
69804-06 15:09:03.385 4931-4931/? W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
69904-06 15:09:03.385 4931-4931/? W/System.err:     at android.os.Looper.loop(Looper.java:145)
70004-06 15:09:03.385 4931-4931/? W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:6934)
70104-06 15:09:03.385 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
70204-06 15:09:03.385 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
70304-06 15:09:03.385 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
70404-06 15:09:03.385 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
70504-06 15:09:03.385 738-1398/? D/SecContentProvider2: query(), uri = 15 selection = getToastGravityEnabledState
70604-06 15:09:03.385 4931-4931/? D/TextView: setTypeface with style : 0
70704-06 15:09:03.385 738-1400/? D/SecContentProvider2: query(), uri = 15 selection = getToastEnabledState
70804-06 15:09:03.385 738-1403/? D/SecContentProvider2: query(), uri = 15 selection = getToastShowPackageNameState
70904-06 15:09:03.395 4931-4931/? D/DataQueryExecutor:         
710                                                   CREATE temporary table stipend  AS 
711                                                    SELECT 5000+r+v as val 
712                                                       FROM 
713                                                           (SELECT val as r from stipend_registrations) x  
714                                                           JOIN (SELECT val as v from stipend_visits) y
71504-06 15:09:03.395 4931-4931/? D/DataTableCreator: table:stipend_registrations
71604-06 15:09:03.395 4931-4931/? D/DataTableCreator: table:stipend_visits
71704-06 15:09:03.395 4931-4931/? D/DataTableCreator: table:client_count
71804-06 15:09:03.395 4931-4931/? D/DataTableCreator: table:scheduled_count
71904-06 15:09:03.395 4931-4931/? D/DataTableCreator: table:non_registration_visit_count
72004-06 15:09:03.395 4931-4931/? D/DataTableCreator: table:percent_complete
72104-06 15:09:03.395 4931-4931/? D/DataTableCreator: table:stipend
72204-06 15:09:03.395 4931-4931/? D/PERIOD:  periodCondition: (created > 1519851600000 AND created <= 1522529999999)
72304-06 15:09:03.395 4931-4931/? D/DataQueryExecutor:  query sql [ SELECT "1. Base Pay" as "Category", 5000  as "Value" FROM client_count UNION
724                                                    SELECT "2. Clients" as "Category", val  as "Value" FROM client_count UNION
725                                                    SELECT "3. Stipend (TSh.)" as "Category",val as "Value" FROM stipend_registrations UNION
726                                                    SELECT "4. Scheduled"  as "Category",val  as "Value" FROM scheduled_count UNION
727                                                    SELECT "5. Completed"  as "Category", val  as "Value" FROM non_registration_visit_count UNION
728                                                    SELECT "6. Visits: (%)" as "Category", val as "Value" FROM percent_complete UNION
729                                                    SELECT "7. Stipend  (TSh.)" as "Category",val as "Value" FROM stipend_visits UNION
730                                                    SELECT "8. Total Stipend  (TSh.)" as "Category",val as "Value" FROM stipend; ]
73104-06 15:09:03.395 4931-4931/? D/QUERY: row count 8
73204-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
73304-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 0,0 = 1. Base Pay
73404-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
73504-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 0,1 = 5000
73604-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
73704-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 1,0 = 2. Clients
73804-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
73904-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 1,1 = 2
74004-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
74104-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 2,0 = 3. Stipend (TSh.)
74204-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
74304-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 2,1 = 0
74404-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
74504-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 3,0 = 4. Scheduled
74604-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
74704-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 3,1 = 10
74804-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
74904-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 4,0 = 5. Completed
75004-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
75104-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 4,1 = 9
75204-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
75304-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 5,0 = 6. Visits: (%)
75404-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
75504-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 5,1 = 90
75604-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
75704-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 6,0 = 7. Stipend  (TSh.)
75804-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
75904-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 6,1 = 0
76004-06 15:09:03.395 4931-4931/? D/QUERY: col  = 0 col name Category
76104-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 7,0 = 8. Total Stipend  (TSh.)
76204-06 15:09:03.395 4931-4931/? D/QUERY: col  = 1 col name Value
76304-06 15:09:03.395 4931-4931/? D/QUERY: Query Value 7,1 = 5000
76404-06 15:09:03.395 4931-4931/? D/PERIOD:  periodCondition: (created > 1519851600000 AND created <= 1522529999999)
76504-06 15:09:03.395 4931-4931/? D/DataQueryExecutor: column headers 2
76604-06 15:09:03.395 4931-4931/? D/DataQueryExecutor:  header  Category
76704-06 15:09:03.395 4931-4931/? D/DataQueryExecutor:  header  Value
76804-06 15:09:03.395 4931-4931/? D/DataQueryExecutor: drop table IF EXISTS client_count
76904-06 15:09:03.395 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS scheduled_count
77004-06 15:09:03.405 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS non_registration_visit_count
77104-06 15:09:03.405 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS percent_complete
77204-06 15:09:03.405 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS stipend
77304-06 15:09:03.405 4931-4931/? D/AbsListView: Get MotionRecognitionManager
77404-06 15:09:03.405 4931-4931/? D/AbsListView: Get MotionRecognitionManager
77504-06 15:09:03.415 4931-4931/? D/values: 16
77604-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 0,0 = 1. Base Pay
77704-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 0,1 = 5000
77804-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 1,0 = 2. Clients
77904-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 1,1 = 2
78004-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 2,0 = 3. Stipend (TSh.)
78104-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 2,1 = 0
78204-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 3,0 = 4. Scheduled
78304-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 3,1 = 10
78404-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 4,0 = 5. Completed
78504-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 4,1 = 9
78604-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 5,0 = 6. Visits: (%)
78704-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 5,1 = 90
78804-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 6,0 = 7. Stipend  (TSh.)
78904-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 6,1 = 0
79004-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 7,0 = 8. Total Stipend  (TSh.)
79104-06 15:09:03.415 4931-4931/? V/ARRAYVALUES: 7,1 = 5000
79204-06 15:09:03.415 4931-4931/? D/DATATABLE: child views 1
79304-06 15:09:03.425 170-170/? E/BufferQueueCore: [com.tp.mangoandroid/com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity] setDefaultMaxBufferCount: setting count to 3, previous is 2 
79404-06 15:09:03.425 170-170/? I/SurfaceFlinger: id=104 createSurf (1x1),1 flag=404, OeoDataTabl
79504-06 15:09:03.435 738-766/? D/StatusBarManagerService: manageDisableList userId=0 what=0x0 pkg=Window{61aa390 u0 d0 com.tp.mangoandroid/com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity}
79604-06 15:09:03.445 738-2900/? D/InputDispatcher: Focus entered window: 4931
79704-06 15:09:03.455 738-768/? D/PointerIcon: setMouseIconStyle1 pointerType: 1001 iconType:101 flag:0 pid:738 uid:1000
79804-06 15:09:03.455 738-768/? D/PointerIcon: setMouseCustomIcon IconType is same.101
79904-06 15:09:03.465 4931-4931/? D/TextView: setTypeface with style : 0
80004-06 15:09:03.465 4931-4931/? D/TextView: setTypeface with style : 0
80104-06 15:09:03.465 4931-4931/? D/TextView: setTypeface with style : 0
80204-06 15:09:03.465 4931-4931/? D/TextView: setTypeface with style : 0
80304-06 15:09:03.475 4931-4931/? D/TextView: setTypeface with style : 0
80404-06 15:09:03.475 4931-4931/? D/TextView: setTypeface with style : 0
80504-06 15:09:03.475 4931-4931/? D/TextView: setTypeface with style : 0
80604-06 15:09:03.475 4931-4931/? D/TextView: setTypeface with style : 0
80704-06 15:09:03.475 4931-4931/? D/TextView: setTypeface with style : 0
80804-06 15:09:03.485 4931-4931/? D/TextView: setTypeface with style : 0
80904-06 15:09:03.485 4931-4931/? D/TextView: setTypeface with style : 0
81004-06 15:09:03.485 4931-4931/? D/TextView: setTypeface with style : 0
81104-06 15:09:03.485 4931-4931/? D/TextView: setTypeface with style : 0
81204-06 15:09:03.485 4931-4931/? D/TextView: setTypeface with style : 0
81304-06 15:09:03.485 4931-4931/? D/TextView: setTypeface with style : 0
81404-06 15:09:03.495 4931-4931/? D/TextView: setTypeface with style : 0
81504-06 15:09:03.495 4931-4931/? D/TextView: setTypeface with style : 0
81604-06 15:09:03.495 4931-4931/? D/TextView: setTypeface with style : 0
81704-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
81804-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
81904-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
82004-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
82104-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
82204-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
82304-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
82404-06 15:09:03.505 4931-4931/? D/TextView: setTypeface with style : 0
82504-06 15:09:03.515 4931-4931/? D/TextView: setTypeface with style : 0
82604-06 15:09:03.515 4931-4931/? D/TextView: setTypeface with style : 0
82704-06 15:09:03.515 4931-4931/? D/TextView: setTypeface with style : 0
82804-06 15:09:03.515 4931-4931/? D/TextView: setTypeface with style : 0
82904-06 15:09:03.515 4931-4931/? D/TextView: setTypeface with style : 0
83004-06 15:09:03.515 4931-4931/? D/TextView: setTypeface with style : 0
83104-06 15:09:03.535 738-1268/? V/WindowStateAnimator: Finishing drawing window Window{61aa390 u0 d0 com.tp.mangoandroid/com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity}: mDrawState=DRAW_PENDING
83204-06 15:09:03.545 738-768/? D/CustomFrequencyManagerService: releaseDVFSLockLocked : Getting Lock type frm List : DVFS_MIN_LIMIT  frequency : 1200000  uid : 1000  pid : 738  tag : ACTIVITY_RESUME_BOOSTER@6
83304-06 15:09:03.545 738-768/? D/ActivityManager: mDVFSHelper.release()
83404-06 15:09:03.545 738-768/? I/Timeline: Timeline: Activity_windows_visible id: ActivityRecord{13db1ea5 u0 com.tp.mangoandroid/com.tp.mangoneo.app.controller.ControllerActivity t592} time:407759
83504-06 15:09:03.545 738-763/? D/CustomFrequencyManagerService: acquireDVFSLockLocked : type : DVFS_MIN_LIMIT  frequency : 1200000  uid : 1000  pid : 738  pkgName : ACTIVITY_RESUME_BOOSTER@12
83604-06 15:09:03.555 738-1089/? D/InputMethodManagerService: windowGainedFocus mCurrentFocusedUserId - 0 and mSecureKeypadEnabled-false
83704-06 15:09:03.555 3952-3952/? D/InputMethodFrameWorkUtils: InputMethodSubtype is found as local:en_GB
83804-06 15:09:03.555 3952-3952/? W/ContextImpl: Calling a method in the system process without a qualified user: android.app.ContextImpl.sendBroadcast:1748 android.content.ContextWrapper.sendBroadcast:392 com.sec.android.inputmethod.inputmethodframework.InputMethodFrameWorkUtils.setCurrentInputMethodSubtype:49 com.ime.framework.common.InputManagerImpl.finishInput:5075 com.sec.android.inputmethod.SamsungKeypad.onFinishInput:682 
83904-06 15:09:03.555 3952-3952/? D/InputMethodFrameWorkUtils: InputMethodSubtype is set as local:en_GB
84004-06 15:09:03.555 3952-3952/? D/SamsungIME: onStartInput: No inputType, No imeOption, isInputViewShown = false, isExtractViewShown = false, isShowInputRequested = false, isConfigChanged = false
84104-06 15:09:03.575 170-170/? E/BufferQueueCore: [Toast] setDefaultMaxBufferCount: setting count to 3, previous is 2 
84204-06 15:09:03.575 170-170/? I/SurfaceFlinger: id=105 createSurf (1x1),1 flag=4, Uoast
84304-06 15:09:03.585 170-170/? D/gralloc.sc8830: fb_post fps = 2.164033
84404-06 15:09:03.595 738-1269/? D/PowerManagerService: [api] acquire WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738
84504-06 15:09:03.645 738-750/? V/WindowStateAnimator: Finishing drawing window Window{61aa390 u0 d0 com.tp.mangoandroid/com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity}: mDrawState=HAS_DRAWN
84604-06 15:09:03.655 738-751/? V/WindowStateAnimator: Finishing drawing window Window{25478caf u0 d0 Toast}: mDrawState=DRAW_PENDING
84704-06 15:09:03.665 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
84804-06 15:09:03.665 170-244/? I/SurfaceFlinger: id=103 Removed DontrollerA (3/10)
84904-06 15:09:03.665 170-244/? I/SurfaceFlinger: id=103 Removed DontrollerA (-2/10)
85004-06 15:09:03.675 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
85104-06 15:09:03.675 738-1268/? V/WindowStateAnimator: Finishing drawing window Window{25478caf u0 d0 Toast}: mDrawState=HAS_DRAWN
85204-06 15:09:03.675 4931-4931/? I/Timeline: Timeline: Activity_idle id: android.os.BinderProxy@12d38597 time:407889
85304-06 15:09:03.685 4931-4931/? I/Timeline: Timeline: Activity_idle id: android.os.BinderProxy@3f1516d5 time:407890
85404-06 15:09:03.695 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
85504-06 15:09:03.705 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
85604-06 15:09:03.725 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
85704-06 15:09:03.745 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
85804-06 15:09:03.755 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
85904-06 15:09:03.775 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
86004-06 15:09:03.795 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
86104-06 15:09:03.805 738-768/? D/WindowAnimator: Skip setting animation background if there is an exiting window only.
86204-06 15:09:03.825 738-768/? I/Timeline: Timeline: Activity_windows_visible id: ActivityRecord{2453dcb6 u0 com.tp.mangoandroid/com.tp.mangoneo.app.templates.data.NeoDataTablePeriodActivity t592} time:408037
86304-06 15:09:03.825 4931-4931/? D/NeoTempl: class com.tp.mangoneo.app.templates.NeoActionsActivityonDestroy: chw main
86404-06 15:09:03.835 4931-4931/? D/InputMethodManager: windowDismissed mLockisused = false
86504-06 15:09:03.835 170-244/? I/SurfaceFlinger: id=102 Removed OeoActionsA (4/9)
86604-06 15:09:03.835 170-241/? I/SurfaceFlinger: id=102 Removed OeoActionsA (-2/9)
86704-06 15:09:03.845 4931-4931/? D/_MControl: onSaveInstanceState
86804-06 15:09:03.845 4931-4931/? V/ActivityThread: updateVisibility : ActivityRecord{7360500 token=android.os.BinderProxy@3f1516d5 {com.tp.mangoandroid/com.tp.mangoneo.app.controller.ControllerActivity}} show : false
86904-06 15:09:03.845 738-738/? D/CustomFrequencyManagerService: releaseDVFSLockLocked : Getting Lock type frm List : DVFS_MIN_LIMIT  frequency : 1200000  uid : 1000  pid : 738  tag : ACTIVITY_RESUME_BOOSTER@12
87004-06 15:09:04.195 738-982/? E/Watchdog: !@Sync 13 [04-06 15:09:04.207]
87104-06 15:09:06.257 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.50 ] when=410465598000
87204-06 15:09:06.257 738-795/? D/InputReader: lastThreadEndTime = 408416007078, currentThreadStartTime = 408416007078, diff = 0
87304-06 15:09:06.267 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
87404-06 15:09:06.267 738-1089/? I/NotificationService: cancelToast pkg=com.tp.mangoandroid callback=android.app.ITransientNotification$Stub$Proxy@3f5e239a
87504-06 15:09:06.267 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
87604-06 15:09:06.267 4931-4931/? D/InputMethodManager: windowDismissed mLockisused = false
87704-06 15:09:06.287 738-1268/? D/InputDispatcher: Cancel for WindowManager (server) because touched window was removed
87804-06 15:09:06.287 738-1268/? D/PowerManagerService: [api] [s] userActivity : event: 0 flags: 0 (uid: 1000 pid: 738) eventTime = 410491
87904-06 15:09:06.287 738-1268/? D/PowerManagerService: [api] release WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738 (0x0)
88004-06 15:09:06.287 738-1268/? D/PowerManagerService: [api] applyWakeLockFlagsOnReleaseLocked : userActivityNoUpdateLocked is called : SCREEN_BRIGHT_WAKE_LOCK        'WindowManager' ON_AFTER_RELEASE (uid=1000, pid=738, ws=WorkSource{10121}) (elapsedTime=2689)
88104-06 15:09:06.298 170-170/? E/BufferQueueCore: [Toast] setDefaultMaxBufferCount: setting count to 3, previous is 2 
88204-06 15:09:06.298 170-170/? I/SurfaceFlinger: id=106 createSurf (1x1),1 flag=4, Uoast
88304-06 15:09:06.308 738-1179/? D/PowerManagerService: [api] acquire WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738
88404-06 15:09:06.338 738-1400/? V/WindowStateAnimator: Finishing drawing window Window{2e5754a8 u0 d0 Toast}: mDrawState=DRAW_PENDING
88504-06 15:09:06.378 170-170/? D/gralloc.sc8830: fb_post fps = 5.016754
88604-06 15:09:06.388 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=410591177000
88704-06 15:09:06.838 170-241/? I/SurfaceFlinger: id=105 Removed Uoast (8/9)
88804-06 15:09:06.838 170-1291/? I/SurfaceFlinger: id=105 Removed Uoast (-2/9)
88904-06 15:09:06.978 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.51 ] when=411186759000
89004-06 15:09:06.978 738-795/? D/InputReader: lastThreadEndTime = 410591391599, currentThreadStartTime = 410591391599, diff = 0
89104-06 15:09:06.978 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
89204-06 15:09:06.988 738-1269/? I/NotificationService: cancelToast pkg=com.tp.mangoandroid callback=android.app.ITransientNotification$Stub$Proxy@22f662a7
89304-06 15:09:06.988 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
89404-06 15:09:06.988 738-794/? D/PowerManagerService: [api] userActivityFromNative : 60 (event: 2 flags: 0) eventTime = 411186
89504-06 15:09:06.988 4931-4931/? D/InputMethodManager: windowDismissed mLockisused = false
89604-06 15:09:07.008 738-811/? D/InputDispatcher: Cancel for WindowManager (server) because touched window was removed
89704-06 15:09:07.008 738-811/? D/PowerManagerService: [api] [s] userActivity : event: 0 flags: 0 (uid: 1000 pid: 738) eventTime = 411210
89804-06 15:09:07.008 738-811/? D/PowerManagerService: [api] release WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738 (0x0)
89904-06 15:09:07.008 738-811/? D/PowerManagerService: [api] applyWakeLockFlagsOnReleaseLocked : userActivityNoUpdateLocked is called : SCREEN_BRIGHT_WAKE_LOCK        'WindowManager' ON_AFTER_RELEASE (uid=1000, pid=738, ws=WorkSource{10121}) (elapsedTime=700)
90004-06 15:09:07.018 170-170/? E/BufferQueueCore: [Toast] setDefaultMaxBufferCount: setting count to 3, previous is 2 
90104-06 15:09:07.018 170-170/? I/SurfaceFlinger: id=107 createSurf (1x1),1 flag=4, Uoast
90204-06 15:09:07.028 738-1179/? D/PowerManagerService: [api] acquire WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738
90304-06 15:09:07.038 182-733/? D/EnterpriseController: netId is 0
90404-06 15:09:07.038 182-733/? D/Netd: getNetworkForDns: using netid 0 for uid 10121
90504-06 15:09:07.038 4931-5026/? W/io.grpc.internal.zzdf: [{0}] Failed to resolve name. status={1}
90604-06 15:09:07.058 738-1398/? V/WindowStateAnimator: Finishing drawing window Window{1df102fd u0 d0 Toast}: mDrawState=DRAW_PENDING
90704-06 15:09:07.138 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=411341605000
90804-06 15:09:07.319 182-733/? D/EnterpriseController: netId is 0
90904-06 15:09:07.319 182-733/? D/Netd: getNetworkForDns: using netid 0 for uid 10006
91004-06 15:09:07.319 1203-4250/? W/bird: [{0}] Failed to resolve name. status={1}
91104-06 15:09:07.339 182-733/? D/EnterpriseController: netId is 0
91204-06 15:09:07.339 182-733/? D/Netd: getNetworkForDns: using netid 0 for uid 10075
91304-06 15:09:07.389 170-170/? D/gralloc.sc8830: fb_post fps = 44.536533
91404-06 15:09:07.559 170-244/? I/SurfaceFlinger: id=106 Removed Uoast (8/9)
91504-06 15:09:07.569 170-241/? I/SurfaceFlinger: id=106 Removed Uoast (-2/9)
91604-06 15:09:07.769 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.52 ] when=411966605000
91704-06 15:09:07.769 738-795/? D/InputReader: lastThreadEndTime = 411341849363, currentThreadStartTime = 411341879880, diff = 0
91804-06 15:09:07.769 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
91904-06 15:09:07.769 738-1269/? I/NotificationService: cancelToast pkg=com.tp.mangoandroid callback=android.app.ITransientNotification$Stub$Proxy@3b358bf2
92004-06 15:09:07.769 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
92104-06 15:09:07.769 4931-4931/? D/InputMethodManager: windowDismissed mLockisused = false
92204-06 15:09:07.779 738-794/? D/InputDispatcher: Waiting for application to become ready for input: 4931.  Reason: Waiting because the touched window's input channel is not registered with the input dispatcher.  The window may be in the process of being removed.
92304-06 15:09:07.779 738-811/? D/InputDispatcher: Cancel for WindowManager (server) because touched window was removed
92404-06 15:09:07.779 738-811/? D/PowerManagerService: [api] [s] userActivity : event: 0 flags: 0 (uid: 1000 pid: 738) eventTime = 411987
92504-06 15:09:07.779 738-811/? D/PowerManagerService: [api] release WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738 (0x0)
92604-06 15:09:07.779 738-811/? D/PowerManagerService: [api] applyWakeLockFlagsOnReleaseLocked : userActivityNoUpdateLocked is called : SCREEN_BRIGHT_WAKE_LOCK        'WindowManager' ON_AFTER_RELEASE (uid=1000, pid=738, ws=WorkSource{10121}) (elapsedTime=749)
92704-06 15:09:07.789 170-170/? E/BufferQueueCore: [Toast] setDefaultMaxBufferCount: setting count to 3, previous is 2 
92804-06 15:09:07.789 170-170/? I/SurfaceFlinger: id=108 createSurf (1x1),1 flag=4, Uoast
92904-06 15:09:07.809 738-1401/? D/PowerManagerService: [api] acquire WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738
93004-06 15:09:07.839 738-1398/? V/WindowStateAnimator: Finishing drawing window Window{62610c0 u0 d0 Toast}: mDrawState=DRAW_PENDING
93104-06 15:09:07.879 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=412082236000
93204-06 15:09:08.329 170-1182/? I/SurfaceFlinger: id=107 Removed Uoast (8/9)
93304-06 15:09:08.329 170-1291/? I/SurfaceFlinger: id=107 Removed Uoast (-2/9)
93404-06 15:09:08.500 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.53 ] when=412707083000
93504-06 15:09:08.500 738-795/? D/InputReader: lastThreadEndTime = 412082480466, currentThreadStartTime = 412082480466, diff = 0
93604-06 15:09:08.500 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
93704-06 15:09:08.500 738-1269/? I/NotificationService: cancelToast pkg=com.tp.mangoandroid callback=android.app.ITransientNotification$Stub$Proxy@2bcfd1f9
93804-06 15:09:08.500 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
93904-06 15:09:08.500 4931-4931/? D/InputMethodManager: windowDismissed mLockisused = false
94004-06 15:09:08.510 738-750/? D/InputDispatcher: Cancel for WindowManager (server) because touched window was removed
94104-06 15:09:08.510 738-750/? D/PowerManagerService: [api] [s] userActivity : event: 0 flags: 0 (uid: 1000 pid: 738) eventTime = 412722
94204-06 15:09:08.510 738-750/? D/PowerManagerService: [api] release WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738 (0x0)
94304-06 15:09:08.510 738-750/? D/PowerManagerService: [api] applyWakeLockFlagsOnReleaseLocked : userActivityNoUpdateLocked is called : SCREEN_BRIGHT_WAKE_LOCK        'WindowManager' ON_AFTER_RELEASE (uid=1000, pid=738, ws=WorkSource{10121}) (elapsedTime=707)
94404-06 15:09:08.620 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=412832602000
94504-06 15:09:09.060 170-848/? I/SurfaceFlinger: id=108 Removed Uoast (8/8)
94604-06 15:09:09.060 170-241/? I/SurfaceFlinger: id=108 Removed Uoast (-2/8)
94704-06 15:09:10.622 210-313/? D/ENGPC: parse_event: event { 'change', '/devices/sec-battery.4/power_supply/battery', 'power_supply', '' }
94804-06 15:09:10.632 738-1179/? D/BatteryService: !@BatteryListener : batteryPropertiesChanged!
94904-06 15:09:10.632 738-1179/? D/BatteryService: level:74, scale:100, status:2, health:2, present:true, voltage: 4122, temperature: 343, technology: Li-ion, AC powered:false, USB powered:true, POGO powered:false, Wireless powered:false, icon:17303410, invalid charger:0
95004-06 15:09:10.632 738-1179/? D/BatteryService: online:4, current avg:325, charge type:1, power sharing:false, high voltage charger:false, capacity:280000, batterySWSelfDischarging:false, current_now:325
95104-06 15:09:10.632 738-738/? D/BatteryService: Sending ACTION_BATTERY_CHANGED.
95204-06 15:09:10.632 863-863/? D/KeyguardUpdateMonitor: received broadcast android.intent.action.BATTERY_CHANGED
95304-06 15:09:10.632 863-863/? I/PERF: received broadcast android.intent.action.BATTERY_CHANGED
95404-06 15:09:10.632 863-863/? D/KeyguardUpdateMonitor: handleBatteryUpdate
95504-06 15:09:10.642 863-863/? D/PhoneStatusBar: ACTION_BATTERY_CHANGED received - mBatteryLevel = 74
95604-06 15:09:10.662 863-863/? D/BatteryMeterView: ACTION_BATTERY_CHANGED : level:74 status:2 health:2
95704-06 15:09:10.662 863-863/? D/BatteryMeterView: ACTION_BATTERY_CHANGED : level:74 status:2 health:2
95804-06 15:09:10.662 863-863/? D/BatteryMeterView: ACTION_BATTERY_CHANGED : level:74 status:2 health:2
95904-06 15:09:10.662 863-863/? D/QSTile.TorchLightTile: ACTION_BATTERY_CHANGED - Level :: 74, Status :: 2
96004-06 15:09:11.002 738-761/? D/SensorService: [SO] 0.456 -0.097 9.673
96104-06 15:09:11.362 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.54 ] when=415572409000
96204-06 15:09:11.362 738-794/? I/InputDispatcher: Delivering touch to (863): action: 0x4, toolType: 1
96304-06 15:09:11.362 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
96404-06 15:09:11.362 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
96504-06 15:09:11.362 738-795/? D/InputReader: lastThreadEndTime = 412832816160, currentThreadStartTime = 412832816160, diff = 0
96604-06 15:09:11.513 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=415726950000
96704-06 15:09:11.513 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x1, toolType: 1
96804-06 15:09:11.643 738-2258/? D/SSRM:n: SIOP:: AP = 340, CUR = 325, LCD = 134
96904-06 15:09:11.883 4931-4931/? D/PeriodPagerAdapter: getItem 2
97004-06 15:09:11.913 4931-4931/? D/DATATABLE:  config com.tp.mangoneo.model.app.MQueryConfigForDataTable@280b0287
97104-06 15:09:11.923 4931-4931/? D/TextView: setTypeface with style : 0
97204-06 15:09:11.923 4931-4931/? D/PERIOD:  period: 24218
97304-06 15:09:11.923 4931-4931/? D/DataTableCreator: Not a supervisory activity.  ObjectType is null
97404-06 15:09:11.923 4931-4931/? D/DeploymentSQLiteHelper: DataTableFragment - get - 66baf30063e24621be8d443b620c1a16614d89fd2ab444a5a458de28ef251004en
97504-06 15:09:11.933 4931-4931/? D/DataQueryExecutor:  CREATE temporary table client_count   AS 
976                                                    SELECT count(*) as val FROM client WHERE (created > 1517432400000 AND created <= 1519851599999)
97704-06 15:09:11.933 4931-4931/? D/DataQueryExecutor: CREATE temporary table scheduled_count  AS 
978                                                    SELECT count(*) as val FROM visit v 
979                                                    WHERE  (v.nextvisitdate > 1517432400000 AND v.nextvisitdate <= 1519851599999)
98004-06 15:09:11.943 4931-4931/? D/DataQueryExecutor: CREATE temporary table non_registration_visit_count  AS 
981                                                    SELECT count(*) as val FROM visit v 
982                                                    WHERE  (created > 1517432400000 AND created <= 1519851599999)
983                                                    AND not(registration)
98404-06 15:09:11.943 4931-4931/? D/DataQueryExecutor: CREATE temporary table percent_complete  AS 
985                                                    SELECT (CASE WHEN (s = 0) THEN 0 
986                                                                 WHEN (s > 0) THEN (n*100)/s
987                                                            END) as val 
988                                                            FROM 
989                                                                (SELECT val as s FROM scheduled_count) x 
990                                                                JOIN 
991                                                                (SELECT val as n from non_registration_visit_count) y
99204-06 15:09:11.953 4931-4931/? D/DataQueryExecutor: CREATE temporary table stipend_registrations  AS 
993                                                    SELECT 
994                                                     (CASE WHEN (clientsRegistered < 2) THEN 0
995                                                              WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
996                                                              WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
997                                                             WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
998                                                      FROM 
999                                                            (SELECT val as clientsRegistered FROM client_count) x 
100004-06 15:09:11.963 4931-4931/? E/SQLiteLog: (1) table stipend_registrations already exists
100104-06 15:09:11.963 4931-4931/? W/System.err: android.database.sqlite.SQLiteException: table stipend_registrations already exists (code 1): , while compiling: CREATE temporary table stipend_registrations  AS 
100204-06 15:09:11.963 4931-4931/? W/System.err: SELECT 
100304-06 15:09:11.963 4931-4931/? W/System.err:  (CASE WHEN (clientsRegistered < 2) THEN 0
100404-06 15:09:11.963 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
100504-06 15:09:11.963 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
100604-06 15:09:11.963 4931-4931/? W/System.err:          WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
100704-06 15:09:11.963 4931-4931/? W/System.err:   FROM 
100804-06 15:09:11.963 4931-4931/? W/System.err:         (SELECT val as clientsRegistered FROM client_count) x
100904-06 15:09:11.963 4931-4931/? W/System.err: #################################################################
101004-06 15:09:11.963 4931-4931/? W/System.err: Error Code : 1 (SQLITE_ERROR)
101104-06 15:09:11.963 4931-4931/? W/System.err: Caused By : SQL(query) error or missing database.
101204-06 15:09:11.963 4931-4931/? W/System.err: 	(table stipend_registrations already exists (code 1): , while compiling: CREATE temporary table stipend_registrations  AS 
101304-06 15:09:11.963 4931-4931/? W/System.err: SELECT 
101404-06 15:09:11.963 4931-4931/? W/System.err:  (CASE WHEN (clientsRegistered < 2) THEN 0
101504-06 15:09:11.963 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 2  AND  clientsRegistered < 4)  THEN 5000
101604-06 15:09:11.963 4931-4931/? W/System.err:           WHEN (clientsRegistered >= 4 AND  clientsRegistered < 6) THEN 10000
101704-06 15:09:11.963 4931-4931/? W/System.err:          WHEN   (clientsRegistered >= 6) THEN 15000 END) as val
101804-06 15:09:11.963 4931-4931/? W/System.err:   FROM 
101904-06 15:09:11.963 4931-4931/? W/System.err:         (SELECT val as clientsRegistered FROM client_count) x)
102004-06 15:09:11.963 4931-4931/? W/System.err: #################################################################
102104-06 15:09:11.963 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
102204-06 15:09:11.963 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1067)
102304-06 15:09:11.963 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:644)
102404-06 15:09:11.963 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
102504-06 15:09:11.973 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
102604-06 15:09:11.973 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
102704-06 15:09:11.973 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812)
102804-06 15:09:11.973 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743)
102904-06 15:09:11.973 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataQueryExecutor.executeCommands(DataQueryExecutor.java:88)
103004-06 15:09:11.973 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableCreator.<init>(DataTableCreator.java:49)
103104-06 15:09:11.973 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableFragment.onActivityCreated(DataTableFragment.java:128)
103204-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.Fragment.performActivityCreated(Fragment.java:2270)
103304-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1442)
103404-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveFragmentToExpectedState(FragmentManager.java:1750)
103504-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1819)
103604-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.executeOps(BackStackRecord.java:797)
103704-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOps(FragmentManager.java:2590)
103804-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOpsTogether(FragmentManager.java:2377)
103904-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.removeRedundantOperationsAndExecute(FragmentManager.java:2332)
104004-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.execSingleAction(FragmentManager.java:2209)
104104-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.commitNowAllowingStateLoss(BackStackRecord.java:649)
104204-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.app.FragmentStatePagerAdapter.finishUpdate(FragmentStatePagerAdapter.java:167)
104304-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1238)
104404-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1086)
104504-06 15:09:11.973 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager$3.run(ViewPager.java:267)
104604-06 15:09:11.973 4931-4931/? W/System.err:     at android.view.Choreographer$CallbackRecord.run(Choreographer.java:829)
104704-06 15:09:11.973 4931-4931/? W/System.err:     at android.view.Choreographer.doCallbacks(Choreographer.java:606)
104804-06 15:09:11.973 4931-4931/? W/System.err:     at android.view.Choreographer.doFrame(Choreographer.java:575)
104904-06 15:09:11.973 4931-4931/? W/System.err:     at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:815)
105004-06 15:09:11.973 4931-4931/? W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
105104-06 15:09:11.973 4931-4931/? W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
105204-06 15:09:11.973 4931-4931/? W/System.err:     at android.os.Looper.loop(Looper.java:145)
105304-06 15:09:11.973 4931-4931/? W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:6934)
105404-06 15:09:11.973 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
105504-06 15:09:11.973 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
105604-06 15:09:11.973 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
105704-06 15:09:11.973 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
105804-06 15:09:11.973 738-780/? D/SecContentProvider2: query(), uri = 15 selection = getToastGravityEnabledState
105904-06 15:09:11.973 4931-4931/? D/TextView: setTypeface with style : 0
106004-06 15:09:11.973 738-2900/? D/SecContentProvider2: query(), uri = 15 selection = getToastEnabledState
106104-06 15:09:11.973 738-2160/? D/SecContentProvider2: query(), uri = 15 selection = getToastShowPackageNameState
106204-06 15:09:11.983 4931-4931/? D/DataQueryExecutor:          
1063                                                   
1064                                                   CREATE temporary table stipend_visits  AS 
1065                                                   
1066                                                   SELECT 
1067                                                       (CASE WHEN pc < 25 THEN 0
1068                                                             WHEN (pc >= 25 AND pc < 50) THEN 5000
1069                                                             WHEN (pc >= 50  AND pc < 75) THEN 10000
1070                                                            WHEN  (pc >= 75) THEN 15000 END)
1071                                                   as val 
1072                                                       FROM 
1073                                                           (SELECT val as pc from percent_complete) y
107404-06 15:09:11.983 4931-4931/? E/SQLiteLog: (1) table stipend_visits already exists
107504-06 15:09:11.983 4931-4931/? W/System.err: android.database.sqlite.SQLiteException: table stipend_visits already exists (code 1): , while compiling: CREATE temporary table stipend_visits  AS 
107604-06 15:09:11.983 4931-4931/? W/System.err: SELECT 
107704-06 15:09:11.983 4931-4931/? W/System.err:     (CASE WHEN pc < 25 THEN 0
107804-06 15:09:11.983 4931-4931/? W/System.err:           WHEN (pc >= 25 AND pc < 50) THEN 5000
107904-06 15:09:11.983 4931-4931/? W/System.err:           WHEN (pc >= 50  AND pc < 75) THEN 10000
108004-06 15:09:11.983 4931-4931/? W/System.err:          WHEN  (pc >= 75) THEN 15000 END)
108104-06 15:09:11.983 4931-4931/? W/System.err: as val 
108204-06 15:09:11.983 4931-4931/? W/System.err:     FROM 
108304-06 15:09:11.983 4931-4931/? W/System.err:         (SELECT val as pc from percent_complete) y
108404-06 15:09:11.983 4931-4931/? W/System.err: #################################################################
108504-06 15:09:11.983 4931-4931/? W/System.err: Error Code : 1 (SQLITE_ERROR)
108604-06 15:09:11.983 4931-4931/? W/System.err: Caused By : SQL(query) error or missing database.
108704-06 15:09:11.983 4931-4931/? W/System.err: 	(table stipend_visits already exists (code 1): , while compiling: CREATE temporary table stipend_visits  AS 
108804-06 15:09:11.983 4931-4931/? W/System.err: SELECT 
108904-06 15:09:11.983 4931-4931/? W/System.err:     (CASE WHEN pc < 25 THEN 0
109004-06 15:09:11.983 4931-4931/? W/System.err:           WHEN (pc >= 25 AND pc < 50) THEN 5000
109104-06 15:09:11.983 4931-4931/? W/System.err:           WHEN (pc >= 50  AND pc < 75) THEN 10000
109204-06 15:09:11.983 4931-4931/? W/System.err:          WHEN  (pc >= 75) THEN 15000 END)
109304-06 15:09:11.983 4931-4931/? W/System.err: as val 
109404-06 15:09:11.983 4931-4931/? W/System.err:     FROM 
109504-06 15:09:11.983 4931-4931/? W/System.err:         (SELECT val as pc from percent_complete) y)
109604-06 15:09:11.983 4931-4931/? W/System.err: #################################################################
109704-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
109804-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1067)
109904-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:644)
110004-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
110104-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
110204-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
110304-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812)
110404-06 15:09:11.983 4931-4931/? W/System.err:     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743)
110504-06 15:09:11.983 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataQueryExecutor.executeCommands(DataQueryExecutor.java:88)
110604-06 15:09:11.983 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableCreator.<init>(DataTableCreator.java:49)
110704-06 15:09:11.983 4931-4931/? W/System.err:     at com.tp.mangoneo.process.activities.data.DataTableFragment.onActivityCreated(DataTableFragment.java:128)
110804-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.Fragment.performActivityCreated(Fragment.java:2270)
110904-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1442)
111004-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveFragmentToExpectedState(FragmentManager.java:1750)
111104-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1819)
111204-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.executeOps(BackStackRecord.java:797)
111304-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOps(FragmentManager.java:2590)
111404-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.executeOpsTogether(FragmentManager.java:2377)
111504-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.removeRedundantOperationsAndExecute(FragmentManager.java:2332)
111604-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentManagerImpl.execSingleAction(FragmentManager.java:2209)
111704-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.BackStackRecord.commitNowAllowingStateLoss(BackStackRecord.java:649)
111804-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.app.FragmentStatePagerAdapter.finishUpdate(FragmentStatePagerAdapter.java:167)
111904-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1238)
112004-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager.populate(ViewPager.java:1086)
112104-06 15:09:11.983 4931-4931/? W/System.err:     at android.support.v4.view.ViewPager$3.run(ViewPager.java:267)
112204-06 15:09:11.983 4931-4931/? W/System.err:     at android.view.Choreographer$CallbackRecord.run(Choreographer.java:829)
112304-06 15:09:11.983 4931-4931/? W/System.err:     at android.view.Choreographer.doCallbacks(Choreographer.java:606)
112404-06 15:09:11.983 4931-4931/? W/System.err:     at android.view.Choreographer.doFrame(Choreographer.java:575)
112504-06 15:09:11.983 4931-4931/? W/System.err:     at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:815)
112604-06 15:09:11.983 4931-4931/? W/System.err:     at android.os.Handler.handleCallback(Handler.java:739)
112704-06 15:09:11.983 4931-4931/? W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:95)
112804-06 15:09:11.983 4931-4931/? W/System.err:     at android.os.Looper.loop(Looper.java:145)
112904-06 15:09:11.983 4931-4931/? W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:6934)
113004-06 15:09:11.983 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
113104-06 15:09:11.983 4931-4931/? W/System.err:     at java.lang.reflect.Method.invoke(Method.java:372)
113204-06 15:09:11.983 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
113304-06 15:09:11.983 4931-4931/? W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
113404-06 15:09:11.983 738-972/? D/SecContentProvider2: query(), uri = 15 selection = getToastGravityEnabledState
113504-06 15:09:11.983 4931-4931/? D/TextView: setTypeface with style : 0
113604-06 15:09:11.983 738-811/? D/SecContentProvider2: query(), uri = 15 selection = getToastEnabledState
113704-06 15:09:11.993 738-1179/? D/SecContentProvider2: query(), uri = 15 selection = getToastShowPackageNameState
113804-06 15:09:11.993 4931-4931/? D/DataQueryExecutor:         
1139                                                   CREATE temporary table stipend  AS 
1140                                                    SELECT 5000+r+v as val 
1141                                                       FROM 
1142                                                           (SELECT val as r from stipend_registrations) x  
1143                                                           JOIN (SELECT val as v from stipend_visits) y
114404-06 15:09:11.993 4931-4931/? D/DataTableCreator: table:stipend_registrations
114504-06 15:09:11.993 4931-4931/? D/DataTableCreator: table:stipend_visits
114604-06 15:09:11.993 4931-4931/? D/DataTableCreator: table:client_count
114704-06 15:09:11.993 4931-4931/? D/DataTableCreator: table:scheduled_count
114804-06 15:09:11.993 4931-4931/? D/DataTableCreator: table:non_registration_visit_count
114904-06 15:09:11.993 4931-4931/? D/DataTableCreator: table:percent_complete
115004-06 15:09:11.993 4931-4931/? D/DataTableCreator: table:stipend
115104-06 15:09:11.993 4931-4931/? D/PERIOD:  periodCondition: (created > 1517432400000 AND created <= 1519851599999)
115204-06 15:09:11.993 4931-4931/? D/DataQueryExecutor:  query sql [ SELECT "1. Base Pay" as "Category", 5000  as "Value" FROM client_count UNION
1153                                                    SELECT "2. Clients" as "Category", val  as "Value" FROM client_count UNION
1154                                                    SELECT "3. Stipend (TSh.)" as "Category",val as "Value" FROM stipend_registrations UNION
1155                                                    SELECT "4. Scheduled"  as "Category",val  as "Value" FROM scheduled_count UNION
1156                                                    SELECT "5. Completed"  as "Category", val  as "Value" FROM non_registration_visit_count UNION
1157                                                    SELECT "6. Visits: (%)" as "Category", val as "Value" FROM percent_complete UNION
1158                                                    SELECT "7. Stipend  (TSh.)" as "Category",val as "Value" FROM stipend_visits UNION
1159                                                    SELECT "8. Total Stipend  (TSh.)" as "Category",val as "Value" FROM stipend; ]
116004-06 15:09:11.993 4931-4931/? D/QUERY: row count 8
116104-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
116204-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 0,0 = 1. Base Pay
116304-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
116404-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 0,1 = 5000
116504-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
116604-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 1,0 = 2. Clients
116704-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
116804-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 1,1 = 6
116904-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
117004-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 2,0 = 3. Stipend (TSh.)
117104-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
117204-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 2,1 = 0
117304-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
117404-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 3,0 = 4. Scheduled
117504-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
117604-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 3,1 = 14
117704-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
117804-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 4,0 = 5. Completed
117904-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
118004-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 4,1 = 15
118104-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
118204-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 5,0 = 6. Visits: (%)
118304-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
118404-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 5,1 = 107
118504-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
118604-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 6,0 = 7. Stipend  (TSh.)
118704-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
118804-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 6,1 = 0
118904-06 15:09:11.993 4931-4931/? D/QUERY: col  = 0 col name Category
119004-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 7,0 = 8. Total Stipend  (TSh.)
119104-06 15:09:11.993 4931-4931/? D/QUERY: col  = 1 col name Value
119204-06 15:09:11.993 4931-4931/? D/QUERY: Query Value 7,1 = 5000
119304-06 15:09:11.993 4931-4931/? D/PERIOD:  periodCondition: (created > 1517432400000 AND created <= 1519851599999)
119404-06 15:09:11.993 4931-4931/? D/DataQueryExecutor: column headers 2
119504-06 15:09:11.993 4931-4931/? D/DataQueryExecutor:  header  Category
119604-06 15:09:11.993 4931-4931/? D/DataQueryExecutor:  header  Value
119704-06 15:09:11.993 4931-4931/? D/DataQueryExecutor: drop table IF EXISTS client_count
119804-06 15:09:12.003 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS scheduled_count
119904-06 15:09:12.003 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS non_registration_visit_count
120004-06 15:09:12.003 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS percent_complete
120104-06 15:09:12.003 4931-4931/? D/DataQueryExecutor: drop table  IF EXISTS stipend
120204-06 15:09:12.003 4931-4931/? D/AbsListView: Get MotionRecognitionManager
120304-06 15:09:12.013 4931-4931/? D/AbsListView: Get MotionRecognitionManager
120404-06 15:09:12.013 4931-4931/? D/values: 16
120504-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 0,0 = 1. Base Pay
120604-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 0,1 = 5000
120704-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 1,0 = 2. Clients
120804-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 1,1 = 6
120904-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 2,0 = 3. Stipend (TSh.)
121004-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 2,1 = 0
121104-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 3,0 = 4. Scheduled
121204-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 3,1 = 14
121304-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 4,0 = 5. Completed
121404-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 4,1 = 15
121504-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 5,0 = 6. Visits: (%)
121604-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 5,1 = 107
121704-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 6,0 = 7. Stipend  (TSh.)
121804-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 6,1 = 0
121904-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 7,0 = 8. Total Stipend  (TSh.)
122004-06 15:09:12.013 4931-4931/? V/ARRAYVALUES: 7,1 = 5000
122104-06 15:09:12.023 4931-4931/? D/DATATABLE: child views 1
122204-06 15:09:12.033 4931-4931/? D/TextView: setTypeface with style : 0
122304-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
122404-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
122504-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
122604-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
122704-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
122804-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
122904-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
123004-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
123104-06 15:09:12.043 4931-4931/? D/TextView: setTypeface with style : 0
123204-06 15:09:12.053 4931-4931/? D/TextView: setTypeface with style : 0
123304-06 15:09:12.053 4931-4931/? D/TextView: setTypeface with style : 0
123404-06 15:09:12.053 4931-4931/? D/TextView: setTypeface with style : 0
123504-06 15:09:12.053 4931-4931/? D/TextView: setTypeface with style : 0
123604-06 15:09:12.053 4931-4931/? D/TextView: setTypeface with style : 0
123704-06 15:09:12.053 4931-4931/? D/TextView: setTypeface with style : 0
123804-06 15:09:12.083 3952-3952/? D/InputMethodFrameWorkUtils: InputMethodSubtype is found as local:en_GB
123904-06 15:09:12.083 3952-3952/? W/ContextImpl: Calling a method in the system process without a qualified user: android.app.ContextImpl.sendBroadcast:1748 android.content.ContextWrapper.sendBroadcast:392 com.sec.android.inputmethod.inputmethodframework.InputMethodFrameWorkUtils.setCurrentInputMethodSubtype:49 com.ime.framework.common.InputManagerImpl.finishInput:5075 com.sec.android.inputmethod.SamsungKeypad.onFinishInput:682 
124004-06 15:09:12.083 3952-3952/? D/InputMethodFrameWorkUtils: InputMethodSubtype is set as local:en_GB
124104-06 15:09:12.093 3952-3952/? D/SamsungIME: onStartInput: No inputType, No imeOption, isInputViewShown = false, isExtractViewShown = false, isShowInputRequested = false, isConfigChanged = false
124204-06 15:09:12.093 170-170/? E/BufferQueueCore: [Toast] setDefaultMaxBufferCount: setting count to 3, previous is 2 
124304-06 15:09:12.093 170-170/? I/SurfaceFlinger: id=109 createSurf (1x1),1 flag=4, Uoast
124404-06 15:09:12.113 738-1400/? D/PowerManagerService: [api] acquire WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738
124504-06 15:09:12.143 738-1089/? V/WindowStateAnimator: Finishing drawing window Window{21faff9f u0 d0 Toast}: mDrawState=DRAW_PENDING
124604-06 15:09:12.173 4931-4945/? I/art: Background partial concurrent mark sweep GC freed 21948(1613KB) AllocSpace objects, 1(817KB) LOS objects, 11% free, 31MB/35MB, paused 1.037ms total 116.912ms
124704-06 15:09:12.303 5430-5470/? I/System.out: (HTTPLog)-Static: isSBSettingEnabled false
124804-06 15:09:12.303 5430-5470/? I/System.out: (HTTPLog)-Static: isShipBuild true
124904-06 15:09:12.303 5430-5470/? I/System.out: (HTTPLog)-Thread-711-152396470: SmartBonding Enabling is false, SHIP_BUILD is true, log to file is false, DBG is false
125004-06 15:09:12.303 5430-5470/? I/System.out: (HTTPLog)-Thread-711-152396470: SMARTBONDING_FEATURE_ENABLED is false
125104-06 15:09:12.303 5430-5470/? I/System.out: (HTTPLog)-Static: isSBSettingEnabled false
125204-06 15:09:12.303 5430-5470/? I/System.out: KnoxVpnUidStorageknoxVpnSupported API value returned is false
125304-06 15:09:12.303 182-733/? D/EnterpriseController: netId is 0
125404-06 15:09:12.303 182-733/? D/Netd: getNetworkForDns: using netid 0 for uid 10102
125504-06 15:09:12.303 5430-5470/? E/PlayCommon: [711] PlayEventLogger.uploadLog: Failed to connect to server: java.net.UnknownHostException: Unable to resolve host "play.googleapis.com": No address associated with hostname
125604-06 15:09:13.194 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.55 ] when=417404379000
125704-06 15:09:13.194 738-795/? D/InputReader: lastThreadEndTime = 415727194822, currentThreadStartTime = 415727194822, diff = 0
125804-06 15:09:13.194 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
125904-06 15:09:13.194 738-751/? I/NotificationService: cancelToast pkg=com.tp.mangoandroid callback=android.app.ITransientNotification$Stub$Proxy@203f29f0
126004-06 15:09:13.194 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
126104-06 15:09:13.204 4931-4931/? D/InputMethodManager: windowDismissed mLockisused = false
126204-06 15:09:13.214 738-1179/? D/InputDispatcher: Cancel for WindowManager (server) because touched window was removed
126304-06 15:09:13.214 738-1179/? D/PowerManagerService: [api] [s] userActivity : event: 0 flags: 0 (uid: 1000 pid: 738) eventTime = 417429
126404-06 15:09:13.214 738-1179/? D/PowerManagerService: [api] release WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738 (0x0)
126504-06 15:09:13.214 738-1179/? D/PowerManagerService: [api] applyWakeLockFlagsOnReleaseLocked : userActivityNoUpdateLocked is called : SCREEN_BRIGHT_WAKE_LOCK        'WindowManager' ON_AFTER_RELEASE (uid=1000, pid=738, ws=WorkSource{10121}) (elapsedTime=1105)
126604-06 15:09:13.224 170-170/? E/BufferQueueCore: [Toast] setDefaultMaxBufferCount: setting count to 3, previous is 2 
126704-06 15:09:13.224 170-170/? I/SurfaceFlinger: id=110 createSurf (1x1),1 flag=4, Uoast
126804-06 15:09:13.234 738-1401/? D/PowerManagerService: [api] acquire WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738
126904-06 15:09:13.264 738-1398/? V/WindowStateAnimator: Finishing drawing window Window{36dea9ee u0 d0 Toast}: mDrawState=DRAW_PENDING
127004-06 15:09:13.304 170-170/? D/gralloc.sc8830: fb_post fps = 6.583072
127104-06 15:09:13.314 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=417529685000
127204-06 15:09:13.725 738-795/? I/InputReader: Touch event's action is 0x0 (deviceType=0) [pCnt=1, s=0.56 ] when=417930441000
127304-06 15:09:13.725 738-1403/? I/NotificationService: cancelToast pkg=com.tp.mangoandroid callback=android.app.ITransientNotification$Stub$Proxy@10a90e8f
127404-06 15:09:13.725 738-795/? D/InputReader: lastThreadEndTime = 417529929197, currentThreadStartTime = 417529929197, diff = 0
127504-06 15:09:13.725 738-794/? I/InputDispatcher: Delivering touch to (4931): action: 0x0, toolType: 1
127604-06 15:09:13.725 4931-4931/? D/ViewRootImpl: ViewPostImeInputStage ACTION_DOWN
127704-06 15:09:13.725 4931-4931/? D/InputMethodManager: windowDismissed mLockisused = false
127804-06 15:09:13.735 738-1399/? D/InputDispatcher: Cancel for WindowManager (server) because touched window was removed
127904-06 15:09:13.735 738-1399/? D/PowerManagerService: [api] [s] userActivity : event: 0 flags: 0 (uid: 1000 pid: 738) eventTime = 417945
128004-06 15:09:13.735 738-1399/? D/PowerManagerService: [api] release WakeLock flags=0x2000000a tag=WindowManager uid=1000 pid=738 (0x0)
128104-06 15:09:13.735 738-1399/? D/PowerManagerService: [api] applyWakeLockFlagsOnReleaseLocked : userActivityNoUpdateLocked is called : SCREEN_BRIGHT_WAKE_LOCK        'WindowManager' ON_AFTER_RELEASE (uid=1000, pid=738, ws=WorkSource{10121}) (elapsedTime=501)
128204-06 15:09:13.755 170-1291/? I/SurfaceFlinger: id=109 Removed Uoast (8/9)
128304-06 15:09:13.755 170-244/? I/SurfaceFlinger: id=109 Removed Uoast (-2/9)
128404-06 15:09:13.835 738-795/? I/InputReader: Touch event's action is 0x1 (deviceType=0) [pCnt=1, s=] when=418046134000
128504-06 15:09:14.285 170-848/? I/SurfaceFlinger: id=110 Removed Uoast (8/8)
128604-06 15:09:14.285 170-1291/? I/SurfaceFlinger: id=110 Removed Uoast (-2/8)
128704-06 15:09:14.355 182-733/? D/EnterpriseController: netId is 0
128804-06 15:09:14.355 182-733/? D/Netd: getNetworkForDns: using netid 0 for uid 10121