unable to start the mywebmethods server 7.1.1 with oracle 9i

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
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.

hi im also getting the same error. did you figure out the solution

Hi,

Is it the 1st instance or 2nd instance?Have you started the MWS at least once?

  1. Please use the Database Component Configurator to create a unique database or tablespace for this server instance. You can refer to the webMethods Installation Guide.

  2. Make sure <webMethods_dir>\MWS\server\test\config\mws.db.xml exists and the database information in the file are correct.

please take note that

  1. each MWS instance must have its own database. for a given database server, the following configuration entries must be unique among all mws instances that use the same database server:
  • database user name
  • database name
  1. for MWS instances running concurrently on the same machine, the following host/port number, if used, must be unique among all servers:
  • HTTP port
  • HTTPS port (if used)
  • AJP13 port and IIS or Apache Web server host and port (if Used)