JR42736: SCA AND CEI MESSAGING ENGINES START WITH EXCEPTIONS DURING STANDALONE PROFILE CREATION WITH SQL SERVER DATABASE

APAR status

• Closed as program error.

Error description

• SCA and CEI messaging engines start with exceptions during
  Standalone profile creation with SQL Server database when SQL
  Server authentication is used.
  If a Standalone profile creation was created using SQL Server
  database and if the SQL Server authentication was used the
  messaging engine settings for SCA System Bus, SCA Application
  Bus and CEI Bus would result in exceptions during the server
  start. This iFix resolves the issue by fixing the settings. If a
  profile is already created with the wrong settings, the existing
  profile needs to be deleted and database needs to be cleaned
  before applying the iFix and regenerating the profile.
  

Local fix

• BPM v8.0 concurrent iFix.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  users creating profiles with Microsoft SQL  *
  *                  Server Databases using Microsoft SQL Server *
  *                  authentication.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: With SQL Server db using SQL Server     *
  *                      authentication SCA, CEI messaging       *
  *                      engines                                 *
  *                      start with exceptions.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SCA and CEI messaging engines start with exceptions during
  Standalone profile creation with SQL Server database when SQL
  Server authentication is used.
  If a Standalone profile creation was created using SQL Server
  database and if the SQL Server authentication was used the
  messaging engine settings for SCA System Bus, SCA Application
  Bus and CEI Bus would result in exceptions during the server
  start. This iFix resolves the issue by fixing the settings.
  If a profile is already created with the wrong settings, the
  existing profile needs to be deleted and database needs to be
  cleaned before applying the iFix and regenerating the profile.
  

Problem conclusion

• updated configSCA.ant scripts to include appropriate MS SQL Serv
  authentication information.
  

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

  BPM ADVANCED

• Fixed component ID

  5725C9400

Applicable component levels

• R750 PSY

     UP