I am trying to upgrade a project that uses a native connection to an Oracle 7.3.4
database from ND 3.1.2 to ND 4.1.3. After performing the "automatic"
upgrade, I
found that the DBRMS service was frequently--but not consistently--crashing
whenever
any data objects (select objects or stored procedures) were executed.
I downloaded the "DSHangTest" utility from the Diagnostic Tools page on the ND website
(http://www.netdynamics.com/support/tools.html) in order to try to isolate the problem.
To simplify things as much as possible, I created a table TB_TEST with a single field
TX_ENTRY (of type VARCHAR2(80)), and populated it with some values.
I then modified the file DSHangTest.ini to be the following:
USERNAME_RDBMS_PROXY=Studio
PASSWORD_RDBMS_PROXY=12345678
DATABASE_TYPE=ORACLE
SERVER_NAME=myServer
DATABASE_NAME=
USER_NAME=uname
PASSWORD=pwd
SQL_STATEMENT=select * from tb_test
NO_OF_RECORDS_TO_FETCH=100
I then executed the DSHangTest utility at the command line as follows:
java -classpath %NETDYN_CLASSPATH% DSHangTest DSHangTest.ini
The output reflected the problems I was having with the project. Sometimes, the test
succeeds:
C:\temp>java -classpath %NETDYN_CLASSPATH%DSHangTest DSHangTest.ini
*******************************************
<--PROXY CREATED-->
DATABASE TYPE -> ORACLE
SERVER NAME -> myServer
DATABASE NAME ->
USER NAME -> uname
PASSWORD -> pwd
NUMBER OF RECORDS TO FETCH -> 100
SQL STATEMENT -> select * from tb_test
<--EXECUTED SQL - WAITING FOR THE RESULT-->
# of columns -> 1
# of records -> 39
<--COOL....SUCCESS!-->
<--GOODBYE. PROXY RELEASED-->
*******************************************
But more often it fails as follows:
C:\temp>java -classpath %NETDYN_CLASSPATH%DSHangTest DSHangTest.ini
*******************************************
<--PROXY CREATED-->
DATABASE TYPE -> ORACLE
SERVER NAME -> myServer
DATABASE NAME ->
USER NAME -> uname
PASSWORD -> pwd
NUMBER OF RECORDS TO FETCH -> 100
SQL STATEMENT -> select * from tb_test
<--EXECUTED SQL - WAITING FOR THE RESULT-->
Failed: org.omg.CORBA.UNKNOWN[completed=NO]
org.omg.CORBA.UNKNOWN[completed=NO]
at com.visigenic.vbroker.orb.SE.read(SE.java:28)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(GiopStubDelegate.java:569)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(GiopStubDelegate.java:477)
at org.omg.CORBA.portable.ObjectImpl._invoke(ObjectImpl.java:154)
at netdyn.services.dsrdbms.stubs._st_INdDSRdbms.executeSQL(Compiled Code)
at netdyn.services.dsrdbms.client.CNdDSRdbmsProxy.executeSQL(Compiled Code)
at DSHangTest.main(DSHangTest.java:117)
Has anyone else encountered this sort of problem? I tried some patches recommended by
ND technical support, but none had any effect on this behavior.
I would greatly appreciate any advice, suggestions, or karma.
Thanks,
Daniel Tunkelang ([EMAIL PROTECTED])
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
