Hi,
I am getting the following error when a notification (with dynamic subject) for a task creation is send to the assignee. it looks like the task can’t be find in the inboxes. Help please…
08-10 17:25:11 CEST (notifications : DEBUG) - SubscriptionDeliverer, got portal event, thing_id = /meta/default/basic/0000012400
2010-08-10 17:25:12 CEST (notifications : DEBUG) - EmailAgent: get event com.webMethods.portal.service.notification.deliver y.SubscriptionDeliveryEvent
2010-08-10 17:25:12 CEST (task : DEBUG) - User Tasks Task Search Query [max:2147483647]{taskID = 29126}
2010-08-10 17:25:12 CEST (task : DEBUG) - User Tasks Task Search Query [max:2147483647]{taskID = 29126}
2010-08-10 17:25:12 CEST (task : DEBUG) - User Tasks Task Search Query [max:2147483647]{taskID = 29126}
2010-08-10 17:25:12 CEST (notifications : FATAL) - [POP.001.0002] A “java.sql.SQLException” occurred with the Message "[wm-cjdbc36-0039][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
"
java.sql.SQLException: [wm-cjdbc36-0039][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
at com.wm.dd.jdbc.base.BaseExceptions.createException (Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Un known Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute( Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Un known Source)
at com.wm.dd.jdbc.base.BaseStatement.executeQueryInte rnal(Unknown Source)
at com.wm.dd.jdbc.base.BasePreparedStatement.executeQ uery(Unknown Source)
at com.webmethods.portal.service.sql.core.BaseSqlWork er.executeQuery(BaseSqlWorker.java:458)
at com.webmethods.portal.service.sql.runtime.base.Tas kSearchFromInboxes.executeQuery(TaskSearchFromInboxes.java:45)
at com.webmethods.portal.service.sql.core.BaseSqlWork er.executeQueryProcResult(BaseSqlWorker.java:639)
at com.webmethods.portal.service.sql.core.BaseSqlWork er.executeQueryProcResult(BaseSqlWorker.java:604)
at com.webmethods.portal.service.task.impl.TaskDistri butionService.searchUserTasks(TaskDistributionService.java:286)
at com.webmethods.portal.mech.task.impl.TaskMechanics .listTasks(TaskMechanics.java:1275)
at com.webmethods.portal.mech.task.impl.TaskMechanics .isTaskAssignedToPrincipal(TaskMechanics.java:1141 )
at com.webmethods.portal.mech.task.impl.TaskMechanics .canDeliverToPrincipal(TaskMechanics.java:394)
at com.webmethods.portal.widget.impl.wm_emailagent.Ev entProcessor.processEvent(EventProcessor.java:123)
at com.webMethods.portal.widget.impl.wm_emailagent.Em ailNotificationDeliverer$DbWorker.run(EmailNotificationDeliverer.java:168)