Funny thing is I don't know why it's using port 50000 - that is a port usually used by a DB2 repository and we do not have any DB2 on our system. The Information Server repository is Oracle and it is on the default 1521 port. Anyone know why Information Analyzer running with an Oracle repository would be trying to access port 50000?AuthoringServiceBridge.java:257 executeBaseProfile: Exception in process: An error occurred while accessing the ScratchSpace [IBM][Oracle JDBC Driver]Error establishing socket to host and port: ######.###.###.###.##:50000. Reason: Connection refused
Connection refused to port 50000
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Connection refused to port 50000
Trying to run an Information Analyzer column analysis for the first time and getting the following message in the log after it fails (I masked the domain name for security reasons):
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That is indeed a curious error message, particularly since it is being emitted by the IBM Oracle JDBC driver. Perhaps this uses port #50000 internally (but only IBM could verify this for sure). I assume that your firewall does not pass this port number.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Found the config page. There is a tab under "Analysis Settings" called "Analysis Database" and the install had left the port number as 50000. I switched the port and validated the client setting and it worked. Also noticed on this page that the IADB DSN is missing! It should have been set up by the install. Does anyone know what the .odbc.ini section should look like for IADB against an Oracle repository?
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn