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

uCMD to SIM integration.

SOLVED
Go to Solution
Valued 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
Occasional Advisor

Re: uCMD to SIM integration.

Hi,

 

Please copy here Integration Adapter properties here.

Especially the JVM Class path value here. 

 

 

Valued 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"

Valued Contributor

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.

//Add this to "OnDomLoad" event