Troubleshooting
Problem
JGATE running on USS gets "Undefined Error" when connecting to Oracle.
Symptom
The following will be seen from the JGATE Console:
"Undefined Error" is returned when trying to make connection to Oracle.
The following will be seen in the Debug.log file:
Apr 23, 2020 12:08:07 PM [log.drda_service thread:DRDAConnThread_2 com.ibm.rsbi.drda.sql.QJConnectionFactory.createDatasourceConnection]
com.ibm.rsbi.common.dbio.ProviderException:DAL01013. Cannot create connection to server 'MAJESIMP' due to the following: IO Error: Undefined Error
at com.ibm.rsbi.common.dbio.ProviderException.create(ProviderException.java:628)
at com.ibm.rsbi.common.dbio.ConnectionFactory.createJDBCConnection(ConnectionFactory.java:99)
at com.ibm.rsbi.common.dbio.ConnectionFactory.createConnection(ConnectionFactory.java:58)
at com.ibm.rsbi.common.dbio.PasswordManager.createConnection(PasswordManager.java:39)
at com.ibm.rsbi.common.dbio.connection_pool.SubPool.createNewConnectionImpl(SubPool.java:485)
at com.ibm.rsbi.common.dbio.connection_pool.SubPool.getPooledConnection(SubPool.java:375)
at com.ibm.rsbi.common.dbio.connection_pool.ConnectionPool.createConnection(ConnectionPool.java:167)
at com.ibm.rsbi.common.dbio.ServersFactory.createConnection(ServersFactory.java:94)
at com.ibm.rsbi.common.dbio.Server.getConnection(Server.java:364)
at com.ibm.rsbi.common.dbio.ConnectionHandle.<init>(ConnectionHandle.java:102)
at com.ibm.rsbi.common.dbio.Server.openConnection(Server.java:325)
at com.ibm.rsbi.drda.sql.QJConnectionFactory.createDatasourceConnection(QJConnectionFactory.java:86)
at com.ibm.rsbi.drda.sql.QJConnectionFactory.create(QJConnectionFactory.java:37)
at com.ibm.rsbi.drda.sql.QJDriver.connect(QJDriver.java:59)
at com.ibm.rsbi.drda.core.impl.drda.Database.makeConnection(Database.java:254)
at com.ibm.rsbi.drda.core.impl.drda.DRDAConnThread.getConnFromDatabaseName(DRDAConnThread.java:1664)
at com.ibm.rsbi.drda.core.impl.drda.DRDAConnThread.verifyUserIdPassword(DRDAConnThread.java:1604)
at com.ibm.rsbi.drda.core.impl.drda.DRDAConnThread.parseSECCHK(DRDAConnThread.java:3573)
at com.ibm.rsbi.drda.core.impl.drda.DRDAConnThread.parseDRDAConnection(DRDAConnThread.java:1376)
at com.ibm.rsbi.drda.core.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:1087)
at com.ibm.rsbi.drda.core.impl.drda.DRDAConnThread.run(DRDAConnThread.java:359)
Resolving The Problem
Refer to the IBM Data Virtualization Manager installation guide for installing JDBC Gateway in USS. The most common issue with this exception is the following step:
Add the following to the startServer.sh script:
Add the following to the startServer.sh script:
export IBM_JAVA_OPTIONS="-Dfile.encoding=ISO8859-1"
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"Component":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
11 November 2020
UID
ibm15694837