IBM Support

JR54934: DOC - MICROSOFT DATABASE IDENTIFIERS LIMITATION REGARDING SQL FILE EXECUTION NOT DOCUMENTED AND NOT CHECKED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • When you create an IBM Business Process Manager (BPM) deployment
    environment (DE) by using a Microsoft SQL Server database and
    the database user name or schema name is not a regular
    identifier according to the Microsoft Database Identifiers page
    (https://msdn.microsoft.com/en-us/library/ms175874.aspx), the
    SQL file execution fails with an error like the following error
    (the invalid character in this example is '-'):
    
    com.microsoft.sqlserver.jdbc.SQLServerException
    Syntax error near '-'
    
    This limitation is not documented.
    
    PRODUCTS AFFECTED
    IBM BPM Advanced
    IBM BPM Standard
    IBM BPM Express
    

Local fix

  • use DB username without the '-'
    

Problem summary

  • The database user name and schema name are not quoted in the
    generated SQL files for Microsoft SQL Server. Because IBM BPM
    does not support database schema names that are not a regular
    Microsoft Database Identifiers, running the SQL file fails when
    the user name or schema name contains special characters like
    the hyphen (-). This information is not documented.
    

Problem conclusion

  • The "Configuration properties for the BPMConfig command"
    (http://www.ibm.com/support/knowledgecenter/SSFPJS_8.5.6/com.ibm
    .wbpm.ref.doc/topics/samplecfgprops.html?lang=en) topic will be
    updated the next time the documentation is refreshed.
    
    A fix will be available in a later release that ensures during
    initial configuration properties file validation that database
    schema names are valid, instead of failing later when the
    generated SQL files run.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR54934

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    856

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-12-14

  • Closed date

    2016-02-18

  • Last modified date

    2016-02-18

  • 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

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

Document Information

Modified date:
18 February 2016