Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6566

Scheduled files are getting deleted once downloaded

    Details

    • Type: Bug
    • Status: In Development
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Production
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Item State:
      Development - On Hold

      Description

      Go to company
      schedule any report
      once scheduled report run is completed, try to download it multiple times

      actual - first time its getting downloaded
      expected - it should allow to download multiple times.

      NOTE - as discussed with Dev team member, file is getting deleted from file server when we download it for first time.

        Attachments

          Activity

          sachin.hingole Sachin Hingole (Inactive) created issue -
          prasanna Prasanna Karlekar (Inactive) logged work - 31/Dec/16 04:00 AM
          • Time Spent:
            1h
             

            Issue and code fix discussion with Design Team member.

          prasanna Prasanna Karlekar (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 0h [ 0 ]
          Time Spent 1h [ 3600 ]
          Worklog Id 16548 [ 16548 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Prasanna Karlekar [ prasanna ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Priority Medium [ 3 ] High [ 2 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi Nandkumar Prabhakar Karlekar,

          Reports team is working on this fix as delivered reports once downloaded are getting deleted from the server.

          cc: Sachin Hingole

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , Reports team is working on this fix as delivered reports once downloaded are getting deleted from the server. cc: Sachin Hingole
          satyap Satya made changes -
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 1h [ 3600 ] 1.75h [ 6300 ]
          Worklog Id 16676 [ 16676 ]
          prasanna Prasanna Karlekar (Inactive) logged work - 03/Jan/17 02:28 AM
          • Time Spent:
            0.75h
             

            Issue fix, Unit testing and code check in for LB & Stage.

          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Production Testing [ 10202 ] Reopen in Production [ 10027 ]
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Hi Nandkumar Prabhakar Karlekar,

          We have verified for BenAdmin reports on production town of cary and able to download scheduled reports multiple times.

          But getting server error message on 1095C scheduled report download on production town of cary. Please note same run can be downloaded from show runs pop up.

          Can you please assign this JIRA to ACA Dev team member.

          Below is error log for
          _______________________________
          ErrorID : 0
          ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->CopyFileToFileServer.Save->CommonFunctions.CopyFileToServer
          ErrorMessage: The network path was not found.

          StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
          at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput)
          TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

          Thanks,
          Sachin Hingole

          Prasanna Karlekar Ramya Tantry

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , We have verified for BenAdmin reports on production town of cary and able to download scheduled reports multiple times. But getting server error message on 1095C scheduled report download on production town of cary. Please note same run can be downloaded from show runs pop up. Can you please assign this JIRA to ACA Dev team member. Below is error log for _______________________________ ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->CopyFileToFileServer.Save->CommonFunctions.CopyFileToServer ErrorMessage: The network path was not found. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity) Thanks, Sachin Hingole Prasanna Karlekar Ramya Tantry
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Nandkumar [ satyap ]
          sachin.hingole Sachin Hingole (Inactive) logged work - 03/Jan/17 01:04 PM
          • Time Spent:
            1h
             
            <No comment>
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Time Spent 1.75h [ 6300 ] 2.75h [ 9900 ]
          Worklog Id 16922 [ 16922 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Reopen in Production [ 10027 ] In Development [ 10007 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Development(10200)
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi Ramya Tantry

          Can you please look into this if you get the time

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Ramya Tantry Can you please look into this if you get the time
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Kumar Chhajed [ kumar.chhajed ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: In Progress(10206)
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 08/Feb/17 01:05 PM - edited
          • Time Spent:
            6h
             

            Analysis
            Project setup
            Coding
            Unit Testing
            Internal discussion with abhijeet

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 21.25h [ 76500 ]
          Original Estimate 24h [ 86400 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 21.25h [ 76500 ] 15.25h [ 54900 ]
          Time Spent 2.75h [ 9900 ] 8.75h [ 31500 ]
          Worklog Id 23763 [ 23763 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Worklog Id 23763 [ 23763 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Module Parent values: BenAdmin(10100)Level 1 values: Report(10109) Parent values: ACA(10104)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Component/s ACA [ 10004 ]
          Component/s BenAdmin [ 10000 ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 09/Feb/17 11:22 AM
          • Time Spent:
            4h
             

            Unit testing
            Internal discussion with Abhijeet

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 15.25h [ 54900 ] 11.25h [ 40500 ]
          Time Spent 8.75h [ 31500 ] 12.75h [ 45900 ]
          Worklog Id 24030 [ 24030 ]
          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited

          3C's -
          Concern - Scheduled files are getting deleted once downloaded
          Cause - Scheduled files are not getting deleted, actually the issue is caused due to reasons -

          1. Incorrect file path assigned to variable for download.
          2. File name stored into table is appended with session id .

          Correction - Provided correct path , removed the session id from file name if call is from scheduled report and same is stored into the table

          Ramya Tantry Abhijeet Khandagale

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited 3C's - Concern - Scheduled files are getting deleted once downloaded Cause - Scheduled files are not getting deleted, actually the issue is caused due to reasons - Incorrect file path assigned to variable for download. File name stored into table is appended with session id . Correction - Provided correct path , removed the session id from file name if call is from scheduled report and same is stored into the table Ramya Tantry Abhijeet Khandagale
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 17/Feb/17 02:08 PM
          • Time Spent:
            1h
             

            Code review by nandu
            Check-in to LB

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 11.25h [ 40500 ] 10.25h [ 36900 ]
          Time Spent 12.75h [ 45900 ] 13.75h [ 49500 ]
          Worklog Id 25944 [ 25944 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          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)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Sachin Hingole [ sachin.hingole ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Code Reviewed By Nandkumar Karlekar [ 11904 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Scheduler does not work on LB, Hence marking it ready for stage.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Scheduler does not work on LB, Hence marking it ready for stage.
          sachin.hingole Sachin Hingole (Inactive) logged work - 20/Feb/17 01:13 PM
          • Time Spent:
            0.25h
             

            verified 1095C report run and download

          sachin.hingole Sachin Hingole (Inactive) made changes -
          Remaining Estimate 10.25h [ 36900 ] 10h [ 36000 ]
          Time Spent 13.75h [ 49500 ] 14h [ 50400 ]
          Worklog Id 26155 [ 26155 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          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 Sachin Hingole (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 24/Feb/17 01:53 PM
          • Time Spent:
            1h
             

            Internal discussion with Sachin
            Analysis of query

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 10h [ 36000 ] 9h [ 32400 ]
          Time Spent 14h [ 50400 ] 15h [ 54000 ]
          Worklog Id 27314 [ 27314 ]
          sachin.hingole Sachin Hingole (Inactive) logged work - 24/Feb/17 07:00 PM
          • Time Spent:
            2h
             

            Verified bug on Stage

          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on Stage LHP for HSPL and its not working.
          1095C report is scheduled on LHP for HSPL but its run is shown on LHP main company. Also scheduled file shown on LHP FOR HSPL but when user try to download it gives server error.

          ERROR LOG
          _________________________________
          Exception : Could not find file `\\192.168.31.16\workterra\Reports\IRSReport\12102\DNL_1095_C_LHP_Montclair_LLC_20170223234420_573.zip`.
          App Error Log : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->CopyFileToFileServer.Save->CommonFunctions.CopyFileToServer
          Employee ID : 0
          Action Name : DownloadScheduledReportFile
          Model : System.Web.Mvc.HandleErrorInfo
          Controller : Report
          Web Error Log : at WORKTERRA.Shared.WORKTERRAControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode)
          at WORKTERRA.SharedFunctionWebTier.CopyFileToServer(FileServerInfo objFileServerInfo, ArrayList DeletedFiles)
          at WORKTERRA.BenAdmin.Areas.Report.Models.ScheduledReportDownloadPVModel.DownloadFile(String DownloadFileName, String ReportPath, Int32 OptionalParam)
          at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.DownloadScheduledReportFile(String DownloadFileName, String ReportPath, Int32 OptionalParam)
          at lambda_method(Closure , ControllerBase , Object[] )
          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.ControllerActionInvoker.<>c_DisplayClass13.b_10()
          at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
          at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
          at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
          at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
          at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage LHP for HSPL and its not working. 1095C report is scheduled on LHP for HSPL but its run is shown on LHP main company. Also scheduled file shown on LHP FOR HSPL but when user try to download it gives server error. ERROR LOG _________________________________ Exception : Could not find file `\\192.168.31.16\workterra\Reports\IRSReport\12102\DNL_1095_C_LHP_Montclair_LLC_20170223234420_573.zip`. App Error Log : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->CopyFileToFileServer.Save->CommonFunctions.CopyFileToServer Employee ID : 0 Action Name : DownloadScheduledReportFile Model : System.Web.Mvc.HandleErrorInfo Controller : Report Web Error Log : at WORKTERRA.Shared.WORKTERRAControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode) at WORKTERRA.SharedFunctionWebTier.CopyFileToServer(FileServerInfo objFileServerInfo, ArrayList DeletedFiles) at WORKTERRA.BenAdmin.Areas.Report.Models.ScheduledReportDownloadPVModel.DownloadFile(String DownloadFileName, String ReportPath, Int32 OptionalParam) at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.DownloadScheduledReportFile(String DownloadFileName, String ReportPath, Int32 OptionalParam) at lambda_method(Closure , ControllerBase , Object[] ) 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.ControllerActionInvoker.<>c_ DisplayClass13.b _10() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Kumar Chhajed [ kumar.chhajed ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Remaining Estimate 9h [ 32400 ] 7h [ 25200 ]
          Time Spent 15h [ 54000 ] 17h [ 61200 ]
          Worklog Id 27467 [ 27467 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          Hi Sachin Hingole,

          Currently I'm working on support task and as per discussion with nandkumar we keeping this JIra on low priority.

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Sachin Hingole , Currently I'm working on support task and as per discussion with nandkumar we keeping this JIra on low priority.
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Priority High [ 2 ] Medium [ 3 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Development(10200)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: In Analysis(10204)
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 17/Apr/17 01:16 PM - edited
          • Time Spent:
            3.5h
             

            Analysis
            Unit testing
            Stage VPN setup

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 7h [ 25200 ] 3.5h [ 12600 ]
          Time Spent 17h [ 61200 ] 20.5h [ 73800 ]
          Worklog Id 38767 [ 38767 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Worklog Id 38767 [ 38767 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: On Hold(10207)
          Transition Time In Source Status Execution Times
          Prasanna Karlekar (Inactive) made transition -
          Open In Development
          40d 20h 37m 1
          Rakesh Roy (Inactive) made transition -
          Stage Testing In Production Testing
          2s 1
          Sachin Hingole (Inactive) made transition -
          In Production Testing Reopen in Production
          5h 43m 1
          Rakesh Roy (Inactive) made transition -
          Reopen in Production In Development
          21d 6h 6m 1
          Kumar Chhajed (Inactive) made transition -
          In Development In LB Testing
          27d 12h 17m 2
          Sachin Hingole (Inactive) made transition -
          In LB Testing Stage Testing
          3d 22h 33m 2
          Sachin Hingole (Inactive) made transition -
          Stage Testing Reopened in Stage
          3d 3m 1
          Kumar Chhajed (Inactive) made transition -
          Reopened in Stage In Development
          49d 50m 1

            People

            Assignee:
            kumar.chhajed Kumar Chhajed (Inactive)
            Reporter:
            sachin.hingole Sachin Hingole (Inactive)
            QA:
            Sachin Hingole (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Time Spent - 20.5h Remaining Estimate - 3.5h
                3.5h
                Logged:
                Time Spent - 20.5h Remaining Estimate - 3.5h
                20.5h