Hi Yashau MacShate,

We will provide an update on this by 25-Oct-2017.

Thank you!

cc: Gaurav Sodani

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

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]

Hello,
I removed the brackets and the report works fine

Thank you,
Yashau

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]

Thank you!

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

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

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

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.

Sachin Hingole

Thanks,
Venkatesh

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

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

Please close. Thank you!