× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
vaibhavladdha271(*) reported 2015-07-22T06:19:46Z  · nhilam last modified 2018-03-14T16:58:47Z

Unable to delete an index from ER-modeler window if index is created on View & view is deleted


PM
Dev
QA
Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version Future
Product: Aqua Data Studio
Version: 17.0.0-dev-87
Build #: 44832
Build Date: 2015-Jul-21 06:12:05 PM
 
Operating Environment: Linux (3.13.0-57-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072;  Total=634,912,768;  Free=162,931,280;  CPUs=8

Scenario 1:
1)Click on ER-modeler menu & select New 
Select any database which has indexes(eg. Oracle)
Click on OK.
2)Right click on Tables node & select New table option.
Right click on Table & select Properties option.
Enter "c1" in Column name field.
Click on OK
3)Right click on Views node & select New view
View is created in Diagram pane.
Right click on created view in diagram pane & select Properties option.
In Properties window enter c1 in Column name field
Click on OK.
In Tables node expand created table
4)Right click on Indexes & select New Index.
In Index window select created View 'View_1" from Table field
Click on Sequence field to assign an order 
Click on OK.
5)Right click on created View & select Delete option
Click on Yes
6)Right click on created index & select Properties option.
You will observe that Index gets created on Table as view is deleted.
7)Right click on created index & select Delete option
Click on yes
Index is not deleted from Table node.
8)Double click on created table 
Right click on created column & select Delete column
Click on OK
You will observe that Index is not deleted even if there is no column in table
9)Right click on created index & select properties option.
In Properties window switch to preview sql tab

Illegal argument exception is displayed in Preview sql tab.

java.lang.IllegalArgumentException
at \\.\\.\\हिñçêČάй語简�?한\\.e⢦ꐽᛥꉮ.check(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.e⢦ꐽᛥꉮ.<init>(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.mꊘᡂꉣᡱbreakprotected.ce(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.mꊘᡂꉣᡱbreakprotected$3.stateChanged(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.bᠦꇔꀹꀓtransientfloat$1$1.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:749)
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.awt.EventQueue.dispatchEvent(EventQueue.java:719)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1654)
at java.awt.Component.setVisible(Component.java:1606)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at \\.\\.\\हिñçêČάй語简�?한\\.Bᛌꈟ⣕ꐪthis4.open(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.mꊘᡂꉣᡱbreakprotected.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Dꏸꋀꐹꋿbytefinally.b(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.uᚥꊥꂝꐥstaticlong$4.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)
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.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
at java.awt.Component.processMouseEvent(Component.java:6525)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
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 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)
 

 

1 attachment

Issue #13559

New
 
 
Completion
No due date
No fixed build
No time estimate

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