by ellenmeserow » Wed Apr 13, 2011 10:01 pm
From the Performance log, cleared just before i encounter the problem. None of the below refers to emergency_yn:
Total Time (mm:ss:ms) Count Avg Time (mm:ss:ms) Type Action
00:00:016 1 00:00:016 Aggregate SQL select top 2 sum(cast(actual as double precision)) as sumactual, sum(cast(target as double precision)) as sumtarget, sum(cast(model as double precision)) as summodel, sum(cast(etc as double precision)) as sumetc, sum(cast(eac as double precision)) as sumeac from cm where (userid = ? and fk_projid = ?)
00:00:016 1 00:00:016 Find select top 201 proj_id from TblProj01Project where proj_id = ? order by proj_id asc
00:00:016 2 00:00:008 Relation select top 61 qa_id, tier0_id, tier1_id, recommendedrange, qacomment, tier2_id from TblLookup33QA where (tier1_id = ? and tier0_id = ? and tier2_id = ?) order by qa_id asc
00:00:015 2 00:00:007 Insert insert into cm (sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modlamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
00:00:000 1 00:00:000 Delete delete from cm where (userid = ? and fk_projid = ?) and userid = ?
00:00:000 1 00:00:000 Insert insert into cm (sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modlamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
00:00:000 1 00:00:000 Load valueList select distinct top 801 section_id, section_title from TblLookup10Section where section_id = ? order by section_title asc
00:00:000 3 00:00:000 Refresh/Rollback select top 2 sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, costmanagementid, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modl_display, modlamt, modelamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt from cm where costmanagementid = ?
00:00:000 2 00:00:000 Aggregate SQL select top 2 sum(cast(actual as double precision)) as sumactual, sum(cast(target as double precision)) as sumtarget, sum(cast(model as double precision)) as summodel, sum(cast(etc as double precision)) as sumetc, sum(cast(eac as double precision)) as sumeac from cm where (fk_projid = ? and userid = ? and tier2_id = ?)
00:00:000 1 00:00:000 Aggregate SQL select top 2 sum(cast(calcpercent as double precision)) as sumpercent, sum(cast(budget as double precision)) as sumbudget from TblContractPlan01Budget where budget_id = ?
00:00:000 1 00:00:000 Find select top 201 costmanagementid from cm where (userid = ? and fk_projid = ?) and userid = ? order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 budget_id, proj_id, tier2_id, bct_code, budget, contract_nbr, contract_desc, curve_type, update_date, end_date, start_date, UserId, update_mark, tier3_id, contract_id, calcyear, calcpercent, subnbr, tax_percent, parentbudget_id, contracttype_id, contractmilestoneshow_yn, hide_yn, converted, ytdstatusmonth, contract_title, paytype_id, loe_amt, otherfund_yn, shortscope, user_requested_id, inqtrlyrpt_yn, milestone_yn, showbudgetQtrly_yn, rfpad_date, reqrfpaddate, origscope_id from TblContractPlan01Budget where budget_id = ? order by budget_id asc
00:00:000 2 00:00:000 Load foundset select top 61 costmanagementid from cm where (fk_projid = ? and userid = ? and tier2_id = ?) order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 proj_id, ratingyear_id, eval_desc, eval_reason, eval_scope, budgetphase_id, budgetshare_id, percent_new, percent_existing, update_date, userid, update_mark, art_yn, artreason_id, artother_desc, artpercent_id, escalated_yn, model_yn, highrisk_yn, annualop_amt, opstartyear_nbr, highriskscore_amt from TblProj12EvalInfo where (proj_id = ? and ratingyear_id = ?) order by proj_id asc, ratingyear_id asc
00:00:000 1 00:00:000 Relation select top 61 screen_id, code, name, reminder_id, formname, tabname, nickname, hometabindex, projecttabindex, contracttabindex, projectfinancialstabindex, contractfinancialstabindex, projectscheduletabindex, tab1index, tab2index, tab3index, tab4index, tab5index, printing, exporting, storedproc, printing_notes, exporting_notes, readonly, help from screens where code = ? order by screen_id asc
00:00:000 2 00:00:000 Relation select top 61 sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, costmanagementid, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modl_display, modlamt, modelamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt from cm where (fk_projid = ? and userid = ? and tier2_id = ?) order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, costmanagementid, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modl_display, modlamt, modelamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt from cm where (userid = ? and fk_projid = ?) order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 target_id, target_desc, target_date, datadate, update_date, userid, escalate_amt, proj_id, prevtarget_id, master_projid, formula_id, escalatetype, CRaboveline_yn from TblLookup25TargetDate where target_id = ? order by target_id asc
00:00:000 2 00:00:000 Relation select top 61 tier2_id, tier1_id, tier2_desc, obsolete, sort_order, phase_id, budgetgroup, title_yn, omb_id, milestonegroup, ShowTaxPercent_yn from TblLookup02Tier2 where tier2_id = ? order by tier2_id asc
ellen escarcega (formerly meserow)
meserow design
Servoy 2019 9
MSSQL 2017
Windows AWS Servers