JR50514: Using special characters for database password may cause file fr om -script_file option of StagingCopy to not run correctly

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• An SQL file generated by the StagingCopy utility against an
  Oracle database may not execute successfully using the sqlplus
  command.
  
  This can occur if the password required to connect to the
  database contains characters that have special meaning to the
  operating system on which the sqlplus command was invoked, e.g.,
   $ character on unix-like platforms.
  

Local fix

• Do not use password with special characters
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 who use the StagingCopy utility
   and have Oracle backend WebSphere Commerce databases
  
  PROBLEM ABSTRACT:
  Using special characters for database password may cause file
  from -script_file option of StagingCopy to not run correctly
  
  BUSINESS IMPACT:
  Execution of scripted SQL file generated by the StagingCopy
  utility may not complete successfully
  
  RECOMMENDATION:
  

Problem conclusion

• StagingCopy code was modified to correctly handle passwords when
   saving to script files for Oracle databases.
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP