-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Bug Severity:Medium
-
Module:BenAdmin - Enrollment
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
ZCC company
- Just to test the max length of health tier policy no - i entered a policy no as 'Alan_Dental-A+ (AA) / W lon policy name for testing the policy max length problem in SA utility server error'
- employee enrolled in respective plan
- when I tried recalculating healthcare policy no though SA utility - a server error appeared [it worked well with the smaller length policy nos]
With the client JIRA WT-7819 we have allowed to put Number, alphanumeric letters (a-z, A-Z, 0-9) with white space and only few special characters like - Plus ( + ), Hypen ( - ) , Rounded Brackets ( ( ) ), Forward Slash ( / ) and Underscore (_) for policy nos
CC - Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy Umesh Kadam
Error Log
Exception : String or binary data would be truncated.The statement has been terminated.
App Error Log : ControllerAppTier.Save->BenAdminControllerAppTier.Save->SAUtilityToolBox.Save->PlanDesignHealthTierMapping.HealthTierPolicyNoCalculation->PlanDesignHealthTierMapping.RecalculateHealthTierPolicyNo->PlanDesignHealthTierMapping.UpdatePolicyNo_logValues
Employee ID : 0
Action Name : ProcessData
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode) in d:\WT\branches\LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 65
at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.RecalculateHealthTierPolicy() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 1673
at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.ProcessData() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 629
at WORKTERRA.BenAdmin.Areas.Customization.Controllers.CustomizationController.ProcessData(SAUtilityToolboxModel objToolBoxModel) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\SAUtilityToolbox\SAUtilityToolboxController.cs:line 32
at lambda_method(Closure , ControllerBase , Object[] )
Hi Alankar Chavan,
Please find below 3Cs :
| Concern | Server Error on SA Utility if health tier policy no is of longer length and characters. |
| Cause | As per current table structure, lenght of policy number allowed in DB is 50 characters only. Hence code to insert / update policy number having length greater than 50 characters is failing. |
| Correction | We have changed size of a policy number column in a DB to allow length up to 250 characters. |
| Impacted Areas |
|
Thanks and Regards,
Abhilash Warkari
CC : Jyoti Mayne, Umesh Kadam, Vinanti Yadav
As Discussed with Alankar ;
Assigning this issue to Alankar Chavan
Priya Handepatil (Inactive)
added a comment - As Discussed with Alankar ;
Assigning this issue to Alankar Chavan This is tested on WT Stage - Worked Well
Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation
Ready for Stage
This is tested on Stage - Worked Well
Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation
Ready for Production
CC - Rakesh Roy Prasad Pise
This is tested on Production - Worked Well
Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation
CC - Prasad Pise Rakesh Roy
related to
WT-7819