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[] )

Prasanna Karlekar

Can you please check?

Thanks,
Nidhi.

Vijayendra Shinde

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

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 WongSmita Pawar

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

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 Can please assist with hiding the Safe Harbor report on the global tier. Thank you.

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

Hi Smita Pawar,

This JIRA has been deployed on LB & Azure.

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

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

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