PM67022: Merging Workspaces as 'normal' users creates Views with wrong schema

APAR status

• Closed as program error.

Error description

• Configuration:
  --------------
  Tool = Rational System Architect
  Version = 11.4.1.1
  
  Description:
  ------------
  Merging Workspaces as 'normal' users creates Views with wrong
  schema
  
  Work Around:
  ----------------
  Manually change teh owner schema for the created views to dbo
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Views created in SASP_WorkspacesViewsUpdate are not
  explicitly set to be created in dbo schema.
  

Problem conclusion

• Views are created in users default schema.
  
  
  The easy workaround here is in SQL Server Management Studio
  to set the users default schema to dbo:
  
  Under the server name expand logins
  Double-click on the user
  In the Login Properties dialog for User Mapping, select the
  database (SA encycloepdia)
  Hit the elipses button for Default schema
  Type dbo
  Hit Check Names
  Hit OK
  Hit OK on the Login Properties dialog
  

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

  TLOGIC SYS ARCH

• Fixed component ID

  5724V68SX

Applicable component levels

• RB41 PSN

     UP