1097 Pre-Production Feedback is not registered.

XMLWordPrintable

    • 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." }

              Assignee:
              Mokirala Kumar
              Reporter:
              Manisha Dilip Shinde [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: