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: < Traceback (most recent call last): File "SIM_Discovery", line 1062, in getNodeNamesFromDB IllegalArgumentException: java.lang.IllegalArgumentException: Attribute simprotocol_dbname has no value ></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?
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.