Highlighted
Trusted Contributor.
Trusted Contributor.
630 views

getting db errors in ucmdb 10.01 cup6 when trying to connect dataflowprobe

Hi,

 

Could you please help understanding the errors.

 

uCMDB Ver : 10.01 CUP6

OS : Windows 2k8r2

DB : Oraacle 

 

Error from log file as below..

 

Caused by: com.mercury.topaz.cmdb.shared.base.CmdbException: [ErrorCode [-2147483648] undefined error code]
com.mercury.topaz.cmdb.server.manage.dal.CmdbDalBatchException: [ErrorCode [-2147483648] undefined error code]
Can't execute BATCH prepared statement [INSERT INTO HDM_140910IP_ADDRESS_1 (ID, CMDB_ID, A_IP_ISBROADCAST,A_IPADDRESS_STATIC_ROUTE,A_IPADDRESS_ALIAS,A_CITY,A_IP_ISDHCP,A_CREATE_TIME,A_IP_PROBENAME,A_TENANTOWNER,A_IP_NETCLASS,A_IP_NETMASK,A_ROOT_CONTAINER,A_DATA_EXTERNALID,A_DATA_ORIGIN,A_IP_NETTYPE,A_DESCRIPTION,A_IP_ADDRESS,A_ACK_CLEARED_TIME,A_IP_ISMANAGED,A_LANGUAGE,A_DIGEST,A_IP_DHCPDOMAINNAME,A_CODEPAGE,A_TRACK_CHANGES,A_DISPLAY_LABEL,A_NAME,A_ISVIRTUAL,A_IP_LEASE_TIME,A_SG_IP_IS_DHCP,A_DATA_ALLOW_AUTO_DISCOVERY,A_AUTHORITATIVE_DNS_NAME,A_USER_LABEL,A_ROOT_ENABLEAGEING,A_SG_IP_ADDRESS_ATOD,A_CALCULATED_ID,A_GLOBAL_ID,A_IP_NETADDR,A_ROUTING_DOMAIN,A_ACK_ID,A_ROOT_ICONPROPERTIES,A_ARP_MAC,A_COUNTRY,A_DATA_SOURCE,A_SG_IP_ADDRESS_ATOT,A_DATA_NOTE,A_CREDENTIALS_ID,A_IS_SAVE_PERSISTENCY,A_STATE,A_IP_ADDRESS_TYPE,A_ROOT_SYSTEM,A_IP_ADDRESS_PROPERTY,A_IP_ADDRESS_VALUE,A_DOCUMENT_LIST,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

at com.mercury.topaz.cmdb.shared.model.operation.update.impl.HistoryModelChangeListenerFineGrained.onFinishDeployment(HistoryModelChangeListenerFineGrained.java:316)
at com.mercury.topaz.cmdb.shared.notification.service.util.ChangesPublisher.publish(ChangesPublisher.java:34)
at com.mercury.topaz.cmdb.shared.model.operation.update.impl.AbstractExternalModelUpdate.auditChanges(AbstractExternalModelUpdate.java:279)
at com.mercury.topaz.cmdb.shared.model.operation.update.impl.AbstractExternalModelUpdate.modelUpdateExecute(AbstractExternalModelUpdate.java:254)
at com.mercury.topaz.cmdb.shared.model.operation.update.impl.bulk.AbstractModelUpdateBulks.bulkExecute(AbstractModelUpdateBulks.java:91)
at com.mercury.topaz.cmdb.shared.model.operation.update.impl.bulk.AbstractModelUpdateBulks.modelUpdateExecute(AbstractModelUpdateBulks.java:77)
at com.mercury.topaz.cmdb.shared.model.operation.update.impl.AbstractExternalModelUpdate.doExecute(AbstractExternalModelUpdate.java:154)
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:83)
... 66 more
Caused by: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalBatchException: [ErrorCode [-2147483648] undefined error code]
Can't execute BATCH prepared statement [INSERT INTO HDM_140910IP_ADDRESS_1 (ID, CMDB_ID, A_IP_ISBROADCAST,A_IPADDRESS_STATIC_ROUTE,A_IPADDRESS_ALIAS,A_CITY,A_IP_ISDHCP,A_CREATE_TIME,A_IP_PROBENAME,A_TENANTOWNER,A_IP_NETCLASS,A_IP_NETMASK,A_ROOT_CONTAINER,A_DATA_EXTERNALID,A_DATA_ORIGIN,A_IP_NETTYPE,A_DESCRIPTION,A_IP_ADDRESS,A_ACK_CLEARED_TIME,A_IP_ISMANAGED,A_LANGUAGE,A_DIGEST,A_IP_DHCPDOMAINNAME,A_CODEPAGE,A_TRACK_CHANGES,A_DISPLAY_LABEL,A_NAME,A_ISVIRTUAL,A_IP_LEASE_TIME,A_SG_IP_IS_DHCP,A_DATA_ALLOW_AUTO_DISCOVERY,A_AUTHORITATIVE_DNS_NAME,A_USER_LABEL,A_ROOT_ENABLEAGEING,A_SG_IP_ADDRESS_ATOD,A_CALCULATED_ID,A_GLOBAL_ID,A_IP_NETADDR,A_ROUTING_DOMAIN,A_ACK_ID,A_ROOT_ICONPROPERTIES,A_ARP_MAC,A_COUNTRY,A_DATA_SOURCE,A_SG_IP_ADDRESS_ATOT,A_DATA_NOTE,A_CREDENTIALS_ID,A_IS_SAVE_PERSISTENCY,A_STATE,A_IP_ADDRESS_TYPE,A_ROOT_SYSTEM,A_IP_ADDRESS_PROPERTY,A_IP_ADDRESS_VALUE,A_DOCUMENT_LIST,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

at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl.internalExecuteBatch(CmdbDalPreparedStatementImpl.java:355)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl.executeBatch(CmdbDalPreparedStatementImpl.java:319)
at com.hp.ucmdb.history.dal.command.modify.HistoryDalAddEventCommand.insertNewEntries(HistoryDalAddEventCommand.java:247)
at com.hp.ucmdb.history.dal.command.modify.HistoryDalAddEventCommand.perform(HistoryDalAddEventCommand.java:87)
at com.hp.ucmdb.history.dal.command.modify.HistoryDalAddEventCommand.perform(HistoryDalAddEventCommand.java:37)
at com.mercury.topaz.cmdb.server.manage.dal.DalAbstractCommand$FlowControlDalCommandExecutor.execute(DalAbstractCommand.java:36)
at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:222)
at com.mercury.topaz.cmdb.server.manage.dal.DalAbstractCommand.execute(DalAbstractCommand.java:54)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO$CmdbDalDeadlockRetriable.performAction(CmdbDalJdbcDAO.java:120)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO$CmdbDalDeadlockRetriable.performAction(CmdbDalJdbcDAO.java:105)
at com.mercury.topaz.cmdb.shared.util.retry.impl.DefaultRetriableExecutorImpl.doExecute(DefaultRetriableExecutorImpl.java:37)
at com.mercury.topaz.cmdb.shared.util.retry.impl.AbstractRetriableExecutor.execute(AbstractRetriableExecutor.java:37)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO.execute(CmdbDalJdbcDAO.java:81)
at com.mercury.topaz.cmdb.server.dal.dao.impl.CmdbDalJdbcDataModelDAO.executeBulk(CmdbDalJdbcDataModelDAO.java:387)
at com.mercury.topaz.cmdb.shared.model.operation.update.impl.HistoryModelChangeListenerFineGrained.onFinishDeployment(HistoryModelChangeListenerFineGrained.java:304)
... 74 more
Caused by: com.mercury.jdbc.oraclebase.ddc: [mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

at com.mercury.jdbc.oraclebase.dddg.executeBatch(Unknown Source)
at com.mercury.jdbc.oraclebase.dddk.executeBatch(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl$FlowControlBatchExecuter.execute(CmdbDalPreparedStatementImpl.java:525)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl$FlowControlBatchExecuter.execute(CmdbDalPreparedStatementImpl.java:517)
at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl.internalExecuteBatch(CmdbDalPreparedStatementImpl.java:329)
... 89 more

0 Likes
3 Replies
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: getting db errors in ucmdb 10.01 cup6 when trying to connect dataflowprobe

I know that support already working on the case. It would be nice if you can share with us the solution, when the problm will be solved.

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
0 Likes
Highlighted
Valued Contributor.. Valued Contributor..
Valued Contributor..

Re: getting db errors in ucmdb 10.01 cup6 when trying to connect dataflowprobe

Hello,

 

Do you have any solution regarding to this issue? 

 

Kind regards.

 

Taylan

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: getting db errors in ucmdb 10.01 cup6 when trying to connect dataflowprobe

how this is resolved ..im also facing the same

Cheers!

Nvr Blame a day in ur life....... Good day gives "happiness" & Bad day gives "experience" ......
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.