#14798: java.lang.reflect.InvocationTargetException is thrown on executing select query to retrieve columns more than the value of 'Maximum number of columns allowed'.

vaibgoyal reported 2016-10-21T13:21:37Z · JennyNishimura last modified 2017-01-30T18:05:24Z

java.lang.reflect.InvocationTargetException is thrown on executing select query to retrieve columns more than the value of 'Maximum number of columns allowed'.

Dev	JennyNishimura
QA	vaibgoyal

Priority	Major
Complexity	Unknown

Component	Q Analyzer - Grid Results
Version	17.0

Product: Aqua Data Studio

Version: 17.0.10

Build #: 51450

Build Date: 2016-Oct-11 04:23:02 PM

Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_77-b03

Memory: Max=704,643,072; Total=418,906,112; Free=241,493,712; CPUs=8

Steps to reproduce:

1. Launch ADS v17.0.10

2. [Mandatory Step] Go to 'File > Options' > Results > Grid Results > Set 'Maximum number of columns allowed' to '2'.

3. Connect to MySQL database > Open Query Analyzer > Run the Create_Table.sql script attached.

4. Open view log.

5. Open new query analyzer > Run the Select_query.sql script attached to retrieve the columns of the created tables.

Actual Result: On executing select query to retrieve columns of 4 or more tables having column more than the value set to 'Maximum number of columns allowed', java.lang.reflect.InvocationTargetException is thrown.

[Please refer to the screenshot attached]

Expected Result: Appropriate error message should be displayed.

Observations:

This issue occurs on all the three OS.

ADS Builds	ADS > Results
	Grid Results
	Windows OS
ADS 17.0.10	Exception is thrown
ADS v18	Exception is thrown
ADS v16	Option not available
ADS v15	Option not available
ADS v14	Option not available

6 attachments

Select_query.sql

2016-10-21T13:21:37Z

102 B
Create_tables.sql

2016-10-21T13:21:37Z

512 B
Grid_Results.png

2016-10-21T13:21:37Z

134 KB
14798_17_0_4-4.png

2016-10-24T04:40:14Z

96 KB
Screen Shot 2016-10-26 at 4.01.49 PM.png

2016-10-26T23:01:33Z

68 KB
#14798_Verified_preview35.png

2017-01-30T06:35:18Z

153 KB

All Comments (6) Change History

vaibgoyal 2016-10-21T13:26:30Z

Stack Trace:

java.lang.reflect.InvocationTargetException

at java.awt.EventQueue.invokeAndWait(Unknown Source)

at javax.swing.SwingUtilities.invokeAndWait(Unknown Source)

at com.aquafold.datastudio.queryanalyzer.jᢜ̅ꃫꀌlongvolatile.run(Unknown Source)

Caused by: java.lang.NullPointerException

at com.aquafold.datastudio.queryanalyzer.jᢜ̅ꃫꀌlongvolatile.u(Unknown Source)

at com.aquafold.datastudio.queryanalyzer.jᢜ̅ꃫꀌlongvolatile.t(Unknown Source)

at com.aquafold.datastudio.queryanalyzer.jᢜ̅ꃫꀌlongvolatile.a(Unknown Source)

at com.aquafold.datastudio.queryanalyzer.jᢜ̅ꃫꀌlongvolatile$8.run(Unknown Source)

at java.awt.event.InvocationEvent.dispatch(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.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

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.run(Unknown Source)

SachinPrakash 2016-10-22T02:43:12Z

@jenny: pls look at linked issue.

SachinPrakash 2016-10-22T02:44:29Z

@vaibgoyal: pls determine the exact build in v17 when this breakage started. Look at #14411 to see when the feature was introduced.

vaibgoyal 2016-10-24T04:49:59Z

This issue is reproducible from implementation build of Issue 14411 i.e ADS 17.0.4-4. [Please refer to the screenshot 14798_17_0_4-4.png attached.]

tariqrahiman 2016-10-26T23:01:58Z

Verified in AD v18.0.0-alpha-9

vaibgoyal 2017-01-30T06:36:34Z

Verified in ADS v18.0.0-preview-35. [Please refer to the screenshot #14798_Verified_preview3.png attached.]

Search Tips

Aqua Data Studio / nhilam

java.lang.reflect.InvocationTargetException is thrown on executing select query to retrieve columns more than the value of 'Maximum number of columns allowed'.

6 attachments

Issue #14798

Completion

1 issue link

Issue #14411

Search Tips

Aqua Data Studio / nhilam

Title

java.lang.reflect.InvocationTargetException is thrown on executing select query to retrieve columns more than the value of 'Maximum number of columns allowed'.

6 attachments

Issue #14798

Completion

1 issue link

Issue #14411