This discussion is archived
4 Replies Latest reply: Oct 4, 2012 1:53 PM by Sergiusz Wolicki (Oracle) RSS

DMU conncetion closed when click on Convert button

950728 Newbie
Currently Being Moderated
I am recieving the below error when I click on the convert button,.

03.11:38:56:051;C001;C;00000 Connected successfully to florad5 jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usmtnctdebsdb02.dev.emrsn.org)(PORT=34101))(CONNECT_DATA=(UR=A)(SERVICE_NAME=florad5))).
03.11:38:56:056;C001;C;05006 Connection ID is 9998, session ID is 816, serial number is 689.
03.11:38:56:057;C002;C;05007 About to close connection to jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usmtnctdebsdb02.dev.emrsn.org)(PORT=34101))(CONNECT_DATA=(UR=A)(SERVICE_NAME=florad5))).
03.11:38:56:060;C002;C;05006 Connection ID is 9997, session ID is 709, serial number is 59.
03.11:38:56:063;C002;C;00001 Disconnected successfully from jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usmtnctdebsdb02.dev.emrsn.org)(PORT=34101))(CONNECT_DATA=(UR=A)(SERVICE_NAME=florad5))).
03.11:38:56:065;BCCL;F;05000 SQL text is select c.intcol#, co.intcol#, co.name, co.type#, decode(co.type#, 58, nvl2(ct.synobj#, (select o.name from obj$ o where o.obj#=ct.synobj#), ot.name), 111, nvl2(ct.synobj#, (select o.name from obj$ o where o.obj#=ct.synobj#), ot.name), 121, nvl2(ct.synobj#, (select o.name from obj$ o where o.obj#=ct.synobj#), ot.name), 122, nvl2(ct.synobj#, (select o.name from obj$ o where o.obj#=ct.synobj#), ot.name), 123, nvl2(ct.synobj#, (select o.name from obj$ o where o.obj#=ct.synobj#), ot.name),null) typeName, co.property, rawtohex(ct.toid) toid, co.spare3 length, co.null$, cn.type# conType, decode(bitand(co.property, 1), 0, co.name, (select decode(c1.type#, 58, decode(ct1.toid, '00000000000000000000000000020100', c1.name||'.', ''), '') ||tc.name from sys.attrcol$ tc, sys.col$ c1, sys.coltype$ ct1 where co.obj# = tc.obj# and co.intcol# = tc.intcol# and c1.obj#=co.obj# and c1.intcol#=co.col# and c1.obj#=ct1.obj#(+) and c1.intcol#=ct1.intcol#(+))) QUALIFIED_COL_NAME from system.dum$columns c, sys.col$ co, sys.coltype$ ct, sys.obj$ ot, (select cc.obj# obj#, cc.intcol# intcol#, cc.con# con#, cd.type# type# from sys.ccol$ cc, sys.cdef$ cd where cc.con#=cd.con# and cd.type#=2) cn where c.obj#=co.obj# and c.obj#=ct.obj#(+) and c.intcol#=co.intcol# and c.intcol#=ct.intcol#(+) and ct.toid = ot.oid$(+) and ot.type#(+) = 13 and c.obj# = cn.obj#(+) and c.intcol#=cn.intcol#(+) and c.obj#=43469 order by co.intcol# ;
03.11:38:56:066;BCCL;F;05001 Exception call stack is
java.sql.SQLRecoverableException: IO Error at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:897)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at oracle.duma.data.util.SQLUtil.executeQuery(Unknown Source)
at oracle.duma.data.util.SQLUtil.executeReturnArrayList(Unknown Source)
at oracle.duma.data.util.SQLUtil.executeReturnArrayList(Unknown Source)
at oracle.duma.data.common.Database.getColumnsByTable(Unknown Source)
at oracle.duma.data.common.Table.getOwnedObjects(Unknown Source)
at oracle.duma.gui.common.properties.TableProperties.loadChildren(Unknown Source)
at oracle.duma.gui.cleansing.bulk.BulkCleansingLoader$BulkCleansingColumnsLoader.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points