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

          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
          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
          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
          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
          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.
          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)
          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.

            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