UCMDB and UD Practitioners Forum (Previously CMS)
cancel

HP UCMDB CM 9.20 on Oracle

Highlighted
Mastron_s
Super Contributor.

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
Adrian_David
Outstanding 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