Details
-
Type:
Bug
-
Status:
Ready for QA
(View Workflow)
-
Priority:
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
- 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
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
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
Error fixed on both db view and additional info view class.