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

        Hide
        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.

          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