-
Type:
Change Request
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - Export
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
Getting server error when exporting Billing Data Template when Invoice is generated and its finalized .
Error Log:
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ExportProcessRowwise.ExportData->CommonExportRoutines.GetProviderWiseBillingData
ErrorMessage: Invalid column name 'InvoiceForMonthYear'.
Invalid column name 'InvoiceForMonthYear'.
- causes
-
WT-6331 BCC Invoice Management - Adjustments in future Invoice
-
- Closed
-
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | |
| Remaining Estimate | 1h [ 3600 ] | |
| Original Estimate | 1h [ 3600 ] |
| Code Review Date | 07/Dec/2016 | |
| Code Reviewed By | Vinalyak Kulkarni [ 12100 ] | |
| Dev Due Date | 08/Dec/2016 |
| Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 1h [ 3600 ] | |
| Worklog Id | 11918 [ 11918 ] |
Affected Files: OES_SP_Export_ProviderWiseInvoiceReport
| Environment | LB [ 10800 ] | |
| Issue Type | Bug [ 1 ] | Change Request [ 10002 ] |
| Workflow | WT_Defects [ 28406 ] | WT_Features [ 28410 ] |
| Original Estimate | 1h [ 3600 ] | 6h [ 21600 ] |
| Time Spent | 1h [ 3600 ] | 3h [ 10800 ] |
| Worklog Id | 11997 [ 11997 ] |
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) |
| Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Aniruddha Dev [ aniruddha.dev ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Tested this change on LB with following scenarios
a) Generating invoice but not finalizing it.
b) Generating and finalizaing invoice
Both above scenarios are considered for Rowise Columnwise type of templates along with below
1) Verified on Changes and full files
2) Verified on Group Templates (Same Companies)
3) Verified on Group Templates (Different Companies)
4) Verified for Multiple Providers and single provider
5) Verified by deleting run dates from group as well as company level templates
Records exporting on files are as expected. Ready for Stage Deployement
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Comment | [ Adding LB Testing hours (after fix) 3hrs and time already spent (2hrs) along with developer's time spent (1hr) ] |
Updating hours including LB stage and Production testing estimates along developers time spent
| Original Estimate | 6h [ 21600 ] | 12h [ 43200 ] |
| Time Spent | 3h [ 10800 ] | 8h [ 28800 ] |
| Worklog Id | 12104 [ 12104 ] |
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) |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
We are BLOCKED to test WT-6949 and WT-5308 on Stage as we are unable to generate invoice and finalize it (as Export file needs finalized invoices).
We have committed 12/12/2016 Production date for this BCC Providerwise Export enhancement which can be delayed due to this. Will resume testing once WT-6989 gets deployed on stage
CC: Prasanna Karlekar Rohan J Khandave Satya Hrishikesh DeshpandeSamir
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Verified this on Stage on company level as well as on group level template. Working as expected.
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Time Spent | 8h [ 28800 ] | 10h [ 36000 ] |
| Worklog Id | 12369 [ 12369 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates is working as expected.
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Time Spent | 10h [ 36000 ] | 12h [ 43200 ] |
| Worklog Id | 13749 [ 13749 ] |
| Worklog Id | 13749 [ 13749 ] |
| Attachment | WT-6949.xls [ 56922 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
37m 21s | 1 |
|
19h 36m | 1 |
|
4h 33m | 1 |
|
20h 50m | 1 |
|
3s | 1 |
|
3d 35m | 1 |
|
2s | 1 |
|
2s | 1 |
|
3h 6m | 1 |
|
28s | 1 |
Concern: Getting server error when exporting Billing Data Template when Invoice is generated and its finalized .
Cause: This issue is because of
WT-6331new enhancement during the this change column definition get changesCorrection: We handle this with code change.
CC-Rohan J Khandave,Vinayak Kulkarni,Rakesh Shahane