Troubleshooting
Problem
Beginning with Maximo 7.1.1.6, when opening command line interface, navigating to C:\IBM\SMP\maximo\applications\maximo\ and typing version.bat, gets error from version.bat,
Symptom
Example output from version.bat error appears as follows:
Maximo 7.1 (Oracle)
C:\IBM\SMP\maximo\applications\maximo>version.bat > version.txt
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(DriverManager.java:572)
at java.sql.DriverManager.getConnection(DriverManager.java:196)
at psdi.util.DBConnect.getConnection(DBConnect.java:97)
at psdi.util.DBConnect.getConnection(DBConnect.java:61)
at psdi.util.Version.getConnection(Version.java:255)
at psdi.util.Version.getString(Version.java:160)
at psdi.util.Version.main(Version.java:581)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:361)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 11 more
Common PMP 7.1.1.7 Build 201006041645 DB Build V7117-02
C:\IBM\SMP\maximo\applications\maximo>
Maximo 7.5 (DB2)
C:\IBM\SMP\maximo\applications\maximo>version.bat
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.11.69] Exception java.net.ConnectException: Error opening socket to server maxdev.mymaximo.com/192.32.221.6 on port 50,005 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001
at com.ibm.db2.jcc.am.gd.a(gd.java:319)
at com.ibm.db2.jcc.am.gd.a(gd.java:337)
at com.ibm.db2.jcc.t4.wb.a(wb.java:408)
at com.ibm.db2.jcc.t4.wb.<init>(wb.java:80)
at com.ibm.db2.jcc.t4.a.y(a.java:320)
at com.ibm.db2.jcc.t4.b.a(b.java:1808)
at com.ibm.db2.jcc.am.lb.a(lb.java:603)
at com.ibm.db2.jcc.am.lb.<init>(lb.java:555)
at com.ibm.db2.jcc.t4.b.<init>(b.java:305)
at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:460)
at java.sql.DriverManager.getConnection(DriverManager.java:379)
at java.sql.DriverManager.getConnection(DriverManager.java:354)
at psdi.util.DBConnect.getConnection(DBConnect.java:96)
at psdi.util.DBConnect.getConnection(DBConnect.java:62)
at psdi.util.Version.getConnection(Version.java:284)
at psdi.util.Version.getString(Version.java:175)
at psdi.util.Version.main(Version.java:628)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:381)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:243)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:230)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:377)
at java.net.Socket.connect(Socket.java:539)
at com.ibm.db2.jcc.t4.x.run(x.java:34)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.db2.jcc.t4.wb.a(wb.java:394)
... 15 more
Tivoli's process automation engine 7.5.0.9 Build 20151009-1735 DB Build V7509-25,
IBM Maximo Asset Management 7.5.0.9 Build 201510092235 DB Build V7509-00,
IBM TPAE Integration Framework 7.5.1.4 Build 20150920-1700 DB Build V7514-04
C:\ibm\SMP\maximo\applications\maximo>
Maximo 7.6 (SQL Server)
C:\IBM\SMP\maximo\applications\maximo>version.bat
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "MAXIMO" requested by the login. The login failed. ClientConnectionId:9f71c664-b3b9-4065-ad48-a8441baa3c72
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at java.sql.DriverManager.getConnection(DriverManager.java:590)
at java.sql.DriverManager.getConnection(DriverManager.java:232)
at psdi.util.DBConnect.getConnection(DBConnect.java:100)
at psdi.util.DBConnect.getConnection(DBConnect.java:64)
at psdi.util.Version.getConnection(Version.java:340)
at psdi.util.Version.getString(Version.java:213)
at psdi.util.Version.main(Version.java:692)
Tivoli's process automation engine 7.6.0.2 Build 20150903-2113 DB Build V7602-31,
IBM TPAE Integration Framework 7.6.0.2 Build 20150901-2100 DB Build V7602-05,
IBM Maximo Asset Management 7.6.0.2 Build 20150903-2113 DB Build V7601-01
C:\ibm\SMP\maximo\applications\maximo>
Cause
Occurs in Maximo 7.1.1.6 or later. When running version.bat , Maximo attempts to connect to the database. It does so to double-check installed product and version information. The error will be generated if:
- the connection parameters in maximo.properties are incorrect,
- the connection parameters in maximo.properties are missing,
- the Maximo database is not running, or
- the Maximo database is not accessible.
Resolving The Problem
To check whether the connection parameter is correct, go to maximo.properties (by default, in C:\IBM\SMP\maximo\applications\maximo\properties)
If the parameters mxe.encrypted=true exists, mxe.db.password is missing, and there is a string of unreadable characters at the bottom, close the file.
Rename maximo.properties to maximo.properties_orig (or some other name of your choice).
Copy the unencrypted version of the file from c:\ibm\smp\etc to C:\IBM\SMP\maximo\applications\maximo\properties.
Open the file, and modify it as follows:
- Delete all lines with the parameter mxe.encrypted=true (there may be more than one)
- Make sure that mxe.db.user=maximo (or, if the schemaowner is not maximo, change it to the schemaowner)
- Make sure that the parameter mxe.db.password=<password> is correct.
- Make sure that the parameter mxe.db.driver=<driver_name> exists and is correct.
- Save the file.
If the connection parameters are already correct, then check that the administrative workstation is able to connect to the Maximo database by means of a SQL editor. If not, the database or database server may be shut down or unavailable due to network problems or firewall settings.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21418311