-
Type:
Bug
-
Resolution: Done
-
Priority:
High
-
None
-
Affects Version/s: None
-
AMRIT Sprint 29
*Description: * When fill state , district and another details after click on Register getting error.
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 it should be register feedback.
Actual Result:
User should be register feedback without any error.
*Observed Environment *: Pre- Production
Environment
URL: http://192.168.35.152:8080/1097-ui/
Username: naco5 password: Test@123
*Browser: *Chrome
PF below Inspect details,
Header: : http://192.168.35.152:8080/1097api-v1.0/co/saveBenFeedback?apikey=undefined
payload: 1. [
{ "instituteTypeID": 2, "instituteName": "ART centers", "stateID": 1, "districtID": 1, "blockID": 1024, "designationID": 1, "severityID": 1, "feedbackTypeID": 1, "feedback": "test", "beneficiaryRegID": 260760, "serviceID": 1, "subServiceID": 17, "userID": 187, "createdBy": "Naco5", "benCallID": "1907410", "1097ServiceID": 1 }]
Response:
{ "statusCode": 5000, "errorMessage": "could not execute statement [Unknown column \u0027BeneficiaryConsent\u0027 in \u0027field list\u0027] [insert into t_feedback (BenCallID,BeneficiaryConsent,BeneficiaryRegID,BlockID,CategoryID,CreatedBy,DesignationID,DistrictBranchID,DistrictID,EmailStatusID,Feedback,FeedbackAgainst,FeedbackNatureID,FeedbackStatusID,FeedbackTypeID,institutionname,InstitutionTypeID,InstitutionID,ModifiedBy,requestID,SMSPhoneNo,ServiceAvailDate,ProviderServiceMapID,SeverityID,StateID,SubCategoryID,UserID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQL [insert into t_feedback (BenCallID,BeneficiaryConsent,BeneficiaryRegID,BlockID,CategoryID,CreatedBy,DesignationID,DistrictBranchID,DistrictID,EmailStatusID,Feedback,FeedbackAgainst,FeedbackNatureID,FeedbackStatusID,FeedbackTypeID,institutionname,InstitutionTypeID,InstitutionID,ModifiedBy,requestID,SMSPhoneNo,ServiceAvailDate,ProviderServiceMapID,SeverityID,StateID,SubCategoryID,UserID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]", "status": "Failed with could not execute statement [Unknown column \u0027BeneficiaryConsent\u0027 in \u0027field list\u0027] [insert into t_feedback (BenCallID,BeneficiaryConsent,BeneficiaryRegID,BlockID,CategoryID,CreatedBy,DesignationID,DistrictBranchID,DistrictID,EmailStatusID,Feedback,FeedbackAgainst,FeedbackNatureID,FeedbackStatusID,FeedbackTypeID,institutionname,InstitutionTypeID,InstitutionID,ModifiedBy,requestID,SMSPhoneNo,ServiceAvailDate,ProviderServiceMapID,SeverityID,StateID,SubCategoryID,UserID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQL [insert into t_feedback (BenCallID,BeneficiaryConsent,BeneficiaryRegID,BlockID,CategoryID,CreatedBy,DesignationID,DistrictBranchID,DistrictID,EmailStatusID,Feedback,FeedbackAgainst,FeedbackNatureID,FeedbackStatusID,FeedbackTypeID,institutionname,InstitutionTypeID,InstitutionID,ModifiedBy,requestID,SMSPhoneNo,ServiceAvailDate,ProviderServiceMapID,SeverityID,StateID,SubCategoryID,UserID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)] at Wed Jan 15 12:08:40 IST 2025.Please try after some time. If error is still seen, contact your administrator." }