[NF-4892] Azure - Any company - Functional - Server error on Rate Import - Workterra Jira

Hrishikesh Deshpande (Inactive) created issue - 22/Oct/17 05:19 AM

Hrishikesh Deshpande (Inactive) made changes - 22/Oct/17 05:19 AM

Field	Original Value	New Value
Link		This issue clones ~~NF-4891~~ [ ~~NF-4891~~ ]

Hrishikesh Deshpande (Inactive) made changes - 22/Oct/17 05:19 AM

Description

System throws server error while editing any Rate

System throws server error while editing any Rate Import

Hrishikesh Deshpande (Inactive) made changes - 22/Oct/17 05:19 AM

Link

This issue clones ~~NF-4891~~ [ ~~NF-4891~~ ]

Hrishikesh Deshpande (Inactive) made changes - 22/Oct/17 05:20 AM

Link

This issue is cloned by ~~NF-4893~~ [ ~~NF-4893~~ ]

Hrishikesh Deshpande (Inactive) made changes - 22/Oct/17 05:22 AM

Link

This issue is cloned by ~~NF-4893~~ [ ~~NF-4893~~ ]

Nidhi Kaul (Inactive) made changes - 23/Oct/17 05:02 AM

Assignee

Nidhi Kaul [ nidhi.kaul ]

Rohan J Khandave [ rohan.khandave ]

Rohan J Khandave (Inactive) made changes - 23/Oct/17 06:32 AM

Assignee

Rohan J Khandave [ rohan.khandave ]

Vijayendra Shinde [ ID10506 ]

Hide

Permalink

Vijayendra Shinde (Inactive) added a comment - 25/Oct/17 05:43 AM

Hi Hrishikesh Deshpande,

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

Thanks,
Vijayendra

CC:Rakesh Roy, Sachin Hingole

Show

Vijayendra Shinde (Inactive) added a comment - 25/Oct/17 05:43 AM Hi Hrishikesh Deshpande , Please provide snapshot of error and detailed log for this error. Thanks, Vijayendra CC: Rakesh Roy , Sachin Hingole

Vijayendra Shinde (Inactive) made changes - 25/Oct/17 05:43 AM

Assignee

Vijayendra Shinde [ ID10506 ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Hrishikesh Deshpande (Inactive) made changes - 25/Oct/17 05:51 AM

Attachment

RateImport.png [ 65564 ]

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 25/Oct/17 05:51 AM

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.

Show

Hrishikesh Deshpande (Inactive) added a comment - 25/Oct/17 05:51 AM 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.<>c DisplayClass2b.b _1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_ DisplayClass21.b _1e(IAsyncResult asyncResult) Let me know in case any details required. Thanks, Hrishikesh.

Hrishikesh Deshpande (Inactive) made changes - 25/Oct/17 05:51 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Vijayendra Shinde [ ID10506 ]

Vijayendra Shinde (Inactive) made changes - 27/Oct/17 06:11 AM

Assignee

Vijayendra Shinde [ ID10506 ]

Pratap Patil [ pratap.patil ]

Pratap Patil (Inactive) made changes - 27/Oct/17 10:02 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Mahendra Mungase (Inactive) made changes - 31/Oct/17 01:28 PM

Link

This issue is caused by ~~NF-4352~~ [ ~~NF-4352~~ ]

Permalink

Pratap Patil (Inactive) logged work - 01/Nov/17 09:29 AM

Time Spent:

2h
- Re-produced issue on local system with same error log.
- Installed the office setup on local machine to fix oledb issue.
- oledb issue fixed but found another issue with error as file format is different.

Pratap Patil (Inactive) made changes - 02/Nov/17 09:29 AM

Company		All Clients/Multiple Clients [ 18434 ]
Environment_New		Others [ 18445 ]
Item State		Parent values: Development(10200)Level 1 values: In Progress(10206)
Remaining Estimate		8h [ 28800 ]
Original Estimate		8h [ 28800 ]

Pratap Patil (Inactive) made changes - 02/Nov/17 09:32 AM

Remaining Estimate	8h [ 28800 ]	6h [ 21600 ]
Time Spent		2h [ 7200 ]
Worklog Id		88751 [ 88751 ]

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 21/Nov/17 04:41 AM

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

Show

Nidhi Kaul (Inactive) added a comment - 21/Nov/17 04:41 AM Hi Vijayendra Shinde , Is this the JIRA we discussed in yesterday's call? If so, please update the next action.

Vijayendra Shinde (Inactive) made changes - 21/Nov/17 06:38 AM

Assignee

Pratap Patil [ pratap.patil ]

Sonali Farakate [ sonali.farakate ]

Permalink

Sonali Farakate (Inactive) logged work - 21/Nov/17 06:06 PM

Time Spent:

6h

Analysis, code change

Sonali Farakate (Inactive) made changes - 22/Nov/17 06:07 AM

Remaining Estimate	6h [ 21600 ]	0h [ 0 ]
Time Spent	2h [ 7200 ]	8h [ 28800 ]
Worklog Id		92019 [ 92019 ]

Sonali Farakate (Inactive) made changes - 22/Nov/17 06:52 AM

Code Reviewed By

Vijayendra Shinde [ 11901 ]

Hide

Permalink

Sonali Farakate (Inactive) added a comment - 22/Nov/17 06:53 AM

Hi Hrishikesh Deshpande

Please check once build get deployed.

Thanks,
Sonali.

Show

Sonali Farakate (Inactive) added a comment - 22/Nov/17 06:53 AM Hi Hrishikesh Deshpande Please check once build get deployed. Thanks, Sonali.

Sonali Farakate (Inactive) made changes - 22/Nov/17 06:53 AM

Assignee

Sonali Farakate [ sonali.farakate ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Kunal Kedari (Inactive) made changes - 22/Nov/17 07:07 AM

Attachment

ServerError_RateImport_Codemap.JPG [ 68324 ]

Hide

Permalink

Kunal Kedari (Inactive) added a comment - 22/Nov/17 07:07 AM

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

Show

Kunal Kedari (Inactive) added a comment - 22/Nov/17 07:07 AM 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

Kunal Kedari (Inactive) made changes - 22/Nov/17 07:07 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: LB QA(10201)

Kunal Kedari (Inactive) made changes - 22/Nov/17 07:07 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Sonali Farakate [ sonali.farakate ]

Kunal Kedari (Inactive) made changes - 22/Nov/17 07:08 AM

Item State

Parent values: LB QA(10201)

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Kunal Kedari (Inactive) made changes - 22/Nov/17 07:08 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Kunal Kedari (Inactive) made changes - 22/Nov/17 07:08 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Permalink

Sonali Farakate (Inactive) logged work - 22/Nov/17 07:23 PM - edited

Time Spent:

1.5h

Discussion and changes in vb file

Permalink

Sonali Farakate (Inactive) logged work - 23/Nov/17 05:36 AM

Time Spent:

1.5h

Analysis and research

Sonali Farakate (Inactive) made changes - 23/Nov/17 05:36 AM

Time Spent	8h [ 28800 ]	9.5h [ 34200 ]
Worklog Id		92262 [ 92262 ]

Sonali Farakate (Inactive) made changes - 23/Nov/17 05:36 AM

Time Spent	9.5h [ 34200 ]	10h [ 36000 ]
Worklog Id		92263 [ 92263 ]

Hide

Permalink

Sonali Farakate (Inactive) added a comment - 23/Nov/17 05:39 AM

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

Show

Sonali Farakate (Inactive) added a comment - 23/Nov/17 05:39 AM 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

Sonali Farakate (Inactive) made changes - 23/Nov/17 05:39 AM

Assignee

Sonali Farakate [ sonali.farakate ]

Ashwin Wankhede [ ashwin.wankhede ]

Khandu Kshirsagar (Inactive) made changes - 23/Nov/17 07:00 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

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

Permalink

Sonali Farakate (Inactive) logged work - 23/Nov/17 12:34 PM

Time Spent:

1h

<No comment>

Permalink

Sonali Farakate (Inactive) logged work - 24/Nov/17 05:36 AM

Time Spent:

0.5h

<No comment>

Sonali Farakate (Inactive) made changes - 28/Nov/17 07:24 AM

Time Spent	10h [ 36000 ]	11.5h [ 41400 ]
Worklog Id		93174 [ 93174 ]

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 29/Nov/17 08:56 AM

Ashwin Wankhede

What is the status on this one?

Nidhi.

Show

Nidhi Kaul (Inactive) added a comment - 29/Nov/17 08:56 AM Ashwin Wankhede What is the status on this one? Nidhi.

Sonali Farakate (Inactive) made changes - 29/Nov/17 12:34 PM

Time Spent	11.5h [ 41400 ]	12.5h [ 45000 ]
Worklog Id		93478 [ 93478 ]

Sonali Farakate (Inactive) made changes - 29/Nov/17 12:45 PM

Worklog Id

93174 [ 93174 ]

Permalink

Ashwin Wankhede (Inactive) logged work - 04/Dec/17 09:11 AM

Time Spent:

1.5h

<No comment>

Hide

Permalink

Ashwin Wankhede (Inactive) added a comment - 04/Dec/17 09:11 AM

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.

Show

Ashwin Wankhede (Inactive) added a comment - 04/Dec/17 09:11 AM 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.

Ashwin Wankhede (Inactive) made changes - 04/Dec/17 09:11 AM

Assignee

Ashwin Wankhede [ ashwin.wankhede ]

Sonali Farakate [ sonali.farakate ]

Ashwin Wankhede (Inactive) made changes - 04/Dec/17 09:11 AM

Time Spent	12.5h [ 45000 ]	14h [ 50400 ]
Worklog Id		94537 [ 94537 ]

Sonali Farakate (Inactive) made changes - 04/Dec/17 09:29 AM

Item State

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

Parent values: Development(10200)Level 1 values: In Progress(10206)

Permalink

Sonali Farakate (Inactive) logged work - 04/Dec/17 12:57 PM

Time Spent:

4h

<No comment>

Hide

Permalink

Sonali Farakate (Inactive) added a comment - 05/Dec/17 12:57 PM

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.

Show

Sonali Farakate (Inactive) added a comment - 05/Dec/17 12:57 PM 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.

Permalink

Sonali Farakate (Inactive) logged work - 05/Dec/17 12:58 PM

Time Spent:

2h

Issue repro and settings related to Export and import

Permalink

Sonali Farakate (Inactive) logged work - 05/Dec/17 12:58 PM

Time Spent:

1h

Internal Discussion

Sonali Farakate (Inactive) made changes - 05/Dec/17 12:58 PM

Time Spent	14h [ 50400 ]	18h [ 64800 ]
Worklog Id		94749 [ 94749 ]

Sonali Farakate (Inactive) made changes - 05/Dec/17 12:58 PM

Time Spent	18h [ 64800 ]	20h [ 72000 ]
Worklog Id		94751 [ 94751 ]

Sonali Farakate (Inactive) made changes - 05/Dec/17 12:58 PM

Time Spent	20h [ 72000 ]	21h [ 75600 ]
Worklog Id		94752 [ 94752 ]

Permalink

Sonali Farakate (Inactive) logged work - 05/Dec/17 12:59 PM

Time Spent:

3h

Issue fixing

Permalink

Sonali Farakate (Inactive) logged work - 05/Dec/17 12:59 PM

Time Spent:

1.5h

Code review and Unit Testing

Sonali Farakate (Inactive) made changes - 05/Dec/17 12:59 PM

Time Spent	21h [ 75600 ]	24h [ 86400 ]
Worklog Id		94753 [ 94753 ]

Sonali Farakate (Inactive) made changes - 05/Dec/17 12:59 PM

Time Spent	24h [ 86400 ]	25.5h [ 91800 ]
Worklog Id		94754 [ 94754 ]

Sonali Farakate (Inactive) made changes - 05/Dec/17 01:00 PM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

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

Sonali Farakate (Inactive) made changes - 05/Dec/17 01:00 PM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Hide

Permalink

Sonali Farakate (Inactive) added a comment - 06/Dec/17 05:00 AM

HI Hrishikesh Deshpande

This will be deployed in next build.

Thanks,
Sonali

Show

Sonali Farakate (Inactive) added a comment - 06/Dec/17 05:00 AM HI Hrishikesh Deshpande This will be deployed in next build. Thanks, Sonali

Sonali Farakate (Inactive) made changes - 06/Dec/17 05:00 AM

Assignee

Sonali Farakate [ sonali.farakate ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Khandu Kshirsagar (Inactive) made changes - 06/Dec/17 09:56 AM

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)

Hrishikesh Deshpande (Inactive) made changes - 13/Dec/17 05:58 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Sanjana Jadhav [ sanjana.jadhav ]

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 08: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)

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 08:45 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 10:42 AM

Attachment

NF-4892.png [ 69976 ]

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 10:42 AM

Attachment

server error.txt [ 69977 ]

Permalink

Sanjana Jadhav (Inactive) logged work - 13/Dec/17 10:43 AM

Time Spent:

1h

Analysis
Testing

Hide

Permalink

Sanjana Jadhav (Inactive) added a comment - 13/Dec/17 10:43 AM

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

Show

Sanjana Jadhav (Inactive) added a comment - 13/Dec/17 10:43 AM 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

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 10:43 AM

Item State

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

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 10:43 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 10:43 AM

Assignee

Sanjana Jadhav [ sanjana.jadhav ]

Sonali Farakate [ sonali.farakate ]

Sanjana Jadhav (Inactive) made changes - 13/Dec/17 10:44 AM

Time Spent	25.5h [ 91800 ]	26.5h [ 95400 ]
Worklog Id		95912 [ 95912 ]

Permalink

Sonali Farakate (Inactive) logged work - 13/Dec/17 05:12 PM

Time Spent:

1.5h

Issue reproduction
Internal discussion

Permalink

Sanjana Jadhav (Inactive) logged work - 14/Dec/17 03:54 AM

Time Spent:

0.5h

Internal discussion
Testing

Sanjana Jadhav (Inactive) made changes - 14/Dec/17 03:54 AM

Time Spent	26.5h [ 95400 ]	27h [ 97200 ]
Worklog Id		96000 [ 96000 ]

Sonali Farakate (Inactive) made changes - 14/Dec/17 05:13 AM

Time Spent	27h [ 97200 ]	28.5h [ 102600 ]
Worklog Id		96032 [ 96032 ]

Hide

Permalink

Sonali Farakate (Inactive) added a comment - 14/Dec/17 05:15 AM

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

Show

Sonali Farakate (Inactive) added a comment - 14/Dec/17 05:15 AM 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

Sonali Farakate (Inactive) made changes - 14/Dec/17 05:15 AM

Assignee

Sonali Farakate [ sonali.farakate ]

Ashwin Wankhede [ ashwin.wankhede ]

Khandu Kshirsagar (Inactive) made changes - 14/Dec/17 12:40 PM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Hrishikesh Deshpande (Inactive) made changes - 15/Dec/17 06:49 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Hrishikesh Deshpande (Inactive) made changes - 15/Dec/17 06:49 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hrishikesh Deshpande (Inactive) made changes - 15/Dec/17 06:49 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Hrishikesh Deshpande (Inactive) made changes - 15/Dec/17 06:49 AM

Resolution		Unresolved [ 10200 ]
Status	Stage Testing [ 10201 ]	Reopen in Stage [ 10023 ]

Hrishikesh Deshpande (Inactive) made changes - 15/Dec/17 06:49 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: Re-open(10216)

Hrishikesh Deshpande (Inactive) made changes - 15/Dec/17 06:51 AM

Attachment

RateImport-Fail_PreProd.png [ 70124 ]

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 15/Dec/17 06:51 AM

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

Show

Hrishikesh Deshpande (Inactive) added a comment - 15/Dec/17 06:51 AM 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.<>c DisplayClass2b.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

Hrishikesh Deshpande (Inactive) made changes - 15/Dec/17 06:52 AM

Time Spent	28.5h [ 102600 ]	28.75h [ 103500 ]
Worklog Id		96273 [ 96273 ]

Permalink

Hrishikesh Deshpande (Inactive) logged work - 15/Dec/17 06:51 PM

Time Spent:

0.25h

<No comment>

Hide

Permalink

Ashwin Wankhede (Inactive) added a comment - 19/Dec/17 09:16 AM

Hi Hrishikesh Deshpande,

Can you please check it now.

Show

Ashwin Wankhede (Inactive) added a comment - 19/Dec/17 09:16 AM Hi Hrishikesh Deshpande , Can you please check it now.

Ashwin Wankhede (Inactive) made changes - 19/Dec/17 09:17 AM

Assignee

Ashwin Wankhede [ ashwin.wankhede ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Permalink

Hrishikesh Deshpande (Inactive) logged work - 19/Dec/17 09:24 AM

Time Spent:

0.5h

<No comment>

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 09:24 AM

Time Spent	28.75h [ 103500 ]	29.25h [ 105300 ]
Worklog Id		96821 [ 96821 ]

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 09:25 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Re-open(10216)

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

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 09:25 AM

Status

Reopen in Stage [ 10023 ]

In Development [ 10007 ]

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 09:25 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 09:25 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 19/Dec/17 09:26 AM

This issue has been fixed on Pre-Production.

Show

Hrishikesh Deshpande (Inactive) added a comment - 19/Dec/17 09:26 AM This issue has been fixed on Pre-Production.

Hrishikesh Deshpande (Inactive) made changes - 19/Dec/17 09:26 AM

Attachment

RateImport-Pass.png [ 70355 ]

Permalink

Ashwin Wankhede (Inactive) logged work - 19/Dec/17 01:05 PM

Time Spent:

0.5h

<No comment>

Ashwin Wankhede (Inactive) made changes - 19/Dec/17 01:05 PM

Time Spent	29.25h [ 105300 ]	29.75h [ 107100 ]
Worklog Id		96918 [ 96918 ]

Pratap Patil (Inactive) made transition - 27/Oct/17 10:02 AM

Open

In Development

5d 4h 43m

1

Sanjana Jadhav (Inactive) made transition - 13/Dec/17 10:43 AM

In LB Testing

Reopen in Local

1h 58m

2

Hrishikesh Deshpande (Inactive) made transition - 15/Dec/17 06:49 AM

Reopen in Local

In Development

15d 1h 58m

2

Hrishikesh Deshpande (Inactive) made transition - 15/Dec/17 06:49 AM

Stage Testing

Reopened in Stage

3s

1

Hrishikesh Deshpande (Inactive) made transition - 19/Dec/17 09:25 AM

Reopened in Stage

In Development

4d 2h 35m

1

Hrishikesh Deshpande (Inactive) made transition - 19/Dec/17 09:25 AM

In Development

In LB Testing

33d 17h 50m

4

Hrishikesh Deshpande (Inactive) made transition - 19/Dec/17 09:25 AM

In LB Testing

Stage Testing

7s

2

New Features 2017

Azure - Any company - Functional - Server error on Rate Import

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Time Tracking