-
Type:
Bug
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Bug Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Bug Type:Functional
-
Level:Partner
-
Module:BenAdmin - Enrollment
-
Reported by:Harbinger
-
Item State:Stage QA - Production Deployment on Hold
-
Issue Importance:Q2
- Login as Partner
- Select company
- Search Employee
- Go to benadmin module
- Click on Rates
- Move Global rate to Company rate
Actual result : Global rates cloning on Company giving SERVER ERROR
Expected Result : Global rates cloning on Company should not give SERVER ERROR
Please find below 3C's:
Concern: Cloning from Global Rate to Company shows server error
Cause: During Cloning global rate to company, GenericEligibilityRulesID was set to be 0(zero) by default
which gives foreign key conflict error.
Correction: As discussed with Amruta to fix this issue, we have passed GenericEligibilityRulesID of 'InActive Status Rule' in case of cloning global rate to company .
Please verify.
Shailendra Honrao (Inactive)
added a comment - - edited Please find below 3C's:
Concern: Cloning from Global Rate to Company shows server error
Cause : During Cloning global rate to company, GenericEligibilityRulesID was set to be 0(zero) by default
which gives foreign key conflict error.
Correction: As discussed with Amruta to fix this issue, we have passed GenericEligibilityRulesID of 'InActive Status Rule' in case of cloning global rate to company .
Please verify.
Cc: Jyoti Mayne , Umesh Kadam Hi
I have verified this issue on Azure;
Verified with Partner login;
Its still getting re-open
PFA 
CC:Sachin Hingole Prasad Pise Rakesh Roy
ErrorID : 0
ErrorSource : ControllerAppTier.Clone->BenAdminControllerAppTier.Clone->Rate.Clone->Rate.CloneRates
ErrorMessage: Invalid object name 'SubRatesEligibilityRules'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Priya Handepatil (Inactive)
added a comment - - edited Hi
I have verified this issue on Azure;
Verified with Partner login;
Its still getting re-open
PFA
CC: Sachin Hingole Prasad Pise Rakesh Roy
ErrorID : 0
ErrorSource : ControllerAppTier.Clone->BenAdminControllerAppTier.Clone->Rate.Clone->Rate.CloneRates
ErrorMessage: Invalid object name 'SubRatesEligibilityRules'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. Hi Priya Handepatil,
This issue is related to Azure. Please assign this to respective team.
We cross verified on LB and local, rate cloning from global to company has done successfully. No such error message was shown.
Cc: Satya
Ashwin Wankhede: Can we please check database scripts execution on this company?
Rohan J Khandave: Let's discuss in case it doesn't get fixed after script execution.
Regards,
Satya Prakash
Ashwin Wankhede Please assign QA once above task is done.
Hi Rakesh Roy,
I have not executed any script and checked with Priya Handepatil for issue on HSPL copy.
The Rates are getting cloned from Global rate to company rate.
Priya Handepatil, Can you please verify it again .
Hi
Verified this issue
Its working fine
PFA 
Sachin Hingole Rakesh Roy Prasad Pise
Priya Handepatil (Inactive)
added a comment - Hi
Verified this issue
Its working fine
PFA
Sachin Hingole Rakesh Roy Prasad Pise 
NF-1174UI Refresh-Functional-Global rates cloning on Company giving SERVER ERRORSteps:
1) Login as Partner
2) Select company
3) Search Employee
4) Go to benadmin module
5) Click on Rates
6) Drag Global rate to Company rate
Exception:
The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Rate_subName_GenericEligibilityRules". The conflict occurred in database "UiRefresh_DC_Dev_13553", table "dbo.GenericEligibilityRules", column 'ID'.
CC: Vijayendra Shinde