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

OutOfMemoryError when sync between UCMDB and Microsoft SMS

SOLVED
Go to Solution
Super Advisor

OutOfMemoryError when sync between UCMDB and Microsoft SMS

[ Edited ]

Hello Expert,

We are getting the error message "java.lang.OutOfMemoryError" when trying to syncronize between Migrosoft SMS and UCMDB

UCMDB Version 8.04

java.lang.OutOfMemoryError: Java heap space
at com.mercury.util.UtilTransliteratorUsingTable.decode(Unknown Source)
at com.mercury.jdbc.sqlserver.SQLServerByteOrderedDataReader.readString(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.getReturnedValue(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.getColumnDataForRow(Unknown Source)
at com.mercury.jdbc.sqlserver.SQLServerImplResultSet.getData(Unknown Source)
at com.mercury.jdbc.base.BaseResultSet.getString(Unknown Source)
at com.mercury.jdbc.base.BaseResultSet.getString(Unknown Source)
at org.hibernate.type.StringType.get(StringType.java:18)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.loader.hql.QueryLoader.getResultColumnOrRow(QueryLoader.java:341)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:594)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.impl.FcmdbDalAbstractCommand.executeQuery(FcmdbDalAbstractCommand.java:203)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.datamodel.impl.FcmdbDalConditionComplexCommand.performQueryCondition(FcmdbDalConditionComplexCommand.java:97)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.datamodel.impl.FcmdbDalGetTriplesComplexCommand.perform(FcmdbDalGetTriplesComplexCommand.java:88)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.impl.FcmdbDalAbstractCommand.execute(FcmdbDalAbstractCommand.java:104)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.datamodel.impl.FcmdbDalChunkedTripleConditionComplexCommand.buildResult(FcmdbDalChunkedTripleConditionComplexCommand.java:80)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.datamodel.impl.FcmdbDalChunkedTripleConditionComplexCommand.perform(FcmdbDalChunkedTripleConditionComplexCommand.java:65)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.impl.FcmdbDalAbstractCommand.execute(FcmdbDalAbstractCommand.java:104)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.impl.FcmdbDalTransactionComplexCommand.executeCommands(FcmdbDalTransactionComplexCommand.java:90)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.impl.FcmdbDalTransactionComplexCommand.perform(FcmdbDalTransactionComplexCommand.java:50)

at com.mercury.topaz.cmdb.server.fcmdb.util.ExceptionConverter.createAdapterAccessGeneralException(ExceptionConverter.java:134)
at com.mercury.topaz.cmdb.server.fcmdb.util.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:65)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.createAdapterAccessException(AbstractDataAccessAdapterOperation.java:56)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:41)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:62)
... 31 more

Regards
Shiva

 

 

P.S. This thread has ben moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum Moderator

OpenVIew
2 REPLIES
Honored Contributor

Re: OutOfMemoryError when sync between UCMDB and Microsoft SMS

Hi Shiva,

I assume that you replicate the data that was selected by certain TQL.
Can you refine the TQL to replicate the smaller amount of data, so the OOM won't happen?

Regards,
Alex
Super Advisor

Re: OutOfMemoryError when sync between UCMDB and Microsoft SMS

Hello Alex,

Thanks for your reply,

I have refined the TQL as attached which include only root, SMHOST and CPU.

Do i need to do any configuration fintuning which will help me, current the server 4GB memory running UCMDB application as well as database server.

Regards
Shiva
*******
OpenVIew
//Add this to "OnDomLoad" event