-
Type:
Bug
-
Resolution: Done
-
Priority:
High
-
None
-
Affects Version/s: None
-
AMRIT Sprint 31
Description: Registration details fill after click on Beneficiary id getting error pop up.
Steps to Reproduce:
Open the application on Chrome.
Navigate to the login page.
Enter valid username and password.
Click on the "Login" button.
Expected Result:
User should be logged in and should able to do registration.
Actual Result:
User should do the registration without any error.
*Observed Environment *: Pre- Production
Environment: http://192.168.35.152:8080/1097-ui/
Username: naco5 Password: Test@123
PF below inspect details,
*Header: *http://192.168.35.152:8080/commonapi-v1.0/feedback/getFeedbacksList?apikey=undefined
*payload: *
{ "beneficiaryRegID": 260760, "serviceID": 1 }Response:
{ "statusCode": 5000, "errorMessage": "JDBC exception executing SQL [select fd1_0.FeedbackID,fd1_0.BenCallID,fd1_0.BeneficiaryConsent,fd1_0.BeneficiaryRegID,fd1_0.BlockID,fd1_0.CategoryID,fd1_0.CreatedBy,fd1_0.CreatedDate,fd1_0.Deleted,fd1_0.DesignationID,fd1_0.DistrictID,fd1_0.DistrictBranchID,fd1_0.EmailStatusID,fd1_0.Feedback,fd1_0.FeedbackAgainst,fd1_0.FeedbackNatureID,fd1_0.FeedbackStatusID,fd1_0.FeedbackTypeID,fd1_0.institutionname,fd1_0.InstitutionID,fd1_0.InstitutionTypeID,fd1_0.InstitutionID,fd1_0.LastModDate,fd1_0.UserID,fd1_0.ModifiedBy,fd1_0.ProviderServiceMapID,fd1_0.requestID,fd1_0.SMSPhoneNo,fd1_0.ServiceAvailDate,fd1_0.SeverityID,fd1_0.StateID,fd1_0.SubCategoryID,fd1_0.UserID from t_feedback fd1_0 where fd1_0.ProviderServiceMapID\u003d? and fd1_0.BeneficiaryRegID\u003d? and fd1_0.Deleted\u003d0 and fd1_0.BeneficiaryRegID is not null order by fd1_0.FeedbackID desc] [Unknown column \u0027fd1_0.BeneficiaryConsent\u0027 in \u0027field list\u0027] [n/a]; SQL [n/a]", "status": "Failed with JDBC exception executing SQL [select fd1_0.FeedbackID,fd1_0.BenCallID,fd1_0.BeneficiaryConsent,fd1_0.BeneficiaryRegID,fd1_0.BlockID,fd1_0.CategoryID,fd1_0.CreatedBy,fd1_0.CreatedDate,fd1_0.Deleted,fd1_0.DesignationID,fd1_0.DistrictID,fd1_0.DistrictBranchID,fd1_0.EmailStatusID,fd1_0.Feedback,fd1_0.FeedbackAgainst,fd1_0.FeedbackNatureID,fd1_0.FeedbackStatusID,fd1_0.FeedbackTypeID,fd1_0.institutionname,fd1_0.InstitutionID,fd1_0.InstitutionTypeID,fd1_0.InstitutionID,fd1_0.LastModDate,fd1_0.UserID,fd1_0.ModifiedBy,fd1_0.ProviderServiceMapID,fd1_0.requestID,fd1_0.SMSPhoneNo,fd1_0.ServiceAvailDate,fd1_0.SeverityID,fd1_0.StateID,fd1_0.SubCategoryID,fd1_0.UserID from t_feedback fd1_0 where fd1_0.ProviderServiceMapID\u003d? and fd1_0.BeneficiaryRegID\u003d? and fd1_0.Deleted\u003d0 and fd1_0.BeneficiaryRegID is not null order by fd1_0.FeedbackID desc] [Unknown column \u0027fd1_0.BeneficiaryConsent\u0027 in \u0027field list\u0027] [n/a]; SQL [n/a] at Wed Jan 15 12:04:20 IST 2025.Please try after some time. If error is still seen, contact your administrator." }