[NF-5618] NF:- Any company Server error displayed on clone plan to same company or other company. - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Bug Fixed
Affects Version/s: None
Fix Version/s: None
Component/s: UI Refresh
Labels:
None

Environment:

Pre Production
Bug Type:
Functional
Bug Severity:
Medium
Level:

Partner
Module:
BenAdmin - Customization
Reported by:
Harbinger
Company:
All Clients/Multiple Clients
Item State:
Stage QA - Production Deployment on Hold
Browser:

Google Chrome
UAT For:

UI Refresh

Description

Step:-
1] Log onto Preprod site.
2] Search and select city of ssf for hspl company.
3] Click on Add/Change plan design option from BenAdmin curtain
4] select any Benefit type
5] Try to clone any plan

Server error is displayed. The error log is as below:-

Exception : Exception of type `WORKTERRA.ExceptionHandler` was thrown.
App Error Log : ControllerAppTier.Clone->BenAdminControllerAppTier.Clone->BenefitPlanDesign.Clone->BenefitPlanDesign.ClonePlanDesignFromCompanyToCompany_Wrapper
Employee ID : 0
Action Name : ClonePlanDesignFromCompanyToCompany
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Clone(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode, String I_ClonedCompanyIDList) in c:\WT\branches\UiRefresh-LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 270
at WORKTERRA.BenAdmin.Areas.Customization.Models.ClonePlanModel.ClonePlanDesignFromCompanyToCompany() in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\PlanDesign\ClonePlanModel.cs:line 73
at WORKTERRA.BenAdmin.Areas.Customization.Controllers.CustomizationController.ClonePlanDesignFromCompanyToCompany(ClonePlanModel objClonePlanModel) in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\PlanDesign\PlanDesignController.cs:line 97
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)

Sachin Hingole

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

5618.jpg
256 kB
03/Jan/18 06:10 AM
5618.txt
3 kB
03/Jan/18 06:10 AM
5618DifferentCompany.jpg
174 kB
11/Jan/18 12:32 PM
5618SameCompany.jpg
174 kB
11/Jan/18 12:32 PM

Issue Links

relates to

NF-5538 City of SeaTac-invoice Issue

Closed

Activity

Ascending order - Click to sort in descending order

Venkatesh Pujari (Inactive) created issue - 29/Dec/17 06:08 AM

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 29/Dec/17 07:19 AM

Venkatesh Pujari
What JIRA is this linked to?

Thanks,
Nidhi.

Show

Nidhi Kaul (Inactive) added a comment - 29/Dec/17 07:19 AM Venkatesh Pujari What JIRA is this linked to? Thanks, Nidhi.

Venkatesh Pujari (Inactive) made changes - 29/Dec/17 07:25 AM

Field	Original Value	New Value
Link		This issue relates to ~~NF-5538~~ [ ~~NF-5538~~ ]

Pratap Patil (Inactive) made changes - 29/Dec/17 10:03 AM

Assignee

Nidhi Kaul [ nidhi.kaul ]

Ramesh Shinde [ ramesh.shinde ]

Ramesh Shinde (Inactive) made changes - 29/Dec/17 10:05 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Ramesh Shinde (Inactive) made changes - 29/Dec/17 10:05 AM

Item State

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

Jayshree Nagpure (Inactive) made changes - 03/Jan/18 06:10 AM

Attachment

5618.jpg [ 71146 ]

Jayshree Nagpure (Inactive) made changes - 03/Jan/18 06:10 AM

Attachment

5618.txt [ 71147 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 03/Jan/18 06:10 AM

Hi Ramesh Shinde,

Issue is getting reproduced on City of ssf for hspl - preprod
We have restored company and verified on hspl copy
PFA - 5618.txt

cc : Sachin Hingole Prasad Pise Rakesh Roy Venkatesh Pujari

Show

Jayshree Nagpure (Inactive) added a comment - 03/Jan/18 06:10 AM Hi Ramesh Shinde , Issue is getting reproduced on City of ssf for hspl - preprod We have restored company and verified on hspl copy PFA - 5618.txt cc : Sachin Hingole Prasad Pise Rakesh Roy Venkatesh Pujari

Permalink

Ramesh Shinde (Inactive) logged work - 03/Jan/18 04:18 PM

Time Spent:

5.5h

--> Discussion with Venktesh.
--> Debugging and discussion with Pratap.
--> Company download and restoring on local database.
--> Issue reproducing on local.

Permalink

Ramesh Shinde (Inactive) logged work - 04/Jan/18 04:26 PM

Time Spent:

0.5h

--> Debugging for issue reproducing with Pratap.

Vijayendra Shinde (Inactive) made changes - 10/Jan/18 05:46 AM

Assignee

Ramesh Shinde [ ramesh.shinde ]

Seema Gaikwad [ seema.gaikwad ]

Hide

Permalink

Seema Gaikwad (Inactive) added a comment - 10/Jan/18 01:16 PM

Modified file

UiRefresh-LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ClonePlanDesignFromCompanyToCompanies.StoredProcedure.sql

Show

Seema Gaikwad (Inactive) added a comment - 10/Jan/18 01:16 PM Modified file UiRefresh-LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ClonePlanDesignFromCompanyToCompanies.StoredProcedure.sql

Hide

Permalink

Seema Gaikwad (Inactive) added a comment - 10/Jan/18 01:21 PM

Hi Venkatesh Pujari,

This issue is fixed and can deployed in next build.Please verify this after next build.
Assigning ticket back to you.

Thanks,
Seema.

Show

Seema Gaikwad (Inactive) added a comment - 10/Jan/18 01:21 PM Hi Venkatesh Pujari , This issue is fixed and can deployed in next build.Please verify this after next build. Assigning ticket back to you. Thanks, Seema.

Seema Gaikwad (Inactive) made changes - 10/Jan/18 01:21 PM

Assignee

Seema Gaikwad [ seema.gaikwad ]

Venkatesh Pujari [ venkatesh.pujari ]

Permalink

Seema Gaikwad (Inactive) logged work - 10/Jan/18 01:22 PM - edited

Time Spent:

5h
- Discussion with Ramesh and Vijayendra.
- Fixed issue
- Unit testing

Seema Gaikwad (Inactive) made changes - 10/Jan/18 01:22 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)

Seema Gaikwad (Inactive) made changes - 10/Jan/18 01:22 PM

Code Review Date		10/Jan/2018
Code Reviewed By		Vijayendra Shinde [ 11901 ]

Seema Gaikwad (Inactive) made changes - 10/Jan/18 01:23 PM

Remaining Estimate		0h [ 0 ]
Time Spent		5h [ 18000 ]
Worklog Id		99906 [ 99906 ]

Ramesh Shinde (Inactive) made changes - 11/Jan/18 04:20 AM

Time Spent	5h [ 18000 ]	10.5h [ 37800 ]
Worklog Id		99949 [ 99949 ]

Ramesh Shinde (Inactive) made changes - 11/Jan/18 04:26 AM

Time Spent	10.5h [ 37800 ]	11h [ 39600 ]
Worklog Id		99955 [ 99955 ]

Seema Gaikwad (Inactive) made changes - 11/Jan/18 04:49 AM

Time Spent	11h [ 39600 ]	11.5h [ 41400 ]
Worklog Id		99906 [ 99906 ]

Hide

Permalink

Seema Gaikwad (Inactive) added a comment - 11/Jan/18 06:00 AM

Concern : Any company Server error displayed on clone plan to same company or other company.
Cause : Inside sp 'OES_SP_ClonePlanDesignFromCompanyToCompanies' declration of Variables type are inproper for two variables named '@CloneFromCompanyName','@CloneInCompanyName '
Correction : Proper size given for these two variables.

Show

Seema Gaikwad (Inactive) added a comment - 11/Jan/18 06:00 AM Concern : Any company Server error displayed on clone plan to same company or other company. Cause : Inside sp 'OES_SP_ClonePlanDesignFromCompanyToCompanies' declration of Variables type are inproper for two variables named '@CloneFromCompanyName','@CloneInCompanyName ' Correction : Proper size given for these two variables.

Khandu Kshirsagar (Inactive) made changes - 11/Jan/18 06:05 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)

Sachin Hingole (Inactive) made changes - 11/Jan/18 06:43 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 11/Jan/18 06:44 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)

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 11/Jan/18 12:31 PM

Verified on codemap
Company - QA hubb

Issue of cloning plan for same and different company is fixed.
PFA -

Marking item state as Ready for Stage

Thanks,
Jayshree

CC - Rakesh Roy Prasad Pise Sachin Hingole

Show

Jayshree Nagpure (Inactive) added a comment - 11/Jan/18 12:31 PM Verified on codemap Company - QA hubb Issue of cloning plan for same and different company is fixed. PFA - Marking item state as Ready for Stage Thanks, Jayshree CC - Rakesh Roy Prasad Pise Sachin Hingole

Jayshree Nagpure (Inactive) made changes - 11/Jan/18 12:31 PM

Item State

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

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Permalink

Jayshree Nagpure (Inactive) logged work - 11/Jan/18 12:32 PM

Time Spent:

1h

Testing on codemap

Jayshree Nagpure (Inactive) made changes - 11/Jan/18 12:32 PM

Attachment

5618DifferentCompany.jpg [ 71649 ]

Jayshree Nagpure (Inactive) made changes - 11/Jan/18 12:32 PM

Attachment

5618SameCompany.jpg [ 71650 ]

Jayshree Nagpure (Inactive) made changes - 11/Jan/18 12:32 PM

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

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 11/Jan/18 12:33 PM

Hi Seema Gaikwad,

I have tested this issue on Codemap. It is working fine as expected. This is ready for Stage.

Sachin Hingole

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 11/Jan/18 12:33 PM Hi Seema Gaikwad , I have tested this issue on Codemap. It is working fine as expected. This is ready for Stage. Sachin Hingole Thanks, Venkatesh

Permalink

Venkatesh Pujari (Inactive) logged work - 11/Jan/18 12:34 PM

Time Spent:

0.25h

Testing on Codemap

Venkatesh Pujari (Inactive) made changes - 11/Jan/18 12:34 PM

Time Spent	12.5h [ 45000 ]	12.75h [ 45900 ]
Worklog Id		100062 [ 100062 ]

Khandu Kshirsagar (Inactive) made changes - 12/Jan/18 04:59 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

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

Sachin Hingole (Inactive) made changes - 12/Jan/18 10:30 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 12/Jan/18 10:32 AM

Item State

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

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

Seema Gaikwad (Inactive) made changes - 17/Jan/18 06:11 AM

Remaining Estimate	0h [ 0 ]	0.5h [ 1800 ]
Time Spent	12.75h [ 45900 ]	12.25h [ 44100 ]
Worklog Id		99906 [ 99906 ]

Venkatesh Pujari (Inactive) made changes - 12/Mar/18 05:53 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Venkatesh Pujari (Inactive) made changes - 12/Mar/18 06:06 AM

Resolution		Bug Fixed [ 10402 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Venkatesh Pujari (Inactive) made changes - 12/Mar/18 06:07 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 12/Mar/18 06:07 AM

I have tested this issue on Production. It is working fine as expected.

Show

Venkatesh Pujari (Inactive) added a comment - 12/Mar/18 06:07 AM I have tested this issue on Production. It is working fine as expected.

Venkatesh Pujari (Inactive) made changes - 12/Mar/18 06:07 AM

Remaining Estimate	0.5h [ 1800 ]	0.25h [ 900 ]
Time Spent	12.25h [ 44100 ]	12.5h [ 45000 ]
Worklog Id		107826 [ 107826 ]

Permalink

Venkatesh Pujari (Inactive) logged work - 12/Mar/18 06:07 PM

Time Spent:

0.25h

<No comment>

Transition	Time In Source Status	Execution Times

Ramesh Shinde (Inactive) made transition - 29/Dec/17 10:05 AM

Open

In Development

3h 56m

Sachin Hingole (Inactive) made transition - 11/Jan/18 06:43 AM

In Development

In LB Testing

12d 20h 37m

Sachin Hingole (Inactive) made transition - 12/Jan/18 10:30 AM

In LB Testing

Stage Testing

1d 3h 47m

Venkatesh Pujari (Inactive) made transition - 12/Mar/18 05:53 AM

Stage Testing

In Production Testing

58d 18h 22m

Venkatesh Pujari (Inactive) made transition - 12/Mar/18 06:06 AM

In Production Testing

Production Complete

13m 39s

Venkatesh Pujari (Inactive) made transition - 12/Mar/18 06:07 AM

Production Complete

Closed

People

Assignee:: Venkatesh Pujari (Inactive)

Reporter:: Venkatesh Pujari (Inactive)

QA:: Venkatesh Pujari (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 29/Dec/17 06:08 AM

Updated:: 12/Mar/18 06:07 AM

Resolved:: 12/Mar/18 06:06 AM

Code Review Date:: 10/Jan/2018

Time Tracking

Estimated:

Not Specified

Remaining:

0.25h

Logged:

12.5h