Skip to Content
author's profile photo Former Member
0
Former Member

java.sql.SQLException: Io exception: Invalid number format for port number

Posted on Jul 06, 2007 at 03:16 PM 1.5k Views

Hi,

I am having problems while installing Solution Manager 4.0 SR2 on HP-UX 11.23 Itanium 2. The installation stops while Java Load. The DB is up and running.I can connect to it through SQL.The details of the jload.log file are as under:

05.07.07 14:57:03 com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

05.07.07 14:57:03 com.sap.inst.jload.Jload logStackTrace

SEVERE: java.sql.SQLException: Io exception: Invalid number format for port number

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)

at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)

at com.sap.inst.jload.Jload.main(Jload.java:580)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

I have checked the tnsnames.ora file and the entries are good and the PORT is set to 1521.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2007 at 02:58 PM
    0

    Hi Siddarth

    I'm getting same problem (invalid port). Could you pls pass me the solution of this problem?

    Regards

    Amar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2007 at 08:41 AM
    0

    Hello,

    I have some troubles while installating a portal as Add-in (same database as our BI 7).

    I have already installed the central service instance (SCS).

    However, when I try to install the Java stack, there is an error during the phase "Java dump importation".

    This error is :

    "java.sql.SQLException: Io exception: Invalid number format for port number

    Io exception: Invalid number format for port number".

    In fact, the tns port of my instance is 1531 instead of the standard port 1521 (/etc/tnsname.ora and /etc/listener.ora), but I don't know how to modify this port in the installation files (is it in the control.xml file ?).

    I wonder if the url for jdbc access is correct, but I don't how to check this ...

    I tried to change the port of the listener in 1521 and 1527, I restarted each time the listener and the installation, but I always obtain the same error ...

    So, I need help !

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 07:17 PM
    0

    Hello,

    Does anyone have a solution to this problem?

    I'm having the same issue with the installation of the java stack as part of an ERP 6.0 installation, on an HP-UX 11.23 Itanium system. The SCS instance installs fine, but when I run the install for the java database instance, I get the following error messages in the "Import java dump" step:

    07.01.08 11:19:37 com.sap.inst.jload.Jload main

    SEVERE: couldn't connect to DB

    07.01.08 11:19:37 com.sap.inst.jload.Jload logStackTrace

    SEVERE: java.sql.SQLException: Io exception: Invalid number format for port number

    I'm using 1527 for the listener port. Is this the problem?

    Thank you.

    Brad

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 08:57 AM
    0

    Hello,

    sap fixed my problem.

    In fact, there was an error in xml files used for the Java Add-in installation.

    During the phase "createSecureStore ", the port was indicated as undefined.

    So, I sent the files control.xml and keydb.xml to SAP in order to indicate a port number.

    I placed these files in my installation directory and continued with old installation and it worked !

    Regards

    Raphael Gauthereau

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.