[NF-4535] Partner - Functional - When accessing BenAdmin's Safe Harbor Report, it throws system error - Workterra Jira

Rakesh Roy (Inactive) created issue - 04/Oct/17 09:02 AM

Rakesh Roy (Inactive) made changes - 04/Oct/17 09:03 AM

Field	Original Value	New Value
Bug Severity	Medium [ 16702 ]	Low [ 16703 ]

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 04/Oct/17 09:03 AM

Exception : Arithmetic overflow error converting float to data type numeric. [WTUS-SQL01].[CityofIrvine_710].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[CityofIrvine_710].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[CVHP_723].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[CVHP_723].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[Southland_847].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[Southland_847].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[ElDorado_969].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[ElDorado_969].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[MEA_1119].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[MEA_1119].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[CityofDurham_1157].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[CityofDurham_1157].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[Softchoice_1320].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[Softchoice_1320].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[CityofDenton_1365].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[CityofDenton_1365].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[FDU_1466].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[FDU_1466].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[Green_Bay_Area_Public_Schools_1577].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[Green_Bay_Area_Public_Schools_1577].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[MATT_11878].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[MATT_11878].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[FDAC_EBA_11933].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[FDAC_EBA_11933].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[County_of_Del_Norte_11941].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[County_of_Del_Norte_11941].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[JCCC_11954].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[JCCC_11954].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[JEDunn_11986].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`The statement has been terminated.Select * From [WTUS-SQL01].[JEDunn_11986].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[CAISO_12033].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[CAISO_12033].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[OhioNorthernUniversity_12063].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[OhioNorthernUniversity_12063].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[ElCaminoHospital_12099].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[ElCaminoHospital_12099].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[CityofBellevue_12269].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[CityofBellevue_12269].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[WackerNeusonCorporation_12358].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[WackerNeusonCorporation_12358].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[TotalWorks_12368].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[TotalWorks_12368].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[Prime_Centinela_Hospital_Medical_Center_12380].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[Prime_Centinela_Hospital_Medical_Center_12380].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[TIBCO_12472].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[TIBCO_12472].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[Five_Guys_Exchange_12651].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[Five_Guys_Exchange_12651].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[LONGBuildingTechnologies_12702].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[LONGBuildingTechnologies_12702].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[TSRDemoCompany_12871].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[TSRDemoCompany_12871].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[HopeCommunityResources_12899].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[HopeCommunityResources_12899].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[UiRefresh_DC_12936].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[UiRefresh_DC_12936].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[SampleCompanyTobedeleted_13572].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[SampleCompanyTobedeleted_13572].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[SampleCompany2Tobedeleted_13573].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[SampleCompany2Tobedeleted_13573].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[UI_TEST_Barrow_13574].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[UI_TEST_Barrow_13574].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[HCMDemo_13575].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[HCMDemo_13575].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[OnboardDemo_13579].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[OnboardDemo_13579].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[BenAdminDemo_13584].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[BenAdminDemo_13584].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[SampleCompany3Tobedeleted_13585].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[SampleCompany3Tobedeleted_13585].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[SampleCompany4Tobedeleted_13597].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[SampleCompany4Tobedeleted_13597].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[DemoCompanyAndrea_13622].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[DemoCompanyAndrea_13622].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[DemoCompanyEvan_13623].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[DemoCompanyEvan_13623].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[DemoCompanyRob_13624].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[DemoCompanyRob_13624].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[DemoCompanyBrian_13625].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[DemoCompanyBrian_13625].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[DemoCompanyChad_13626].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[DemoCompanyChad_13626].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[DemoCompanyJennifer_13627].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[DemoCompanyJennifer_13627].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[DemoCompanyMike_13628].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[DemoCompanyMike_13628].dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01].[SampleCompany6Tobedeleted_13629].dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01].[SampleCompany6Tobedeleted_13629].dbo.TempData_ACASafeHarbors WHERE UserId = 5400
App Error Log : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->ACASafeHarbors.SaveAndGetData->ACASafeHarbors.SaveACASafeHarborTempData
Employee ID : 0
Action Name : SafeHarborReport
Model : System.Web.Mvc.HandleErrorInfo
Controller : ACA
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.SaveAndGetData(ObjectType I_objectType, Object objInputObject, Object I_context, Hashtable I_criteria, Boolean I_mode, Boolean I_needCollection)
at WORKTERRA.BenAdmin.Areas.ACA.Models.ACAAnalytics.SafeHarborReportModel.LoadCharts()
at WORKTERRA.BenAdmin.Areas.ACA.Controllers.ACAController.SafeHarborReport()
at lambda_method(Closure , ControllerBase , Object[] )

Show

Rakesh Roy (Inactive) added a comment - 04/Oct/17 09:03 AM Exception : Arithmetic overflow error converting float to data type numeric. [WTUS-SQL01] . [CityofIrvine_710] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [CityofIrvine_710] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [CVHP_723] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [CVHP_723] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [Southland_847] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [Southland_847] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [ElDorado_969] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [ElDorado_969] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [MEA_1119] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [MEA_1119] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [CityofDurham_1157] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [CityofDurham_1157] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [Softchoice_1320] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [Softchoice_1320] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [CityofDenton_1365] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [CityofDenton_1365] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [FDU_1466] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [FDU_1466] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [Green_Bay_Area_Public_Schools_1577] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [Green_Bay_Area_Public_Schools_1577] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [MATT_11878] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [MATT_11878] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [FDAC_EBA_11933] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [FDAC_EBA_11933] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [County_of_Del_Norte_11941] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [County_of_Del_Norte_11941] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [JCCC_11954] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [JCCC_11954] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [JEDunn_11986] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`The statement has been terminated.Select * From [WTUS-SQL01] . [JEDunn_11986] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [CAISO_12033] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [CAISO_12033] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [OhioNorthernUniversity_12063] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [OhioNorthernUniversity_12063] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [ElCaminoHospital_12099] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [ElCaminoHospital_12099] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [CityofBellevue_12269] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [CityofBellevue_12269] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [WackerNeusonCorporation_12358] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [WackerNeusonCorporation_12358] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [TotalWorks_12368] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [TotalWorks_12368] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [Prime_Centinela_Hospital_Medical_Center_12380] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [Prime_Centinela_Hospital_Medical_Center_12380] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [TIBCO_12472] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [TIBCO_12472] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [Five_Guys_Exchange_12651] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [Five_Guys_Exchange_12651] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [LONGBuildingTechnologies_12702] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [LONGBuildingTechnologies_12702] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [TSRDemoCompany_12871] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [TSRDemoCompany_12871] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [HopeCommunityResources_12899] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [HopeCommunityResources_12899] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [UiRefresh_DC_12936] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [UiRefresh_DC_12936] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [SampleCompanyTobedeleted_13572] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [SampleCompanyTobedeleted_13572] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [SampleCompany2Tobedeleted_13573] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [SampleCompany2Tobedeleted_13573] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [UI_TEST_Barrow_13574] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [UI_TEST_Barrow_13574] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [HCMDemo_13575] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [HCMDemo_13575] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [OnboardDemo_13579] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [OnboardDemo_13579] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [BenAdminDemo_13584] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [BenAdminDemo_13584] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [SampleCompany3Tobedeleted_13585] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [SampleCompany3Tobedeleted_13585] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [SampleCompany4Tobedeleted_13597] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [SampleCompany4Tobedeleted_13597] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [DemoCompanyAndrea_13622] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [DemoCompanyAndrea_13622] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [DemoCompanyEvan_13623] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [DemoCompanyEvan_13623] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [DemoCompanyRob_13624] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [DemoCompanyRob_13624] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [DemoCompanyBrian_13625] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [DemoCompanyBrian_13625] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [DemoCompanyChad_13626] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [DemoCompanyChad_13626] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [DemoCompanyJennifer_13627] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [DemoCompanyJennifer_13627] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [DemoCompanyMike_13628] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [DemoCompanyMike_13628] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 [WTUS-SQL01] . [SampleCompany6Tobedeleted_13629] .dbo.OES_SP_SET_ACASafeHarborUserData `Aug 1 2017 12:00AM`,`Oct 31 2017 12:00AM`,92.50,0.095,5400,`-1`,`-1`,`-1`,`-1`,0,`0,1,2,3,4,5,6,7,8,9,10`Select * From [WTUS-SQL01] . [SampleCompany6Tobedeleted_13629] .dbo.TempData_ACASafeHarbors WHERE UserId = 5400 App Error Log : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->ACASafeHarbors.SaveAndGetData->ACASafeHarbors.SaveACASafeHarborTempData Employee ID : 0 Action Name : SafeHarborReport Model : System.Web.Mvc.HandleErrorInfo Controller : ACA Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.SaveAndGetData(ObjectType I_objectType, Object objInputObject, Object I_context, Hashtable I_criteria, Boolean I_mode, Boolean I_needCollection) at WORKTERRA.BenAdmin.Areas.ACA.Models.ACAAnalytics.SafeHarborReportModel.LoadCharts() at WORKTERRA.BenAdmin.Areas.ACA.Controllers.ACAController.SafeHarborReport() at lambda_method(Closure , ControllerBase , Object[] )

Nidhi Kaul (Inactive) made changes - 04/Oct/17 09:03 AM

Assignee

Nidhi Kaul [ nidhi.kaul ]

Prasanna Karlekar [ prasanna ]

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 04/Oct/17 09:04 AM

Prasanna Karlekar

Can you please check?

Thanks,
Nidhi.

Vijayendra Shinde

Show

Nidhi Kaul (Inactive) added a comment - 04/Oct/17 09:04 AM Prasanna Karlekar Can you please check? Thanks, Nidhi. Vijayendra Shinde

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 04/Oct/17 09:05 AM

Error is for selection of all companies,,working fine if we select less number of companies.

Show

Rakesh Roy (Inactive) added a comment - 04/Oct/17 09:05 AM Error is for selection of all companies,,working fine if we select less number of companies.

Rakesh Roy (Inactive) made changes - 04/Oct/17 09:05 AM

Account Executive		Diana Wong [ diana ]
Environment		Others [ 13600 ]

Rakesh Roy (Inactive) made changes - 04/Oct/17 09:12 AM

Module

Parent values: BenAdmin(10100)Level 1 values: Report(10109)

Parent values: ACA(10104)

Prasanna Karlekar (Inactive) made changes - 04/Oct/17 09:12 AM

Assignee

Prasanna Karlekar [ prasanna ]

Ramya Tantry [ ramya.tantry ]

Prasanna Karlekar (Inactive) made changes - 04/Oct/17 09:12 AM

Module

Parent values: ACA(10104)

Parent values: ACA(10104)Level 1 values: Reports(12001)

Permalink

Ramya Tantry (Inactive) logged work - 04/Oct/17 12:47 PM

Time Spent:

0.75h

Discussion
Draft reply

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 04/Oct/17 12:47 PM

Hi Rakesh Roy,

ACA SafeHarbor Report provides with a view on how good the company's benefit strategy is.
This is expected to run only for following :
1. Those companies whose employees are spread across companies and are falling under same EIN.
2. Group of Companies having same benefit strategy.

It is not expected to run for all companies as benefit strategy will be different for different companies and also EIN's will be different.

Please let us know your views on this.

CC: Nandkumar Prabhakar Karlekar, Kumar Chhajed,Smita Pawar

Show

Ramya Tantry (Inactive) added a comment - 04/Oct/17 12:47 PM Hi Rakesh Roy , ACA SafeHarbor Report provides with a view on how good the company's benefit strategy is. This is expected to run only for following : 1. Those companies whose employees are spread across companies and are falling under same EIN. 2. Group of Companies having same benefit strategy. It is not expected to run for all companies as benefit strategy will be different for different companies and also EIN's will be different. Please let us know your views on this. CC: Nandkumar Prabhakar Karlekar , Kumar Chhajed , Smita Pawar

Ramya Tantry (Inactive) made changes - 04/Oct/17 12:47 PM

Assignee

Ramya Tantry [ ramya.tantry ]

Rakesh Roy [ rakeshr ]

Ramya Tantry (Inactive) made changes - 04/Oct/17 12:47 PM

Remaining Estimate		8h [ 28800 ]
Original Estimate		8h [ 28800 ]

Ramya Tantry (Inactive) made changes - 04/Oct/17 12:48 PM

Remaining Estimate	8h [ 28800 ]	7.25h [ 26100 ]
Time Spent		0.75h [ 2700 ]
Worklog Id		83207 [ 83207 ]

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 04/Oct/17 03:44 PM

Thanks Ramya Tantry, i was thinking the same.

So to avoid server error there could be options like
1. Either provide validation after selection of companies
2. OR Provide some informative message on this page

Diana Wong Smita Pawar

Show

Rakesh Roy (Inactive) added a comment - 04/Oct/17 03:44 PM Thanks Ramya Tantry , i was thinking the same. So to avoid server error there could be options like 1. Either provide validation after selection of companies 2. OR Provide some informative message on this page Diana Wong Smita Pawar

Rakesh Roy (Inactive) made changes - 04/Oct/17 03:44 PM

Assignee

Rakesh Roy [ rakeshr ]

Ramya Tantry [ ramya.tantry ]

Diana Wong (Inactive) made changes - 05/Oct/17 02:45 AM

Attachment

SafeHarbors.png [ 63533 ]

Hide

Permalink

Diana Wong (Inactive) added a comment - 05/Oct/17 02:46 AM

Ramya Tantry Rakesh Roy Prasanna Karlekar I recommend to make the following change instead

Change 'Select Company(s)' to 'Select Company'
Change the listing option to a dropdown option so they can only choose one company
Remove the option of 'All Company'

In this way they are only selecting only one company so we don't need to do validation nor will it encounter any server error

Show

Diana Wong (Inactive) added a comment - 05/Oct/17 02:46 AM Ramya Tantry Rakesh Roy Prasanna Karlekar I recommend to make the following change instead Change 'Select Company(s)' to 'Select Company' Change the listing option to a dropdown option so they can only choose one company Remove the option of 'All Company' In this way they are only selecting only one company so we don't need to do validation nor will it encounter any server error

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 05/Oct/17 12:55 PM - edited

Hi Diana Wong

There is already a functionality of safe harbors for company level under ACA Analytics where in data of that company is processed.
If your recommended changes are done, it will lead to duplication of the functionality which is provided under ACA Analytics->Safe Harbors.

Currently there is a issue on company level safe harbor report : NF-4548. We will analyze it and will update the jira accordingly.

Will it be fine if we remove Global Level Safe harbor Report as it is not in use or Can you suggest any alternate views on this.

CC : Nandkumar Prabhakar Karlekar,Jennifer Leugers,Rakesh Roy,Smita Pawar,Kumar Chhajed

Show

Ramya Tantry (Inactive) added a comment - 05/Oct/17 12:55 PM - edited Hi Diana Wong There is already a functionality of safe harbors for company level under ACA Analytics where in data of that company is processed. If your recommended changes are done, it will lead to duplication of the functionality which is provided under ACA Analytics->Safe Harbors. Currently there is a issue on company level safe harbor report : NF-4548 . We will analyze it and will update the jira accordingly. Will it be fine if we remove Global Level Safe harbor Report as it is not in use or Can you suggest any alternate views on this. CC : Nandkumar Prabhakar Karlekar , Jennifer Leugers , Rakesh Roy , Smita Pawar , Kumar Chhajed

Ramya Tantry (Inactive) made changes - 05/Oct/17 12:58 PM

Assignee

Ramya Tantry [ ramya.tantry ]

Diana Wong [ diana ]

Permalink

Ramya Tantry (Inactive) logged work - 05/Oct/17 04:36 PM

Time Spent:

1.5h

Analysis of company level safe harbor
Discussion
Draft reply

Ramya Tantry (Inactive) made changes - 06/Oct/17 04:37 AM

Remaining Estimate	7.25h [ 26100 ]	5.75h [ 20700 ]
Time Spent	0.75h [ 2700 ]	2.25h [ 8100 ]
Worklog Id		83488 [ 83488 ]

Hide

Permalink

Diana Wong (Inactive) added a comment - 25/Oct/17 06:00 AM

Ramya Tantry Can please assist with hiding the Safe Harbor report on the global tier. Thank you.

Show

Diana Wong (Inactive) added a comment - 25/Oct/17 06:00 AM Ramya Tantry Can please assist with hiding the Safe Harbor report on the global tier. Thank you.

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 25/Oct/17 06:10 AM

Hi Diana Wong,

Yes, We have received approval from Jennifer Leugers to remove the Safe Harbor from Global level yesterday.
We have added this in our development queue and will take it up accordingly.

CC : Jennifer Leugers,Rakesh Roy,Nidhi Kaul,Nandkumar Prabhakar Karlekar,Smita Pawar,Kumar Chhajed

Show

Ramya Tantry (Inactive) added a comment - 25/Oct/17 06:10 AM Hi Diana Wong , Yes, We have received approval from Jennifer Leugers to remove the Safe Harbor from Global level yesterday. We have added this in our development queue and will take it up accordingly. CC : Jennifer Leugers , Rakesh Roy , Nidhi Kaul , Nandkumar Prabhakar Karlekar , Smita Pawar , Kumar Chhajed

Ramya Tantry (Inactive) made changes - 25/Oct/17 06:10 AM

Assignee

Diana Wong [ diana ]

Ramya Tantry [ ramya.tantry ]

Ramya Tantry (Inactive) made changes - 25/Oct/17 09:35 AM

Assignee

Ramya Tantry [ ramya.tantry ]

Kumar Chhajed [ kumar.chhajed ]

Kumar Chhajed (Inactive) made changes - 25/Oct/17 10:03 AM

Code Review Date		25/Oct/2017
Code Reviewed By		Ramya Tantry [ 13001 ]
Company		All Clients/Multiple Clients [ 18434 ]

Kumar Chhajed (Inactive) made changes - 25/Oct/17 11:46 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Kumar Chhajed (Inactive) made changes - 25/Oct/17 12:40 PM

Remaining Estimate	5.75h [ 20700 ]	4.25h [ 15300 ]
Time Spent	2.25h [ 8100 ]	3.75h [ 13500 ]
Worklog Id		86350 [ 86350 ]

Permalink

Kumar Chhajed (Inactive) logged work - 25/Oct/17 01:39 PM

Time Spent:

1.5h

Analysis
Writing sql script
unit testing
code review
Internal discussion
check-ins

Khandu Kshirsagar (Inactive) made changes - 25/Oct/17 01:42 PM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Kumar Chhajed (Inactive) made changes - 25/Oct/17 01:54 PM

Assignee

Kumar Chhajed [ kumar.chhajed ]

Smita Pawar [ smita.pawar ]

Hide

Permalink

Kumar Chhajed (Inactive) added a comment - 27/Oct/17 06:54 AM

Hi Smita Pawar,

This JIRA has been deployed on LB & Azure.

CC Nandkumar Prabhakar Karlekar Ramya Tantry Diana Wong Rakesh Roy Nidhi Kaul

Show

Kumar Chhajed (Inactive) added a comment - 27/Oct/17 06:54 AM Hi Smita Pawar , This JIRA has been deployed on LB & Azure. CC Nandkumar Prabhakar Karlekar Ramya Tantry Diana Wong Rakesh Roy Nidhi Kaul

Kumar Chhajed (Inactive) made changes - 31/Oct/17 05:18 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Kumar Chhajed (Inactive) made changes - 31/Oct/17 05:18 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Kumar Chhajed (Inactive) made changes - 31/Oct/17 05:18 AM

Developer

Kumar Chhajed [ kumar.chhajed ]

Satya made changes - 04/Nov/17 06:43 AM

Environment_New

Others [ 18445 ]

Smita Pawar (Inactive) made changes - 06/Nov/17 12:21 PM

Assignee

Smita Pawar [ smita.pawar ]

Rutuja Chilwar [ rutuja.chilwar ]

Rutuja Chilwar (Inactive) made changes - 07/Nov/17 05:45 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Rutuja Chilwar (Inactive) made changes - 07/Nov/17 07:01 AM

Attachment

NF-4535_done azure.png [ 67032 ]

Rutuja Chilwar (Inactive) made changes - 07/Nov/17 07:01 AM

Attachment

NF-4535_LB done.png [ 67033 ]

Hide

Permalink

Rutuja Chilwar (Inactive) added a comment - 07/Nov/17 07:02 AM - edited

verified above mentioned point for LB & Azure , now the safe harbor report under Benadmin at global level is removed.

We are keeping this point on hold as it will get move with WT-11505

CC- Rakesh Roy Sachin Hingole Smita Pawar

Show

Rutuja Chilwar (Inactive) added a comment - 07/Nov/17 07:02 AM - edited verified above mentioned point for LB & Azure , now the safe harbor report under Benadmin at global level is removed. We are keeping this point on hold as it will get move with WT-11505 CC- Rakesh Roy Sachin Hingole Smita Pawar

Rutuja Chilwar (Inactive) made changes - 07/Nov/17 07:02 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Permalink

Rutuja Chilwar (Inactive) logged work - 07/Nov/17 12:40 PM

Time Spent:

1.5h

<No comment>

Rutuja Chilwar (Inactive) made changes - 07/Nov/17 12:40 PM

Remaining Estimate	4.25h [ 15300 ]	2.75h [ 9900 ]
Time Spent	3.75h [ 13500 ]	5.25h [ 18900 ]
Worklog Id		89496 [ 89496 ]

Rutuja Chilwar (Inactive) made changes - 16/Nov/17 12:01 PM

Assignee

Rutuja Chilwar [ rutuja.chilwar ]

Smita Pawar [ smita.pawar ]

Rutuja Chilwar (Inactive) made changes - 16/Nov/17 12:33 PM

Assignee

Smita Pawar [ smita.pawar ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 22/Dec/17 07:43 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 22/Dec/17 09:05 AM

Item State

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)

Priya Dhamande (Inactive) made changes - 04/Mar/18 12:04 PM

Attachment

Screenshot (162).png [ 74022 ]

Hide

Permalink

Priya Dhamande (Inactive) added a comment - 04/Mar/18 12:10 PM

Environment: Production
Login: partner

The issue is checked for Safe Harbour report. the report appeared as expected. Screen capture attached.

So, closing jira on production.
Sachin Hingole Hrishikesh Deshpande

Show

Priya Dhamande (Inactive) added a comment - 04/Mar/18 12:10 PM Environment: Production Login: partner The issue is checked for Safe Harbour report. the report appeared as expected. Screen capture attached. So, closing jira on production. Sachin Hingole Hrishikesh Deshpande

Priya Dhamande (Inactive) made changes - 04/Mar/18 12:10 PM

Remaining Estimate	2.75h [ 9900 ]	2.25h [ 8100 ]
Time Spent	5.25h [ 18900 ]	5.75h [ 20700 ]
Worklog Id		107005 [ 107005 ]

Permalink

Priya Dhamande (Inactive) logged work - 05/Mar/18 08:00 AM - edited

Time Spent:

0.5h

Production testing

Mahendra Mungase (Inactive) made changes - 08/Mar/18 09:47 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Mahendra Mungase (Inactive) made changes - 08/Mar/18 09:47 AM

Resolution		Done [ 10000 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Mahendra Mungase (Inactive) made changes - 08/Mar/18 09:47 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Priya Dhamande (Inactive) made changes - 12/Mar/18 11:33 AM

Remaining Estimate	2.25h [ 8100 ]	1.75h [ 6300 ]
Time Spent	5.75h [ 20700 ]	6.25h [ 22500 ]
Worklog Id		107960 [ 107960 ]

Priya Dhamande (Inactive) made changes - 12/Mar/18 11:33 AM

Worklog Id

107960 [ 107960 ]

Priya Dhamande (Inactive) made changes - 12/Mar/18 11:33 AM

Time Spent	6.25h [ 22500 ]	5.75h [ 20700 ]
Worklog Id	107005 [ 107005 ]
Worklog Time Spent	0.5h [ 1800 ]

Kumar Chhajed (Inactive) made transition - 31/Oct/17 05:18 AM

Open

In Development

26d 20h 16m

1

Kumar Chhajed (Inactive) made transition - 31/Oct/17 05:18 AM

In Development

In LB Testing

2s

1

Sachin Hingole (Inactive) made transition - 22/Dec/17 07:43 AM

In LB Testing

Stage Testing

52d 3h 24m

1

Mahendra Mungase (Inactive) made transition - 08/Mar/18 09:47 AM

Stage Testing

In Production Testing

76d 2h 4m

1

Mahendra Mungase (Inactive) made transition - 08/Mar/18 09:47 AM

In Production Testing

Production Complete

8s

1

Mahendra Mungase (Inactive) made transition - 08/Mar/18 09:47 AM

Production Complete

Closed

2s

1

New Features 2017

Partner - Functional - When accessing BenAdmin's Safe Harbor Report, it throws system error

Details

Description

Attachments

Attachments

Activity

People

Dates

Time Tracking