Utility of broker_log_top report parser

Test step
1.select tools->Broker log top merge utility
2.select log_top.q log_tp.res path and the merge excel name and parse
3.click ok button then check whether the merge excel is right ,the A/B/C/D/E column is read from log_tp.res file,the F column SQL is parsed from log_top.q file

Issue detail:
Parse prepared statement SQL at log_top.q file to normal SQL by the bind log ,then append it to .res file , it's matched by ID which is like [Q264] [Q265].... ,at last write the merge data to excel file .If the SQL ID can't be matched , it won't be write to excel
.q file data is like the follow string
[Q264]-------------------------------------------
log_top.q:3098
06/04 15:11:32.101 (18) execute_all srv_h_id 18 /* AppsStarScore.selectAppsStarScore */ SELECT prod_no as productNo , mbr_id as memberId , prod_type_cd as productTypeCode , stscr_scr as starScore , reg_ymdt as registerYmdt FROM nst_prod_app_stscr_scr_4 WHERE prod_no = ? AND mbr_id = ?
06/04 15:11:32.101 (18) bind 1 : INT 409414
06/04 15:11:32.101 (18) bind 2 : VARCHAR (12)nvqa_3tc051
06/04 15:11:32.101 (18) execute_all 0 tuple 0 time 0.000

.res data file is like the follow string
max min avg cnt(err)
-----------------------------------------------------
[Q264] 0.557 0.508 0.540 3 (0)

the result write to excel should be:

[Q264] 0.557 0.508 0.540 3 (0) SELECT prod_no as productNo , mbr_id as memberId , prod_type_cd as productTypeCode , stscr_scr as starScore , reg_ymdt as registerYmdt FROM nst_prod_app_stscr_scr_4 WHERE prod_no = 409414 AND mbr_id = 'nvqa_3tc051'

Please check TOOLS-1180.pptx file.

Modify excel pattern

Fixed in CM8.4.1.2204 and CQB8.4.1.2204