IBM Support

JR34857: EXCEPTION OCCURS ON DESIGNER WITH A PARTICULAR OPERATION.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Desinger puts "Unable to rename the item.  Unable to retrieve
    the details for items <tableDefnID>" messages with the below
    operations.
    
    1) Create a table & job
    2) Use the table in the job such that a relationship is created
    3) With the job open, attempt to rename the table
    4) An error message was produced saying: "Unable to rename the
    item.  Unable to retrieve the details for items <tableDefnID>".
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    DataStage users
    ****************************************************************
    PROBLEM DESCRIPTION:
    Delete and rename operations in a multi-user environment can
    fail under certain circumstances without a clear error message
    to describe why the operation failed.  The scenarios where this
    can occur are:
    
    A - Rename when current user has job open
    1) Create a table & job
    2) Use the table in the job such that a relationship is created
    3) With the job open, current user attempts to rename the table
    (choosing the update jobs option)
    4) An error message was produced saying: "Unable to rename the
    item.  Unable to retrieve the details for items <tableDefnID>".
    
    
    B - Rename when another user has job open
    1) Create a table & job
    2) Use the table in the job such that a relationship is created
    3) With the job open by user A, user B attempts to rename the
    table (choosing either the update jobs or break relationship
    option)
    4) An error message was produced saying: "Unable to rename the
    item.  Unable to retrieve the details for items <tableDefnID>".
    
    
    C - Delete when another user has job open
    1) Create a table & job
    2) Use the table in the job such that a relationship is created
    3) With the job open by user A, user B attempts to delete the
    table
    4) An error message was produced saying: "Unable to delete the
    item."
    ****************************************************************
    RECOMMENDATION:
    Install patch to get clearer delete and rename error messages.
    ****************************************************************
    

Problem conclusion

  • A fix has been produced to produce more descriptive messages:
    
    A - Rename when current user has job open
    This has been modified to include the message "It is not
    possible to rename an item that is referenced by another item
    which you are currently editing (you currently have '<jobName>'
    open)."
    
    B - Rename when another user has job open
    This has been modified to include the message "It is not
    possible to rename an item that is referenced by another item
    which somebody else is currently editing (user '<user>'
    currently has '<jobName>' open in session '<sessionID>')."
    
    C - Delete when another user has job open
    This has been modified to include the message  "It is not
    possible to delete an item that is referenced by another item
    which somebody else is currently editing (user '<user>'
    currently has '<jobName>' open in session '<sessionID>')."
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34857

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-16

  • Closed date

    2009-11-30

  • Last modified date

    2009-11-30

  • 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

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R810 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 October 2021