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