on 07-05-2011 10:28 AM
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
Hi
SSAPIDM01\MSSQLSRV_IM1
is not a valid hostname/FQDN.
So your IC-/Database-Settings are not correct.
BR
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.