HP UCMDB CM 9.20 on Oracle (219 Views)
Reply
Frequent Advisor
Mastron_s
Posts: 111
Registered: ‎05-05-2010
Message 1 of 2 (219 Views)

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]

Respected Contributor
Adrian_David
Posts: 111
Registered: ‎05-30-2012
Message 2 of 2 (207 Views)

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 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.