Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-3092

UI Refresh - Invoice management --> Server Error displayed on deleting an invoice

    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:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Low
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Production Deployment on Hold
    • Issue Importance:
      Q2
    • Browser:
      Google Chrome
    • UAT For:
      UI Refresh

      Description

      Steps:-
      1] Log into the Azure site using partner credentials
      2] Search and select Softchoice for hspl company
      3] Now click on Invoice Management option from Benadmin curtain
      4] Now edit an invoice in which only one month's invoice is generated.
      5] Try to delete that invoice and observe

      Actual Result:-
      Server Error is displayed on click of delete button

      Expected Result:-
      Invoice should be deleted without any errors

      Please let me know if you need any more information on this

        Attachments

          Issue Links

            Activity

            venkatesh.pujari Venkatesh Pujari (Inactive) created issue -
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to NF-2916 [ NF-2916 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Attachment DeleteInvoice.png [ 53471 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] surender kumar [ surender.kumar ]
            surender.kumar surender kumar (Inactive) made changes -
            Assignee surender kumar [ surender.kumar ] Vinayak Kulkarni [ vinayak.kulkarni ]
            surender.kumar surender kumar (Inactive) made changes -
            Comment [ Hi [~Vinayak.Kulkarni],

            As per discussion, This is issue related to Export.
            So, Assigning to you.

            Regards,
            Surender Kumar ]
            surender.kumar surender kumar (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] surender kumar [ surender.kumar ]
            prasanna Prasanna Karlekar (Inactive) logged work - 30/Jun/17 01:00 AM
            • Time Spent:
              0.25h
               

              Delete issue go through, discussion fix and
              verification for invoice

            surender.kumar surender kumar (Inactive) made changes -
            Assignee surender kumar [ surender.kumar ] Jyoti Agrawal [ jyoti.agrawal ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 59811 [ 59811 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Bug Severity Low [ 16703 ]
            Original Estimate 0h [ 0 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Harshada Borole [ harshada.borole ]
            harshada.borole Harshada Borole (Inactive) logged work - 06/Jul/17 04:05 PM - edited
            • Time Spent:
              2h
               

              Discussion and analysis

            prasanna Prasanna Karlekar (Inactive) logged work - 06/Jul/17 10:30 PM
            • Time Spent:
              0.25h
               

              Discussion on TR_ProtectTable Trigger

            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            harshada.borole Harshada Borole (Inactive) made changes -
            Link This issue relates to WT-9681 [ WT-9681 ]
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are 3C's :-

            Concern:- Server Error displayed on deleting an invoice.

            Cause :- On deleting invoice we drop the temporary tables.
            A trigger 'TR_ProtectTables' at database level was restricting the drop of table. This was causing server error.

            Correction :- Dropped the trigger 'TR_ProtectTables' from all databases as this was no more in use.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are 3C's :- Concern:- Server Error displayed on deleting an invoice. Cause :- On deleting invoice we drop the temporary tables. A trigger 'TR_ProtectTables' at database level was restricting the drop of table. This was causing server error. Correction :- Dropped the trigger 'TR_ProtectTables' from all databases as this was no more in use.
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Venkatesh Pujari [ venkatesh.pujari ]
            harshada.borole Harshada Borole (Inactive) logged work - 07/Jul/17 08:38 AM - edited
            • Time Spent:
              0.5h
               

              Discussion,testing

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 0.25h [ 900 ] 2.25h [ 8100 ]
            Worklog Id 61502 [ 61502 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1.5h [ 5400 ]
            Time Spent 2.25h [ 8100 ] 0.75h [ 2700 ]
            Worklog Id 61502 [ 61502 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 0.75h [ 2700 ] 2.75h [ 9900 ]
            Worklog Id 61808 [ 61808 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Worklog Id 61808 [ 61808 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Worklog Id 61808 [ 61808 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Verified this on Azure. Working fine as expected.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Verified this on Azure. Working fine as expected.
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 2.75h [ 9900 ] 3h [ 10800 ]
            Worklog Id 61874 [ 61874 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 10/Jul/17 05:43 PM
            • Time Spent:
              0.25h
               
              <No comment>
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 3h [ 10800 ] 3.25h [ 11700 ]
            Worklog Id 65451 [ 65451 ]
            satyap Satya made changes -
            Environment_New Others [ 18445 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 14/Mar/18 12:42 PM
            • Time Spent:
              0.5h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 3.25h [ 11700 ] 3.75h [ 13500 ]
            Worklog Id 108269 [ 108269 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            9d 21h 36m 1
            Venkatesh Pujari (Inactive) made transition -
            In Development In LB Testing
            3d 33m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            190d 10h 38m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            56d 19h 50m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            28m 31s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            15s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3.75h
                  3.75h