cancel
Showing results for 
Search instead for 
Did you mean: 

Error Testing Dispatcher Scripts (IdM 7.1 SP5 on MSSQL 2008)

Former Member
0 Kudos

Hi,

i get the following errors when testing my created dispatcher scripts.

Running MxDispatcher_ssapidm01.
[05.07.2011 11:15:59-975] - Initialized log for com.sap.idm.ic.services.api.MXMC
Api. Log level is Debug
MxDispatcher version: 7.10.5.2 Built: 07.06.2011 16:20:24 (c) Copyright 2008 SAP
 AG. All rights reserved.
Java VM: Sun Microsystems Inc.   Version: 1.5.0_22
Java home: C:\Program Files (x86)\Java\jre1.5.0_22
Java lib/ext: C:\Program Files (x86)\Java\jre1.5.0_22\lib\ext
CLASSPATH: C:\Program Files (x86)\sap\idm\identity center\Java\mxdispatcher.jar;
C:\Program Files (x86)\sap\idm\identity center\Java\mxmcapi.jar;C:\Program Files
\MS SQL Server 2008 JDBC driver\sqljdbc_1.2\enu\sqljdbc.jar;C:\Program Files\MS
SQL Server 2008 JDBC driver\sqljdbc_1.2\enu\sqljdbc.jar
[05.07.2011 11:15:59-992] - MxDispatcher:Reading prop files
[05.07.2011 11:15:59-992] - MxDispatcher:Loading driver: com.microsoft.sqlserver
.jdbc.SQLServerDriver
[05.07.2011 11:16:00-063] - MxDispatcher:Creating connection to : jdbc:sqlserver
://SSAPIDM01\MSSQLSRV_IM1:1433;databasename=mxmc_db;user=mxmc_rt;password=***********
[05.07.2011 11:16:01-099] - Can not create connection:'jdbc:sqlserver://SSAPIDM0
1\MSSQLSRV_IM1:1433;databasename=mxmc_db;user=mxmc_rt;password=***********
[05.07.2011 11:16:01-099] - MxDispatcher:Can not create connection:'jdbc:sqlserv
er://SSAPIDM01\MSSQLSRV_IM1:1433;databasename=mxmc_db;user=mxmc_rt;password=***********'. Exception:Es konnte keine TCP/IP-Verbindung mit dem Host  hergestellt
werden. java.net.ConnectException: Connection refused: connect
[05.07.2011 11:16:01-099] - MxDispatcher:Unavailable connection to : jdbc:sqlser
ver://SSAPIDM01\MSSQLSRV_IM1:1433;databasename=mxmc_db;user=mxmc_rt;password=***********
[05.07.2011 11:16:01-104] - MxDispatcher:Sleeping 30 seconds
[05.07.2011 11:16:32-106] - Can not create connection:'jdbc:sqlserver://SSAPIDM0
1\MSSQLSRV_IM1:1433;databasename=mxmc_db;user=mxmc_rt;password=***********
[05.07.2011 11:16:32-107] - MxDispatcher:Can not create connection:'jdbc:sqlserv
er://SSAPIDM01\MSSQLSRV_IM1:1433;databasename=mxmc_db;user=mxmc_rt;password=***********'. Exception:Es konnte keine TCP/IP-Verbindung mit dem Host  hergestellt
werden. java.net.ConnectException: Connection refused: connect
[05.07.2011 11:16:32-110] - MxDispatcher:First attempt to start dispatcher faile
d: Es konnte keine TCP/IP-Verbindung mit dem Host  hergestellt werden. java.net.
ConnectException: Connection refused: connect
C:\Program Files (x86)\Java\jre1.5.0_22\bin>

I think this is a simple connection error, but I dont get it.

All components are installed on the same host.

My options look like this:

Path to java.exe:

C:\Program Files (x86)\Java\jre1.5.0_22\bin\java.exe

Path to jvm.dll:

C:\Program Files (x86)\Java\jre1.5.0_22\bin\client\jvm.dll

JDBC driver jar:

C:\Program Files\MS SQL Server 2008 JDBC driver\sqljdbc_1.2\enu\sqljdbc.jar

JDBC driver names:

com.microsoft.jdbc.sqlserver.SQLServerDriver;com.microsoft.sqlserver.jdbc.SQLServerDriver;com.sap.dbtech.jdbc.DriverSapDB;org.gjt.mm.mysql.Driver;sun.jdbc.odbc.JdbcOdbcDriver;oracle.jdbc.driver.OracleDriver;COM.ibm.db2.jdbc.app.DB2Driver;COM.ibm.db2.jcc.DB2Driver;COM.ibm.db2.jdbc.net.DB2Driver

Classpath extension:

C:\Program Files\MS SQL Server 2008 JDBC driver\sqljdbc_1.2\enu\sqljdbc.jar;

If you need any other input, let me know.

Thanks for your help!!

Edited by: SAP-3r1k on Jul 5, 2011 11:29 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

SSAPIDM01\MSSQLSRV_IM1

is not a valid hostname/FQDN.

So your IC-/Database-Settings are not correct.

BR

Michael

Former Member
0 Kudos

Hi Michael,

why is this not a valid hostname?

The Identity Center Database Connection Wizard says that the connection is successful.

The hostname of the server is: SSAPIDM01

The name of the MSSQL Server which is installed on SSAPIDM01 is MSSQLSRV_IM1

This should result in SSAPIDM01\MSSQLSRV_IM1, or am i wrong?

Greets

Former Member
0 Kudos

I think it will work if you simply enter the hostname; then IdM will connect to the default DB-instance.

I'm not sure if IdM JDBC can connect to a named DB-instance.

Former Member
0 Kudos

After some research:

Maybe you have to escape the backslash, so it'll look like (double-backslash):

jdbc:bea:sqlserver://server1\\instance1;User=test;Pasword=secret

Former Member
0 Kudos

I tried to specify

SSAPIDM01\\MSSQLSRV_IM1

as host, but the Connection Wizard doesn't accept this.

Maybe I should try to edit hard the scripts. But where is the Connection String saved?

edit

Tried with

SSAPIDM01\\MSSQLSRV_IM1

but results in the same error.

Edited by: SAP-3r1k on Jul 5, 2011 1:49 PM

Edited by: SAP-3r1k on Jul 5, 2011 3:02 PM

Former Member
0 Kudos

The last post in this [Thread|; got the solution.

I had to leave out the port-number in the connection string.

Thanks for your effort Michael.

Edited by: SAP-3r1k on Jul 5, 2011 6:18 PM

Answers (0)