Exception : Conversion from type `DBNull` to type `String` is not valid. App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->BenefitPlanDesign.GetData->BenefitPlanDesign.GetPCPDetailsNew Employee ID : 4824 Action Name : PCPCodePopup Model : System.Web.Mvc.HandleErrorInfo Controller : UserDetails Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection) in c:\WT\branches\UiRefresh-LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 101 at WORKTERRA.BenAdmin.Areas.UserDetails.Models.PCPCodeModel.InitialisePCPPopup(String planDesignId, String EffectiveDate, String IsAlreadyEnrolled, Boolean IsRecommend) at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.PCPCodePopup(String PlanDesignID, String EffectiveDate, String IsAlreadyEnrolled, Boolean IsRecommend) at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.b__3d() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.b__32(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.b__1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.b__1e(IAsyncResult asyncResult)