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 = 1can 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.