-
Type:
Support Activity
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Support Task Type:Data Correction
-
Environment:Production
-
Reported by:Harbinger
-
Module:BenAdmin - Report
-
Issue Importance:Must Have
-
Severity:Simple
- is caused by
-
WT-7760 BCC Invoice Management - Tier or plan change in middle of the month
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Debbie Kulling [ dkulling ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
-
- Time Spent:
- 1.5h
-
Audit discussion for CDC and CWC
Discussion on fix that can be done to resolve server error on invoice generation
Analysis on approach to fix Invoice generation server error
| Assignee | Debbie Kulling [ dkulling ] | Jyoti Agrawal [ jyoti.agrawal ] |
| Issue Type | Bug [ 1 ] | Support Activity [ 10301 ] |
| Status | In Development [ 10007 ] | Open [ 1 ] |
| Support Task Type | Data Correction [ 11203 ] | |
| Workflow | WT_Defects [ 34051 ] | WT_Support [ 34084 ] |
Hi Jyoti Agrawal,
I have verified the issue on the hspl copies of Tibco,CWC and CDC company. I have also tested generation editing deleting and export functionality of the reports. Working fine with no issues.
Thanks,
Venkatesh
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Prasanna Karlekar [ prasanna ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Venkatesh Pujari [ venkatesh.pujari ] |
Hi Debbie Kulling,
The issue has been fixed and also tested on Tibco, CDC and CWC companies. Please could you verify and let us know if the issue still exists.
Prasanna Karlekar,Jyoti Agrawal
Thanks,
Venkatesh
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Debbie Kulling [ dkulling ] |
Following are 3Cs :-
Concern :- Getting error on generating Invoices for existing template
Cause :- In change that was done for WT-7760, we have added new column in database and made changes in queries. While creating new template, changes got reflected properly but for existing templates this was not reflected which caused the error.
Correction :- Added new column in database and made changes in queries for existing templates. This is fixed for CDC, CWC, and TIBCO.
Jyoti Agrawal (Inactive)
added a comment - Following are 3Cs :-
Concern :- Getting error on generating Invoices for existing template
Cause :- In change that was done for WT-7760 , we have added new column in database and made changes in queries. While creating new template, changes got reflected properly but for existing templates this was not reflected which caused the error.
Correction :- Added new column in database and made changes in queries for existing templates. This is fixed for CDC, CWC, and TIBCO. -
- Time Spent:
- 0.75h
-
Discussion on approach to fix the invoice generation error
Verification
Jyoti Agrawal (Inactive)
made changes -
| Remaining Estimate | 5h [ 18000 ] | |
| Original Estimate | 5h [ 18000 ] |
Jyoti Agrawal (Inactive)
made changes -
| Remaining Estimate | 5h [ 18000 ] | 1h [ 3600 ] |
| Time Spent | 4h [ 14400 ] | |
| Worklog Id | 30390 [ 30390 ] |
| Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 4h [ 14400 ] | 5.5h [ 19800 ] |
| Worklog Id | 31201 [ 31201 ] |
| Time Spent | 5.5h [ 19800 ] | 6.25h [ 22500 ] |
| Worklog Id | 31496 [ 31496 ] |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
13m 21s | 1 |
|
15h 3m | 1 |
|
7h 54m | 1 |
|
8s | 1 |
Hi Debbie Kulling,
We are getting error on Invoice generation for existing templates.
There will error in generating April 2017 invoice for CDC, CWC and TIBCO.
We have found the root cause. We need time to fix and verify.
This will be fixed and verified by tomorrow.
cc: Satya, Jyoti Agrawal, Sachin Hingole