JR57110: EACH ORACLE CREATE SEQUENCE STATEMENT IN THE CELL-LEVEL DATABASE IS MISSING A SCHEMA QUALIFIER

bpm.8570.cf2017.03.delta.repository
Downloading IBM Business Process Manager V8.5.7 Cumulative Fix 2017.03

APAR status

• Closed as fixed if next.

Error description

• The @SCHEMA@ replacement variable in the cell-level database of
  an IBM Business Process Manager Advanced environment is missing
  from the template createSchema_CommonDBCellOnly.sql file for
  Oracle.
  

Local fix

• When you create the IBM BPM Advanced deployment environment that
   uses an Oracle database, set bpm.de.deferSchemaCrreation=false
  and then manually add the missing schema qualifier <userName> to
   the following CREATE SEQUENCE statements in the generated
  <profile_root>/dbscripts/<cellName>/Oracle/<databaseName>/<userN
  ame>/createSchema_Advanced.sql file before creating the database
   schema:
  
  CREATE SEQUENCE  SEQ_W_LIT_DOUBLE_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_LIT_FLOAT_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_LIT_LONG_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_NAMESPACE_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_OBJ_LIT_ANY_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_OBJ_LIT_DATE_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_OBJ_LIT_DATETIME_ID  MINVALUE 1
  NOMAXVALUE INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
  ;
  CREATE SEQUENCE  SEQ_W_OBJ_LIT_STRING_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_STATEMENT_ID  MINVALUE 1 NOMAXVALUE
  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  CREATE SEQUENCE  SEQ_W_URI_ID  MINVALUE 1 NOMAXVALUE INCREMENT
  BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  

Problem summary

• This issue might occur because the following Oracle SEQUENCE
  objects are created in the schema of the user who runs the
  generated createSchema_Advanced.sql script instead of in the
  schema of the runtime user:
  
  SEQ_W_LIT_DOUBLE_ID
  SEQ_W_LIT_FLOAT_ID
  SEQ_W_LIT_LONG_ID
  SEQ_W_NAMESPACE_ID
  SEQ_W_OBJ_LIT_ANY_ID
  SEQ_W_OBJ_LIT_DATE_ID
  SEQ_W_OBJ_LIT_DATETIME_ID
  SEQ_W_OBJ_LIT_STRING_ID
  SEQ_W_STATEMENT_ID
  SEQ_W_URI_ID
  
  
  A fix will be available in IBM BPM V8.5.7 cumulative fix 2017.03
   that adds the schema qualifier to the template
  createSchema_CommonDBCellOnly.sql file for Oracle so the schema
  qualifier is in the generated SQL files.
  
  To determine whether the cumulative fix is available, complete
  the following steps on Fix Central
  (http://www.ibm.com/support/fixcentral):
  
  1. On the Select product tab, select WebSphere as the product
  group, IBM Business Process Manager with your edition from the
  WebSphere options, All as the installed version, and All as the
  platform, and then click Continue.
  2. In the Text field, enter "cumulative fix", and click
  Continue.
  
  If cumulative fix 2017.03 is available, download and install it.
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

Problem conclusion

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