-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
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
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Issues :
Randomly, Getting server error on selecting all companies for Global Level Standard Report [ Any Report Type ]
ErrorID : 0
ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->ReportDetails.GetData->ReportDetails.GetReportListByCompanyIds
ErrorMessage: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)
- relates to
-
WT-129 Ability to run an enrollment report across all companies
-
- Production Complete
-
Parmeshwar Jumbad (Inactive)
made changes -
| Status | Open [ 1 ] | In Development [ 10007 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Sachin Hingole [ sachin.hingole ] |
This is already deployed on stage along with WT-129. So need to check this on both environments (Stage/Production)
Parmeshwar Jumbad (Inactive)
added a comment - - edited This is already deployed on stage along with WT-129 . So need to check this on both environments (Stage/Production) Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Mahendra Mungase [ mahendra.mungase ] |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| 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) |
We have regressed this issue on Stage and observed that issue does not exist.Hence marking ready for production
| Production Due Date | 26/Sep/2017 |
| QA | Mahendra Mungase [ mahendra.mungase ] |
| Developer | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
Parmeshwar Jumbad (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) |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
We have regressed this issue on Production and observed that issue does not exist.Hence marking production complete.
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Done [ 10000 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Resolution | Done [ 10000 ] | Fixed [ 1 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| QA Estimates | 2 |
| Remaining Estimate | 0.75h [ 2700 ] | |
| Original Estimate | 1h [ 3600 ] |
| Remaining Estimate | 0.75h [ 2700 ] | 0.5h [ 1800 ] |
| Time Spent | 0.25h [ 900 ] | |
| Worklog Id | 82632 [ 82632 ] |
| Environment_New | Stage [ 18443 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Parmeshwar Jumbad (Inactive)
made transition
-
|
30d 1h 25m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
18h 10m | 1 |
|
5m 44s | 1 |
|
4d 2h 19m | 1 |
|
8m 34s | 1 |
|
4s | 1 |
3C's:
Concern: Global Level Standard Reports - Throws Server error on selecting all companies
Cause: Server name not considered before database name while form query. But on stage environment we have different companies database on different servers but it was trying to search database on same server.
Correction: We have added server name while generate query so this will not throw exceptions now.
Tested Scenarios:
1. Select and deselect company functionality for multiple report type.
Affected Files: This resolved under the main enhancement
WT-129.Affected Areas: Global level reports.
Note: Same issue will occur in case of any company is an active but database not available on mentioned server. Already discussed scenario with Ashwin Wankhede and according to them this case will handle at there side.
CC: Prasanna Karlekar Sachin Hingole