JR34000: WHEN EXPORT WISD PROJECT ON ONE SYSTEMM AND IMPORT ON ANOTHER, CUSTOM COLUMN NAMES LOST DUE TO IMPORT NOT MAPPING AGENT NAME.

APAR status

• Closed as requirement.

Error description

• When Export WISD project from one system and import on another,
  custom sql column names lost when forced to update service
  connection info due to unknown agent name.
                                                                 .
  WISD definitions include information services connection of type
  "Oracle Database Server" and an Application information provider
  defintion of type "Oracle Database Server", Subtype "SQL
  Statement".  The output tab contains customized names in the
  Operation argument column (i.e. name is different from SQL
  column name it maps to).
                                                                 .
  When site exports this Project/Application from systemA and
  imports on systemB, even though both systems have an information
  service provider with same name, the exported
  "referenceProvider" element contains an agent name unique to
  source system (hostname:port).  After import, the application
  cannot be deployed as-is since exception occurs due to agent
  name.   To resolve, user is forced to edit/save service provider
  details which removes the custom argument names, even if the SQL
  statement is not changed.
                                                                 .
  Since import is on new system, agent name imported will have
  different hostname that the new target system, resulting in
  exception when deploy.  This forces the site to make a service
  provider update in application, which in turn removes the custom
  names.
                                                                 .
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• fixed change.  Customer tested the patch
  

APAR Information

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

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

Fix information

Applicable component levels