Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tOracleInput: ArrayIndexOutOfBoundsException

My job (DMI) is OK in Talend, but when I call it in Linux or Windows (java -jar ...), I have this error:
java.lang.ArrayIndexOutOfBoundsException: -1
       at oracle.jdbc.driver.T4CTTIoauthenticate.setSessionFields(T4CTTIoauthenticate.java:1019)
       at oracle.jdbc.driver.T4CTTIoauthenticate.<init>(T4CTTIoauthenticate.java:186)
       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:354)
       at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
       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:802)
       at java.sql.DriverManager.getConnection(Unknown Source)
       at java.sql.DriverManager.getConnection(Unknown Source)
       at dmi.dmi_1_2.DMI.tOracleInput_1Process(DMI.java:1996)
       at dmi.dmi_1_2.DMI.tOracleInput_2Process(DMI.java:5682)

DMI.java: 1996 :
conn_tOracleInput_1 = java.sql.DriverManager.getConnection(
url_tOracleInput_1, dbUser_tOracleInput_1,
dbPwd_tOracleInput_1);

Previous lines:
int nb_line_tOracleInput_1 = 0;
java.sql.Connection conn_tOracleInput_1 = null;
String driverClass_tOracleInput_1 = "oracle.jdbc.driver.OracleDriver";
java.lang.Class.forName(driverClass_tOracleInput_1);
String url_tOracleInput_1 = null;
url_tOracleInput_1 = "jdbc:oracle:thin:@" + "myserver" + ":"
+ "7777" + ":" + "mySID";
String dbUser_tOracleInput_1 = "mylogin";
final String decryptedPassword_tOracleInput_1 = routines.system.PasswordEncryptUtil
.decryptPassword("501385eghf5dd32bb02570r0ee181318");
String dbPwd_tOracleInput_1 = decryptedPassword_tOracleInput_1;

I think it's correct. The line 5682 is like the 1996.
Is it normal the "Unknown Source" in getConnection?
Edit: I use ojdbc14.jar and TOS 5.6.0.
Labels (4)
10 Replies
Anonymous
Not applicable
Author

The start scripts in the standalone jobs usually only use java without path. You can change this by set the full path to the JRE java in the scripts.