Hi All,

We have been getting the following error in MWS logs since a last few days. Not sure about the reason. We are running MWS 7.1.3 with Fix 18. We suspected that it is fix 18 that caused the issue but uninstalling and installing back didn’t fix the issue. The server starts up but we are not able to login to the server as the page gives null pointer exception with more Oracle errors in the logs.

Can anyone suggest how to fix these errors or to find the source of such errors?

[i]2013-10-02 15:08:24 EST (notifications : FATAL) - Subscription delivery failed
java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: “LOCATE”: invalid identifier

at com.wm.dd.jdbc.oraclebase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions40.createSQLException(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseStatement.commonExecute(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseStatement.executeQueryInternal(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BasePreparedStatement.executeQuery(Unknown Source)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQuery(BaseSqlWorker.java:491)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQuery(BaseSqlWorker.java:448)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQuery(BaseSqlWorker.java:424)
at com.webmethods.portal.service.sql.runtime.base.SubMatchList.executeQuery(SubMatchList.java:107)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQueryProcResult(BaseSqlWorker.java:672)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQueryProcResult(BaseSqlWorker.java:637)
at com.webmethods.portal.portlet.wm_subscriptionagent.SubscriptionAgentDeliverer.findSubscriptions(SubscriptionAgentDeliverer.java:197)
at com.webmethods.portal.portlet.wm_subscriptionagent.SubscriptionAgentDeliverer.matchSubscriptions(SubscriptionAgentDeliverer.java:145)
at com.webmethods.portal.portlet.wm_subscriptionagent.SubscriptionAgentDeliverer.onEvent(SubscriptionAgentDeliverer.java:72)
at com.webmethods.portal.event.IPortalEvent$Listeners$Listener.onEvent(IPortalEvent.java:40)
at com.webmethods.rtl.event.BaseListeners$ObjectEvListener.onEvent(BaseListeners.java:72)
at com.webmethods.rtl.event.EventDeliverer.deliver(EventDeliverer.java:79)
at com.webmethods.rtl.event.AsynchronousDeliverer$1.run(AsynchronousDeliverer.java:93)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

[/i]

appreciate your help,
Thanks and Regards,
Ninad Patil

You can fix all types of errors related to Oracle database file with the help of professional and trusted Oracle file repair tool. Such recovery tool has specifically made to deeply scan the Oracle database and fix all types of errors.
Visit - http://oracle.filerepairtool.net/ to know more.