IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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
  • 1.  Cannot initialize MWS, invalid database schema is specified

    Posted Thu April 18, 2019 04:11 AM

    We are receiving the following errors every 10 seconds in server.log, have been unable to track down where it could possibly be coming from. Any thoughts or suggestions are much appreciated?

    2019-04-17 10:58:23 CDT [ISS.0095.0013I] Audit Logging initialized.
    2019-04-17 10:58:24 CDT [ISS.0033.0168C] Cluster Node Name: xxx.yyyy.zzzz.
    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] Initializing component: com.webMethods.rtl.util.xml.XMLUtil
    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] Loading phase: [phaseID, phaseName] [miePhaseTwo, miePhaseTwo]
    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] Initializing components of: miePhaseTwo
    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] Initializing component: com.webMethods.portal.service.sql.core.ConnectionManager
    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] No registered exception delegate
    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] webMethods Integration Server Shutting down…
    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] StackTrace for shutdown - this is an expect info message only :
    java.lang.Thread.getStackTrace(Thread.java:1556)
    com.webMethods.portal.system.PortalSystem.shutdown(PortalSystem.java:959)
    com.webMethods.portal.system.PortalSystem.main(PortalSystem.java:879)
    com.webMethods.sc.mws.MWSLibrary.init(MWSLibrary.java:271)
    com.wm.app.b2b.server.cds.CDSUserManager.initialize(CDSUserManager.java:187)
    com.wm.app.b2b.server.UserManager.jndiInit(UserManager.java:589)
    com.wm.app.b2b.server.UserManager.init(UserManager.java:520)
    com.wm.app.b2b.server.Server.run(Server.java:515)

    2019-04-17 10:58:24 CDT [CommonLib.MWS.0002I] Stopped sending JDK log messages to Log4j
    2019-04-17 10:58:24 CDT [ISS.0024.0010C] Central User Manager initialization failed with error : [POP.004.0201] Cannot initialize MWS, invalid database schema is specified
    2019-04-17 10:58:24 CDT [ISS.0024.0001E] Could not initialize User Manager.


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Cannot initialize MWS, invalid database schema is specified

    Posted Thu April 18, 2019 12:43 PM

    Hi Patrick,

    looks like you have configured the Central Users Pool in IS for using Central User Management, but did not start the MWS before starting IS.

    MWS needs to be started once using this MWS database schema to initializie its default user, groups and roles.
    After this initialization is completed, restart your IS and the Central Users feature will be enabled in IS.

    Regards,
    Holger


    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Cannot initialize MWS, invalid database schema is specified

    Posted Fri April 19, 2019 09:31 AM

    Thanks, we tried that and still did not work, are you aware of a way we can review the MWS database to make sure everything was initialized correctly ( default user, groups and roles).

    Also, we can’t find where the 10 second check is coming from, any thoughts on that?


    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Cannot initialize MWS, invalid database schema is specified

    Posted Sat April 20, 2019 01:13 AM

    To set or modify external database connections, use the mws.db.xml file, which you can find at this
    location:
    Software AG_directory\MWS\server\serverName \config
    You need to specify the following values:
    Element Value
    The URL to the database server
    The database user name
    The password of the database user
    After you save and close the ms.db.xml file, start My webMethods Server.

    Configuring Whether Diagnostics Are Executed at Startup
    By default at startup, My webMethods Server performs the following diagnostic actions:
    Determines the fixes that have been applied to My webMethods Server
    Executes the dbintegritycheck tool that searches for potential database errors
    You can prevent My webMethods Server from performing one or both of
    these diagnostic actions by updating the phaseProvider.xml configuration file.
    The phaseProvider.xml configuration file is located in the database or under
    My webMethods Server_directory\server\serverName \config.

    Preventing My webMethods Server from Executing dbintegritycheck at Startup
    The My webMethods Server automatically executes the dbintegritycheck tool at startup
    and logs the results to the full.log file. The dbintegritycheck tool reviews the dynamic
    business objects (DBOs) deployed to My webMethods Server to search for potential
    errors that might have occurred if a DBO was installed or upgraded incorrectly.
    Although it is recommended that you keep this action enabled, you can prevent My
    webMethods Server from executing dbintegritycheck at startup. To do so, edit the
    startupDiagnostics section of the phaseProvider.xml configuration file as shown
    below.

    .
    .
    .


    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: Cannot initialize MWS, invalid database schema is specified

    Posted Tue April 23, 2019 11:58 AM

    Is your MWS started and accessible?
    Can you login to it with Administrator/manage?

    Regards,

    If so, this indicates that the MWS schema was initialized correctly.
    If not, check the MWS logs for error during startup.

    Both, MWS and IS, have to point to the same database schema for enabling Central User Management in IS successfully.

    Regards,
    Holger


    #Integration-Server-and-ESB
    #webMethods