Hi Hrishikesh Deshpande,

Please provide snapshot of error and detailed log for this error.

Thanks,
Vijayendra

CC:Rakesh Roy, Sachin Hingole

Hi Vijayendra Shinde,

Screenshot -

Error Log -

Exception : The `Microsoft.ACE.OLEDB.12.0` provider is not registered on the local machine.
App Error Log : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->RatesImportExportExcel.ImportRatesFromExcel->RatesImportExportExcel.ImportExcelWorkbook
Employee ID : 0
Action Name : ImportRate
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
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.Customization.Models.ImportRateModel.ImportRate()
at WORKTERRA.BenAdmin.Areas.Customization.Controllers.CustomizationController.ImportRate(ImportRateModel objImportRateModel)
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.ActionInvocation.InvokeSynchronousActionMethod()
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.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
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.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass21.<>cDisplayClass2b.b_1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass21.b_1e(IAsyncResult asyncResult)

Let me know in case any details required.

Thanks,
Hrishikesh.

Hi Vijayendra Shinde,
Is this the JIRA we discussed in yesterday's call? If so, please update the next action.

Hi Hrishikesh Deshpande

Please check once build get deployed.

Thanks,
Sonali.

Hi Sonali Farakate,

We have verified the fix on codemap, the issue is still reproducible.
Server error is still displaying while importing rate.
Refer below screenshot for more details:

cc: Hrishikesh Deshpande, Prasad Pise, Sachin Hingole, Vijayendra Shinde

Hi Ashwin Wankhede

This issue is regarding `Microsoft.ACE.OLEDB.12.0` provider is not registered on the local machine.

Assigning as per discussion with Vijayendra Shinde

Thanks,
Sonali

CC: Vijayendra Shinde

Ashwin Wankhede

What is the status on this one?

Nidhi.

Hi Sonali Farakate,

As we have checked from backend. Rates are getting imported. But still the error message is showing. Can you please check it.

Previously server error was due to database components were not installed. These are working fine now.

cause :
When this issue resolved, Rate Import was working fine but getting a validation message and server error because as per old implementation it was trying to click on parent buttons to close pop-up.

So upload file and rate import buttons get clicked and hence occurring validation message and server error.

Correction : Now after Rate import we are clicking on close button So that pop-up get closed.

HI Hrishikesh Deshpande

This will be deployed in next build.

Thanks,
Sonali

Hi Sonali Farakate

Verified on codemap.
still showing server error while importing rate.
Please refer attached screen shot and error log:
server error.txt

Thanks,
Sanjana Jadhav.

CC:Hrishikesh Deshpande Prasad Pise Sachin Hingole Rakesh Roy

Hi Ashwin Wankhede

I have checked this on code map.
It's Still giving error like "The `Microsoft.ACE.OLEDB.12.0` provider is not registered on the local machine."
Please Look in to this.

Thanks,
Sonali

Hi Ashwin Wankhede Sonali Farakate,

This issue is Deployed and Reopened on Pre-Production.

Rate Import is still throwing server error on Pre-Prod.

Screenshot -

Error log -

Exception : The `Microsoft.ACE.OLEDB.12.0` provider is not registered on the local machine.
App Error Log : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->RatesImportExportExcel.ImportRatesFromExcel->RatesImportExportExcel.ImportExcelWorkbook
Employee ID : 0
Action Name : ImportRate
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
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) in c:\WT\branches\UiRefresh-LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 329
at WORKTERRA.BenAdmin.Areas.Customization.Models.ImportRateModel.ImportRate() in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\Rates\ImportRateModel.cs:line 59
at WORKTERRA.BenAdmin.Areas.Customization.Controllers.CustomizationController.ImportRate(ImportRateModel objImportRateModel) in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\Rates\RatesController.cs:line 194
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.<>cDisplayClass2b.b_1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass21.b_1e(IAsyncResult asyncResult)

Please check and update QA once fixed.

Thanks,
Hrishikesh
CC : Vijayendra Shinde

Hi Hrishikesh Deshpande,

Can you please check it now.

This issue has been fixed on Pre-Production.