68 views

Description

Comparing two records for a table that has been deleted results in a blank screen and a NullPointerException in the logs.

This issue is resolved in the Jakarta release; the error message "Invalid table: <table_name>" is displayed.

Steps to Reproduce

  1. In the Application Navigator, type sys_db_object.list into the Filter navigator field and press enter or return on your keyboard.
  2. Create a table that extends the sys_metadata table.
  3. Right-click in the header bar and select Save.
  4. Modify the new record so that two different sys_update_version records are generated.
    • In the Application Access section or tab, select the Can create option.
    • Right-click in the header bar and select Save.
    • In the Application Access section or tab, clear the Can create option.
    • Right-click in the header bar and select Save.
    • Right-click in the header bar and select Copy sys id.
    • Paste the sys id into a text file (you will need it for several later steps). 
  5. Verify that two different version records were generated.
    • In the Application Navigator, type sys_update_version.list into the Filter navigator field and press enter or return on your keyboard.
    • In the search box under the Name column header, type *, paste the sys id you copied, and press enter or return on your keyboard. (If the search box is not displayed under the Name column header, click the magnifying glass icon  to the left of the Created column header.)
      There should be at least two version records.
  6. Delete the table you created in step 2.
    • In the Application Navigator, type sys_db_object.list into the Filter navigator field and press enter or return on your keyboard.
    • Open the record for the table.
    • Click Delete.
    • Type the word delete and click OK.
  7. In the Application Navigator, type sys_update_version.list into the Filter navigator field and press enter or return on your keyboard.
  8. In the search box under the Name field, type * and paste the sys id you copied.
  9. Click on one of the versions created in step 4.
  10. In Related Links, click Compare to Current.
    Note that a blank screen is displayed. Also, a NullPointerException appears in the logs. There should be an error message stating that the table is not valid.

Workaround

Check that the record you are comparing has an existing table.


Related Problem: PRB721443

Seen In

Helsinki Patch 2

Fixed In

Jakarta

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-08-29 16:49:08
Published:2017-08-29