-
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
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
Attachment | DeleteInvoice.png [ 53471 ] |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | surender kumar [ surender.kumar ] |
Assignee | surender kumar [ surender.kumar ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Comment |
[ Hi [~Vinayak.Kulkarni], As per discussion, This is issue related to Export. So, Assigning to you. Regards, Surender Kumar ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | surender kumar [ surender.kumar ] |
-
- Time Spent:
- 0.25h
-
Delete issue go through, discussion fix and
verification for invoice
Assignee | surender kumar [ surender.kumar ] | Jyoti Agrawal [ jyoti.agrawal ] |
Remaining Estimate | 0h [ 0 ] | |
Time Spent | 0.25h [ 900 ] | |
Worklog Id | 59811 [ 59811 ] |
Bug Severity | Low [ 16703 ] | |
Original Estimate | 0h [ 0 ] |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Harshada Borole [ harshada.borole ] |
-
- Time Spent:
- 2h
-
Discussion and analysis
-
- Time Spent:
- 0.25h
-
Discussion on TR_ProtectTable Trigger
Status | Open [ 1 ] | In Development [ 10007 ] |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Assignee | Harshada Borole [ harshada.borole ] | Venkatesh Pujari [ venkatesh.pujari ] |
-
- Time Spent:
- 0.5h
-
Discussion,testing
Time Spent | 0.25h [ 900 ] | 2.25h [ 8100 ] |
Worklog Id | 61502 [ 61502 ] |
Remaining Estimate | 0h [ 0 ] | 1.5h [ 5400 ] |
Time Spent | 2.25h [ 8100 ] | 0.75h [ 2700 ] |
Worklog Id | 61502 [ 61502 ] |
Remaining Estimate | 1.5h [ 5400 ] | 0h [ 0 ] |
Time Spent | 0.75h [ 2700 ] | 2.75h [ 9900 ] |
Worklog Id | 61808 [ 61808 ] |
Worklog Id | 61808 [ 61808 ] |
Worklog Id | 61808 [ 61808 ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Time Spent | 2.75h [ 9900 ] | 3h [ 10800 ] |
Worklog Id | 61874 [ 61874 ] |
Time Spent | 3h [ 10800 ] | 3.25h [ 11700 ] |
Worklog Id | 65451 [ 65451 ] |
Environment_New | Others [ 18445 ] |
Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
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) |
Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Resolution | Bug Fixed [ 10402 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Status | Production Complete [ 10028 ] | Closed [ 6 ] |
Time Spent | 3.25h [ 11700 ] | 3.75h [ 13500 ] |
Worklog Id | 108269 [ 108269 ] |
Transition | Time In Source Status | Execution Times |
---|
|
9d 21h 36m | 1 |
|
3d 33m | 1 |
|
190d 10h 38m | 1 |
|
56d 19h 50m | 1 |
|
28m 31s | 1 |
|
15s | 1 |
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.