RS03632: 'CREATE TRIGGER' MUST BE THE FIRST STATEMENT IN A QUERY BATCH ERROR WHEN CREATING A DC REPOSITORY USING MSSQLSERVER MGMT STUDIO

Operational Decision Manager V8.10.2.2 Interim Fix 11 for Decision Center
IBM Operational Decision Manager V8.10.5 Download Document
IBM Operational Decision Manager V8.10.5 Refresh Pack

APAR status

• Closed as program error.

Error description

• Running tables creation script on SQLServer using MS SQL Server
  Management Studio fails because the CREATE TRIGGER statement
  should be the first statement in a transaction.
  
  'CREATE
  TRIGGER' must be the first statement in a query batch
  'CREATE
  VIEW' must be the first statement in a query batch
  

Local fix

• insert a GO statement before create VIEW and create TRIGGER
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users running MMS SQL Server.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Running tables creation script on SQLServer using MS SQL     *
  * Server Management Studio fails because the CREATE TRIGGER    *
  * statement should be the first statement in a transaction.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• 'CREATE TRIGGER' must be the first statement in a query batch
  'CREATE VIEW' must be the first statement in a query batch
  

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

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R892 PSY

     UP