[WT-9033] Cannot download bad file from global level - Workterra Jira

Details

Type: Bug
Status: Production Complete
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Environment:

Production
Bug Severity:
Medium
Module:
BenAdmin - Import
Reported by:
Support
Item State:
Production Complete - Closed

Description

When user tries to download a bad file (company specific) from global level system throws an error.

Attachments

Activity

Ascending order - Click to sort in descending order

Amit Thorve (Inactive) created issue - 30/Mar/17 06:45 AM

Jaideep Vinchurkar (Inactive) made changes - 30/Mar/17 07:53 AM

Field	Original Value	New Value
Assignee	Jaideep Vinchurkar [ jaideep.vinchurkar ]	Suraj Sokasane [ suraj.sokasane ]

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 07/Apr/17 05:28 AM

Error log which will help
1. Barrow -
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteImportBadFileDTS.ImportBadFileIntoTable->CopyFileFromServer.CopyFileFromServer
ErrorMessage: Could not find file '\\10.145.65.73\WorkTerra\ImportBadFile\Company\0\Bad_bcss new hire load 7-9-1507_09_2015 06_19_16 AM.txt'.
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput)
TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)
2.ASML -
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteImportBadFileDTS.ImportBadFileIntoTable->CopyFileFromServer.CopyFileFromServer
ErrorMessage: Could not find file '\\10.145.65.73\WorkTerra\ImportBadFile\Company\0\Bad_Terminations Load as Active Initial Load10_11_2015 10_03_44 AM.txt'.
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput)
TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Show

Rakesh Roy (Inactive) added a comment - 07/Apr/17 05:28 AM Error log which will help 1. Barrow - ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteImportBadFileDTS.ImportBadFileIntoTable->CopyFileFromServer.CopyFileFromServer ErrorMessage: Could not find file '\\10.145.65.73\WorkTerra\ImportBadFile\Company\0\Bad_bcss new hire load 7-9-1507_09_2015 06_19_16 AM.txt'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity) 2.ASML - ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteImportBadFileDTS.ImportBadFileIntoTable->CopyFileFromServer.CopyFileFromServer ErrorMessage: Could not find file '\\10.145.65.73\WorkTerra\ImportBadFile\Company\0\Bad_Terminations Load as Active Initial Load10_11_2015 10_03_44 AM.txt'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Suraj Sokasane (Inactive) made changes - 13/Apr/17 06:59 AM

Assignee

Suraj Sokasane [ suraj.sokasane ]

Vijay Siddha [ vijays ]

Suraj Sokasane (Inactive) made changes - 13/Apr/17 06:59 AM

Assignee

Vijay Siddha [ vijays ]

Suraj Sokasane [ suraj.sokasane ]

Suraj Sokasane (Inactive) made changes - 13/Apr/17 06:59 AM

Dev Due Date

19/Apr/2017

Hide

Permalink

Suraj Sokasane (Inactive) added a comment - 13/Apr/17 07:00 AM

We will assign this to Snehal once she has a working code base and a JIRA account.

Show

Suraj Sokasane (Inactive) added a comment - 13/Apr/17 07:00 AM We will assign this to Snehal once she has a working code base and a JIRA account.

Suraj Sokasane (Inactive) made changes - 18/Apr/17 04:15 AM

Assignee

Suraj Sokasane [ suraj.sokasane ]

Vishal Bajad [ vishal.bajad ]

Vishal Bajad (Inactive) made changes - 18/Apr/17 05:47 AM

Assignee

Vishal Bajad [ vishal.bajad ]

snehal katkar [ snehal.katkar ]

Suraj Sokasane (Inactive) made changes - 18/Apr/17 07:30 AM

Remaining Estimate		0h [ 0 ]
Time Spent		0.75h [ 2700 ]
Worklog Id		38899 [ 38899 ]

Permalink

Suraj Sokasane (Inactive) logged work - 18/Apr/17 09:30 AM

Time Spent:

0.75h

Solving configuration issue.

Hide

Permalink

Amit Thorve (Inactive) added a comment - 18/Apr/17 11:47 AM

Who is going to fix this issue and when? We need estimates.

Show

Amit Thorve (Inactive) added a comment - 18/Apr/17 11:47 AM Who is going to fix this issue and when? We need estimates.

Hide

Permalink

Suraj Sokasane (Inactive) added a comment - 18/Apr/17 11:59 AM

Hi Amit Thorve,

Snehal Katkar is working on this and it will be completed by 04/20.

Show

Suraj Sokasane (Inactive) added a comment - 18/Apr/17 11:59 AM Hi Amit Thorve , Snehal Katkar is working on this and it will be completed by 04/20.

Permalink

Snehal Katkar (Inactive) logged work - 19/Apr/17 05:37 AM

Time Spent:

8h

Code study

Permalink

Suraj Sokasane (Inactive) logged work - 19/Apr/17 03:08 PM

Time Spent:

0.75h

Discuusion with Snehal

Suraj Sokasane (Inactive) made changes - 19/Apr/17 03:08 PM

Time Spent	0.75h [ 2700 ]	1.5h [ 5400 ]
Worklog Id		39465 [ 39465 ]

Permalink

Snehal Katkar (Inactive) logged work - 19/Apr/17 05:00 PM

Time Spent:

7h

Code changes

Snehal Katkar (Inactive) made changes - 20/Apr/17 05:37 AM

Time Spent	1.5h [ 5400 ]	8.5h [ 30600 ]
Worklog Id		39554 [ 39554 ]

Snehal Katkar (Inactive) made changes - 20/Apr/17 05:38 AM

Time Spent	8.5h [ 30600 ]	16.5h [ 59400 ]
Worklog Id		39555 [ 39555 ]

Snehal Katkar (Inactive) made changes - 20/Apr/17 10:36 AM

Account Executive		Amit Thorve [ amitthorve ]
Code Review Date		20/Apr/2017
Code Reviewed By		Jaideep Vinchurkar [ 11908 ]
Developer		snehal katkar [ snehal.katkar ]
Original Estimate		0h [ 0 ]

Hide

Permalink

Snehal Katkar (Inactive) added a comment - 20/Apr/17 10:43 AM - edited

Concern: Can not download bad file from view bad file, if accessed it from global level.

Cause: Bad files are stored on file server in company specific folders. When we request for downloading a bad file from company level, bad file screen is already having company information to find out file location on file server. When we do such request from global level, company information was not there. That's why system was not able to find the file.

Correction: Modified code to retrieve company information from company selection drop down control on global level view bad file page.

Show

Snehal Katkar (Inactive) added a comment - 20/Apr/17 10:43 AM - edited Concern: Can not download bad file from view bad file, if accessed it from global level. Cause: Bad files are stored on file server in company specific folders. When we request for downloading a bad file from company level, bad file screen is already having company information to find out file location on file server. When we do such request from global level, company information was not there. That's why system was not able to find the file. Correction: Modified code to retrieve company information from company selection drop down control on global level view bad file page.

Hide

Permalink

Snehal Katkar (Inactive) added a comment - 20/Apr/17 10:47 AM

Files having changes:
1. D:\WT\branches\LB\Web\Web Projects\WORKTERRA\Areas\Customization\Controllers\EDI\viewbadfileconroller.cs
2. D:\WT\branches\LB\Web\Web Projects\WORKTERRA\Areas\Customization\Views\EDI\viewbadfile.cshtml

Impacted areas:
1. View bad file page - company level
2. View bad file page - global level

Unit test scenarios:
1. view bad file
2. Download bad file
both scenarios at company as well as at global level.

Show

Snehal Katkar (Inactive) added a comment - 20/Apr/17 10:47 AM Files having changes: 1. D:\WT\branches\LB\Web\Web Projects\WORKTERRA\Areas\Customization\Controllers\EDI\viewbadfileconroller.cs 2. D:\WT\branches\LB\Web\Web Projects\WORKTERRA\Areas\Customization\Views\EDI\viewbadfile.cshtml Impacted areas: 1. View bad file page - company level 2. View bad file page - global level Unit test scenarios: 1. view bad file 2. Download bad file both scenarios at company as well as at global level.

Snehal Katkar (Inactive) made changes - 20/Apr/17 10:47 AM

Dev Due Date

19/Apr/2017

20/Apr/2017

Snehal Katkar (Inactive) made changes - 20/Apr/17 10:47 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Snehal Katkar (Inactive) made changes - 20/Apr/17 10:49 AM

Item State		Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
Original Estimate	0h [ 0 ]	10h [ 36000 ]

Khandu Kshirsagar (Inactive) made changes - 20/Apr/17 12:26 PM

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)

Permalink

Snehal Katkar (Inactive) logged work - 20/Apr/17 12:35 PM

Time Spent:

2h

Code checkin, jira update

Permalink

Jaideep Vinchurkar (Inactive) logged work - 20/Apr/17 01:29 PM

Time Spent:

0.5h

code review, code chek in and JIRA updates

Jaideep Vinchurkar (Inactive) made changes - 20/Apr/17 01:29 PM

Assignee

snehal katkar [ snehal.katkar ]

Jayshree Nagpure [ jayshree.nagpure ]

Jaideep Vinchurkar (Inactive) made changes - 20/Apr/17 01:29 PM

Time Spent	16.5h [ 59400 ]	17h [ 61200 ]
Worklog Id		39699 [ 39699 ]

Jayshree Nagpure (Inactive) made changes - 21/Apr/17 05:48 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)

Jayshree Nagpure (Inactive) made changes - 21/Apr/17 05:48 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Snehal Katkar (Inactive) made changes - 21/Apr/17 12:35 PM

Time Spent	17h [ 61200 ]	19h [ 68400 ]
Worklog Id		40035 [ 40035 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 21/Apr/17 02:15 PM

Hi Snehal Katkar,

Verified on LB
Company-Symphony
Verified below scenario:

1)View bad file - company level
2) View bad file - global level
3)View bad file- Company -> BenAdmin module
3)Download the bad file through all level
Verified For synchronous and asynchronous

For correct data, import is done successfully

Marking item state as ready for stage

Thanks,
Jayshree

CC: Suraj Sokasane Prasad Pise Rakesh Roy

Show

Jayshree Nagpure (Inactive) added a comment - 21/Apr/17 02:15 PM Hi Snehal Katkar , Verified on LB Company-Symphony Verified below scenario: 1)View bad file - company level 2) View bad file - global level 3)View bad file- Company -> BenAdmin module 3)Download the bad file through all level Verified For synchronous and asynchronous For correct data, import is done successfully Marking item state as ready for stage Thanks, Jayshree CC: Suraj Sokasane Prasad Pise Rakesh Roy

Jayshree Nagpure (Inactive) made changes - 21/Apr/17 02:15 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 - 21/Apr/17 02:43 PM

Time Spent:

2h

LB testing

Jayshree Nagpure (Inactive) made changes - 21/Apr/17 02:43 PM

Time Spent	19h [ 68400 ]	21h [ 75600 ]
Worklog Id		40135 [ 40135 ]

Khandu Kshirsagar (Inactive) made changes - 26/Apr/17 07:03 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)

Jayshree Nagpure (Inactive) made changes - 26/Apr/17 08:26 AM

Item State

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

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Jayshree Nagpure (Inactive) made changes - 26/Apr/17 08:26 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 26/Apr/17 01:13 PM

Hi Snehal Katkar,

Verified on Caiso for hspl.
Verified all above scenario.
Working as expected
Marking item state as Ready for Production.

Thanks,
Jayshree

CC: Rakesh Roy Prasad Pise Suraj Sokasane

Show

Jayshree Nagpure (Inactive) added a comment - 26/Apr/17 01:13 PM Hi Snehal Katkar , Verified on Caiso for hspl. Verified all above scenario. Working as expected Marking item state as Ready for Production. Thanks, Jayshree CC: Rakesh Roy Prasad Pise Suraj Sokasane

Jayshree Nagpure (Inactive) made changes - 26/Apr/17 01:13 PM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Permalink

Jayshree Nagpure (Inactive) logged work - 27/Apr/17 04:35 AM

Time Spent:

0.5h

Stage testing

Jayshree Nagpure (Inactive) made changes - 27/Apr/17 04:36 AM

Time Spent	21h [ 75600 ]	21.5h [ 77400 ]
Worklog Id		41096 [ 41096 ]

Hide

Permalink

Amit Thorve (Inactive) added a comment - 04/May/17 04:00 PM

Rakesh Roy Stage and production deployment dates are not specified on this ticket. Please inform me regarding production deployment date.

Show

Amit Thorve (Inactive) added a comment - 04/May/17 04:00 PM Rakesh Roy Stage and production deployment dates are not specified on this ticket. Please inform me regarding production deployment date.

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 04/May/17 04:08 PM - edited

Amit Thorve This is deployed and verified on stage and its ready for production deployment. could you please check and confirm on stage, so will move tomorrow on production?

Show

Rakesh Roy (Inactive) added a comment - 04/May/17 04:08 PM - edited Amit Thorve This is deployed and verified on stage and its ready for production deployment. could you please check and confirm on stage, so will move tomorrow on production?

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 07/May/17 06:20 PM

Amit Thorve We'll deploy this on production on 9th May.

Show

Rakesh Roy (Inactive) added a comment - 07/May/17 06:20 PM Amit Thorve We'll deploy this on production on 9th May.

Khandu Kshirsagar (Inactive) made changes - 09/May/17 07:17 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Jayshree Nagpure (Inactive) made changes - 09/May/17 08:23 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Jayshree Nagpure (Inactive) made changes - 09/May/17 08:23 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 09/May/17 12:47 PM

Verified on Production
Company - Caiso for hspl
Login - Partner
Verified all above scenario, working fine
Marking item state as Production complete.

Thanks,
Jayshree

CC: Rakesh Roy Prasad Pise

Show

Jayshree Nagpure (Inactive) added a comment - 09/May/17 12:47 PM Verified on Production Company - Caiso for hspl Login - Partner Verified all above scenario, working fine Marking item state as Production complete. Thanks, Jayshree CC: Rakesh Roy Prasad Pise

Jayshree Nagpure (Inactive) made changes - 09/May/17 12:48 PM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Jayshree Nagpure (Inactive) made changes - 09/May/17 12:50 PM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Rakesh Roy (Inactive) made changes - 11/May/17 08:54 AM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Amit Thorve [ amitthorve ]

Rakesh Roy (Inactive) made changes - 29/Aug/17 09:39 AM

Bug Severity		Medium [ 16702 ]
Code Review Date	20/Apr/2017	20/Apr/2017
Dev Due Date	20/Apr/2017	20/Apr/2017

Satya made changes - 04/Nov/17 06:36 AM

Environment_New

Production [ 18442 ]

Transition	Time In Source Status	Execution Times

Snehal Katkar (Inactive) made transition - 20/Apr/17 10:47 AM

Open

In Development

21d 4h 2m

Jayshree Nagpure (Inactive) made transition - 21/Apr/17 05:48 AM

In Development

In LB Testing

19h 1m

Jayshree Nagpure (Inactive) made transition - 26/Apr/17 08:26 AM

In LB Testing

Stage Testing

5d 2h 37m

Jayshree Nagpure (Inactive) made transition - 09/May/17 08:23 AM

Stage Testing

In Production Testing

12d 23h 57m

Jayshree Nagpure (Inactive) made transition - 09/May/17 12:50 PM

In Production Testing

Production Complete

4h 26m

People

Assignee:: Amit Thorve (Inactive)

Reporter:: Amit Thorve (Inactive)

Account Executive:: Amit Thorve (Inactive)

EDI Analyst 1:: Amit Thorve (Inactive)

Developer:: Snehal Katkar (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 30/Mar/17 06:45 AM

Updated:: 04/Nov/17 06:36 AM

Resolved:: 09/May/17 12:50 PM

Dev Due Date:: 20/Apr/2017

Code Review Date:: 20/Apr/2017

Time Tracking

Estimated:

10h

Remaining:

Logged:

21.5h