Product: Aqua Data Studio
Version: 18.0.0-preview-20
Build #: 52769
Build Date: 2017-Jan-22 11:23:38 PM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_101-b13
Memory: Max=704,643,072; Total=423,100,416; Free=176,464,856; CPUs=8
Database DB2 LUW 11.1/10.5
Steps to reproduce:-
1.Launch ADS.
2.Connect to database DB2 LUW 11.1/10.5
3.Open View Log and SQL Log.
4.Expand tree node of DB2 LUW 11.1/10.5.
5.Expand Management>Expand Current Activity>Expand Connection Info
6.Right click on any connection info>Script object to window as>Drop
Actual Result:-Script to drop connection info is not generated and an exception is observed in View Log.
Expected Result:-Script to drop connection info should be generated in QA and any exception should not be observed in View Log.
Please refer the attachment:-'DropConnectionInfoException.png'
Reference:-http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0023574.html
Observation:-
-If we execute below script (generated in SQL Log ) in QA then error occurs
SELECT
APPLICATION_HANDLE AS AGENT_ID,
CLIENT_IPADDR||' '||CLIENT_PORT_NUMBER AS INBOUND_COMM_ADDRESS,
SESSION_AUTH_ID AS AUTH_ID,
current server AS DB_NAME,
APPLICATION_NAME AS APPL_NAME,
CLIENT_PROTOCOL,
CLIENT_PLATFORM,
CLIENT_HOSTNAME AS CLIENT_NNAME,
CONNECTION_START_TIME AS APPL_CON_TIME,
APPLICATION_ID AS APPL_ID,
EXECUTION_ID,
-1 AS APPL_STATUS
FROM
TABLE(MON_GET_CONNECTION(cast(NULL as bigint), -2)) AND
APPLICATION_HANDLE = 12196
ORDER BY
APPLICATION_HANDLE
-If we execute below script(generated in preview tab of Kill Session window opened through session manager) in QA then query is executed successfully.Connection info is dropped.
CALL SYSPROC.ADMIN_CMD('FORCE APPLICATION (12196)')
|
Windows |
|
|
Latest Build (ADS v18-preview 20) |
Issue is observed |
|
ADS v17 |
Issue is observed |
|
ADS v16 |
Issue is observed |
|
ADS v15 |
Issue is observed |
|
ADS v14 |
Unable to test.On expanding connection info->"No authorized routine named "SNAPSHOT_APPL" of type "FUNCTION" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884, DRIVER=3.61.75" |
Stack Trace
java.sql.SQLException: I/O Error: Connection reset
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1099)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:465)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
at \\.\\.\\हिñçêČάй語简�?한\\.gꐑꆁꍭͷnew1.executeQuery(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Cꂥᛄꍬꅵvolatilenative.k(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Cꂥᛄꍬꅵvolatilenative.j(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.lꈜꐥꎕᡒbreaknew.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Sꅏꑓꌽᢖsynchronizedpublic.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.u⠠ꍰꀃ⡳6.a(Unknown Source)
at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:866)
at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:650)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:381)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at java.io.DataInputStream.readFully(Unknown Source)
at java.io.DataInputStream.readFully(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:851)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:732)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:473)
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:110)
at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:89)
at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:4164)
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1092)
... 50 more
@tom: pls have any code changes reviewed by @ivan prior to check-in