Product: Aqua Data Studio
Version: 17.0.0-1
Build #: 48372
Build Date: 2016-Jan-26 05:31:26 PM
Operating Environment: Linux (3.19.0-15-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=419,954,688; Free=227,713,280; CPUs=8
Connect Sybase ASE-16.0
//Create default function
CREATE FUNCTION "dbo"."fx_hello_world"
(@firstString varchar(255), @secondString varchar(255))
RETURNS varchar(511)
AS
BEGIN
declare @newString varchar(511)
set @newString = 'Hello World!
@firstString: '||@firstString||'
@secondString: '||@secondString
RETURN @newString
END
Go to Functions tree node
Right click on created Functions "dbo"."fx_hello_world"
Select Debug in Function debugger option.
Debug in Function debugger window opens
Click on Start icon.
Parameter window opens
Enter parameter values and click on execute button.
Function executed successfully.
Go to pivot grid result set.
Click on View as spreadsheet button.
Actual Result:
You can see that,Opened "Export Pivot Grid:Failed" window.
Expected Result:
It should Export pivot grid data,after clicking on View as spreadsheet button in pivot grid.
Check view log:
java.lang.NullPointerException
at com.aquafold.datastudio.queryanalyzer.Tꀉꁘꅓꋢ33.dnJ(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Tꀉꁘꅓꋢ33.Nd(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Mꏧꆆꉹ᛬transientbyte.action(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.p̕⢅ꊰꀯ.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 com.jidesoft.plaf.metal.MetalJideSplitButtonUI$MouseInputHandler.cancelMenuIfNecessary(Unknown Source)
at com.jidesoft.plaf.metal.MetalJideSplitButtonUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
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)
Observation:
1)I have executed above scenario for Grid Result->View as spreadsheet button.
I have observed that,Grid data Exported successfully.
2)Please handle above scenario for Stored procedure->Debug in procedure debugger option.also.
3)Broken build info:
A)Same issue i have observed in V16.0 .
B)We have not supported Debug in Function debugger option in V15.0.
C)Same issue i have observed in V15.0 for Stored procedure->Debug in procedure debugger option.
.
NPE occurs b/c in PivotTablePaneView#saveExcelPivot() is called. When invoked, qp = null, qb = null and engine = null. NPE occurs b/c engine is null.