Hello,

We have not be able to replicate this. Is it still an issue?

Thanks,

Tom

Yes, this has been an ongoing issue since version 20. Others chased down the issue to the point that it is somehow connected to the clip board, or more specifically to applications that manipulate the clip board. TextExpander, I believe LaunchBar and other applications running at the same time as Aqua Data Studio cause the issue to occur. One of the people I discussed this with indicated that it was related to the version of the Java virtual machine that Aqua Data Studio uses and the fact it has some issue with later Mac OS versions. Unfortunately I don't have any technical details on that, but I did exchange several e-mail messages with someone in your support group about it. Typically I have to shut down and re-start ADS a couple of times a day to get past the issue.

For reference, here is the most recent exchange I had with someone at AquaFold regarding this issue. Not sure why you wouldn't have had a reference to this information.

On February 4, 2021 at 15:04:02, AquaFold Support - Support (support@aquafold.com) wrote:

 

David, 

Sorry for the delay in getting back to you on this case. 

Development debugged this issue further and it is not specific to ADS. Rather the issue is in JRE in combination with 

Mac OS 
Popup Menu, List selection 
Accessibility application 

They looked into multiple fixes but almost all point to later versions of Java; 9 or higher. 

They tried isolating the issue with some sample test cases but none of them is reproducible. Will continue investigating this and see if they can have workaround till they upgrade the Java. 

This case will remain open but deferred to development until a fix is released. As updates become available we will pass them along. 

John Reed 
AquaFold Technical Support 
support@aquafold.com 

--------------- Original Message --------------- 
From: David Sheeks [dsheeks@udlcomputing.com] 
Sent: 1/18/2021 5:34 PM 
To: support@aquafold.com 
Subject: RE: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ref:_00D30HwR._500 [ [ ] 

John, 

OK, thanks. I noticed one interesting thing that "may" be related. I use few of the .xjs scripts to automate various things. When I execute those and they establish a database connection using something like the following that works normally and the editor window is unaffected. 

var conn = aqua.project.getServerConnection('LCDB01'); 
conn.connect(); 
conn.changeDatabase('lc_bsi');  

David Sheeks 
UDL Computing 

On January 18, 2021 at 13:37:51, AquaFold Support - Support (support@aquafold.com) wrote: 

David,  

To be honest with you I really can't tell you what is going on under the hood. I have submitted your comment and questions to development and will pass their response on to you when I hear back from them.  

John Reed  
AquaFold Technical Support  
support@aquafold.com  

--------------- Original Message ---------------  
From: David Sheeks [dsheeks@udlcomputing.com]  
Sent: 1/16/2021 9:15 AM  
To: support@aquafold.com  
Subject: RE: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ref:_00D30HwR._500 [ [ ]  

John,  

OK, I spent a good amount of time going through all of the apps that had the Privacy / Accessibility setting enabled and it appears two definitely impact the "locked edit window" issue in the Query Analyzer:  

- Text Expander  (https://textexpander.com)  
- Keyboard Maestro  (https://www.keyboardmaestro.com/main/)  

Both of those are commonly used Mac OS applications that I use all the time. I don't use Keyboard Maestro in conjunction with Aqua Data Studio normally, but use Text Expanders excellent fill in text in ADS constantly for shortcuts when writing SQL. I know Aqua Data Studio has simple substitution abbreviations but those are not really comparable to what TextExpander does.  

Anyhow, are you saying that there is an issue with the version of the Java runtime environment currently used by Aqua Data Studio (I assume starting with version 20 where I first saw the problem) and any Mac OS application that manipulates the clipboard (I'm fairly sure that must be where the issue is, particularly with Text Expander since that's the exact focus of what it does; Keyboard Maestro does that as well, along with many other things)? Is that something Oracle would have to change in the JRE (or did change in the JRE used starting with ADS v20)? Is there a specific feature in ADS that is affected by the accessibility setting (such as the simplistic text substitutions) that could be turned off to avoid the problem?  

Note that disabling accessibility settings for Text Expander and Keyboard Maestro did not fix other bugs I've mentioned in v21 of ADS.   

David Sheeks  
UDL Computing  

On January 15, 2021 at 10:25:18, AquaFold Support - Support (support@aquafold.com) wrote:  

David,  

The logs you sent us indicate that an accessibility enabled app is not working correctly with Java and is blocking ADS from working properly.  

Please go to System Preferences > Security & Privacy > Privacy > Accessibility > Disable everything and then relaunch ADS to see if it works okay. If ADS runs properly then enable one accessibility app at a time to determine which app is causing the problem. At that point you can leave it disabled, providing you don't use it, or possibly set it to ignore ADS.  

Please let us know if this works for you.  

John Reed  
AquaFold Technical Support  
support@aquafold.com  

--------------- Original Message ---------------  
From: David Sheeks [dsheeks@udlcomputing.com]  
Sent: 1/15/2021 8:15 AM  
To: support@aquafold.com  
Subject: RE: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ref:_00D30HwR._500 [ [ ]  

John,  

Another bug. In query analyzer if you change the current SQL Server database using the following:  

use somedatabase  

the drop-down list showing the current database doesn't update, and more significantly, the auto-complete schema information is not updated for the new database. I also had a null pointer error just trying to open a Query Analyzer window. See attached latest error logs.  



David Sheeks  
UDL Computing  

On January 14, 2021 at 11:03:59, AquaFold Support - Support (support@aquafold.com) wrote:  

David,  

Please send me the logs again and any screen shots showing this problem.  

John Reed  
AquaFold Technical Support  
support@aquafold.com  

--------------- Original Message ---------------  
From: David Sheeks [dsheeks@udlcomputing.com]  
Sent: 1/14/2021 9:09 AM  
To: support@aquafold.com  
Subject: RE: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ref:_00D30HwR._500 [ [ ]  

John,  

I upgraded to 21.0.4. That did not fix the reconnect / query analyzer editor stops working issue.  

Just a minute ago I switched to a tab with an active database connection (SQL Server), pasted in a single SQL statement, executed it and received the following error. I've seen these java.lang.NullPointerException errors an number of times. When that happens if I try executing the statement again it works, but the tab on the Query Analyzer window shows an animated circle of dots and no further SQL statements can be executed in the Query Analyzer window.  

java.lang.NullPointerException  
at sun.lwawt.macosx.CAccessible$AXChangeNotifier.propertyChange(CAccessible.java:147)  
at java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:335)  
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:327)  
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:263)  
at javax.accessibility.AccessibleContext.firePropertyChange(AccessibleContext.java:768)  
at java.awt.Component.disable(Component.java:1548)  
at javax.swing.JComponent.disable(JComponent.java:3639)  
at java.awt.Component.enable(Component.java:1515)  
at java.awt.Component.setEnabled(Component.java:1478)  
at javax.swing.JComponent.setEnabled(JComponent.java:2680)  
at javax.swing.plaf.basic.BasicComboBoxUI$Handler.propertyChange(BasicComboBoxUI.java:1727)  
at java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:335)  
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:327)  
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:263)  
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:303)  
at java.awt.Component.firePropertyChange(Component.java:8454)  
at javax.swing.JComponent.firePropertyChange(JComponent.java:4491)  
at javax.swing.JComponent.setEnabled(JComponent.java:2681)  
at javax.swing.JComboBox.setEnabled(JComboBox.java:1391)  
at com.aquafold.datastudio.queryanalyzer.V͜ꀚꆈᡮinstanceofthis.c(Unknown Source)  
at com.aquafold.datastudio.queryanalyzer.V͜ꀚꆈᡮinstanceofthis.ceO(Unknown Source)  
at \\.\\.\\हिñçêČάй語简�?한\\.mꌾꈥ⣱ꇗdo.a(Unknown Source)  
at \\.\\.\\हिñçêČάй語简�?한\\.dꅗꉚꈬ͔char.a(Unknown Source)  
at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)  
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)  
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)  
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)  
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)  
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)  
at javax.swing.AbstractButton.doClick(AbstractButton.java:356)  
at javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:811)  
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668)  
at javax.swing.JComponent.processKeyBinding(JComponent.java:2882)  
at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:699)  
at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706)  
at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706)  
at javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:677)  
at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:307)  
at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:293)  
at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2974)  
at javax.swing.JComponent.processKeyBindings(JComponent.java:2966)  
at javax.swing.JComponent.processKeyEvent(JComponent.java:2845)  
at java.awt.Component.processEvent(Component.java:6316)  
at java.awt.Container.processEvent(Container.java:2239)  
at java.awt.Component.dispatchEventImpl(Component.java:4889)  
at java.awt.Container.dispatchEventImpl(Container.java:2297)  
at java.awt.Component.dispatchEvent(Component.java:4711)  
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954)  
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:834)  
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1102)  
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:973)  
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:799)  
at java.awt.Component.dispatchEventImpl(Component.java:4760)  
at java.awt.Container.dispatchEventImpl(Container.java:2297)  
at java.awt.Window.dispatchEventImpl(Window.java:2746)  
at java.awt.Component.dispatchEvent(Component.java:4711)  
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)  
at java.awt.EventQueue.access$500(EventQueue.java:97)  
at java.awt.EventQueue$3.run(EventQueue.java:709)  
at java.awt.EventQueue$3.run(EventQueue.java:703)  
at java.security.AccessController.doPrivileged(Native Method)  
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)  
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)  
at java.awt.EventQueue$4.run(EventQueue.java:733)  
at java.awt.EventQueue$4.run(EventQueue.java:731)  
at java.security.AccessController.doPrivileged(Native Method)  
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)  
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)  
at com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:866)  
at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:623)  
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:381)  
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)  
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)  
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)  
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)  
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)  
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)  


David Sheeks  
UDL Computing  

On January 13, 2021 at 16:07:48, AquaFold Support - Support (support@aquafold.com) wrote:  

David,  

Yes 21.0.4 is available. Just log into the customer support portal and select "My Products", then "Downloads". I suggested 21.0.4 because some other MAC users said upgrading to it did resolve some issues with "Big Sur" though there wasn't a specific fix, just new compatibility.  

FYI, version 19.0 had JRE 151 in it and this worked well with the MAC OS. Starting in v19.5 the JRE was upgraded and that is where MAC OS and Java started having problems. This was a known issue with several software companies.  

John Reed  
AquaFold Technical Support  
support@aquafold.com  

--------------- Original Message ---------------  
From: David Sheeks [dsheeks@udlcomputing.com]  
Sent: 1/13/2021 2:26 PM  
To: support@aquafold.com  
Subject: RE: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ref:_00D30HwR._500 [ [ ]  

John,  

I didn't see that v21.0.4 was available. I'd be fine trying that if there are bug fixes. Is that a generally available update or still work in progress?  

Also note that v19.x didn't have the query analyzer issue bu v20.x did under the prior "Catalina" version of Mac OS. I originally switched to v20.x some time ago but reverted to v19.x which worked fine until Big Sur came out.  

David Sheeks  
UDL Computing  

On January 13, 2021 at 14:27:22, AquaFold Support - Support (support@aquafold.com) wrote:  

David,  

Thanks for the reply. I have reopened the case.  

We know there have been problems with the MAC version of ADS mostly caused by the MAC OS not working well with Java JRE versions 152 and higher. We also know that prior to version 21.0.x "Big Sur" was not supported. However, "Big Sur" should now work with ADS.  

I see that you are currently on ADS v21.0.3, would you be able to try v21.0.4 to see if that fixes the issue you reported?  

I am going to open a development case concerning the issue you reported. As I have an update, or need more information, I will let you know.  

Regards,  

John Reed  
AquaFold Technical Support  
support@aquafold.com  


--------------- Original Message ---------------  
From: David Sheeks [dsheeks@udlcomputing.com]  
Sent: 1/13/2021 1:08 PM  
To: support@aquafold.com  
Subject: RE: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ref:_00D30HwR._500 [ ]  

John,  

The problem with re-connecting to the database from a SQL Server query analyzer window has existed since v20 came out. It still causes the input window to change modes such that you can't type in text, use the arrow keys to move the cursor, etc. I never used version 20 because of that and some other issues. Unfortunately version 19 isn't compatible with Mac OS 11.1 ("Big Sur"). Version 21 has several other obvious bugs, including occasional Java exceptions after pasting text into the query analyzer window, query analyzer tabs getting stuck with a spinning icon forcing the tab to be closed, problems with using the context menu in query analyzer results, etc. Version 21 seems very beta like. I've used Aqua Data Studio for a number of years with SQL Server, Oracle, Postgesql, and other databases and have never seen anything remotely like the problems in the last two versions before. The Mac OS version has always felt like it is an "also ran" variant of ADS (for example, several default shortcut keys don't work because they are standard Mac OS keyboard shortcuts) but the core functionality has been solid. I don't know if Idera is planning to phase ADS out over time and only bought it to eliminate a competitor or what. Any insights would be appreciated. At this point my I have another full year on my license but would be very hesitant to renew it when the current license fee runs out without some signs of life for the product. Having a pretty significant Query Analyzer bug last through two version (if you asked me for a single new feature in version 20 or 21 I couldn't name one) seems very odd. I've been a software developer for many years so I know very well that bugs happen, and that you can't always support versions of applications on every platform, but having a sense of what Aqua Fold / Idera is planning would be useful.  

Thanks.  

I've been swamped of late, hence the lack of a response, but here is as much of the information you requested as I could find. This re-connect bug is trivial to reproduce though, simply type Ctrl-Alt-Shift-Up-arrow to reconnect and the query analyzer text input window is immediately broken.  

Database server / version:  
  MS SQL Server, various current and recent versions.  

Logs.zip attached.  

I do not see any Java logs in the /Applications/Aqua Data Studio.app directory structure but let me know if I'm missing something there.  

Help | Support Information:  

License Key: B3A3B6221B65B561766D5C2237E48D2CC2BF68FA752E78F1****************  

Product: Aqua Data Studio  
Version: 21.0.3  
Build #: 58424  
Build Date: 2020-Nov-30 03:25:09 PM  

Operating Environment: Mac OS X (10.16, x86_64) / UTF-8 / en / US / AdoptOpenJDK 1.8.0_222-b10  
Memory: Max=1,908,932,608;  Total=581,959,680;  Free=260,180,608;  CPUs=6  

In-Window Graphics Capabilities  
Graphics Vendor: Intel Inc.  
OpenGL Renderer: Intel(R) UHD Graphics 630  
OpenGL Version: 2.1 INTEL-16.1.7  
Double-Buffering: Enabled  
Anti-Aliasing: Enabled  
Anti-Aliasing Sample Count: 16  
Hardware Acceleration: Enabled  
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 8  
Depth Bits: 16  
Accumulation Buffer Bits: Red: 0  Green: 0  Blue: 0  
Initialization Time: 1325 ms  


Offscreen Graphics Capabilities  
Graphics Vendor: Brian Paul  
OpenGL Renderer: Mesa OffScreen  
OpenGL Version: 2.1 Mesa 7.8.2  
Double-Buffering: Disabled  
Anti-Aliasing: Disabled  
Anti-Aliasing Sample Count: 0  
Hardware Acceleration: Disabled  
Color Bits: Red: 8  Green: 8  Blue: 8  Alpha: 8  
Depth Bits: 16  
Accumulation Buffer Bits: Red: 16  Green: 16  Blue: 16  
Initialization Time: 55 ms  
Hardware PBuffer Available: No  
Using PBuffer: No  
Using Ram Buffer: Yes  
Offscreen Rendering: Enabled  
Offscreen Buffer Size: 800x600  



David Sheeks  
UDL Computing  

On January 13, 2021 at 13:22:19, AquaFold Support - Support (support@aquafold.com) wrote:  

David,  

This is John with Aquafold technical support. I have not heard back from you concerning this issue so this case is being closed. If you are still having a problem please let me know and I can reopen this case, or open a new one.  

John Reed  
AquaFold Technical Support  
support@aquafold.com  

--------------- Original Message ---------------  
From: AquaFold Support - Support [support@aquafold.com]  
Sent: 1/8/2021 4:18 PM  
To: dsheeks@udlcomputing.com  
Subject: RE: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ref:_00D30HwR._500 [ ]  

David,  

This is John with Aquafold Technical Support. I wanted to touch base with you again as I have not received a reply to my email from 1/31. Please send the information I requested below so that we can continue working on this issue.  

Regards,  

John Reed  
AquaFold Technical Support  
support@aquafold.com  

--------------- Original Message ---------------  
From: AquaFold Support - Support [support@aquafold.com]  
Sent: 12/31/2020 9:51 AM  
To: dsheeks@udlcomputing.com  
Subject: AquaFold Support 00869293 - Query Analyzer - multiple issues with Mac OS [ ]  

Hello David,  

Thank you for submitting this request to the AquaFold Technical Support Team. My name is John and I will be supporting you with this issue.  

In order to assist you would you please provide me with the following information.  

Copy the technical information available in the Aqua Data Studio menu Help -> Support Information  

Any screenshots to illustrate the problem.  

The database server vendor and version you have.  

Any application logs, which are located in <USER_HOME>\.datastudio\logs  

Any JVM crash logs, which are located in the application installation folder.  

I will research the previous issue you referred to and reference it when I contact development on this new case.  

Sincerely,  

John Reed  
AquaFold Technical Support  
support@aquafold.com  
ref:_00D30HwR._5005a1hFoH2:ref

Hi David,

I apologize for the disconnect. I didn't realize that you had a support case open for this issue. We are looking to upgrade Java in ADS by first quarter next year which should fix some of the Mac OS issues. Support will keep you posted on our progress.

Thanks,

Tom

OK, thanks for the update. Definitely didn't want someone thinking the issues had been resolved. Note that I am currently using ADS v22 which seems significantly more stable than v21 was when it came out. I of course continue to have the main issue here, but haven't run into the types of issue I saw with v21 which seemed quite buggy. Hopefully that's a good sign!