It's all about the answers!

Ask a question

RAFW 7.1.1.4 oracle database connection error


rajesh ch (3121) | asked Jul 08 '10, 4:20 a.m.
Hi, I am facing issue when I tried to test the connection from RAFW server to oracle database using Installation Manager .
In the database connection step I am getting Unexpected Failure Array Index out of range:110 error.
It looks like something is wrong with oracle client or the buildforget oracle connection code . Please help!!!!!!!!.

Thanks,
Raj

6 answers



permanent link
Brent Ulbricht (2.5k11) | answered Jul 08 '10, 9:13 p.m.
JAZZ DEVELOPER
Hi, I am facing issue when I tried to test the connection from RAFW server to oracle database using Installation Manager .
In the database connection step I am getting Unexpected Failure Array Index out of range:110 error.
It looks like something is wrong with oracle client or the buildforget oracle connection code . Please help!!!!!!!!.

Thanks,
Raj


Hi Raj,

A little more information may help. Which platform are you working with (operating system/architecture)? Are you using the 10.2 Oracle Instant Client Package - Basic (32 bit version)? Is there any chance that you could copy/paste the error.

bju

permanent link
rajesh ch (3121) | answered Jul 09 '10, 2:48 p.m.
# ./launcher
WITHING Platform Specifier
JOB::InstallJob in buildforge.console; com.ibm.buildforge.console 7.1.140.0139 features: com.ibm.buildforge.console.webroot,com.ibm.buildforge.console.engine,com.ibm.buildforge.console.slayer,com.ibm.buildforge.console.install.configure
WITHING Platform Specifier
WITHING Platform Specifier
WITHING Platform set
WITHING Platform:Linux
WITHING JAVA HOME set
JAVA HOME:/web/Rational/InstallationManager/eclipse/jre_5.0.3.sr8a_20080811b/jre/bin/java
java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 110
at oracle.net.nl.NVTokens.parseTokens(Unknown Source)
at oracle.net.nl.NVFactory.createNVPair(Unknown Source)
at oracle.net.nl.NLParamParser.addNLPListElement(Unknown Source)
at oracle.net.nl.NLParamParser.initializeNlpa(Unknown Source)
at oracle.net.nl.NLParamParser.<init>(Unknown Source)
at oracle.net.resolver.TNSNamesNamingAdapter.loadFile(Unknown Source)
at oracle.net.resolver.TNSNamesNamingAdapter.checkAndReload(Unknown Source)
at oracle.net.resolver.TNSNamesNamingAdapter.resolve(Unknown Source)
at oracle.net.resolver.NameResolver.resolveName(Unknown Source)
at oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)
at oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
at oracle.net.ns.NSProtocol.connect(Unknown Source)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:858)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
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.ibm.buildforge.console.install.pages.OracleInterface.openConnection(OracleInterface.java:64)
at com.ibm.buildforge.console.install.pages.OracleInterface.jdbcTest(OracleInterface.java:175)
at com.ibm.buildforge.console.install.pages.OracleInterface.test(OracleInterface.java:76)
at com.ibm.buildforge.console.install.pages.DatabaseDisplay$22.widgetSelected(DatabaseDisplay.java:1082)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3552)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3171)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2629)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2593)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2427)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:670)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:663)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at com.ibm.cic.agent.internal.ui.AgentUIApplication.launch(AgentUIApplication.java:290)
at com.ibm.cic.agent.internal.ui.AgentUIApplication.start(AgentUIApplication.java:57)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
at org.eclipse.equinox.launcher.Main.main(Main.java:1383)


Here is the error

permanent link
rajesh ch (3121) | answered Jul 09 '10, 2:50 p.m.
its Linux/64bit,yes i have oracle instant client(10.2) package installed along with complete oracle client( for refering tnsnames only)

permanent link
Brent Ulbricht (2.5k11) | answered Jul 09 '10, 3:27 p.m.
JAZZ DEVELOPER
its Linux/64bit,yes i have oracle instant client(10.2) package installed along with complete oracle client( for refering tnsnames only)


Hi Raj,

From looking at the stack trace, I think the oracle jdbc driver does not like something in the formatting of your tnsnames.ora file. This is an example of one that I have used. The spacing of the statements seems to be very important to the oracle jdbc driver. Hopefully, this forum software will preserve that spacing for my example.



TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host.my.company.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)


bju

permanent link
rajesh ch (3121) | answered Jul 09 '10, 7:09 p.m.
wpqa2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xyzdb.brocade.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wpqa2)
)
)

here is the tns entry

permanent link
Brent Ulbricht (2.5k11) | answered Jul 09 '10, 10:18 p.m.
JAZZ DEVELOPER
Can you try with the lines indented like the one below:

wpqa2 =

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xyzdb.brocade.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wpqa2)
)
)

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.