-
Type:
Bug
-
Status: Resolution Setting
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:None
-
Environment:Pre Production
-
Bug Severity:Medium
-
Module:BenAdmin
-
Reported by:Harbinger
-
Company:Virgin Atlantic
-
Item State:Stage QA - Production Deployment on Hold
-
UAT For:UI Refresh
Getting error while processing Following reports:
1.Enrollment Report
2. EE census Report
3. Dependent Census Report
4.Payroll deduction
5.Newly enrolled dependents report
Refer screen shots below
------------------------------------------------------
CC: Mandar Kulkarni, Satya, Hrishikesh Deshpande, Sachin Hingole, Rakesh Roy
Environment: Codemap
Company: or QA Kindercare for hspl
Login: Partner
Reports are checked for the serevr error. No server error found during testing. So, making jira ready for Pre-pro.
3Cs:
Concern: Error while processing reports
Cause: When we execute standard system utilization report as first report for a company, connection string with OnlineEnrollment was getting created for respective company's datasource. This issue was only when, system utilization was the first report to be executed for a company. No other report had such issue.
Correction: Now we have removed code which was used to generate report datasource with Online Enrollment connection string for company level report. Due to this it will create datasource with company specific connection string for standard/dynamic reports.
Affected Files: App\BusinessLogic\Reports\RDLGenerator.vb
Affected Areas: Reports (All types and All levels)
Tested Scenarios:
1. Verified multiple types of report and it's datasource
2. Verified company level, Global level reports
Parmeshwar Jumbad (Inactive)
added a comment - 3Cs :
Concern : Error while processing reports
Cause : When we execute standard system utilization report as first report for a company, connection string with OnlineEnrollment was getting created for respective company's datasource. This issue was only when, system utilization was the first report to be executed for a company. No other report had such issue.
Correction : Now we have removed code which was used to generate report datasource with Online Enrollment connection string for company level report. Due to this it will create datasource with company specific connection string for standard/dynamic reports.
Affected Files : App\BusinessLogic\Reports\RDLGenerator.vb
Affected Areas : Reports (All types and All levels)
Tested Scenarios :
1. Verified multiple types of report and it's datasource
2. Verified company level, Global level reports
CC: Prasanna Karlekar Gaurav Sodani That's a good news that we got the root cause. As long as issue is fixed for now, we should be okay to extend the date.
Thanks,
Nidhi.
Nidhi Kaul (Inactive)
added a comment - That's a good news that we got the root cause. As long as issue is fixed for now, we should be okay to extend the date.
Thanks,
Nidhi. Hi Nidhi Kaul,
While discussing this issue, we had discussed following 2 points:
1. Scan data to check the discrepancy between company ID and connection string. - Complete
We scanned report server data for already created reports in Pre Production environment. There were following 5 companies for which reports are created :
| Company Name |
| CareerBuilder Account |
| CHMC |
| Beta Company 1 |
| BioRad |
| Miller Sierra |
All of them have proper connection string defined. No issues for existing data.
2. To check, if anytime Online enrollment connection string is getting created from code. - Root cause found. Code fix pending.
Thank you! for asking us to check this. We did found a scenario when Online Enrollment connection string can get created while executing a company level report. We will be fixing this issue. Have extended dev due date to 02-Jan-2017.
[~parmeshwar.jumbade] -
Please take this on priority tomorrow 28-Dec-2017.
Thank you!
Testing done on Codemap.
Verified all report on Random basis. Report working as expected.