-
Type:
Bug
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Bug Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Report
-
Reported by:Support
-
Company:SBM
-
Item State:Production Complete - Closed
-
Sprint:WT- Sprint 43
The Client requested a Rejection Report be forwarded to them by 1st of each month, to capture transaction from prior month.
I created the SBM Rejection Report, under Static Reports. The first scheduled report ran 10/1/2017. When reviewing the "downloaded report"; it appeared to have downloaded a file but no file was in the "zipped file". When I manually ran the report, got 6 records.
Please advise why the scheduled report did not attach a file and capture the 6 records obtain from manually running this report?
This is what I get, please see below:
Yashau
Please ref: CT-2670
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Satya [ ID10004 ] | Prasanna Karlekar [ prasanna ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Hi Yashau MacShate,
As per initial analysis, following are the updates:
Report is saved by name "SBM - Rejection Report (Scheduled Report)". In report name there are round brackets "()" due to which blank zip folder is getting delivered.
We tried creating and scheduling a report with and without round brackets and following are our observations:
- The one without round brackets got delivered with an excel in zip folder
- The one with round brackets got delivered with blank zip folder.
We will be doing detailed analysis for this, hence converting this JIRA to Bug.
But, as of now, a quick fix would be to remove round brackets from report name. Can this be done?
Do let us know.
Thank you!
cc: Gaurav Sodani, [~parmeshwar.jumbade], Prasad Patil
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Status | In Progress [ 3 ] | In Development [ 10007 ] |
| Support Task Type | Data Audit [ 18401 ] | |
| Workflow | WT_Support [ 55563 ] | WT_Defects [ 56070 ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
| Developer | Parmeshwar Jumbad [ parmeshwar.jumbade ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | |
| Root Cause | Scenario/Requirement Missed [ 18432 ] |
Prasad Patil (Inactive)
logged work - 25/Oct/17 12:21 PM -
- Time Spent:
- 1h
-
Analysis and discussion with Prasanna.
Prasad Patil (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 1h [ 3600 ] | |
| Worklog Id | 86330 [ 86330 ] |
Parmeshwar Jumbad (Inactive)
logged work - 25/Oct/17 12:28 PM -
- Time Spent:
- 1h
-
Internal discussion with Prasanna.
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 1h [ 3600 ] | 2h [ 7200 ] |
| Worklog Id | 86338 [ 86338 ] |
-
- Time Spent:
- 3h
-
Issue discussion
Issue analysis
Discussion on tracking parameters from Profiler
Code flow go through when report is delivered via email
Report name changes and verification via scheduler
| Time Spent | 2h [ 7200 ] | 5h [ 18000 ] |
| Worklog Id | 86576 [ 86576 ] |
Hi Yashau MacShate,
Gentle Reminder!
As of now, can round brackets be removed from report name?
Do let us know.
If there is bandwidth, we will try to schedule this in upcoming sprint, starting from 06-Nov-2017.
Thank you!
cc: Gaurav Sodani, [~parmeshwar.jumbade]
| Attachment | screenshot-1.png [ 66033 ] |
Hello,
I removed the brackets and the report works fine
Thank you,
Yashau
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Report(10109) |
| Component/s | BenAdmin [ 10000 ] |
Hi Yashau MacShate,
Thank you! for responding back and making the suggested fix.
We will provide proper fix for this. Will provide an update once we schedule this.
Thank you!
cc: Gaurav Sodani, [~parmeshwar.jumbade], [~meghana joshi]
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
| Original Estimate | 0h [ 0 ] |
| Time Spent | 5h [ 18000 ] | 5.25h [ 18900 ] |
| Worklog Id | 88261 [ 88261 ] |
| Labels | Standard_Report |
| Environment_New | Production [ 18442 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Harshada Borole [ harshada.borole ] |
| Dev Due Date | 08/Dec/2017 | |
| Dev Estimates | 30 | |
| Developer | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Harshada Borole [ harshada.borole ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 41 - Bugs [ 95 ] |
Thank you! 
Gaurav Sodani (Inactive)
made changes -
| Approval status | Need approval for development [ 18452 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 41 - Bugs [ 95 ] |
Gaurav Sodani (Inactive)
made changes -
| Deployment Approval | Need approval for development [ 18452 ] |
Harshada Borole (Inactive)
made changes -
| Assignee | Harshada Borole [ harshada.borole ] | Jyoti Agrawal [ jyoti.agrawal ] |
| QA | Venkatesh Pujari [ venkatesh.pujari ] | |
| QA Estimates | 8 |
Parmeshwar Jumbad (Inactive)
logged work - 20/Jan/18 05:09 AM -
- Time Spent:
- 0.5h
-
WBS creation
Internal discussion with Gaurav & Satya
Gaurav Sodani (Inactive)
made changes -
| Attachment | WT-11705 WBS.xlsx [ 72083 ] |
Jyoti Agrawal (Inactive)
made changes -
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Sprint | WT- Sprint 43 [ 98 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Dev Due Date | 08/Dec/2017 | 31/Jan/2018 |
Parmeshwar Jumbad (Inactive)
made changes -
| Dev Estimates | 30 | 24 |
| Time Spent | 5.25h [ 18900 ] | 5.75h [ 20700 ] |
| Worklog Id | 101420 [ 101420 ] |
-
- Time Spent:
- 0.5h
-
WBS go through
Discussion on - If any changes required explicitly in report scheduler routine
Parmeshwar Jumbad (Inactive)
logged work - 24/Jan/18 05:58 AM -
- Time Spent:
- 3.5h
-
Special characters analysis for schedule reports
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 5.75h [ 20700 ] | 6.25h [ 22500 ] |
| Worklog Id | 101914 [ 101914 ] |
Parmeshwar Jumbad (Inactive)
logged work - 25/Jan/18 05:59 AM -
- Time Spent:
- 8h
-
Code changes
Unit testing in New UI
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 6.25h [ 22500 ] | 9.75h [ 35100 ] |
| Worklog Id | 101926 [ 101926 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 9.75h [ 35100 ] | 17.75h [ 63900 ] |
| Worklog Id | 101927 [ 101927 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Amruta Lohiya [ amruta.baheti ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
Parmeshwar Jumbad (Inactive)
logged work - 26/Jan/18 05:07 AM -
- Time Spent:
- 5h
-
Unit testing in old & new UI and internal discussion
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 17.75h [ 63900 ] | 22.75h [ 81900 ] |
| Worklog Id | 102719 [ 102719 ] |
Amruta Lohiya
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Amruta Lohiya
made changes -
| Assignee | Amruta Lohiya [ amruta.baheti ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
Below are the 3C's:
Concern: Blank zip folder is getting delivered.
Cause: While save report into system there was a special characters ( i.e. "(" & ")" ) into report name. While processing report through schedule it was processing report but while generate zip folder it was not copying into zip folder because of those special characters.
Correction: We already handled most of special characters while enter into report name. But, whatever characters we allowed (i.e. underscore ("_"), dash ("-"), opening and closing curly brackets ( "
{" & "}" ), opening and closing round brackets ("(" & ")"), percentage ("%") and dot (".")) out of those problem was only with opening an opening and closing round brackets. This characters were already mentioned in error message (i.e. Not allowed) but it was not work while save and clone report. Handled opening and closing round brackets while save & clone reports. Henceforth opening and closing round brackets will not allowed into report name text-box while clone and save. If some one tries to do then it will show validation message as like other special characters.
While working on this we found that special characters are not validated at Global level reports so now added special characters check at global level as well similar to the company level reports.
Affected Areas: Reports (All Level and All types of reports)
Affected Files:
BenAdmin/Areas/Report/Views/Report/CommonReports/_CloneReport.cshtml
BenAdmin/Areas/Report/Views/Report/StandardReports/_StandardReportAtGlobalLevelPV.cshtml
BenAdmin/Areas/Report/Views/Report/StandardReports/_StandardReportsFormPV.cshtml
BenAdmin/Areas/Report/Views/Report/StaticReport/StaticReports.cshtml
Tested Scenarios:
1. Verified report save functionality (i.e. Add/Edit) for all types and all levels
2. Verified report clone functionality for all types and all levels
3. Checked report save (i.e. Add/Edit) with & without different special characters in report name for different report base type as well as sub type.
4. Checked report clone functionality with & without different special characters in report name for different report base type as well as sub type.
Parmeshwar Jumbad (Inactive)
added a comment - - edited Below are the 3C's :
Concern : Blank zip folder is getting delivered.
Cause : While save report into system there was a special characters ( i.e. "(" & ")" ) into report name. While processing report through schedule it was processing report but while generate zip folder it was not copying into zip folder because of those special characters.
Correction : We already handled most of special characters while enter into report name. But, whatever characters we allowed (i.e. underscore ("_"), dash ("-"), opening and closing curly brackets ( "
{" & "}
" ), opening and closing round brackets ("(" & ")"), percentage ("%") and dot (".")) out of those problem was only with opening an opening and closing round brackets. This characters were already mentioned in error message (i.e. Not allowed) but it was not work while save and clone report. Handled opening and closing round brackets while save & clone reports. Henceforth opening and closing round brackets will not allowed into report name text-box while clone and save. If some one tries to do then it will show validation message as like other special characters.
While working on this we found that special characters are not validated at Global level reports so now added special characters check at global level as well similar to the company level reports.
Affected Areas : Reports (All Level and All types of reports)
Affected Files :
BenAdmin/Areas/Report/Views/Report/CommonReports/_CloneReport.cshtml
BenAdmin/Areas/Report/Views/Report/StandardReports/_StandardReportAtGlobalLevelPV.cshtml
BenAdmin/Areas/Report/Views/Report/StandardReports/_StandardReportsFormPV.cshtml
BenAdmin/Areas/Report/Views/Report/StaticReport/StaticReports.cshtml
Tested Scenarios :
1. Verified report save functionality (i.e. Add/Edit) for all types and all levels
2. Verified report clone functionality for all types and all levels
3. Checked report save (i.e. Add/Edit) with & without different special characters in report name for different report base type as well as sub type.
4. Checked report clone functionality with & without different special characters in report name for different report base type as well as sub type.
CC: Amruta Lohiya Gaurav Sodani 
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) |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Sachin Hingole [ sachin.hingole ] |
| 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: In Testing(10210) |
Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Venkatesh Pujari [ venkatesh.pujari ] |
| Time Spent | 22.75h [ 81900 ] | 29.75h [ 107100 ] |
| Worklog Id | 103074 [ 103074 ] |
Hi [~parmeshwar.jumbade],
Tested this fix on LB on City Of Durham For Hspl. Below are the scenarios tested :-
1. Verified report save functionality (i.e. Add/Edit) for Standard,Dynamic and Static Reports
2. Verified report clone functionality for for Standard,Dynamic and Static Reports
3. Checked report save (i.e. Add/Edit) with & without different special characters in report name for Standard,Dynamic and Static Reports
4. Checked report clone functionality with & without different special characters in report name for Standard,Dynamic and Static Reports
For all reports the system is working fine as expected except two reports i.e Rejection and Admin Enrollment Report. Testing is blocked for both these reports due to ticket no :- WT-11389
Sachin Hingole,Hrishikesh Deshpande,Gaurav Sodani
Thanks,
Venkatesh
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Parmeshwar Jumbad (Inactive)
logged work - 02/Feb/18 05:47 AM -
- Time Spent:
- 1.25h
-
Internal discussion with QA
Ashwin related to Scheduler service & Check Network File path on LB
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 29.75h [ 107100 ] | 31h [ 111600 ] |
| Worklog Id | 103177 [ 103177 ] |
Hi Venkatesh Pujari,
Changes made by are not a report type specific. WT-11389 is pending due to approval. Rejection and Admin Enrollment Report problem not exists on production so you can verify same changes for these two report type on production HSPL copy.
As per discussion with Satya, If it works for all rest of reports except mentioned two report type then it will be fine to mark as ready for stage.
CC: Amruta Lohiya Gaurav Sodani Sachin Hingole Hrishikesh Deshpande
Parmeshwar Jumbad (Inactive)
added a comment - Hi Venkatesh Pujari ,
Changes made by are not a report type specific. WT-11389 is pending due to approval. Rejection and Admin Enrollment Report problem not exists on production so you can verify same changes for these two report type on production HSPL copy.
As per discussion with Satya , If it works for all rest of reports except mentioned two report type then it will be fine to mark as ready for stage.
CC: Amruta Lohiya Gaurav Sodani Sachin Hingole Hrishikesh Deshpande Hi [~parmeshwar.jumbade],
The issue has been tested for Rejection as well as Admin Enrollment Report. Now if there are any special characters also the file is delivered correctly in the Zip Folder. This is ready for Stage.
Sachin Hingole,Hrishikesh Deshpande
Thanks,
Venkatesh
| Item State | Parent values: LB QA(10201)Level 1 values: On Hold(10211) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Time Spent | 31h [ 111600 ] | 31.5h [ 113400 ] |
| Worklog Id | 103814 [ 103814 ] |
| 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 | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Production Due Date | 13/Feb/2018 |
| Time Spent | 31.5h [ 113400 ] | 36.5h [ 131400 ] |
| Worklog Id | 103869 [ 103869 ] |
Hi [~parmeshwar.jumbade],
Tested this fix on Stage on AH For Hspl company. Below are the scenarios tested :-
1. Verified report save functionality (i.e. Add/Edit) for Standard,Dynamic and Static Reports
2. Verified report clone functionality for for Standard,Dynamic and Static Reports
3. Checked report save (i.e. Add/Edit) with & without different special characters in report name for Standard,Dynamic and Static Reports
4. Checked report clone functionality with & without different special characters in report name for Standard,Dynamic and Static Reports
For all reports the system is working fine as expected
This is ready for Production.
Thanks,
Venkatesh
| 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 | 36.5h [ 131400 ] | 38.5h [ 138600 ] |
| Worklog Id | 103916 [ 103916 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Worklog Id | 103916 [ 103916 ] |
-
- Time Spent:
- 2h
-
Testing on Stage
-
- Time Spent:
- 0.5h
-
Testing on WT
| Worklog Id | 103814 [ 103814 ] |
Khandu Kshirsagar (Inactive)
made changes -
| 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 ] | 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) |
Hi [~parmeshwar.jumbade],
Tested this fix on Production on Barrow For Hspl company. Below are the scenarios tested :-
1. Verified report save functionality (i.e. Add/Edit) for Standard,Dynamic and Static Reports
2. Verified report clone functionality for for Standard,Dynamic and Static Reports
3. Checked report save (i.e. Add/Edit) with & without different special characters in report name for Standard,Dynamic and Static Reports
4. Checked report clone functionality with & without different special characters in report name for Standard,Dynamic and Static Reports
For all reports the system is working fine as expected
Thanks,
Venkatesh
-
- Time Spent:
- 3.25h
-
Testing on Production
| Time Spent | 38.5h [ 138600 ] | 40.5h [ 145800 ] |
| Worklog Id | 104349 [ 104349 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Hi Yashau MacShate,
The issue has been fixed and also tested on Production. Please could you verify and close this ticket.
[~parmeshwar.jumbade]
Thanks,
Venkatesh
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Yashau MacShate [ yashau.macshate ] |
| Resolution | Bug Fixed [ 10402 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Time Spent | 40.5h [ 145800 ] | 41.5h [ 149400 ] |
| Worklog Id | 104349 [ 104349 ] |
| Time Spent | 41.5h [ 149400 ] | 41.75h [ 150300 ] |
| Worklog Id | 104349 [ 104349 ] |
Please close. Thank you! 
| Transition | Time In Source Status | Execution Times |
|---|
|
5d 19h 38m | 1 |
|
58m 19s | 1 |
|
98d 18h 11m | 1 |
|
7d 3h 19m | 1 |
|
5d 48m | 1 |
|
2h 43m | 1 |
Hi Yashau MacShate,
We will provide an update on this by 25-Oct-2017.
Thank you!
cc: Gaurav Sodani