Details

    • Customer:
      Airtel India

      Description

      TO ADD NEW ATTRIBUTE TO 5 CELL REPORT (SSB FREQUENCY).. ADD THIS DATA IN LAST OF THIS REPORT

      The Attribute type is a number (Long)
      Add the attribute to the model (and share it with AI team for parsing)
      The new parameter shall be considered in:
      Import from XML/CSV for 5G cells
      Reports of 5G cells
      Edit Panels OF 5G cells
      DB Views: 5G_cell_report

      1. 20260216_V_5G_CELL_REPORT_DBVIEW.sql
        5 kB
        Marwan Kanaan
      2. Ericsson_xml.rar
        834 kB
        Priyasha Tiwari
      3. Nokia_xml.rar
        1.08 MB
        Priyasha Tiwari

        Activity

        Hide
        Marwan Kanaan added a comment -

        this is a CR not a bug

        Show
        Marwan Kanaan added a comment - this is a CR not a bug
        Hide
        Srishti Kashyap added a comment -

        Hi Dear
        Build 3.7.71.556 is release with attribute ssbFrequency added in model of 5g cell.

        Show
        Srishti Kashyap added a comment - Hi Dear Build 3.7.71.556 is release with attribute ssbFrequency added in model of 5g cell.
        Hide
        Abir Messaikeh added a comment -

        incomplete

        Show
        Abir Messaikeh added a comment - incomplete
        Hide
        Priyasha Tiwari added a comment -

        AI patch releases, model attribute only added to database, all other changes to be done

        Import from XML/CSV for 5G cells
        Reports of 5G cells
        Edit Panels OF 5G cells
        DB Views: 5G_cell_report

        Show
        Priyasha Tiwari added a comment - AI patch releases, model attribute only added to database, all other changes to be done Import from XML/CSV for 5G cells Reports of 5G cells Edit Panels OF 5G cells DB Views: 5G_cell_report
        Hide
        Marwan Kanaan added a comment - - edited

        Dear @Priyasha Tiwari,

        The patch has been handed over to Srishti for testing on the DB clone environment, as my local schema currently has significant missing data.

        Once the DB view is delivered by the Integration team, I will proceed with updating it accordingly.

        Best Regards,
        Marwan Kanaan I Software Developer

        Show
        Marwan Kanaan added a comment - - edited Dear @Priyasha Tiwari, The patch has been handed over to Srishti for testing on the DB clone environment, as my local schema currently has significant missing data. Once the DB view is delivered by the Integration team, I will proceed with updating it accordingly. Best Regards, Marwan Kanaan I Software Developer
        Hide
        Marwan Kanaan added a comment -

        Dear @Integration Support team,

        Kindly execute the below query on the target database and restart the server afterward:

        ALTER TABLE NRCELL
        ADD SSBFREQUENCY NUMBER(25);
        COMMIT;

        Please note that this query was already included in the latest patch and should have been executed during the deployment phase to prevent the reported issue.

        Kindly confirm once completed.

        Best Regards,
        Marwan Kanaan I Software Developer

        Show
        Marwan Kanaan added a comment - Dear @Integration Support team, Kindly execute the below query on the target database and restart the server afterward: ALTER TABLE NRCELL ADD SSBFREQUENCY NUMBER(25); COMMIT; Please note that this query was already included in the latest patch and should have been executed during the deployment phase to prevent the reported issue. Kindly confirm once completed. Best Regards, Marwan Kanaan I Software Developer
        Hide
        Marwan Kanaan added a comment -

        Db view handed to srishti to test it

        Show
        Marwan Kanaan added a comment - Db view handed to srishti to test it
        Hide
        Marwan Kanaan added a comment - - edited

        Dear @Priyasha Tiwari,

        Kindly find the updated DB view attached.

        Best Regards,
        Marwan Kanaan I Software Developer

        Show
        Marwan Kanaan added a comment - - edited Dear @Priyasha Tiwari, Kindly find the updated DB view attached. Best Regards, Marwan Kanaan I Software Developer

          People

          • Assignee:
            Srishti Kashyap
            Reporter:
            Priyasha Tiwari
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:
              Planned Start:
              Planned End:
              Actual Start:
              Date of Baselining:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 4 days, 3 hours, 30 minutes
              4d 3h 30m

                Drag and Drop