× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2017-03-10T06:15:40Z  · last modified 2017-03-13T15:07:27Z

Schema Synchronization -> NPE on changing the Group BY Drop Down


Priority Minor
Complexity Unknown
Component Tools - Compare - Schema
Version 18.0
Version: 18.0.3
Build #: 53490
Build Date: 2017-Mar-09 05:40:14 PM
 
Operating Environment: Mac OS X (10.12.3, x86_64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b27
Memory: Max=3,819,962,368;  Total=1,515,716,608;  Free=1,141,111,520;  CPUs=8
 
NPE on changing the Group BY Drop Down to Type of Differences for Schema Synchronization
 
To reproduce
 
1. Create the 2 tables in SQL Server 2014 with below script
OR
in AWS , you can use DB named nare and Narendra at SQL Server 2014 ending 1.69 for Schema Synchronization.
2. Make sure that tables are only in Source and not in the Target DB. Select the DB where you ran the script and another DB
3. Perform Schema Synchronization and check Object = Tables only
4.  From Source DB select only Table21 and Table22
5.  Click on Compare Button and the Schema Compare Results window come up
6. Click on the Sync checkbox for both the objects
7. Click on Synchronize Schema Button and the new window comes up
8. Go back to the Schema Compare Results window
9. Go to the Group By dropdown and Change to Type of differences and you get below NPE
 
Script for SQL Server
------------------------------
CREATE TABLE [dbo].[Table21]  ( 
    [Column1] datetime2(6) NULL 
    )
GO
CREATE TABLE [dbo].[Table22]  ( 
    [Column1] datetime2(2) NULL 
    )
GO
 
java.lang.NullPointerException
at com.aquafold.datastudio.tools.diff.Rᜣꂵꋰꐲ.kM(Unknown Source)
at com.aquafold.datastudio.tools.diff.N᠚ꉁᚼ⣘volatilegoto.getTableCellRendererComponent(Unknown Source)
at javax.swing.JTable$AccessibleJTable.getAccessibleChild(JTable.java:7031)
at javax.swing.JTable$AccessibleJTable.getAccessibleAt(JTable.java:7418)
at javax.swing.JTable$AccessibleJTable.valueChanged(JTable.java:6932)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:164)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:211)
at javax.swing.DefaultListSelectionModel.setLeadSelectionIndex(DefaultListSelectionModel.java:815)
at javax.swing.JTable.clearSelectionAndLeadAnchor(JTable.java:2128)
at javax.swing.JTable.tableChanged(JTable.java:4445)
at com.jidesoft.grid.JideTable.tableChanged(Unknown Source)
at com.jidesoft.grid.CellSpanTable.tableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296)
at com.jidesoft.grid.TableModelWrapperImpl.fireTableChanged(Unknown Source)
at com.jidesoft.grid.CompoundTableModelEvent.fireTableModelEvent(Unknown Source)
at com.jidesoft.grid.TableModelWrapperImpl.fireTableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableDataChanged(AbstractTableModel.java:198)
at com.jidesoft.grid.TableModelWrapperImpl.tableDataChanged(Unknown Source)
at com.jidesoft.grid.DefaultTableModelWrapper.tableDataChanged(Unknown Source)
at com.jidesoft.grid.DefaultTableModelWrapper.tableDataChanged(Unknown Source)
at com.jidesoft.grid.TableModelWrapperImpl.tableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296)
at com.jidesoft.grid.TableModelWrapperImpl.fireTableChanged(Unknown Source)
at com.jidesoft.grid.SortableTableModel.fireTableChanged(Unknown Source)
at com.jidesoft.grid.CompoundTableModelEvent.fireTableModelEvent(Unknown Source)
at com.jidesoft.grid.SortableTableModel.tableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296)
at com.jidesoft.grid.TableModelWrapperImpl.fireTableChanged(Unknown Source)
at com.jidesoft.grid.CompoundTableModelEvent.fireTableModelEvent(Unknown Source)
at com.jidesoft.grid.TableModelWrapperImpl.fireTableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableDataChanged(AbstractTableModel.java:198)
at com.jidesoft.grid.FilterableTableModel.tableDataChanged(Unknown Source)
at com.jidesoft.grid.TableModelWrapperImpl.tableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableChanged(AbstractTableModel.java:296)
at javax.swing.table.AbstractTableModel.fireTableDataChanged(AbstractTableModel.java:198)
at com.aquafold.datastudio.tools.diff.pꅐꈦᛏᛖ.a(Unknown Source)
at com.aquafold.datastudio.tools.diff.Rᜣꂵꋰꐲ.chi(Unknown Source)
at com.aquafold.datastudio.tools.diff.Rᜣꂵꋰꐲ.chj(Unknown Source)
at com.aquafold.datastudio.tools.diff.Rᜣꂵꋰꐲ.a(Unknown Source)
at com.aquafold.datastudio.tools.diff.Rᜣꂵꋰꐲ$4.itemStateChanged(Unknown Source)
at javax.swing.JComboBox.fireItemStateChanged(JComboBox.java:1223)
at javax.swing.JComboBox.selectedItemChanged(JComboBox.java:1280)
at javax.swing.JComboBox.contentsChanged(JComboBox.java:1330)
at javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:118)
at javax.swing.DefaultComboBoxModel.setSelectedItem(DefaultComboBoxModel.java:93)
at javax.swing.JComboBox.setSelectedItem(JComboBox.java:576)
at \\.\\.\\हिñçêČάй語简�?한\\.Aꑕꅡꂻᢄ52.setSelectedItem(Unknown Source)
at javax.swing.JComboBox.setSelectedIndex(JComboBox.java:622)
at javax.swing.plaf.basic.BasicComboPopup$Handler.mouseReleased(BasicComboPopup.java:834)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:290)
at java.awt.Component.processMouseEvent(Component.java:6525)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at com.apple.laf.AquaComboBoxPopup$1.processMouseEvent(AquaComboBoxPopup.java:157)
at java.awt.Component.processEvent(Component.java:6290)
at java.awt.Container.processEvent(Container.java:2234)
at java.awt.Component.dispatchEventImpl(Component.java:4881)
at java.awt.Container.dispatchEventImpl(Container.java:2292)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)
at java.awt.Container.dispatchEventImpl(Container.java:2278)
at java.awt.Window.dispatchEventImpl(Window.java:2750)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:751)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:702)
at java.awt.EventQueue$3.run(EventQueue.java:696)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:724)
at java.awt.EventQueue$4.run(EventQueue.java:722)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:721)
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(EventDispatchThread.java:201)
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)
 

 

4 attachments

Issue #15069

Closed
Fixed
Resolved 2017-03-10T23:02:15Z
 
 
Completion
No due date
Fixed Build ADS 18.0.3-3
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017