webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

URGENT:-- DB Configurator script creating tables inside dbo schema instead of specific schema

  • 1.  URGENT:-- DB Configurator script creating tables inside dbo schema instead of specific schema

    Posted Fri February 21, 2014 06:21 AM

    Hello,

    When we are trying to run the below script, it is creating the table inside the default dbo schema. We are running
    the configurator for TN table creation. The database is SQL server,

    ./dbConfigurator.sh -a drop -d sqlserver -c TNS -v latest -l “jdbc:wm:sqlserver://157.184.229.183:1433;databaseName=wmdbden6” -u WMTN -p WMTN -n WMDBDEN6_FG1

    WMDBDEN6_FG1 is the file group inside the SQL server database wmdbden6. Ideally it should have created the
    tables inside the WMTN schema which is already defined. Can you please let me know if anything is wrong with the
    script. We have also tried the below script with same results.

    1. ./dbConfigurator.sh -a drop -d sqlserver -c TNS -v latest -l “jdbc:wm:sqlserver://157.184.229.183:1433;databaseName=wmdbden6” -u WMTN -p WMTN -n “WMDBDEN6_FG1.WMTN”

    2. ./dbConfigurator.sh -a drop -d sqlserver -c TNS -v latest -l “jdbc:wm:sqlserver://157.184.229.183:1433;databaseName=wmdbden6;schemaName=WMTN” -u WMTN -p WMTN -n WMDBDEN6_FG1

      screenshot_after running script.JPGhttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/41638552fa83e043602f7975a9a1cd03771c26a0.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/41638552fa83e043602f7975a9a1cd03771c26a0.jpeg 2x" data-dominant-color="F1F1F0">
      screenshot_after running script.JPG331×506 41.4 KB

      Capture_before running script.JPG


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 2.  RE: URGENT:-- DB Configurator script creating tables inside dbo schema instead of specific schema

    Posted Fri February 21, 2014 12:28 PM

    I think all tables suppose to be owned by DBO, so they should be viewable under dbo.
    pls check with your DBA.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 3.  RE: URGENT:-- DB Configurator script creating tables inside dbo schema instead of specific schema

    Posted Mon February 24, 2014 10:53 AM

    Yes please check with your DBA/owner of the TN schema unless your db configurator shows it ran successfully and it shows the table counts.

    HTH,
    RMG


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 4.  RE: URGENT:-- DB Configurator script creating tables inside dbo schema instead of specific schema

    Posted Tue February 25, 2014 10:19 AM

    Hello All,

    Thanks for your responses. However the issue has been resolved by restricting the access of the individual users.
    Earlier all the users had sysadmin/sysdba level of access , thats why they were creating the tables inside the dbo
    schema as default schema for sysdba in MS Sql is dbo. Now the access has been restructed to only create and drop
    and the user has been mapped to the schema ( which is not a default case in MS SQL. In oracle user is automatically mapped to schema). Now it is creating the tables inside respective schema.

    Thanks and Regards
    Abir Banerjee


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: URGENT:-- DB Configurator script creating tables inside dbo schema instead of specific schema

    Posted Tue February 25, 2014 10:46 AM

    Yes that is correct…glad to hear the issue resolved now: :smiley:


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


Related Content