ACE
  1. ACE
  2. ACE-110

Customizable configuration not loading & Error on ooredoo platform

        Details

        • Type: Bug Bug
        • Status: Ready for QA Ready for QA (View Workflow)
        • Priority: Urgent Urgent
        • Resolution: Unresolved
        • Affects Version/s: UCMDB 4.0.0.3
        • Fix Version/s: UCMDB 4.0.0.4
        • Component/s: UCMDB
        • Labels:
          None Labels
        • Customer:
          Mobinets

          Description

          1. open the details of any element: e.g. site (http://10.172.20.102:6016/ACE_UCMDB_UI/inv/site/1462/addInfo)
          2. go to customizable configuration: page not working with exception

          it seems an issue with DB scripts

          Caused by: Error : 904, Position : 703, Sql = select invadditio0_.ID as id5_408_, invadditio0_.ADDITIONALINFOID as additionalinfoid1_408_, invadditio0_.ATTRIBUTE as attribute2_408_, invadditio0_.CATEGORY as category3_408_, invadditio0_.CHANGEDATE as changedate12_408_, invadditio0_.CHANGEDBY as changedby13_408_, invadditio0_.DTYPE as dtype4_408_, invadditio0_.DOCUMENTID as documentid14_408_, invadditio0_.ELEMENTID as elementid7_408_, invadditio0_.ELEMENTTYPE as elementtype8_408_, invadditio0_.EXTERNAL_CODE as external_code15_408_, invadditio0_.FIXEDREF as fixedref16_408_, invadditio0_.INSERTDATE as insertdate17_408_, invadditio0_.INSERTEDBY as insertedby18_408_, invadditio0_.NET_STATUS as net_status19_408_, invadditio0_.NOTE as note9_408_, invadditio0_.SUBNETSTATUS as subnetstatus20_408_, invadditio0_.VALUE as value10_408_, invadditio0_.VERSIONID as versionid11_408_ from UCMDB_ELEMENT_ADDITIONAL_INFORMATION_VW invadditio0_ where invadditio0_.ELEMENTID=:1 and invadditio0_.VERSIONID=:2 order by invadditio0_.ID asc fetch first :3 rows only, OriginalSql = select invadditio0_.ID as id5_408_, invadditio0_.ADDITIONALINFOID as additionalinfoid1_408_, invadditio0_.ATTRIBUTE as attribute2_408_, invadditio0_.CATEGORY as category3_408_, invadditio0_.CHANGEDATE as changedate12_408_, invadditio0_.CHANGEDBY as changedby13_408_, invadditio0_.DTYPE as dtype4_408_, invadditio0_.DOCUMENTID as documentid14_408_, invadditio0_.ELEMENTID as elementid7_408_, invadditio0_.ELEMENTTYPE as elementtype8_408_, invadditio0_.EXTERNAL_CODE as external_code15_408_, invadditio0_.FIXEDREF as fixedref16_408_, invadditio0_.INSERTDATE as insertdate17_408_, invadditio0_.INSERTEDBY as insertedby18_408_, invadditio0_.NET_STATUS as net_status19_408_, invadditio0_.NOTE as note9_408_, invadditio0_.SUBNETSTATUS as subnetstatus20_408_, invadditio0_.VALUE as value10_408_, invadditio0_.VERSIONID as versionid11_408_ from UCMDB_ELEMENT_ADDITIONAL_INFORMATION_VW invadditio0_ where invadditio0_.ELEMENTID=? and invadditio0_.VERSIONID=? order by invadditio0_.ID asc fetch first ? rows only, Error Msg = ORA-00904: "INVADDITIO0_"."SUBNETSTATUS": invalid identifier

          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
          ... 203 more

            Activity

            Ascending order - Click to sort in descending order
            Hassan Abdine made changes -
            Field Original Value New Value
            Hassan Abdine made changes -
            Link This issue clones ACE-109 [ ACE-109 ]
            Hassan Abdine made changes -
            Link This issue clones ACE-109 [ ACE-109 ]
            Hassan Abdine made changes -
            Description # open the details of any element: e.g. site
            # go to customizable configuration: the table is empty even there are customizable configuration in DB (was working in previous build)
            # trying to add new record, fill the details, on save getting error.             		# open the details of any element: e.g. site
            # go to customizable configuration: page not working with exception
            Hassan Abdine made changes -
            Attachment Screenshot 2025-08-08 101344.png [ 115003 ]
            Hassan Abdine made changes -
            Description # open the details of any element: e.g. site
            # go to customizable configuration: page not working with exception             		# open the details of any element: e.g. site
            # go to customizable configuration: page not working with exception

            it seems an issue with DB scripts
            Hassan Abdine made changes -
            Attachment exception.txt [ 115004 ]
            Hassan Abdine made changes -
            Description # open the details of any element: e.g. site
            # go to customizable configuration: page not working with exception

            it seems an issue with DB scripts             		# open the details of any element: e.g. site (http://10.172.20.102:6016/ACE_UCMDB_UI/inv/site/1462/addInfo)
            # go to customizable configuration: page not working with exception

            it seems an issue with DB scripts
            {quote}
            Caused by: Error : 904, Position : 703, Sql = select invadditio0_.ID as id5_408_, invadditio0_.ADDITIONALINFOID as additionalinfoid1_408_, invadditio0_.ATTRIBUTE as attribute2_408_, invadditio0_.CATEGORY as category3_408_, invadditio0_.CHANGEDATE as changedate12_408_, invadditio0_.CHANGEDBY as changedby13_408_, invadditio0_.DTYPE as dtype4_408_, invadditio0_.DOCUMENTID as documentid14_408_, invadditio0_.ELEMENTID as elementid7_408_, invadditio0_.ELEMENTTYPE as elementtype8_408_, invadditio0_.EXTERNAL_CODE as external_code15_408_, invadditio0_.FIXEDREF as fixedref16_408_, invadditio0_.INSERTDATE as insertdate17_408_, invadditio0_.INSERTEDBY as insertedby18_408_, invadditio0_.NET_STATUS as net_status19_408_, invadditio0_.NOTE as note9_408_, invadditio0_.SUBNETSTATUS as subnetstatus20_408_, invadditio0_.VALUE as value10_408_, invadditio0_.VERSIONID as versionid11_408_ from UCMDB_ELEMENT_ADDITIONAL_INFORMATION_VW invadditio0_ where invadditio0_.ELEMENTID=:1 and invadditio0_.VERSIONID=:2 order by invadditio0_.ID asc fetch first :3 rows only, OriginalSql = select invadditio0_.ID as id5_408_, invadditio0_.ADDITIONALINFOID as additionalinfoid1_408_, invadditio0_.ATTRIBUTE as attribute2_408_, invadditio0_.CATEGORY as category3_408_, invadditio0_.CHANGEDATE as changedate12_408_, invadditio0_.CHANGEDBY as changedby13_408_, invadditio0_.DTYPE as dtype4_408_, invadditio0_.DOCUMENTID as documentid14_408_, invadditio0_.ELEMENTID as elementid7_408_, invadditio0_.ELEMENTTYPE as elementtype8_408_, invadditio0_.EXTERNAL_CODE as external_code15_408_, invadditio0_.FIXEDREF as fixedref16_408_, invadditio0_.INSERTDATE as insertdate17_408_, invadditio0_.INSERTEDBY as insertedby18_408_, invadditio0_.NET_STATUS as net_status19_408_, invadditio0_.NOTE as note9_408_, invadditio0_.SUBNETSTATUS as subnetstatus20_408_, invadditio0_.VALUE as value10_408_, invadditio0_.VERSIONID as versionid11_408_ from UCMDB_ELEMENT_ADDITIONAL_INFORMATION_VW invadditio0_ where invadditio0_.ELEMENTID=? and invadditio0_.VERSIONID=? order by invadditio0_.ID asc fetch first ? rows only, Error Msg = ORA-00904: "INVADDITIO0_"."SUBNETSTATUS": invalid identifier

            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
            ... 203 more
            {quote}
            Hassan Abdine made changes -
            Assignee Hassan Abdine [ habdine ] Albanna khalil [ akhalil ]
            Hassan Abdine made changes -
            Assignee Albanna khalil [ akhalil ] Khaled Khalil [ kkhalil ]
            Hassan Abdine made changes -
            Link This issue is cloned by ACE-111 [ ACE-111 ]
            Hassan Abdine made changes -
            Link This issue is cloned by ACE-111 [ ACE-111 ]
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Omar Kamalddine [ okamalddine ]
            Omar Kamalddine made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Omar Kamalddine made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Hide
            Permalink
            Omar Kamalddine added a comment -

            Error fixed on both db view and additional info view class.

            Show
            Omar Kamalddine added a comment - Error fixed on both db view and additional info view class.
            Omar Kamalddine made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Attachment Screenshot 2025-08-18 184224.png [ 115607 ]
            Attachment Screenshot 2025-08-18 184259.png [ 115608 ]
            Fix Version/s UCMDB 4.0.0.4 [ 39524 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Omar Kamalddine [ okamalddine ] Hassan Abdine [ habdine ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		10d 8h 30m 1 Omar Kamalddine 18/Aug/25 3:06 PM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		5s 1 Omar Kamalddine 18/Aug/25 3:07 PM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		48s 1 Omar Kamalddine 18/Aug/25 3:07 PM
            To Be Released To Be Released Ready for QA Ready for QA
            		18h 53m 1 Khaled Khalil 19/Aug/25 10:01 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Hassan Abdine
                Reporter:
                Hassan Abdine
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

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

                  Drag and Drop