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

Subscribe

You can track all active APARs for this component.

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 number

    PM67022

  • Reported component name

    TLOGIC SYS ARCH

  • Reported component ID

    5724V68SX

  • Reported release

    B41

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-18

  • Closed date

    2012-09-28

  • Last modified date

    2012-09-28

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational System Architect XT

Software version:

11.4.1

Reference #:

PM67022

Modified date:

2012-09-28

Translate my page

Machine Translation

Content navigation