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

bpm.8570.cf2016.06.delta.repository.1of2
bpm.8570.cf2016.06.delta.repository.2of2

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 is sysrouted FROM one or more of the following:

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

Fix information

Applicable component levels