webMethods Knowlegebase : ORA-00959: tablespace 'WEBMDATA' does not exist. (1754645)

Problem

When deploying a task to MWS along with the task application and portlet it appears to succeed in the Deployer screen; however, while tailing the MWS server log the following error appears and the portlet is not available in MWS admin screen.

2014-04-02 13:19:08 PDT (Framework:FATAL) - [POP.001.0002] A "java.sql.SQLException" occurred with the Message "[SoftwareAG][Oracle JDBC Driver ][Oracle]ORA-00959: tablespace 'WEBMDATA' does not exist

"

java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00959: tablespace 'WEBMDATA' does not exist

at com.wm.dd.jdbc.oraclebase.ddcg.b(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcg.a(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcf.b(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcf.a(Unknown Source)

at com.wm.dd.jdbc.oracle.ddn.s(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddes.v(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddes.x(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddes.executeUpdate(Unknown Source)

at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeUpdate(BaseSqlWorker.java:346)

at com.webmethods.portal.service.meta2.dbo.SQLStatement.executeInternal(SQLStatement.java:99)

at com.webmethods.portal.service.meta2.dbo.SQLStatement.execute(SQLStatement.java:56)

at com.webmethods.portal.service.meta2.dbo.SQLStatement.execute(SQLStatement.java:51)

at com.webmethods.portal.bizPolicy.biz.task.impl.TaskDBOHelper.executeUpdate(TaskDBOHelper.java:528)

at com.webmethods.portal.bizPolicy.biz.task.impl.TaskDBOHelper.createTable(TaskDBOHelper.java:143)

at com.webmethods.portal.portlet.wm_xt_task_definition.mechanics.Task_definitionMechanics.updateProperties(Task_definitionMechanics.java :187)

at com.webmethods.portal.mech.storage.impl.BasicMechanics.create(BasicMechanics.java:2556)

at com.webmethods.portal.mech.storage.impl.ContainerMechanics.createChild(ContainerMechanics.java:1391)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.createNode(XMLImport.java:804)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.importNode(XMLImport.java:499)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.xmlImportList(XMLImport.java:379)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImportContext.importNode(XMLImportContext.java:92)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.xmlImportList(XMLImport.java:379)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.xmlImport(XMLImport.java:321)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.xmlImport(XMLImport.java:269)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImportInclude.importNode(XMLImportInclude.java:56)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.xmlImportList(XMLImport.java:379)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.xmlImport(XMLImport.java:321)

at com.webmethods.portal.bizPolicy.command.system.xml.XMLImport.xmlImport(XMLImport.java:269)

at com.webmethods.portal.framework.mech.install.PortletAppilcationInstallMechanics.importFile(PortletAppilcationInstallMechanics.java:46 5)

at com.webmethods.portal.framework.mech.install.PortletAppilcationInstallMechanics.importFiles(PortletAppilcationInstallMechanics.java:3 16)

at com.webmethods.portal.framework.mech.install.PortletAppilcationInstallMechanics.installComponent(PortletAppilcationInstallMechanics.j ava:299)

at com.webmethods.portal.mech.install.impl.BasicInstallMechanics.installComponentSafe(BasicInstallMechanics.java:981)

at com.webmethods.portal.bizPolicy.command.install.InstallComponent.installComponentLocal(InstallComponent.java:143)

at com.webmethods.portal.bizPolicy.command.install.InstallComponent.installComponent(InstallComponent.java:77)

at com.webmethods.portal.bizPolicy.command.install.InstallComponent.installComponent(InstallComponent.java:189)

at com.webmethods.portal.bizPolicy.biz.install.impl.InstallPolicy.onSynchronousEvent(InstallPolicy.java:157)

at com.webmethods.portal.event.install.IComponentDeploymentEvent$SynchronousListeners$SynchronousListener.onEvent(IComponentDeploymentEv ent.java:59)

at com.webmethods.rtl.event.BaseListeners$ObjectEvListener.onEvent(BaseListeners.java:72)

at com.webmethods.rtl.event.EventDeliverer.deliver(EventDeliverer.java:82)

at com.webmethods.rtl.event.SynchronousDeliverer.add(SynchronousDeliverer.java:29)

at com.webmethods.rtl.event.DeliveryService.raiseRemoteEvent(DeliveryService.java:70)

at com.webmethods.rtl.event.RemoteDeliverer$IbDeliverer.run(RemoteDeliverer.java:274)

When the environment was initially set up, the dbconfigurator was run and the tablespaces were named WEBM_DATA and WEBM_INDX. These were also installed in the database, yet MWS appears to attempt to connect to a tablespace that does not exist.