bsm error - transaction mapping

in BSM 9.30 -> while adding transaction we are getting attached error..We tried adding new but same error persists

 

We run DB verify and it works well . Also perform DB connection wizard

 

Pl suggest

 

Reards

Parents Reply Children
  • the error indicates the issue is coming from RTSM. w/o further investigation in RTSM logs it is impossible to tell if it is due to DB issue or reconciliation.

    i suggest you submit Support Case and the engineer will be able to investigate the logs. you can take a look your self in <DPS>\log\odb\odb\error.log

  • below error i see in odb log..Any idea what could be the issue..This is freash setup and we have defined transaction in eum,.

     

    : operation Model Update: Update model with bulk of operations in mixed OPTIMISTIC/STRICT mode : class com.mercury.topaz.cmdb.shared.base.CmdbException :
    CMDB Internal Error: Error while handling request: {request: ID='b56f264456e626a77ec1bc448b8c1d13' Message='General CMDB request' Operation='com.mercury.topaz.cmdb.shared.model.operation.update.impl.bulk.ModelUpdateBulksMixed@32f60934' Customer ID='1, id name: Default Client'
    Context='CMDB Context: Customer id = '1, id name: Default Client' , User ID = '911' , Caller Application = 'RUM,loggedInUser:{rum_integration_user}''}
    2017-04-14 19:05:37,036 [qtp2101862381-593] (AbstractDataInUpdateOperation.java:274) ERROR - !!!FAILED!!![Operation #34508644 Name=DataInBulkOperation]
    com.hp.ucmdb.reconciliation.datain.operation.DataInOperationException: [ErrorCode [63000] Reconciliation DataIn general error.]
    Error while trying to [addOrUpdate] on level [1]! appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
    CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.base.CmdbException : com.mercury.topaz.cmdb.server.manage.dal.CmdbDalBatchException: [ErrorCode [-2147483648] undefined error code]
    Can't execute BATCH prepared statement [INSERT INTO HDM_170410NODE_1 (ID, CMDB_ID, A_LIC_TYPE_UDI,A_NET_BIOS_NAME,A_SNMP_SYS_NAME,A_PRIMARY_MAC_ADDRESS,A_CITY,A_NODE_OS_DESCRIPTION,A_UD_UNIQUE_ID,A_PROCESSOR_FAMILY,A_DISCOVERED_OS_VENDOR,A_CREATE_TIME,A_BIOS_ASSET_TAG,A_TENANTOWNER,A_HOST_ISVIRTUAL,A_HOST_OSACCURACY,A_ROOT_CONTAINER,A_DATA_EXTERNALID,A_DATA_ORIGIN,A_DESCRIPTION,A_DEFAULT_GATEWAY_IP_ADDRESS,A_PRIMARY_IP_ADDRESS,A_DISCOVERED_VENDOR,A_ACK_CLEARED_TIME,A_LANGUAGE,A_SERIAL_NUMBER,A_HOST_OSINSTALLTYPE,A_DIGEST,A_CODEPAGE,A_SYS_OBJECT_ID,A_DOMAIN_NAME,A_TRACK_CHANGES,A_DISPLAY_LABEL,A_NAME,A_BIOS_DATE,A_BIOS_UUID,A_DISCOVERED_LOCATION,A_DATA_ALLOW_AUTO_DISCOVERY,A_NODE_FAMILY,A_USER_LABEL,A_DISCOVERED_OS_NAME,A_MEMORY_SIZE,A_CHASSIS_TYPE,A_DISCOVERED_CONTACT,A_ROOT_ENABLEAGEING,A_PRIMARY_DNS_NAME,A_INTERNAL_NAME,A_BIOS_SERIAL_NUMBER,A_CALCULATED_ID,A_HOST_NNM_UID,A_GLOBAL_ID,A_DISCOVERED_OS_VERSION,A_ACK_ID,A_ROOT_ICONPROPERTIES,A_OS_VENDOR,A_HOST_OSRELEASE,A_HOST_LAST_BOOT_TIME,A_COUNTRY,A_DATA_SOURCE,A_OS_FAMILY,A_EXTENDED_OS_FAMILY,A_HOST_ISROUTE,A_DATA_NOTE,A_SWAP_MEMORY_SIZE,A_VENDOR,A_CREDENTIALS_ID,A_BIOS_VERSION,A_STATE,A_IS_SAVE_PERSISTENCY,A_CALCULATED_LOCATION,A_HOST_ISDESKTOP,A_ROOT_SYSTEM,A_BIOS_SOURCE,A_OS_DESCRIPTION,A_EXTENDED_NODE_FAMILY,A_DISCOVERED_MODEL,A_HOST_NNM_INTERNAL_KEY,A_DISCOVERED_DESCRIPTION,A_DEFAULT_GATEWAY_437101766,A_DOCUMENT_LIST,A_ACK_UPDATE_TIME,A_LIC_TYPE_UDF,A_HOST_SERVERTYPE,A_NODE_MODEL,START_TIME, CHANGER_DATASTORE,CHANGER_INFO, CHANGE_TYPE,TENANTS_BITMASK) VALUES (?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)], failed prior to DB execution due to exception: com.mercury.jdbc.oraclebase.ddc: [mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
    : operation Model Update: Update model with bulk of operations in mixed OPTIMISTIC/STRICT mode : class com.mercury.topaz.cmdb.shared.base.CmdbException :
    CMDB Internal Error: Error while handling request: {request: ID='b56f264456e626a77ec1bc448b8c1d13' Message='General CMDB request' Operation='com.mercury.topaz.cmdb.shared.model.operation.update.impl.bulk.ModelUpdateBulksMixed@32f60934' Customer ID='1, id name: Default Client'
    Context='CMDB Context: Customer id = '1, id name: Default Client' , User ID = '911' , Caller Application = 'RUM,loggedInUser:{rum_integration_user}''}
    at com.hp.ucmdb.reconciliation.datain.operation.AbstractDataInUpdateOperation.handleBulk(AbstractDataInUpdateOperation.java:716)
    at com.hp.ucmdb.reconciliation.datain.operation.AbstractDataInUpdateOperation.handle(AbstractDataInUpdateOperation.java:378)
    at com.hp.ucmdb.reconciliation.datain.operation.AbstractDataInUpdateOperation.dataInExecute(AbstractDataInUpdateOperation.java:209)
    at com.hp.ucmdb.reconciliation.datain.operation.AbstractDataInOperation.reconciliationExecute(AbstractDataInOperation.java:99)
    at com.hp.ucmdb.reconciliation.operation.AbstractReconciliationOperation.doExecute(AbstractReconciliationOperation.java:19)
    at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
    at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:87)
    at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:60)
    at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
    at com.mercury.topaz.cmdb.shared.manage.operation.flow.OperationInFlowDefaultExecutor.execute(OperationInFlowDefaultExecutor.java:23)
    at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:158)
    at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.doProcessRequest(RequestProcessor.java:217)
    at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.doProcessRequestWithQueueLimitation(RequestProcessor.java:234)
    at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.processRequest(RequestProcessor.java:190)
    at com.mercury.topaz.cmdb.server.manage.rpm.RequestProcessor.handleRequest(RequestProcessor.java:123)
    at com.mercury.topaz.cmdb.server.manage.Framework.handleRequest(Framework.java:624)
    at com.mercury.topaz.cmdb.client.manage.api.impl.AbstractCmdbApi.executeCMDBOperation(AbstractCmdbApi.java:38)
    at com.mercury.topaz.cmdb.client.manage.api.impl.AbstractCmdbApi.executeOperation(AbstractCmdbApi.java:57)
    at com.mercury.topaz.cmdb.client.manage.api.impl.InternalApi.executeOperation(InternalApi.java:32)
    at com.mercury.topaz.cmdb.client.manage.api.impl.InternalApi.executeCMDBOperation(InternalApi.java:24)
    at com.mercury.topaz.cmdb.server.manage.ServerApiFacade.executeOperation(ServerApiFacade.java:56)
    at com.mercury.topaz.cmdb.server.manage.ServerApiFacade.executeOperation(ServerApiFacade.java:34)
    at com.hp.ucmdb.api.server.OperationExecutorForApi.executeOperation(OperationExecutorForApi.java:27)
    at com.hp.ucmdb.api.server.request.AbstractRequestProcessor.executeOperation(AbstractRequestProcessor.java:52)
    at com.hp.ucmdb.api.server.topology.ModifyTopologyBulkProcessor.process(ModifyTopologyBulkProcessor.java:50)
    at com.hp.ucmdb.api.server.topology.ModifyTopologyBulkProcessor.process(ModifyTopologyBulkProcessor.java:27)
    at com.hp.ucmdb.api.server.request.AbstractRequestProcessor.processAndLog(AbstractRequestProcessor.java:125)
    at com.hp.ucmdb.api.server.util.ApiProcessingHelper.processRequestLocally(ApiProcessingHelper.java:39)
    at com.hp.ucmdb.api.server.http.ApiServlet.processRequest(ApiServlet.java:387)
    at com.hp.ucmdb.api.server.http.ApiServlet.doPost(ApiServlet.java:296)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
    at com.hp.ucmdb.util.xss.HttpTraceFilter.doFilter(HttpTraceFilter.java:26)
    at com.hp.ucmdb.util.xss.HttpTraceFilter.doFilter(HttpTraceFilter.java:26)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
    at com.mercury.topaz.cmdb.server.manage.servlet.LBSessionCookieFilter.doFilter(LBSessionCookieFilter.java:58)
    at org.eclipse.jetty.servlet.ServletHandler$C

  • performing rum validation we get below erroe 

     

    Rum Model Validation
    ====================
    # RumUrl points to non-existing app tier. id=19 tierId:999999
    # RumUrl points to non-existing event. Need to repair manually!. id=19 eventId:192
    # Bean was deleted as it points to non-existing entities
    # RumUrl points to non-existing app tier. id=20 tierId:999999
    # RumUrl points to non-existing event. Need to repair manually!. id=20 eventId:193
    # Bean was deleted as it points to non-existing entities
    # Error in RUM Model validation  

    how to repait it manually