[ACE-110] Customizable configuration not loading & Error on ooredoo platform Created: 08/Aug/25  Updated: 19/Aug/25  Due: 08/Aug/25

Status: Ready for QA
Project: ACE
Component/s: UCMDB
Affects Version/s: UCMDB 4.0.0.3
Fix Version/s: UCMDB 4.0.0.4

Type: Bug Priority: Urgent
Reporter: Hassan Abdine Assignee: Hassan Abdine
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screenshot 2025-08-08 101344.png     PNG File Screenshot 2025-08-18 184224.png     PNG File Screenshot 2025-08-18 184259.png     Text File exception.txt    
Customer:
Mobinets
Planned Start:
Planned End:

 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



 Comments   
Comment by Omar Kamalddine [ 18/Aug/25 ]

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

Generated at Wed Apr 15 09:16:37 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.