I have run the tool and added needed information. When I stop and start the metric adapter, the following message appears in the logfile:
Jul 20, 2007 9:03:30 AM;1;10;com.hp.ov.sd.slm.util.SlmLogger;log;com.hp.ov.sd.slm.sa.common.SaException;SEVERE;An Exception with ID=OvisConnector002 LEVEL=CRITICAL occured in component com.hp.ov.sd.slm.sa.ovis.Connector in package: package com.hp.ov.sd.slm.sa.ovis java.sql.SQLException: [servername]Login failed for user 'ovis'. at com.inet.tds.a.a(Unknown Source) at com.inet.tds.a.a(Unknown Source) at com.inet.tds.a.(Unknown Source) at com.inet.tds.TdsDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.hp.ov.sd.slm.sa.ovis.Connector.onOpen(Connector.java:135) at com.hp.ov.sd.slm.sa.common.SuperVisor.openConnectors(SuperVisor.java:691) at com.hp.ov.sd.slm.sa.common.SuperVisor.configure(SuperVisor.java:675) at com.hp.ov.sd.slm.sa.common.SuperVisor.run(SuperVisor.java:1536) at com.hp.ov.sd.slm.sa.ovis.OvisMain.main(OvisMain.java:35)
I have tested the login via SQL Query Analyzer and it works fine.
OVIS db is running on a SQL 2005 DB and OVIS version is 6.2.
When I check which versions the adapters support, only 5.2 and 6.0 are included:
Service Desk Service Level Management Metric Adapters OpenView Performance Manager 5.0 for Windows OpenView Performance Manager 5.0 for HP-UX OpenView Internet Services 5.2, 6.0
Could this be the case?
My DB is on an instance on the SQL server, and I have tried the following connections strings: URL: jdbc:inetdae7:10.30.16.34:144 and jdbc:inetdae7:10.30.16.34/OVOPS:144
10.30.16.34 = db server OVOPS = instance on db
and I have also tried: DBNAME: ovis and ovops/ovis
Sorry, I meant to say that you need to point it at the SQL server not the OVIS server. The key lines in the ovisma.xml file are below. You may have issues with using the IP address so you may want to try the MS SQL server host name instead. Also, note that the DBName is hardcoded to Reporter so you'll need to change this for your DB name. I'm not sure from your description if the database is called OVOPS and the login is ovis?: 10 openview $OVIS_HOSTNAME$ com.hp.ov.sd.slm.sa.ovis.Connector jdbc:inetdae7:$OVIS_HOSTNAME$:$OVIS_PORT$ reporter com.inet.tds.TdsDriver