Product: Aqua Data Studio
Version: 18.0.0-preview-43
Build #: 52875
Build Date: 2017-Jan-31 08:49:54 PM
Steps to Reproduce:
1. Connect MSSQLSERVER db.
2. Right click on Server and select server properties option ,Under Advanced tab add Debugger informations[Domain,Username and Password] then click on SAVE button.
3. Expand Databases node and select master database.
4. Open QA window and execute below script
CREATE PROCEDURE [dbo].[PROC_HELLO_WORLD3] @MYARG int = 3 output
AS
SELECT @MYARG = 6
print 'Hello World!'
GO
5. Procedure created successfully, Now right click on created procedure and select 'Debug in Procedure debugging' option
6. Click on Start icon under Procedure window. Execute dialog box opened successfully now click on Execute button.
Actual Result: Under Message pane and view logs error message is displayed.
Observation : These behaviour is observed in Ubuntu Environment [Version -16.04 and Version 15.04] .
Environment |
Linux Version |
Result |
Ubuntu 16.04 |
Linux (4.4.0-59-generic, amd64) |
Issue Re-producible |
Ubuntu 15.04 |
Linux (3.19.0-79-generic, amd64) |
Issue Re-producible |
Ubuntu 14.04 |
Linux (3.13.0-100-generic, amd64) |
Issue not Re-producible |
Centos 6.7 |
Linux (2.6.32-642.3.1.el6.x86_64, amd64) |
Issue not Re-producible |
Windows |
|
Issue not Re-producible |
Mac OSx |
|
Issue not Re-producible |
Builds |
Result |
ADS -18.0.0-preview-43 |
Issue Re-producible |
ADS V17 |
Issue Re-producible |
ADS V16 |
Issue Re-producible |
ADS V15 |
Issue Re-producible |
org.jinterop.dcom.common.JIException: The RPC server is unavailable. Please check if the COM server is up and running and that route to the COM Server is accessible (A simple "Ping" to the Server machine would do). Also please confirm if the Windows Firewall is not blocking DCOM access. [0x800706BA]
at org.jinterop.dcom.core.JIComServer.call(JIComServer.java:994)
at org.jinterop.dcom.core.JIComServer.call(JIComServer.java:945)
at org.jinterop.dcom.core.JIComObjectImpl.call(JIComObjectImpl.java:271)
at org.jinterop.dcom.core.JIComObjectImpl.call(JIComObjectImpl.java:156)
at com.aquafold.debugger.mssql.impl.tꆫᢑꆎꄯpackage.a(Unknown Source)
at com.aquafold.debugger.mssql.impl.bꂄᛗͬꌱ.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Mꎍᛥ᛭ꀊabstractsynchronized.gL(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Iꀩꁆꉖbreakdefault.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Mꎍᛥ᛭ꀊabstractsynchronized.run(Unknown Source)
Caused by: rpc.FaultException: Received fault. (unknown)
at rpc.ConnectionOrientedEndpoint.call(ConnectionOrientedEndpoint.java:141)
at rpc.Stub.call(Stub.java:113)
at org.jinterop.dcom.core.JIComServer.call(JIComServer.java:990)
... 8 more
java.lang.IllegalArgumentException
at com.aquafold.debugger.mssql.impl.bꂄᛗͬꌱ.i(Unknown Source)
at com.aquafold.debugger.mssql.impl.bꂄᛗͬꌱ.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Mꎍᛥ᛭ꀊabstractsynchronized.cleanup(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Mꎍᛥ᛭ꀊabstractsynchronized.run(Unknown Source)
This is not a bug in ADS. From the environment matrix you have provided, I would guess that your Ubuntu 15.0.4 and 16.04 instances either have a firewall running on it, or your DNS resolving on the client machine is failing. Vikram can is familiar with this as the error is coming from jInterop.