#13249: NPE occurs on option "Procedure Properties"

Shavi57 reported 2015-04-15T04:06:39Z · last modified 2015-04-20T08:48:15Z

NPE occurs on option "Procedure Properties"

Dev	ivangron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	App - Visual Editing
Version	16.0

Product: Aqua Data Studio

Version: 17.0.0-dev-15

Build #: 43546

Build Date: 2015-Apr-12 08:20:14 PM

Operating Environments:

1] Operating Environment: Linux (3.16.0-34-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26

Memory: Max=704,643,072; Total=424,148,992; Free=274,100,760; CPUs=8

2] Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.7.0_60-b19

Memory: Max=704,643,072; Total=354,942,976; Free=192,428,680; CPUs=8

Database Version: MySQL 5.7.6-m16

# Steps to reproduce issue:

Execute script given in attached .sql file

Go to created procedure and Right click on it

Select "Procedure Properties" option

Actual Result: Error pop up get displayed and NPE occurs in View Log

Stack trace:

java.lang.NullPointerException

at \\...\\ .\\हिñçêČάй語简�?한\\.bꇶ⠑ꃤꃈ class int$1.dI(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Xᛙꌃᢙꄷ.process(Unknown Source)

at com.common.ui.util.BackgroundThread.run(Unknown Source)

3 attachments

13249_dataset.sql

2015-04-15T04:15:04Z

693 B
v17-dev-15-13249

2015-04-15T04:54:28Z

74 KB
Netezza7.1_NPE.png

2015-04-15T05:05:01Z

55 KB

All Comments (14) Change History

tariqrahiman 2015-04-15T04:09:06Z

Does this occur in the latest v16 build ? There was a bug which was there and I want to check if its the same one, which was resolved...

Shavi57 2015-04-15T05:09:13Z · (edited)

Issue is reproducible from builds ADS 16.0.3-7 and ADS 17.0.0-dev-9

Issue is reproducible in latest builds ADS 16.0.3-18 and ADS 17.0.0-dev-15

narendravatsaraj(*) 2015-04-15T04:58:15Z · (edited)

This issue is reproducible in Netezza7.1 also.

Create simple procedure.

CREATE PROCEDURE ADMIN.customer1()

RETURNS BIGINT

EXECUTE AS OWNER

LANGUAGE NZPLSQL

BEGIN_PROC

BEGIN

RAISE NOTICE ' The customer name is beta ';

END;

END_PROC

Right click on it to see Procedure Properties.
You will notice Error pop up with displaying NPE in view log.

nileshhmali 2015-04-15T05:18:57Z · (edited)

Same issue we have observed in Teradata-15.0 and Sql server-2014

dutondeumesh 2015-04-15T05:38:42Z

Same issue is getting observed in Sybase Anywhere 16 also

abhishekj(*) 2015-04-15T05:40:58Z

Same issue is getting observed in Oracle12c.

nisha.gaikwad(*) 2015-04-15T05:48:28Z

Same issue is getting observed in DB2LUW 10.5.

VikramPacharne(*) 2015-04-15T06:41:01Z

Same issue is getting observed in DB2 iSeries

deepti 2015-04-15T06:45:00Z

Same issue is observed in Sybase IQ

ivangron 2015-04-15T17:08:48Z

Exception handling required when type is null. Will no longer throw npe.

tariqrahiman 2015-04-15T23:20:18Z

Verified in ADS v16.0.3-19

deepalisalve 2015-04-16T09:43:03Z

Same issue observed for informix.

deepalisalve 2015-04-20T05:19:07Z

Works fine. Verified for Informix in ADS 16.0.4.

Shavi57 2015-04-20T08:48:15Z · (edited)

Verified for all supported Databases in ADS 16.0.4. Please mention the fixed v17 build.

Search Tips

Aqua Data Studio / nhilam

NPE occurs on option "Procedure Properties"

3 attachments

Issue #13249

Completion

1 issue link

Issue #13237

Search Tips

Aqua Data Studio / nhilam

Title

NPE occurs on option "Procedure Properties"

3 attachments

Issue #13249

Completion

1 issue link

Issue #13237