Product: Aqua Data Studio
Version: 15.0.0-dev-311
Build #: 38320
Build Date: 2014-Jun-05 05:09:09 PM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_21-b11
Memory: Max=704,643,072; Total=516,882,432; Free=34,041,536; CPUs=8
Database - DB2LUW all version
Steps to Reproduce :
1. Connect to DB2LUW10.5 database
2. Expand DB2LUW10.5 server
3. Run the following script on Query Analyzer
CREATE SCHEMA "TEST1"
GO
CREATE TRIGGER "TEST1"."FORMER_EMP"
AFTER DELETE ON organizecol.EMPLOYEE
FOR EACH ROW
UPDATE organizecol.COMPANY_STAT SET NBEMP = NBEMP - 8
GO
CREATE SCHEMA "TEST2"
GO
CREATE TRIGGER "TEST2"."FORMER_EMP"
AFTER DELETE ON organizecol.EMPLOYEE
FOR EACH ROW
UPDATE organizecol.COMPANY_STAT SET NBEMP = NBEMP - 10
GO
4. Select "TEST1" and "TEST2" Right click and select "Schema Compare" option
5. In Schema Compare Tool window Select Trigger in Schema Object Pane and click on "Compare" button
6. Schema compare Result window get open
7. Go to "TEST2" schema ,Go to Trigger node
8. Right click on "FORMER_EMP" Trigger and click on "Drop Trigger" option
9. After dropping trigger. Go to Schema Compare Result window and click on "Refresh" icon
Actual Result - After click on Refresh throws java.lang.NullPointerException
java.lang.NullPointerException
at \\...\\ .\\??ñçêC???????\\.i???? case new.a(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.k????.a(Unknown Source)
at \\...\\ .\\??ñçêC???????\\._???? Boolean.a(Unknown Source)
at \\...\\ .\\??ñçêC???????\\.o???? class.run(Unknown Source)
This is the correct behavior. Once you open the Schema Compare it extracts the information from the meta tables including the trigger. Then user drops the trigger at a different connection. Now once you hit refresh, the Schema Compare tries to extract the object, but cannot find the information to script. Exception is logged in the Error log which is the correct flow.