L3 Support
  1. L3 Support
  2. LS-1097

Consolidated Financial Report - zain JO

        Details

        • Type: Bug Bug
        • Status: Cancelled Cancelled (View Workflow)
        • Priority: Normal Normal
        • Resolution: Fixed
        • Component/s: None
        • Labels:
          None Labels
        • Customer:
          Zain Jordan

          Description

          creation date - 28 APr

          Dear @Khaled Khalil,

          Kindly align the resource for the below mentioned issue observed in Zain JO.

          Kindly support to check the Consolidated Financial Report as its not working correctly .

          The total records count showing but not populating the data , @Manjit Kumarkindly provide today logs of Zain JO Prod platform and also check if any error occure.

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Abir Messaikeh added a comment -

            Dear Benadel/Bessem,

            As checked and found below error while sync process running.

            Download full server log from below link.

            server.log.28.04.2026.jo.tgz

            2026-04-28 09:35:21,129 ERROR [com.mobinets.nep.npt.service.impl.NptEditNetworkServiceImpl] (default task-252) error while executing FR Asset sync job for : PassiveNODE
            2026-04-28 09:35:21,130 ERROR [stderr] (default task-252) org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into FR_ASSET
            2026-04-28 09:35:21,136 ERROR [stderr] (default task-252) Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch

            Show
            Abir Messaikeh added a comment - Dear Benadel/Bessem, As checked and found below error while sync process running. Download full server log from below link. server.log.28.04.2026.jo.tgz 2026-04-28 09:35:21,129 ERROR [com.mobinets.nep.npt.service.impl.NptEditNetworkServiceImpl] (default task-252) error while executing FR Asset sync job for : PassiveNODE 2026-04-28 09:35:21,130 ERROR [stderr] (default task-252) org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into FR_ASSET 2026-04-28 09:35:21,136 ERROR [stderr] (default task-252) Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch
            Hide
            Permalink
            Abir Messaikeh added a comment -

            Dear @Manjit Kumar,

            I checked the Consolidated Financial Report issue and found that some key DB functions are missing or marked as invalid .
            Kindly find attached the scripts that need to be re-run in the correct order.
            Best Regards ,
            Mohamed Hassen Benadel

            Show
            Abir Messaikeh added a comment - Dear @Manjit Kumar, I checked the Consolidated Financial Report issue and found that some key DB functions are missing or marked as invalid . Kindly find attached the scripts that need to be re-run in the correct order. Best Regards , Mohamed Hassen Benadel
            Hide
            Permalink
            Abir Messaikeh added a comment -

            Dear Daljeet,

            All script has been executed, kindly validate and share the feedback.

            Show
            Abir Messaikeh added a comment - Dear Daljeet, All script has been executed, kindly validate and share the feedback.
            Hide
            Permalink
            Abir Messaikeh added a comment - - edited

            From: Daljeet Singh Virdi <Daljeet.Virdi@mobinets.com>
            Sent: Thursday, April 30, 2026 8:16 AM
            To: Wilfred Bett <Wilfred.B@cybermak.net>; Abir Messaikeh <Abir.Messaikeh@nuiva.com>; Manjit Kumar <manjit.kumar@mobinets.com>
            Cc: support <support@mobinets.com>; ALM Support <ALM.Support@cybermak.net>; Medhat El Shenawy <Medhat.M@cybermak.net>
            Subject: RE: ZJO - Consolidated Financial Report.

            Dear @Wilfred Bett,

            Issue has been fixed.

            Show
            Abir Messaikeh added a comment - - edited From: Daljeet Singh Virdi <Daljeet.Virdi@mobinets.com> Sent: Thursday, April 30, 2026 8:16 AM To: Wilfred Bett <Wilfred.B@cybermak.net>; Abir Messaikeh <Abir.Messaikeh@nuiva.com>; Manjit Kumar <manjit.kumar@mobinets.com> Cc: support <support@mobinets.com>; ALM Support <ALM.Support@cybermak.net>; Medhat El Shenawy <Medhat.M@cybermak.net> Subject: RE: ZJO - Consolidated Financial Report. Dear @Wilfred Bett, Issue has been fixed.
            Cancel

              People

              • Assignee:
                Daljeet Singh Virdi
                Reporter:
                Daljeet Singh Virdi
                Rejected By:
                Mohamed Benadel
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Planned Start:
                  Planned End:

                  Drag and Drop