IBM Support

JR56714: UPGRADESCHEMAALL_DE_NAME.SH SCRIPT FAILS IF PASSWORD CONTAINS SPECIAL CHARACTERS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When running upgradeSchemaAll_de_name.sh script, that script
    calls createSchema.sh.  createSchema.sh fails with the
    following error:
    
    SQL0104N  An unexpected token "," was found following
    "<identifier>".
    Expected tokens may include:  "NEW".  SQLSTATE=42601
    
    This is related to the password containing special characters.
    

Local fix

  • If you alter createSchema.sh and replacethe following line of
    code "db2 connect to $DB_NAME user $DB_USER using $DB_PASSWORD"
    with "db2 connect to $DB_NAME ", you are prompted for password,
    then script executes.
    

Problem summary

  • The issue has been fixed in BPM8.5.7 2016.12
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR56714

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    857

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-23

  • Closed date

    2016-11-23

  • Last modified date

    2016-11-23

  • 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

  • R857 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
23 November 2016