IBM Support

PI75864: IN IBM RDZ 9.5.1.3, EXTRACT SQL KEY SHORTCUT OF CTRL+ALT+X FAILSTO OPEN SQL OUTLINE WINDOW WHEN ON SQL STATEMENT IN PLI MEMBER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In IBM Rational Developer for z System 9.5.1.3, when a PL/I
    member has a SQL statement and the Extract SQL feature is used
    with the key shortcut of CTRL+ALT+X,  the SQL Outline window
    fails to open and an exception is returned.
    
    Steps to recreate:
    1) Open a PL/I test member with a SQL statement such as "dcl
    sysprint file;"
    2) Put the cursor on the line with the text "dcl sysprint file;"
    or some other SQL statement.
    3) Go to Window/Preferences.  Set Keys to SQL extract for PL/I
    to CTRL+ALT+X and select Apply and OK.
    
    4) Return to the PL/I editor window.  Place the cursor on the
    line with the SQL statement and select CTRL+ALT+X.
    
    5) When the feature works, the SQL Outline view opens to Schemas
    with no errors.
    When the feature does not work, the view window does not appear
    and an exception is returned in the error log:
    
    org.eclipse.e4.core.di.InjectionException:
    org.eclipse.core.commands.ExecutionException: While executing
    the action, an exception occurred
    		 at
    org.eclipse.e4.core.internal.di.MethodRequestor.execute(Unknown
    Source)
    		 ...
    Caused by: java.lang.NullPointerException
    		 at
    com.ibm.systemz.common.editor.FileNavigationLocation.<init>(Unkn
    own Source)
    		 at
    com.ibm.systemz.pl1.editor.sqloutline.populator.search.PL1SQLExt
    ractor.runForOutlineView(Unknown Source)
    		 at
    com.ibm.systemz.pl1.editor.sqloutline.populator.search.PL1SQLExt
    ractor.run(Unknown Source)
    		 at
    com.ibm.systemz.pl1.editor.jface.addon.action.PL1ExtractSQLActio
    n.run(Unknown Source)
    		 at org.eclipse.jface.action.Action.runWithEvent(Unknown
    Source)
    

Local fix

Problem summary

  • NullPointerException was thrown when the extract SQL operation
    was performed on source code that failed to parse due to invalid
    syntax.
    

Problem conclusion

  • A handful of checks were put in place to cover cases where an
    object was being used without first verifying that it was not
    null.  A warning message was also added in the event that no AST
    was present due to parsing failures.
    
    The problem listed in this APAR has been resolved with
    IBM Rational Developer for z Systems V9.5.1.5 Fix Pack which
    is available from the Recommended Fixes support download page:
    http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI75864

  • Reported component name

    ID/Z UTILITIES

  • Reported component ID

    5724T0733

  • Reported release

    951

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-01

  • Closed date

    2017-04-27

  • Last modified date

    2017-04-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DEV FOR Z SYS

  • Fixed component ID

    5724T0700

Applicable component levels

  • R951 PSY

       UP



Document information

More support for: Rational Developer for System z

Software version: 951

Reference #: PI75864

Modified date: 27 April 2017