-
Type:
Bug
-
Status: In Development
-
Priority:
Medium
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Stage
-
Bug Type:Functional
-
Bug Severity:Medium
-
Level:Partner
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Company:All Clients/Multiple Clients
-
Item State:Development - On Hold
-
Browser:Google Chrome
-
Sprint:WT Sprint 35 - Bugs, WT Sprint 37 - Bugs
1.Login to stage
2.Select company:LONG For HSPL
3.Navigate to Home >> Company Home >> standard report
4.click on add new
5.Select Type as 'Employee census'.
6.Provide report name
7.Enter all mandatory field
8.Select all employee fields
10.Click on preview.
Actual result: Getting server error
Expected result: Report should be generated properly.
Please refer attached scrren shot and error log
same issue exist on LB.
Hi [~parmeshwar.jumbade]
Verified on LB
Verified all types of standard report on company and global level
Company level-
1.Employee census -> Pass
2.Dependent census -> Pass
3.Eligibility -> Pass
4.Enrollment -> Pass
5.Billing details -> Pass
6.Payroll deduction -> Pass
7.System utilization- WT-11675
8.Commission details -> Pass
9.Fee details -> Pass
10.Benefit wise billing details -> Pass
global level-
1.Employee census -> Pass
2.Dependent census -> Pass
3.Eligibility- WT-11676
4.Enrollment -> Pass
5.Billing details -> Pass
6.Payroll deduction -> Pass
7.System utilization -> Pass
8.Commission details -> Pass
9.Fee details -> Pass
Verified reports with the selection of special characters fields.
Verified save, Run and preview button fuctionality
Please look into following issues found.Once resolved assign back to me.
1. WT-11675 -> Getting error on systeem utilization report
2.WT-11676 -> Getting server error on global eligiblility report
CC: Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole
Thanks,
Sanjana Jadhav
3C's:
Concern: Getting server error
Cause: The issue was due to after removal of special characters multiple columns names were same. Example: On employee census report having two fields Payroll last date paid for & Payroll last date paid for: respectively. After remove special character (i.e. : in second column name ) it become same as previous one. It was throwing exception.
Correction: Now while forming datasource and writing RDL we have removed special charcter and replaced with underscor. Due to this every fields will get unique name and will not have duplicate while writing datasource.
Affected Files: Please check attached modified fi;es.txt
file.
Affected Areas: Reports (Need to verify every type of report)
Tested Scenarios:
1. Verified all standard reports with multiple combinations.
2. Checked reports with the selection of special characters fields.
3. Checked preview and save functionality.
4. Verified Global level standard report (Not verified data and only normal report)
5. Every reports with multiple fields selections.
Known issues:
1. Scroll not appear to fields if having large text width
2. If two fields having same name but distinct special characters then it will not work because it will form same name after replace spacial characters.
Note: Need to verify this issue on all environment.
Parmeshwar Jumbad (Inactive)
added a comment - 3C's :
Concern : Getting server error
Cause : The issue was due to after removal of special characters multiple columns names were same. Example: On employee census report having two fields Payroll last date paid for & Payroll last date paid for: respectively. After remove special character (i.e. : in second column name ) it become same as previous one. It was throwing exception.
Correction : Now while forming datasource and writing RDL we have removed special charcter and replaced with underscor. Due to this every fields will get unique name and will not have duplicate while writing datasource.
Affected Files : Please check attached modified fi;es.txt file.
Affected Areas : Reports (Need to verify every type of report)
Tested Scenarios :
1. Verified all standard reports with multiple combinations.
2. Checked reports with the selection of special characters fields.
3. Checked preview and save functionality.
4. Verified Global level standard report (Not verified data and only normal report)
5. Every reports with multiple fields selections.
Known issues :
1. Scroll not appear to fields if having large text width
2. If two fields having same name but distinct special characters then it will not work because it will form same name after replace spacial characters.
Note: Need to verify this issue on all environment. 
We are keeping this JIRA On Hold.
From OE perspective, It is fine if we do not send this fix further.
Thank you!
cc: Gaurav Sodani, Jyoti Agrawal, [~parmeshwar.jumbade]