UCMDB and UD Practitioners Forum (Previously CMS)
cancel

uCMD to SIM integration.

SOLVED
Go to solution
Highlighted
Vasily_Martynov
Super Contributor.

uCMD to SIM integration.

Hello collegues!

Got an issue with uCMDB 10.11 integration to SIM. (CP 14 installed)

Got a SIM running on oracle DB. As far as described in manuals I've created an integration point and in credentials left "SIM database name" blank.

As a result i get an error in integration:
<log start="15:00:16" severity="warn">[SIM_Discovery.py:makeOutputXML] Exception: &lt;
Traceback (most recent call last):
File "SIM_Discovery", line 1062, in getNodeNamesFromDB
IllegalArgumentException: java.lang.IllegalArgumentException: Attribute simprotocol_dbname has no value
&gt;</log>

And that goes for SIM_discovery.py script line:

...

dbName = protocol.getProtocolAttribute('simprotocol_dbname') or ''

...

 

As i see, it is directly connected and somehow oracle connection is processed unvalid way.

Anyone got an idea how it should work or how to fix it?

 

Regards!

3 REPLIES
Mohamed_87
Trusted Contributor.

Re: uCMD to SIM integration.

Hi,

 

Please copy here Integration Adapter properties here.

Especially the JVM Class path value here. 

 

 

Vasily_Martynov
Super Contributor.

Re: uCMD to SIM integration.

Hello! Here are the options from integration point.
Checked that all the values are the same as in the adapter options.


Is Integration Activated:
Check

JVM path:
%minimal_classpath%;../content/lib/nnm/ucmdb_wrapper.jar;../runtime/probeManager/discoveryResources/hpsim/mxpartnerlib.jar;../runtime/probeManager/discoveryResources/IntegrationAPI.jar;../runtime/probeManager/discoveryResources/db/mssqlserver/jtds-1.2.6.jar;../runtime/probeManager/discoveryResources/db/oracle/Seropto.jar

CITIDentifier Map:
'Server':'host_node', 'Workstation':'host_node', 'Rack':'rack', 'Printer':'netprinter', 'Switch':'switch', 'WINNT':'nt', 'LINUX':'unix', 'HPUX':'unix', 'AIX':'unix', 'Hypervisor':'unix', 'Solaris':'unix', 'Complex':'hp_complex', 'MgmtProc':'management_processor', 'Embedded':'management_processor', 'Enclosure':'enclosure', 'Storage':'storagearray'

CITIDentifier Attribute:
'DeviceType', 'OSName'

dbIP: %IPv4%
Debug: false
ChunkSize: 500
runInSeparateProcess: true
DFP: the one that has access
Trigger CI Instance: "same CI that is the dbIP"

Vasily_Martynov
Super Contributor.
Solution

Re: uCMD to SIM integration.

As a result of trouble shooting there several issues:

  • First of all remoteJVMClasspath states incorrect java lib ./runtime/probeManager/discoveryResources/db/oracle/Seropto.jar while DFP contains only ojdbc6.jar.
  • SIM_discovery script works with Oracle DB incorrectly. SQL Query  built within script flow is “select name from hpsim.dbo.devices;” and correct is “select name from devices;” The query is built for MS SQL instead of Oracle BD.
  • Also i had some issues with memory attribute of some nodes in SIM

 

Also HP support recomended this (as usual i guess):

Copy mxpartnerlib.jar from this directory:
                  C:\hp\UCMDB\DataFlowProbe\runtime\probeManager\discoveryResources\hpsim
         to this directory:
                  C:\hp\UCMDB\DataFlowProbe\content\lib
    b Open C:\hp\UCMDB\DataFlowProbe\bin\WrapperEnv.conf for editing.
    c Comment out line ~51 with a hash sign (#) at the beginning so that it looks as follows:
    d Save and close the file.
    e Restart the Probe

Here I attach the edited script. If you want to use it - do it on your own risk.