UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

HP UCMDB CM 9.20 on Oracle

Highlighted
Frequent Advisor

HP UCMDB CM 9.20 on Oracle

Hello all!
I have installed  UCMDB CM 9.20 with oracle database and i have some problems with getting CI information from UCMDB. I added view in admin->view management, but i not see any ci`s in it, that must be authorized. i think this problem with oracle, because before it i used UCMDB CM with MS SQL and it worked correctly.
Now i have errors in amber_general.log

2012-12-18 16:25:08,380 WARN  User:                                                          BaselineMatchingSystemConfigurationImpl.syncWithMatchingRulesFromUcmdb:76    attribute: name for class: cluster is managed and not comparable
2012-12-18 16:33:35,690 WARN  User:             job viewComparisonStatistcisJobDetails   job15   JDBCExceptionReporter.logExceptions:100    SQL Error: 12899, SQLState: 72000
2012-12-18 16:33:35,692 ERROR User:             job viewComparisonStatistcisJobDetails   job15   JDBCExceptionReporter.logExceptions:101    ORA-12899: значение для столбца "UCMDBCM"."AMBER_CCI_STATIC_DATA"."NAME" Value Too Large for Column(actual: 257, max: 255)

2012-12-18 16:33:35,693 WARN  User:             job viewComparisonStatistcisJobDetails   job15   JDBCExceptionReporter.logExceptions:100    SQL Error: 12899, SQLState: 72000
2012-12-18 16:33:35,693 ERROR User:             job viewComparisonStatistcisJobDetails   job15   JDBCExceptionReporter.logExceptions:101    ORA-12899: Value Too Large for Column "UCMDBCM"."AMBER_CCI_STATIC_DATA"."NAME"  (actual: 257, max: 255)

2012-12-18 16:33:35,696 ERROR User:             job viewComparisonStatistcisJobDetails   job15   AbstractFlushingEventListener.performExecutions:324    Could not synchronize database state with session
org.hibernate.QueryTimeoutException: could not insert: [com.hp.amber.datamodel.entities.analysis.ManagedCompositeCiStaticData]

1 REPLY
Respected Contributor

Re: HP UCMDB CM 9.20 on Oracle

Hello,

 

I would start by finding out the CI which is causing this error:

JDBCExceptionReporter.logExceptions:101    ORA-12899: Value Too Large for Column "UCMDBCM"."AMBER_CCI_STATIC_DATA"."NAME"  (actual: 257, max: 255)

 

And truncate the value.

 

Adrian