1097 pre-production Information services page getting error pop up

XMLWordPrintable

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

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

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Time Spent - 4 minutes Remaining Estimate - 3 hours, 56 minutes
                3h 56m
                Logged:
                Time Spent - 4 minutes Remaining Estimate - 3 hours, 56 minutes
                4m