Login

Knowledge Sharing

Home

Knowledge Base

Configuration

Database Inbound: Wrong Post Processing Configuration May Cause Listener Stop Working

Written by <a href="http://www.mydocumentum.net/component/comprofiler/userprofile/admin">Administrator</a>

Wednesday, 09 December 2009 22:30

Tags See All Tags Add New Tag...

Please Enter New Tags Separated By Comma's
Or Close

The Database Inbound activity template retrieves rows from a database table or view and creates workflows for these rows. The system creates a listener at runtime that executes the specified select statement to retrieve rows for processing. After the row is processed, a user-defined SQL statement updates or deletes the row to ensure that it not processed multiple times. A wrongly configured post processing query may cause listener stop working.

This problem is metioned in Process Integrator Release Note (6.5):

Database Inbound post-processing fails (BPS-214)
When an incorrect post-processing query is included in a Database Inbound – Initiate activity, the listener does not start the next pooling interval even after uninstalling, correcting the query, and re-installing the process. The application server must be restarted in order to start the listener.

If this problem occured, you can see similiar entries in your JMS log

2009-12-09 21:53:57,139 INFO  [STDOUT] Init Listener: 
Process - DemoDbIntegration Activity - DB Inbound - Step
2009-12-09 21:53:57,155 INFO  [STDOUT] Starting Listener: 
Process - DemoDbIntegration Activity - DB Inbound - Step
2009-12-09 21:53:57,249 INFO  [org.jboss.web.tomcat.service.TomcatDeployer] deploy, 
ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
2009-12-09 21:53:57,358 INFO  [org.jboss.deployment.EARDeployer] 
Init J2EE application: 
file:/C:/Documentum/jboss4.2.0/server/DctmServer_MethodServer/deploy/ServerApps.ear/
2009-12-09 21:53:58,499 INFO  [org.jboss.web.tomcat.service.TomcatDeployer] deploy, 
ctxPath=/DmMail, warUrl=.../deploy/ServerApps.ear/DmMail.war/
2009-12-09 21:53:58,702 INFO  [org.jboss.web.tomcat.service.TomcatDeployer] deploy, 
ctxPath=/DmMethods, warUrl=.../deploy/ServerApps.ear/DmMethods.war/
2009-12-09 21:53:58,999 INFO  [STDOUT] <DCTM>
2009-12-09 21:53:58,999 INFO  [STDOUT] <
2009-12-09 21:53:58,999 INFO  [STDOUT] INFO
2009-12-09 21:53:58,999 INFO  [STDOUT] > 
2009-12-09 21:53:58,999 INFO  [STDOUT] Documentum Java Method Server
2009-12-09 21:53:59,936 INFO  [STDOUT] <?xml version="1.0"?>
<ResultSet fullname="ResultSet">
    <ROW fullname="ROW">
        <case_number fullname="case_number" type="String">12345</case_number>
        <correlation_id fullname="correlation_id" type="String">
e9c237929bb41d6ad2cc8e648e2e096d</correlation_id>
    </ROW>
</ResultSet>
2009-12-09 21:54:00,452 INFO  [STDOUT] Shutting down Listener: 
Process - DemoDbIntegration Activity - DB Inbound - Step
2009-12-09 21:54:00,452 INFO  [STDOUT] Completed Shutting down Listener: 
Process - DemoDbIntegration Activity - DB Inbound - Step
2009-12-09 21:54:03,264 INFO  [STDOUT] <DCTM>