UCMDB and UD Practitioners Forum (Previously CMS)
cancel

OutOfMemoryError when sync between UCMDB and Microsoft SMS

SOLVED
Go to solution
Highlighted
Shivshankar Yad
Honored Contributor.

OutOfMemoryError when sync between UCMDB and Microsoft SMS

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
Alexander Arkhi
Acclaimed Contributor.
Solution

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
Shivshankar Yad
Honored Contributor.

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