We are setting the property using a properties file that is passed to JBoss standalone.bat file using a -P parameter.
For one of my colleagues, the query fails after 2 minutes even after setting the recovery scan to happen every 15 minutes. Please see the logs below.
09:29:06,036 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue1895) START DATA SRC COMMAND: startTime=2013-02-27 09:29:06.036 requestID=kLNCOWeV9nmr.0 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain sql=*******
09:29:06,036 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue1895) START DATA SRC COMMAND: startTime=2013-02-27 09:29:06.036 requestID=kLNCOWeV9nmr.0 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain sql=*******
09:29:06,083 INFO [com.lgc.ow.teiid.translator.OWTBaseExecution] (Worker2_QueryProcessorQueue1895) Executing Openworks Query:*******
09:29:11,911 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-2) closeSession hwEnXA1Q5rZk
09:29:11,911 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-2) closeSession hwEnXA1Q5rZk
09:30:32,680 FINEST [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.connection] (Thread-81) release_connection __EclipseLinkSessionId__: 44808654
09:30:32,680 FINER [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.transaction] (Thread-81) release_unit_of_work __EclipseLinkSessionId__: 1492411530
09:30:32,680 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #2-1) CANCEL SRC COMMAND: endTime=2013-02-27 09:30:32.68 requestID=kLNCOWeV9nmr.0 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=-1
09:30:32,680 FINER [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.connection] (Thread-81) client_released __EclipseLinkSessionId__: 460637763
09:30:32,680 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #2-1) CANCEL SRC COMMAND: endTime=2013-02-27 09:30:32.68 requestID=kLNCOWeV9nmr.0 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=-1
09:30:32,695 INFO [com.lgc.ow.teiid.translator.OWTBaseExecution] (New I/O server worker #2-1) Canceling execution. Rollback
09:30:32,695 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1922) END SRC COMMAND: endTime=2013-02-27 09:30:32.695 requestID=kLNCOWeV9nmr.0 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=4608
09:30:32,695 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1922) END SRC COMMAND: endTime=2013-02-27 09:30:32.695 requestID=kLNCOWeV9nmr.0 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=4608
09:30:32,695 INFO [com.lgc.ow.teiid.translator.OWTBaseExecution] (Worker1_QueryProcessorQueue1922) Closing Execution
09:30:53,071 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
09:30:53,071 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
09:32:53,669 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
09:32:53,669 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
09:34:31,639 FINER [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.connection] (http--0.0.0.0-8080-1) client_acquired __EclipseLinkSessionId__: 44808654
09:34:31,639 FINER [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.transaction] (http--0.0.0.0-8080-1) acquire_unit_of_work_with_argument __EclipseLinkSessionId__: 346687050
09:34:31,639 FINEST [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.query] (http--0.0.0.0-8080-1) execute_query __EclipseLinkSessionId__: 646115039
09:34:31,655 FINEST [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.connection] (http--0.0.0.0-8080-1) acquire_connection __EclipseLinkSessionId__: 44808654
09:34:31,655 FINE [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.sql] (http--0.0.0.0-8080-1) ******* WHERE (SOURCE_NAME = ?)
bind => [WELLS_100K_NAD27] __EclipseLinkSessionId__: 44808654
09:34:31,686 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue1924) START DATA SRC COMMAND: startTime=2013-02-27 09:34:31.686 requestID=kLNCOWeV9nmr.1 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain sql=******
09:34:31,686 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue1924) START DATA SRC COMMAND: startTime=2013-02-27 09:34:31.686 requestID=kLNCOWeV9nmr.1 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain sql=**********
09:34:31,717 INFO [com.lgc.ow.teiid.translator.OWTBaseExecution] (Worker5_QueryProcessorQueue1924) Executing Openworks Query:**************
09:34:53,671 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
09:34:53,671 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
09:36:32,706 FINEST [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.connection] (Thread-81) release_connection __EclipseLinkSessionId__: 44808654
09:36:32,706 FINER [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.transaction] (Thread-81) release_unit_of_work __EclipseLinkSessionId__: 646115039
09:36:32,706 FINER [org.eclipse.persistence.session.vfs:/C:/landmark/jboss-as-7.1.1.Final/bin/content/dsdataserver.war/WEB-INF/classes/_teiidDynamicUnit_url=jdbc:teiid:OW_TEIID@mm://134.132.115.7:31000;ApplicationName=openworks_user=user.connection] (Thread-81) client_released __EclipseLinkSessionId__: 346687050
09:36:32,706 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #2-1) CANCEL SRC COMMAND: endTime=2013-02-27 09:36:32.706 requestID=kLNCOWeV9nmr.1 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=-1
09:36:32,706 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #2-1) CANCEL SRC COMMAND: endTime=2013-02-27 09:36:32.706 requestID=kLNCOWeV9nmr.1 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=-1
09:36:32,706 INFO [com.lgc.ow.teiid.translator.OWTBaseExecution] (New I/O server worker #2-1) Canceling execution. Rollback
09:36:32,706 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue1948) END SRC COMMAND: endTime=2013-02-27 09:36:32.706 requestID=kLNCOWeV9nmr.1 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=4608
09:36:32,706 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue1948) END SRC COMMAND: endTime=2013-02-27 09:36:32.706 requestID=kLNCOWeV9nmr.1 sourceCommandID=3 txID=null modelName=5000_10 translatorName=delegate sessionID=kLNCOWeV9nmr principal=user@dsds-security-domain finalRowCount=4608
09:36:32,706 INFO [com.lgc.ow.teiid.translator.OWTBaseExecution] (Worker4_QueryProcessorQueue1948) Closing Execution
09:36:53,675 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
09:36:53,675 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Keep-alive ping received for session: kLNCOWeV9nmr
</p>