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

unable to start the mywebmethods server 7.1.1 with oracle 9i

  • 1.  unable to start the mywebmethods server 7.1.1 with oracle 9i

    Posted Thu February 21, 2008 10:29 AM

    Hi All,

    i am using mywebmethods server 7.1.1 in windows xp operating system and oracle 9i,i have created mywebmethods server instance by using command C:\webMethods7.1.1\MWS\bin\mws new -Dserver.name=test -Dhttp.port=8585 -Ddb.type=oracle -Ddb.url=jdbc:wm:oracle://localhost:1521;serviceName=Anil -Ddb.username=scott -Ddb.password=tiger

    new instance folder with name test has been created in the C:\webMethods7.1.1\MWS\server\test in windows xp operating system.

    if i start the test server i used the command C:\webMethods7.1.1\MWS\bin>mws -s test run ,the server test is started in the console showing error that

    2008-02-21 20:32:23 GMT+05:30 (Framework : FATAL) - [POP.004.0201] Cannot initia
    lize MWS, invalid database schema is specified
    com.webMethods.portal.system.init.InitializationException: [POP.004.0201] Cannot
    initialize MWS, invalid database schema is specified
    at com.webMethods.portal.service.sql.core.ConnectionManager.validateData
    source(ConnectionManager.java:655)
    at com.webMethods.portal.service.sql.core.ConnectionManager.init(Connect
    ionManager.java:270)
    at com.webMethods.portal.service.sql.core.ConnectionManager.init(Connect
    ionManager.java:212)
    at com.webMethods.portal.service.sql.core.ConnectionManager.init(Connect
    ionManager.java:178)
    at com.webMethods.portal.system.init.impl.DefaultPhase$InitializableWrap
    per.init(DefaultPhase.java:118)
    at com.webMethods.portal.system.init.impl.DefaultPhase.initComponent(Def
    aultPhase.java:99)
    at com.webMethods.portal.system.impl.BaseProvider.initComponents(BasePro
    vider.java:509)
    at com.webMethods.portal.system.impl.BaseProvider.init(BaseProvider.java
    :125)
    at com.webMethods.portal.system.init.impl.DefaultPhase.init(DefaultPhase
    .java:44)
    at com.webMethods.portal.system.init.impl.DefaultPhaseProvider.initCompo
    nent(DefaultPhaseProvider.java:257)
    at com.webMethods.portal.system.impl.BaseProvider.initComponents(BasePro
    vider.java:509)
    at com.webMethods.portal.system.impl.BaseProvider.init(BaseProvider.java
    :125)
    at com.webMethods.portal.system.init.impl.DefaultPhaseProvider.initializ
    ePhases(DefaultPhaseProvider.java:89)
    at com.webMethods.portal.system.PortalSystem.init(PortalSystem.java:867)

        at com.webmethods.portal.system.PortalSystem.main(PortalSystem.java:826)
    
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    

    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.webMethods.portal.system.start.Main.start(Main.java:126)
    at com.webMethods.portal.system.start.Main.main(Main.java:47)
    2008-02-21 20:32:23 GMT+05:30 (Framework : INFO) - Shutting down…
    2008-02-21 20:32:23 GMT+05:30 (Framework : INFO) - Shutting down components of:
    MWS
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: int
    ernalservers
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: mie
    phasetwo
    2008-02-21 20:32:23 GMT+05:30 (Framework : INFO) - Shutting down components of:
    miePhaseTwo
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: ico
    nmaputil
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: mim
    eutil
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: mai
    lutil
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: glo
    bal
    2008-02-21 20:32:23 GMT+05:30 (Framework : INFO) - Shutting down components of:
    global
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: lan
    guagepackmanager
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: res
    ourceloader
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: mes
    sageformatter
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: cla
    ssmanager
    2008-02-21 20:32:23 GMT+05:30 (Framework : INFO) - Shutting down components of:
    classManager
    2008-02-21 20:32:23 GMT+05:30 (Framework : DEBUG) - Shutting down Component: clu
    ster
    2008-02-21 20:32:23 GMT+05:30 (Framework : INFO) - Shutting down components of:
    cluster
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: ser
    ver_master
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: mie
    phaseone
    2008-02-21 20:32:24 GMT+05:30 (Framework : INFO) - Shutting down components of:
    miePhaseOne
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: mem
    orymonitor
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: xsl
    processorfactory
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: xml
    util
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: fil
    eiomanager
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: thr
    eadutil
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: deb
    ug
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: bui
    ldutils
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: sys
    tempaths
    2008-02-21 20:32:24 GMT+05:30 (Framework : DEBUG) - Shutting down Component: fil
    eutil
    2008-02-21 20:32:24 GMT+05:30 (Framework : INFO) - Shutdown complete.

    than i opened the db.xml file which is there in the location C:\webMethods7.1.1\MWS\server\test\config it conatins

    com.webmethods.portal.service.sql.core.BaseSqlWorker com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider com.wm.dd.jdbc.oracle.OracleDriver jdbc:wm:oracle://localhost:1521;serviceName=Anil scott {DES}lVSvxp86ElQ= 100 false SELECT COUNT(*) FROM TBLTHING WHERE IDTHING = 1

    can anyone help me what is the mistake in schema,if not wrong in db.xml tell me what could be reason to get above error.

    if i am wrong in starting the mywebmethods server 7.1.1 tell me scenario to start.


    #webMethods-BPMS
    #webMethods
    #MWS-CAF-Task-Engine