JR34857: EXCEPTION OCCURS ON DESIGNER WITH A PARTICULAR OPERATION.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

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 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