IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

Error while notifying a user on a task queued

  • 1.  Error while notifying a user on a task queued

    Posted 08/16/10 02:14 PM

    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)


    #webMethods-BPMS
    #webMethods
    #MWS-CAF-Task-Engine