=== 2014-04-29 14:43:53,081 [ad-3] DEBUG StrategyDataSource - SELECT cc_calc_work.AVG_TCKT_RDLRS AS averageTicketRetailDollars, cc_calc_work.CC_AVG_UNTS_RCP_PER_ITM AS avgU, cc_calc_work.CC_CHC_CNT_CALC AS calcChoiceCount, cc_calc_work.num_cc AS choiceCount, cc_calc_work.NY_RCMD_CHCS AS choiceCountRcmd, cc_calc_work.NY_RCMD_CHCS_OVRD AS choiceCountRcmdOverride, cc_calc_work.FNCL_DRCT_DLRS AS financialDirectDollars, cc_calc_work.FNCL_STR_DLRS AS financialStoreDollars, cc_calc_work.gm_pct AS gmPct, cc_calc_work.CC_CALC_ID AS id, cc_calc_work.LA_AST_ID AS la_ast_id, cc_calc_work.LAST_UPDATE AS lastUpdated, cc_calc_work.LAST_UPDATE_USR_ID AS lastUpdatedBy, cc_calc_work.LY_CUR_LOC_CNT AS lyCurrentLocCount, cc_calc_work.LY_TOT_LOC_CNT AS lyTotalLocCount, cc_calc_work.CC_NY_AVG_UNTS_RCP_PER_ITM AS newAvgReceipted, cc_calc_work.CC_NY_AVG_UNTS_RCP_PER_ITM_OVRD AS newAvgReceiptedOverride, cc_calc_work.NOTES AS notes, cc_calc_work.CC_TOO_BRD_TOO_NRW_DIFF AS pctNarrowLessBroad, cc_calc_work.CC_STR_RECVD_UNIT_PNTRN_PCT AS pctReceiptUPen, cc_calc_work.CC_SLS_UNTS_PNTRN_PCT AS pctSalesUPen, cc_calc_work.pct_too_brd AS pctTooBroad, cc_calc_work.pct_too_nrw AS pctTooNarrow, cc_calc_work.rcpt_pln_unts_ny AS plannedReceiptU, cc_calc_work.CC_RCMD_UNTS_PLN_RCP_EXT AS rcmdUPlanReceiptExt, cc_calc_work.CC_RCMD_UNTS_PLN_RCP_OVRD AS rcmdUPlanReceiptOverride, cc_calc_work.str_recvd_retl AS receiptDollars, cc_calc_work.str_recvd_unit AS receiptU, cc_calc_work.sales_k AS salesK, cc_calc_work.CC_SLS_UNTS_PNTRN_ADJ_PCT AS salesPenFinal, cc_calc_work.CC_SLS_UNTS_PNTRN_PCT_OVRD AS salesPenFinalOverride, cc_calc_work.CC_SLS_UNTS_PNTRN_TOT_PCT AS salesPenNew, cc_calc_work.sls_unts AS salesU, cc_calc_work.sellthru AS sellThru FROM cc_calc_work WHERE ((cc_calc_work.LA_STRGY_ID = 108 AND cc_calc_work.LA_STRGY_ID IS NOT NULL) AND ((cc_calc_work.LA_AST_ID IN (11798)) AND cc_calc_work.LA_AST_ID IS NOT NULL))
=== 2014-04-29 14:44:07,844 [ad-3] DEBUG SQLDriver - [builtinApplication.null] About to execute SQL query in 'SQLServer' using connection '1299764098'
=== 2014-04-29 14:44:07,845 [ad-3] INFO  SQLDriver - [builtinApplication.null] Executing SQL query on 'SQLServer': SELECT cc_calc_work.AVG_TCKT_RDLRS AS averageTicketRetailDollars, cc_calc_work.CC_AVG_UNTS_RCP_PER_ITM AS avgU, cc_calc_work.CC_CHC_CNT_CALC AS calcChoiceCount, cc_calc_work.num_cc AS choiceCount, cc_calc_work.NY_RCMD_CHCS AS choiceCountRcmd, cc_calc_work.NY_RCMD_CHCS_OVRD AS choiceCountRcmdOverride, cc_calc_work.FNCL_DRCT_DLRS AS financialDirectDollars, cc_calc_work.FNCL_STR_DLRS AS financialStoreDollars, cc_calc_work.gm_pct AS gmPct, cc_calc_work.CC_CALC_ID AS id, cc_calc_work.LA_AST_ID AS la_ast_id, cc_calc_work.LAST_UPDATE AS lastUpdated, cc_calc_work.LAST_UPDATE_USR_ID AS lastUpdatedBy, cc_calc_work.LY_CUR_LOC_CNT AS lyCurrentLocCount, cc_calc_work.LY_TOT_LOC_CNT AS lyTotalLocCount, cc_calc_work.CC_NY_AVG_UNTS_RCP_PER_ITM AS newAvgReceipted, cc_calc_work.CC_NY_AVG_UNTS_RCP_PER_ITM_OVRD AS newAvgReceiptedOverride, cc_calc_work.NOTES AS notes, cc_calc_work.CC_TOO_BRD_TOO_NRW_DIFF AS pctNarrowLessBroad, cc_calc_work.CC_STR_RECVD_UNIT_PNTRN_PCT AS pctReceiptUPen, cc_calc_work.CC_SLS_UNTS_PNTRN_PCT AS pctSalesUPen, cc_calc_work.pct_too_brd AS pctTooBroad, cc_calc_work.pct_too_nrw AS pctTooNarrow, cc_calc_work.rcpt_pln_unts_ny AS plannedReceiptU, cc_calc_work.CC_RCMD_UNTS_PLN_RCP_EXT AS rcmdUPlanReceiptExt, cc_calc_work.CC_RCMD_UNTS_PLN_RCP_OVRD AS rcmdUPlanReceiptOverride, cc_calc_work.str_recvd_retl AS receiptDollars, cc_calc_work.str_recvd_unit AS receiptU, cc_calc_work.sales_k AS salesK, cc_calc_work.CC_SLS_UNTS_PNTRN_ADJ_PCT AS salesPenFinal, cc_calc_work.CC_SLS_UNTS_PNTRN_PCT_OVRD AS salesPenFinalOverride, cc_calc_work.CC_SLS_UNTS_PNTRN_TOT_PCT AS salesPenNew, cc_calc_work.sls_unts AS salesU, cc_calc_work.sellthru AS sellThru, LA_AST.PARENT_ID AS la_parent_id, LA_AST.LA_STRGY_ID AS la_strategy_id, LA_AST.Q_STR_GRD AS storeGrade, LA_AST.ny_avail_sz_cnt AS availSizes FROM cc_calc_work, LA_AST WHERE ((LA_AST.LA_STRGY_ID = 108 AND LA_AST.LA_STRGY_ID IS NOT NULL) AND ((cc_calc_work.LA_AST_ID IN (11798)) AND cc_calc_work.LA_AST_ID IS NOT NULL)) AND cc_calc_work.LA_AST_ID = LA_AST.LA_AST_ID
=== 2014-04-29 14:44:07,891 [ad-3] DEBUG SQLDriver - Freeing SQLDriver dbConnection 1299764098
=== 2014-04-29 14:44:26,116 [ad-3] DEBUG StrategyDataSource - after request run SELECT cc_calc_work.AVG_TCKT_RDLRS AS averageTicketRetailDollars, cc_calc_work.CC_AVG_UNTS_RCP_PER_ITM AS avgU, cc_calc_work.CC_CHC_CNT_CALC AS calcChoiceCount, cc_calc_work.num_cc AS choiceCount, cc_calc_work.NY_RCMD_CHCS AS choiceCountRcmd, cc_calc_work.NY_RCMD_CHCS_OVRD AS choiceCountRcmdOverride, cc_calc_work.FNCL_DRCT_DLRS AS financialDirectDollars, cc_calc_work.FNCL_STR_DLRS AS financialStoreDollars, cc_calc_work.gm_pct AS gmPct, cc_calc_work.CC_CALC_ID AS id, cc_calc_work.LA_AST_ID AS la_ast_id, cc_calc_work.LAST_UPDATE AS lastUpdated, cc_calc_work.LAST_UPDATE_USR_ID AS lastUpdatedBy, cc_calc_work.LY_CUR_LOC_CNT AS lyCurrentLocCount, cc_calc_work.LY_TOT_LOC_CNT AS lyTotalLocCount, cc_calc_work.CC_NY_AVG_UNTS_RCP_PER_ITM AS newAvgReceipted, cc_calc_work.CC_NY_AVG_UNTS_RCP_PER_ITM_OVRD AS newAvgReceiptedOverride, cc_calc_work.NOTES AS notes, cc_calc_work.CC_TOO_BRD_TOO_NRW_DIFF AS pctNarrowLessBroad, cc_calc_work.CC_STR_RECVD_UNIT_PNTRN_PCT AS pctReceiptUPen, cc_calc_work.CC_SLS_UNTS_PNTRN_PCT AS pctSalesUPen, cc_calc_work.pct_too_brd AS pctTooBroad, cc_calc_work.pct_too_nrw AS pctTooNarrow, cc_calc_work.rcpt_pln_unts_ny AS plannedReceiptU, cc_calc_work.CC_RCMD_UNTS_PLN_RCP_EXT AS rcmdUPlanReceiptExt, cc_calc_work.CC_RCMD_UNTS_PLN_RCP_OVRD AS rcmdUPlanReceiptOverride, cc_calc_work.str_recvd_retl AS receiptDollars, cc_calc_work.str_recvd_unit AS receiptU, cc_calc_work.sales_k AS salesK, cc_calc_work.CC_SLS_UNTS_PNTRN_ADJ_PCT AS salesPenFinal, cc_calc_work.CC_SLS_UNTS_PNTRN_PCT_OVRD AS salesPenFinalOverride, cc_calc_work.CC_SLS_UNTS_PNTRN_TOT_PCT AS salesPenNew, cc_calc_work.sls_unts AS salesU, cc_calc_work.sellthru AS sellThru, LA_AST.PARENT_ID AS la_parent_id, LA_AST.LA_STRGY_ID AS la_strategy_id, LA_AST.Q_STR_GRD AS storeGrade, LA_AST.ny_avail_sz_cnt AS availSizes FROM cc_calc_work, LA_AST WHERE ((LA_AST.LA_STRGY_ID = 108 AND LA_AST.LA_STRGY_ID IS NOT NULL) AND ((cc_calc_work.LA_AST_ID IN (11798)) AND cc_calc_work.LA_AST_ID IS NOT NULL)) AND cc_calc_work.LA_AST_ID = LA_AST.LA_AST_ID