DEBUG [http-8080-Processor25] (MetaDataExtractor.java:39) - Extracting dynamic service data {http://ogsadai.org.uk/namespaces/2003/07/gdsf}databaseSchema
 INFO [http-8080-Processor25] (MetaDataExtractor.java:65) - No User Certificate Provided. Setting Default DN.
 INFO [http-8080-Processor25] (MetaDataExtractor.java:71) - UserCertificateDN:
No Certificate Provided
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:93) - Preparing to Connect to Database Prior to Meta-Data Extraction
DEBUG [http-8080-Processor25] (SimpleJDBCDataResourceImplementation.java:84) - Entering getConnection()
DEBUG [http-8080-Processor25] (SimpleJDBCDataResourceImplementation.java:89) - RoleMapper class is uk.org.ogsadai.common.rolemap.SimpleFileRoleMapper
DEBUG [http-8080-Processor25] (DataResourceImplementation.java:137) - Credentials to map = No Certificate Provided
DEBUG [http-8080-Processor25] (DataResourceImplementation.java:158) - Set username to : ogsadai
DEBUG [http-8080-Processor25] (DataResourceImplementation.java:159) - Set password to : abcd
DEBUG [http-8080-Processor25] (SimpleJDBCDataResourceImplementation.java:94) - Set username to : ogsadai
DEBUG [http-8080-Processor25] (SimpleJDBCDataResourceImplementation.java:95) - Set password to : abcd
DEBUG [http-8080-Processor25] (FileConnection.java:20) - systemdir = /scratch/k2/dqp
DEBUG [http-8080-Processor25] (FileDatabaseMetaData.java:42) - systemdir = /scratch/k2/dqp
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tables.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (TABLE_CAT, 12, VARCHAR, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (TABLE_SCHEM, 12, VARCHAR, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (TABLE_NAME, 12, VARCHAR, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (TABLE_TYPE, 12, VARCHAR, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (TABLE_FILENAME, 12, VARCHAR, 256)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (METADATA_FILENAME, 12, VARCHAR, 256)
DEBUG [http-8080-Processor25] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [http-8080-Processor25] (Row.java:40) - Number of bytes available = 290
DEBUG [http-8080-Processor25] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [http-8080-Processor25] (FileDatabaseMetaData.java:59) - mtables = [file1 file1 file1 TABLE /scratch/k2/dqp/data/file1.data /scratch/k2/dqp/data/file1.data.schema ]
[file2 file2 file2 TABLE /scratch/k2/dqp/data/file2.data /scratch/k2/dqp/data/file2.data.schema ]
[ipars ipars ipars TABLE /scratch/k2/dqp/data/ipars-mini.data /scratch/k2/dqp/data/ipars.data.schema ]

DEBUG [http-8080-Processor25] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file1.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:40) - binary line = binary
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file1.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (F1, 4, INTEGER, 5)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (F2, 6, FLOAT, 6)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (F3, 4, INTEGER, 5)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (F4, 6, FLOAT, 6)
DEBUG [http-8080-Processor25] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file2.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file2.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (A1, 4, INTEGER, 5)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (A2, 6, FLOAT, 6)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (A3, 4, INTEGER, 5)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (A4, 6, FLOAT, 6)
DEBUG [http-8080-Processor25] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:40) - binary line = binaryle
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:57) - File is little endian swap bytes effective
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:63) - ncols = 10
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (RID, 4, INTEGER, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (TIME, 4, INTEGER, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (X, 6, FLOAT, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Y, 6, FLOAT, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Z, 6, FLOAT, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (VX, 6, FLOAT, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (VY, 6, FLOAT, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (VZ, 6, FLOAT, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (SOIL, 6, FLOAT, 4)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARBINARY has sql code -3
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (BLOB, -3, VARBINARY, 48)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tablestatus.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Name, 12, VARCHAR, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Row_format, 12, VARCHAR, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Rows, 4, INTEGER, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Avg_row_length, 4, INTEGER, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Data_length, 4, INTEGER, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Index_length, 4, INTEGER, 10)
DEBUG [http-8080-Processor25] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [http-8080-Processor25] (Row.java:40) - Number of bytes available = 90
DEBUG [http-8080-Processor25] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [http-8080-Processor25] (FileDatabaseMetaData.java:88) - mtableStatus = [file1 FIXED 4 30 121313 1212 ]
[file2 DYNAMIC 4 40 1213232 1212 ]
[ipars FIXED 4 30 121313 1212 ]

DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/variables.data.schema
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:63) - ncols = 2
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Variable_name, 12, VARCHAR, 10)
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor25] (FileResultSetMetaData.java:74) - added field (Value, 4, INTEGER, 10)
DEBUG [http-8080-Processor25] (Row.java:30) - row is assumed to have ncols  = 2
DEBUG [http-8080-Processor25] (Row.java:40) - Number of bytes available = 48
DEBUG [http-8080-Processor25] (InMemoryResultSet.java:49) - Added 2 rows to inmemorytable
DEBUG [http-8080-Processor25] (FileDatabaseMetaData.java:104) - mVariables = [max_join_size 33434343 ]
[join_buffer_size 121212 ]

DEBUG [http-8080-Processor25] (SimpleJDBCDataResourceImplementation.java:112) - Exiting getConnection
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:101) - Connected to Database
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:70) - Preparing to Extract Database Schema
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:89) - Extracted Database MetaData
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:90) - Driver Name:stormjdbcdriver
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:91) - Driver Version:1.0
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:92) - User Name:ogsadai
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:93) - URL:jdbc:storm://localhost:5555/stormdb
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:102) - Extracting Table MetaData
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:113) - Table Name: file1
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F1
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F2
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F3
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F4
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:102) - Extracting Table MetaData
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:113) - Table Name: file2
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A1
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A2
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A3
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A4
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:102) - Extracting Table MetaData
DEBUG [http-8080-Processor25] (MySQLMetaDataExtractor.java:113) - Table Name: ipars
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: RID
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: TIME
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: X
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: Y
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: Z
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: VX
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: VY
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: VZ
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: SOIL
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: BLOB
DEBUG [http-8080-Processor25] (SimpleJDBCMetaDataExtractor.java:111) - Extracted Database Meta-Data
DEBUG [http-8080-Processor24] (GridDataServiceFactoryCallback.java:67) - Creating GDS.
DEBUG [http-8080-Processor24] (GridDataService.java:122) - Constructor: start
DEBUG [http-8080-Processor24] (GridDataService.java:131) - Constructing the engine.
DEBUG [http-8080-Processor24] (ActivityEngine.java:61) - Constructing Activity Engine.
DEBUG [http-8080-Processor24] (GridDataService.java:137) - GridDataService object successfully constructed.
DEBUG [http-8080-Processor24] (GridDataService.java:157) - Preparing service data
DEBUG [http-8080-Processor24] (GridDataService.java:161) - Adding activity types SDE
DEBUG [http-8080-Processor24] (GridDataService.java:170) - Adding document schema SDE
DEBUG [http-8080-Processor24] (GridDataService.java:180) - Adding SDE request status.
DEBUG [http-8080-Processor24] (GridDataService.java:149) - Constructor: end
DEBUG [http-8080-Processor24] (GridDataService.java:207) - perform: start
DEBUG [http-8080-Processor24] (GridDataService.java:212) - Trying to deserialize perform document
DEBUG [http-8080-Processor24] (GridDataService.java:217) - Perform document: <?xml version="1.0" encoding="UTF-8"?>
<gridDataServicePerform xsi:schemaLocation="http://ogsadai.org.uk/namespaces/2003/07/gds/types   ../../../../schema/ogsadai/xsd/activities/activities.xsd" xmlns="http://ogsadai.org.uk/namespaces/2003/07/gds/types" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <documentation>
    This example performs a simple select statement to retrieve 
    one row from the test database. The results are delivered 
    within the response document.
  </documentation>

  <sqlQueryStatement name="statement">
    <expression>select * from file1</expression>
    <webRowSetStream name="statementOutput"/>
  </sqlQueryStatement>

<deliverToFile name="delivery">
 <fromLocal from="statementOutput"/>
 <toFile>/scratch/k2/dqp/data/output.txt</toFile>
</deliverToFile>

</gridDataServicePerform>
DEBUG [http-8080-Processor24] (GridDataService.java:272) - Credential obtained from TLS: null
DEBUG [http-8080-Processor24] (GridDataService.java:296) - DN obtained from SecurityManager
 INFO [http-8080-Processor24] (GridDataService.java:306) - UserCertificateDN:
No Certificate Provided
 INFO [http-8080-Processor24] (GridDataService.java:321) - Do not have caller's credentials
DEBUG [http-8080-Processor24] (GridDataService.java:327) - Running perform document against the engine.
DEBUG [http-8080-Processor24] (ActivityEngine.java:207) - Engine received the following request:

<?xml version="1.0" encoding="UTF-8"?>
<gridDataServicePerform xmlns="http://ogsadai.org.uk/namespaces/2003/07/gds/types" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://ogsadai.org.uk/namespaces/2003/07/gds/types   ../../../../schema/ogsadai/xsd/activities/activities.xsd">
    <documentation>
    This example performs a simple select statement to retrieve 
    one row from the test database. The results are delivered 
    within the response document.
  </documentation>
    <sqlQueryStatement name="statement">
        <expression>select * from file1</expression>
        <webRowSetStream name="statementOutput"/>
    </sqlQueryStatement>
    <deliverToFile name="delivery">
        <fromLocal from="statementOutput"/>
        <toFile>/scratch/k2/dqp/data/output.txt</toFile>
    </deliverToFile>
</gridDataServicePerform>

 INFO [http-8080-Processor24] (ObservableStatus.java:83) - RequestStatus : UNSTARTED
DEBUG [http-8080-Processor24] (Activity.java:87) - Constructing activity of type uk.org.ogsadai.activity.sql.SQLQueryStatementActivity named statement
DEBUG [http-8080-Processor24] (SQLActivity.java:166) - Entering Constructor
DEBUG [http-8080-Processor24] (SQLActivity.java:167) - The element [sqlQueryStatement: null]
DEBUG [http-8080-Processor24] (SQLActivity.java:168) - Exiting Constructor
DEBUG [http-8080-Processor24] (SQLQueryStatementActivity.java:95) - Entering Constructor
DEBUG [http-8080-Processor24] (SQLActivity.java:189) - Entering parseSQLParameters
DEBUG [http-8080-Processor24] (SQLActivity.java:195) - No SQLParameters found
DEBUG [http-8080-Processor24] (SQLActivity.java:196) - Exiting parseSQLParameters
DEBUG [http-8080-Processor24] (SQLActivity.java:318) - Entering parseCommand
DEBUG [http-8080-Processor24] (SQLActivity.java:86) - Constructing ParameterInput: 0
DEBUG [http-8080-Processor24] (SQLActivity.java:118) - Constructing ValueInput: select * from file1 : 0
DEBUG [http-8080-Processor24] (SQLActivity.java:354) - command to use = select * from file1
DEBUG [http-8080-Processor24] (SQLActivity.java:359) - Exiting parseCommand
DEBUG [http-8080-Processor24] (SQLActivity.java:371) - Entering parseresultStream
DEBUG [http-8080-Processor24] (SQLActivity.java:387) - My resultStream is called :statementOutput
DEBUG [http-8080-Processor24] (SQLActivity.java:405) - Entering setupInputStreamNames
DEBUG [http-8080-Processor24] (SQLActivity.java:420) - Exiting setupInputStreamNames
DEBUG [http-8080-Processor24] (SQLQueryStatementActivity.java:118) - Exiting Constructor
DEBUG [http-8080-Processor24] (Activity.java:87) - Constructing activity of type uk.org.ogsadai.activity.delivery.DeliverToFileActivity named delivery
DEBUG [http-8080-Processor24] (DeliverToFileActivity.java:56) - Setup deliveryToFile with path: /scratch/k2/dqp/data/output.txt, with from: statementOutput
DEBUG [http-8080-Processor24] (Activity.java:116) - Configuring context for activity: statement
DEBUG [http-8080-Processor24] (ActivityContext.java:109) - Adding internal pipe: statementOutput : uk.org.ogsadai.engine.CallThroughPipe@1593ce6
DEBUG [http-8080-Processor24] (Activity.java:116) - Configuring context for activity: delivery
DEBUG [http-8080-Processor24] (ActivityRequest.java:83) - Initialising each activity
DEBUG [http-8080-Processor24] (SQLActivity.java:430) - Entering setContext
DEBUG [http-8080-Processor24] (SQLActivity.java:437) - About to get credentials
DEBUG [http-8080-Processor24] (SQLActivity.java:445) - About to initialise my inputs
DEBUG [http-8080-Processor24] (SQLActivity.java:460) - About to initialise the outputs
DEBUG [http-8080-Processor24] (SQLActivity.java:474) - Exiting setContext
DEBUG [http-8080-Processor24] (ActivityRequest.java:110) - Constructing internal activities
DEBUG [http-8080-Processor24] (ActivityRequest.java:185) - Request will be processed asynchronously
 INFO [http-8080-Processor24] (ObservableStatus.java:83) - RequestStatus : PROCESSING
DEBUG [http-8080-Processor24] (ActivityEngine.java:129) - Process method has returned.
DEBUG [RequestProcessingThread] (Activity.java:265) - Starting to process activity: delivery
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - deliveryStatus : PROCESSING
DEBUG [RequestProcessingThread] (DeliverToFileActivity.java:67) - Attempting to open stream for delivery to /scratch/k2/dqp/data/output.txt
DEBUG [http-8080-Processor24] (ActivityEngine.java:136) - Check whether there was an error
DEBUG [RequestProcessingThread] (AbstractDeliverToAddressActivity.java:82) - Entering processBlock
DEBUG [http-8080-Processor24] (GridDataService.java:339) - Request complete, response received:

 <?xml version="1.0" encoding="UTF-8"?>
<gridDataServiceResponse xmlns="http://ogsadai.org.uk/namespaces/2003/07/gds/types">
    <request status="PROCESSING"/>
    <result name="statement" status="UNSTARTED"/>
    <result name="delivery" status="PROCESSING"/>
</gridDataServiceResponse>

Processed in 43 milliseconds
DEBUG [RequestProcessingThread] (AbstractDeliverToAddressActivity.java:83) - Commencing delivery to /scratch/k2/dqp/data/output.txt
DEBUG [http-8080-Processor24] (GridDataService.java:355) - About to return results from GridDataService.
DEBUG [RequestProcessingThread] (Activity.java:265) - Starting to process activity: statement
DEBUG [http-8080-Processor24] (GridDataService.java:357) - perform: end (duration: 59
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - statementStatus : PROCESSING
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:136) - Entering startProcessing
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:137) - My driver class is org.storm.jdbc.file.FileDriver
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:145) - Getting a connection
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:84) - Entering getConnection()
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:89) - RoleMapper class is uk.org.ogsadai.common.rolemap.SimpleFileRoleMapper
DEBUG [RequestProcessingThread] (DataResourceImplementation.java:137) - Credentials to map = No Certificate Provided
DEBUG [RequestProcessingThread] (DataResourceImplementation.java:158) - Set username to : ogsadai
DEBUG [RequestProcessingThread] (DataResourceImplementation.java:159) - Set password to : abcd
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:94) - Set username to : ogsadai
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:95) - Set password to : abcd
DEBUG [RequestProcessingThread] (FileConnection.java:20) - systemdir = /scratch/k2/dqp
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:42) - systemdir = /scratch/k2/dqp
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tables.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_CAT, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_SCHEM, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_NAME, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_TYPE, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_FILENAME, 12, VARCHAR, 256)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (METADATA_FILENAME, 12, VARCHAR, 256)
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 290
DEBUG [RequestProcessingThread] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:59) - mtables = [file1 file1 file1 TABLE /scratch/k2/dqp/data/file1.data /scratch/k2/dqp/data/file1.data.schema ]
[file2 file2 file2 TABLE /scratch/k2/dqp/data/file2.data /scratch/k2/dqp/data/file2.data.schema ]
[ipars ipars ipars TABLE /scratch/k2/dqp/data/ipars-mini.data /scratch/k2/dqp/data/ipars.data.schema ]

DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file1.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = binary
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file1.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F1, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F2, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F3, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F4, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file2.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file2.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A1, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A2, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A3, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A4, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = binaryle
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:57) - File is little endian swap bytes effective
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 10
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (RID, 4, INTEGER, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TIME, 4, INTEGER, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (X, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Y, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Z, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (VX, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (VY, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (VZ, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (SOIL, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARBINARY has sql code -3
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (BLOB, -3, VARBINARY, 48)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tablestatus.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Name, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Row_format, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Rows, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Avg_row_length, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Data_length, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Index_length, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 90
DEBUG [RequestProcessingThread] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:88) - mtableStatus = [file1 FIXED 4 30 121313 1212 ]
[file2 DYNAMIC 4 40 1213232 1212 ]
[ipars FIXED 4 30 121313 1212 ]

DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/variables.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 2
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Variable_name, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Value, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 2
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 48
DEBUG [RequestProcessingThread] (InMemoryResultSet.java:49) - Added 2 rows to inmemorytable
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:104) - mVariables = [max_join_size 33434343 ]
[join_buffer_size 121212 ]

DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:112) - Exiting getConnection
DEBUG [RequestProcessingThread] (SQLActivity.java:487) - Expression retrieved. Expression : select * from file1
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:177) - Using a normal Statement
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:186) - Exiting startProcessing
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:205) - Entering getResult
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:247) - Execute normal Statement
DEBUG [RequestProcessingThread] (FileStatement.java:19) - SQL statement = select * from file1
DEBUG [RequestProcessingThread] (FileStatement.java:29) - command parser has produced [ tablename = file1
null]
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:138) - tablefilename map = {file2=/scratch/k2/dqp/data/file2.data, file1=/scratch/k2/dqp/data/file1.data, ipars=/scratch/k2/dqp/data/ipars-mini.data}
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 4
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 160
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:131) - Constructor: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:145) - Getting properties and meta-data
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:153) - Constructing synchronized pipe
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:162) - Creating RunAhead thread
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:879) - Constructor: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:884) - Constructor: stop
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:165) - Thread started
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:168) - Constructor: end
DEBUG [ReadAheadThread] (ResultSetToWebRowSetXMLStream.java:893) - run: start
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:265) - Exiting getResult
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [ReadAheadThread] (ResultSetToWebRowSetXMLStream.java:895) - run: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:205) - Entering getResult
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:212) - There is no expression to process
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - statementStatus : COMPLETED
DEBUG [RequestProcessingThread] (Activity.java:309) - Completed processing activity: statement
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:399) - Entering endProcessing
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:121) - Entering returnConnection
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:133) - Exiting returnConnection
DEBUG [RequestProcessingThread] (SQLActivity.java:710) - Closing Output
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:436) - Exiting endProcessing
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - deliveryStatus : COMPLETED
DEBUG [RequestProcessingThread] (Activity.java:309) - Completed processing activity: delivery
DEBUG [RequestProcessingThread] (ActivityRequest.java:274) - setFinalStatus: start
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - RequestStatus : COMPLETED
 INFO [RequestProcessingThread] (ActivityRequest.java:382) - Request processed in 126 milliseconds. 
DEBUG [RequestProcessingThread] (ActivityRequest.java:305) - setFinalStatus: stop
DEBUG [http-8080-Processor25] (ActivityEngine.java:181) - The engine has received a terminate call.
DEBUG [http-8080-Processor25] (EngineSetupUserException.java:36) - There is no request processing.
uk.org.ogsadai.common.exception.engine.setup.EngineSetupUserException: There is no request processing.
	at uk.org.ogsadai.engine.ActivityEngine.terminate(ActivityEngine.java:187)
	at uk.org.ogsadai.service.gds.impl.GridDataService.destroy(GridDataService.java:672)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
	at org.globus.ogsa.handlers.RPCURIProvider.invokeMethodSub(RPCURIProvider.java:363)
	at org.globus.ogsa.handlers.RPCURIProvider.invokeMethod(RPCURIProvider.java:308)
	at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
	at org.globus.ogsa.handlers.RPCURIProvider.processMessage(RPCURIProvider.java:281)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
	at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:534)
DEBUG [http-8080-Processor24] (MetaDataExtractor.java:39) - Extracting dynamic service data {http://ogsadai.org.uk/namespaces/2003/07/gdsf}databaseSchema
 INFO [http-8080-Processor24] (MetaDataExtractor.java:65) - No User Certificate Provided. Setting Default DN.
 INFO [http-8080-Processor24] (MetaDataExtractor.java:71) - UserCertificateDN:
No Certificate Provided
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:93) - Preparing to Connect to Database Prior to Meta-Data Extraction
DEBUG [http-8080-Processor24] (SimpleJDBCDataResourceImplementation.java:84) - Entering getConnection()
DEBUG [http-8080-Processor24] (SimpleJDBCDataResourceImplementation.java:89) - RoleMapper class is uk.org.ogsadai.common.rolemap.SimpleFileRoleMapper
DEBUG [http-8080-Processor24] (DataResourceImplementation.java:137) - Credentials to map = No Certificate Provided
DEBUG [http-8080-Processor24] (DataResourceImplementation.java:158) - Set username to : ogsadai
DEBUG [http-8080-Processor24] (DataResourceImplementation.java:159) - Set password to : abcd
DEBUG [http-8080-Processor24] (SimpleJDBCDataResourceImplementation.java:94) - Set username to : ogsadai
DEBUG [http-8080-Processor24] (SimpleJDBCDataResourceImplementation.java:95) - Set password to : abcd
DEBUG [http-8080-Processor24] (FileConnection.java:20) - systemdir = /scratch/k2/dqp
DEBUG [http-8080-Processor24] (FileDatabaseMetaData.java:42) - systemdir = /scratch/k2/dqp
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tables.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (TABLE_CAT, 12, VARCHAR, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (TABLE_SCHEM, 12, VARCHAR, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (TABLE_NAME, 12, VARCHAR, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (TABLE_TYPE, 12, VARCHAR, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (TABLE_FILENAME, 12, VARCHAR, 256)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (METADATA_FILENAME, 12, VARCHAR, 256)
DEBUG [http-8080-Processor24] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [http-8080-Processor24] (Row.java:40) - Number of bytes available = 290
DEBUG [http-8080-Processor24] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [http-8080-Processor24] (FileDatabaseMetaData.java:59) - mtables = [file1 file1 file1 TABLE /scratch/k2/dqp/data/file1.data /scratch/k2/dqp/data/file1.data.schema ]
[file2 file2 file2 TABLE /scratch/k2/dqp/data/file2.data /scratch/k2/dqp/data/file2.data.schema ]
[ipars ipars ipars TABLE /scratch/k2/dqp/data/ipars-mini.data /scratch/k2/dqp/data/ipars.data.schema ]

DEBUG [http-8080-Processor24] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file1.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:40) - binary line = binary
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file1.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (F1, 4, INTEGER, 5)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (F2, 6, FLOAT, 6)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (F3, 4, INTEGER, 5)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (F4, 6, FLOAT, 6)
DEBUG [http-8080-Processor24] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file2.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file2.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (A1, 4, INTEGER, 5)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (A2, 6, FLOAT, 6)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (A3, 4, INTEGER, 5)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (A4, 6, FLOAT, 6)
DEBUG [http-8080-Processor24] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:40) - binary line = binaryle
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:57) - File is little endian swap bytes effective
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:63) - ncols = 10
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (RID, 4, INTEGER, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (TIME, 4, INTEGER, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (X, 6, FLOAT, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Y, 6, FLOAT, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Z, 6, FLOAT, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (VX, 6, FLOAT, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (VY, 6, FLOAT, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (VZ, 6, FLOAT, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (SOIL, 6, FLOAT, 4)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARBINARY has sql code -3
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (BLOB, -3, VARBINARY, 48)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tablestatus.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Name, 12, VARCHAR, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Row_format, 12, VARCHAR, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Rows, 4, INTEGER, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Avg_row_length, 4, INTEGER, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Data_length, 4, INTEGER, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Index_length, 4, INTEGER, 10)
DEBUG [http-8080-Processor24] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [http-8080-Processor24] (Row.java:40) - Number of bytes available = 90
DEBUG [http-8080-Processor24] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [http-8080-Processor24] (FileDatabaseMetaData.java:88) - mtableStatus = [file1 FIXED 4 30 121313 1212 ]
[file2 DYNAMIC 4 40 1213232 1212 ]
[ipars FIXED 4 30 121313 1212 ]

DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/variables.data.schema
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:63) - ncols = 2
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Variable_name, 12, VARCHAR, 10)
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [http-8080-Processor24] (FileResultSetMetaData.java:74) - added field (Value, 4, INTEGER, 10)
DEBUG [http-8080-Processor24] (Row.java:30) - row is assumed to have ncols  = 2
DEBUG [http-8080-Processor24] (Row.java:40) - Number of bytes available = 48
DEBUG [http-8080-Processor24] (InMemoryResultSet.java:49) - Added 2 rows to inmemorytable
DEBUG [http-8080-Processor24] (FileDatabaseMetaData.java:104) - mVariables = [max_join_size 33434343 ]
[join_buffer_size 121212 ]

DEBUG [http-8080-Processor24] (SimpleJDBCDataResourceImplementation.java:112) - Exiting getConnection
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:101) - Connected to Database
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:70) - Preparing to Extract Database Schema
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:89) - Extracted Database MetaData
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:90) - Driver Name:stormjdbcdriver
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:91) - Driver Version:1.0
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:92) - User Name:ogsadai
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:93) - URL:jdbc:storm://localhost:5555/stormdb
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:102) - Extracting Table MetaData
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:113) - Table Name: file1
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F1
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F2
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F3
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: F4
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:102) - Extracting Table MetaData
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:113) - Table Name: file2
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A1
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A2
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A3
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: A4
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:102) - Extracting Table MetaData
DEBUG [http-8080-Processor24] (MySQLMetaDataExtractor.java:113) - Table Name: ipars
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: RID
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: TIME
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: X
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: Y
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: Z
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: VX
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: VY
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: VZ
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: SOIL
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:264) - Extracting Column MetaData
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:275) - Column Name: BLOB
DEBUG [http-8080-Processor24] (SimpleJDBCMetaDataExtractor.java:111) - Extracted Database Meta-Data
DEBUG [http-8080-Processor25] (GridDataServiceFactoryCallback.java:67) - Creating GDS.
DEBUG [http-8080-Processor25] (GridDataService.java:122) - Constructor: start
DEBUG [http-8080-Processor25] (GridDataService.java:131) - Constructing the engine.
DEBUG [http-8080-Processor25] (ActivityEngine.java:61) - Constructing Activity Engine.
DEBUG [http-8080-Processor25] (GridDataService.java:137) - GridDataService object successfully constructed.
DEBUG [http-8080-Processor25] (GridDataService.java:157) - Preparing service data
DEBUG [http-8080-Processor25] (GridDataService.java:161) - Adding activity types SDE
DEBUG [http-8080-Processor25] (GridDataService.java:170) - Adding document schema SDE
DEBUG [http-8080-Processor25] (GridDataService.java:180) - Adding SDE request status.
DEBUG [http-8080-Processor25] (GridDataService.java:149) - Constructor: end
DEBUG [http-8080-Processor25] (GridDataService.java:207) - perform: start
DEBUG [http-8080-Processor25] (GridDataService.java:212) - Trying to deserialize perform document
DEBUG [http-8080-Processor25] (GridDataService.java:217) - Perform document: <?xml version="1.0" encoding="UTF-8"?>
<gridDataServicePerform xsi:schemaLocation="http://ogsadai.org.uk/namespaces/2003/07/gds/types   ../../../../schema/ogsadai/xsd/activities/activities.xsd" xmlns="http://ogsadai.org.uk/namespaces/2003/07/gds/types" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <documentation>
    This example performs a simple select statement to retrieve 
    one row from the test database. The results are delivered 
    within the response document.
  </documentation>

  <sqlQueryStatement name="statement">
    <expression>select * from ipars</expression>
    <webRowSetStream name="statementOutput"/>
  </sqlQueryStatement>

<deliverToFile name="delivery">
 <fromLocal from="statementOutput"/>
 <toFile>/scratch/k2/dqp/data/output.txt</toFile>
</deliverToFile>

</gridDataServicePerform>
DEBUG [http-8080-Processor25] (GridDataService.java:272) - Credential obtained from TLS: null
DEBUG [http-8080-Processor25] (GridDataService.java:296) - DN obtained from SecurityManager
 INFO [http-8080-Processor25] (GridDataService.java:306) - UserCertificateDN:
No Certificate Provided
 INFO [http-8080-Processor25] (GridDataService.java:321) - Do not have caller's credentials
DEBUG [http-8080-Processor25] (GridDataService.java:327) - Running perform document against the engine.
DEBUG [http-8080-Processor25] (ActivityEngine.java:207) - Engine received the following request:

<?xml version="1.0" encoding="UTF-8"?>
<gridDataServicePerform xmlns="http://ogsadai.org.uk/namespaces/2003/07/gds/types" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://ogsadai.org.uk/namespaces/2003/07/gds/types   ../../../../schema/ogsadai/xsd/activities/activities.xsd">
    <documentation>
    This example performs a simple select statement to retrieve 
    one row from the test database. The results are delivered 
    within the response document.
  </documentation>
    <sqlQueryStatement name="statement">
        <expression>select * from ipars</expression>
        <webRowSetStream name="statementOutput"/>
    </sqlQueryStatement>
    <deliverToFile name="delivery">
        <fromLocal from="statementOutput"/>
        <toFile>/scratch/k2/dqp/data/output.txt</toFile>
    </deliverToFile>
</gridDataServicePerform>

 INFO [http-8080-Processor25] (ObservableStatus.java:83) - RequestStatus : UNSTARTED
DEBUG [http-8080-Processor25] (Activity.java:87) - Constructing activity of type uk.org.ogsadai.activity.sql.SQLQueryStatementActivity named statement
DEBUG [http-8080-Processor25] (SQLActivity.java:166) - Entering Constructor
DEBUG [http-8080-Processor25] (SQLActivity.java:167) - The element [sqlQueryStatement: null]
DEBUG [http-8080-Processor25] (SQLActivity.java:168) - Exiting Constructor
DEBUG [http-8080-Processor25] (SQLQueryStatementActivity.java:95) - Entering Constructor
DEBUG [http-8080-Processor25] (SQLActivity.java:189) - Entering parseSQLParameters
DEBUG [http-8080-Processor25] (SQLActivity.java:195) - No SQLParameters found
DEBUG [http-8080-Processor25] (SQLActivity.java:196) - Exiting parseSQLParameters
DEBUG [http-8080-Processor25] (SQLActivity.java:318) - Entering parseCommand
DEBUG [http-8080-Processor25] (SQLActivity.java:86) - Constructing ParameterInput: 0
DEBUG [http-8080-Processor25] (SQLActivity.java:118) - Constructing ValueInput: select * from ipars : 0
DEBUG [http-8080-Processor25] (SQLActivity.java:354) - command to use = select * from ipars
DEBUG [http-8080-Processor25] (SQLActivity.java:359) - Exiting parseCommand
DEBUG [http-8080-Processor25] (SQLActivity.java:371) - Entering parseresultStream
DEBUG [http-8080-Processor25] (SQLActivity.java:387) - My resultStream is called :statementOutput
DEBUG [http-8080-Processor25] (SQLActivity.java:405) - Entering setupInputStreamNames
DEBUG [http-8080-Processor25] (SQLActivity.java:420) - Exiting setupInputStreamNames
DEBUG [http-8080-Processor25] (SQLQueryStatementActivity.java:118) - Exiting Constructor
DEBUG [http-8080-Processor25] (Activity.java:87) - Constructing activity of type uk.org.ogsadai.activity.delivery.DeliverToFileActivity named delivery
DEBUG [http-8080-Processor25] (DeliverToFileActivity.java:56) - Setup deliveryToFile with path: /scratch/k2/dqp/data/output.txt, with from: statementOutput
DEBUG [http-8080-Processor25] (Activity.java:116) - Configuring context for activity: statement
DEBUG [http-8080-Processor25] (ActivityContext.java:109) - Adding internal pipe: statementOutput : uk.org.ogsadai.engine.CallThroughPipe@176e9c0
DEBUG [http-8080-Processor25] (Activity.java:116) - Configuring context for activity: delivery
DEBUG [http-8080-Processor25] (ActivityRequest.java:83) - Initialising each activity
DEBUG [http-8080-Processor25] (SQLActivity.java:430) - Entering setContext
DEBUG [http-8080-Processor25] (SQLActivity.java:437) - About to get credentials
DEBUG [http-8080-Processor25] (SQLActivity.java:445) - About to initialise my inputs
DEBUG [http-8080-Processor25] (SQLActivity.java:460) - About to initialise the outputs
DEBUG [http-8080-Processor25] (SQLActivity.java:474) - Exiting setContext
DEBUG [http-8080-Processor25] (ActivityRequest.java:110) - Constructing internal activities
DEBUG [http-8080-Processor25] (ActivityRequest.java:185) - Request will be processed asynchronously
 INFO [http-8080-Processor25] (ObservableStatus.java:83) - RequestStatus : PROCESSING
DEBUG [http-8080-Processor25] (ActivityEngine.java:129) - Process method has returned.
DEBUG [RequestProcessingThread] (Activity.java:265) - Starting to process activity: delivery
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - deliveryStatus : PROCESSING
DEBUG [RequestProcessingThread] (DeliverToFileActivity.java:67) - Attempting to open stream for delivery to /scratch/k2/dqp/data/output.txt
DEBUG [http-8080-Processor25] (ActivityEngine.java:136) - Check whether there was an error
DEBUG [RequestProcessingThread] (AbstractDeliverToAddressActivity.java:82) - Entering processBlock
DEBUG [http-8080-Processor25] (GridDataService.java:339) - Request complete, response received:

 <?xml version="1.0" encoding="UTF-8"?>
<gridDataServiceResponse xmlns="http://ogsadai.org.uk/namespaces/2003/07/gds/types">
    <request status="PROCESSING"/>
    <result name="statement" status="UNSTARTED"/>
    <result name="delivery" status="PROCESSING"/>
</gridDataServiceResponse>

Processed in 42 milliseconds
DEBUG [RequestProcessingThread] (AbstractDeliverToAddressActivity.java:83) - Commencing delivery to /scratch/k2/dqp/data/output.txt
DEBUG [http-8080-Processor25] (GridDataService.java:355) - About to return results from GridDataService.
DEBUG [RequestProcessingThread] (Activity.java:265) - Starting to process activity: statement
DEBUG [http-8080-Processor25] (GridDataService.java:357) - perform: end (duration: 61
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - statementStatus : PROCESSING
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:136) - Entering startProcessing
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:137) - My driver class is org.storm.jdbc.file.FileDriver
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:145) - Getting a connection
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:84) - Entering getConnection()
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:89) - RoleMapper class is uk.org.ogsadai.common.rolemap.SimpleFileRoleMapper
DEBUG [RequestProcessingThread] (DataResourceImplementation.java:137) - Credentials to map = No Certificate Provided
DEBUG [RequestProcessingThread] (DataResourceImplementation.java:158) - Set username to : ogsadai
DEBUG [RequestProcessingThread] (DataResourceImplementation.java:159) - Set password to : abcd
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:94) - Set username to : ogsadai
DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:95) - Set password to : abcd
DEBUG [RequestProcessingThread] (FileConnection.java:20) - systemdir = /scratch/k2/dqp
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:42) - systemdir = /scratch/k2/dqp
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tables.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_CAT, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_SCHEM, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_NAME, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_TYPE, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TABLE_FILENAME, 12, VARCHAR, 256)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (METADATA_FILENAME, 12, VARCHAR, 256)
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 290
DEBUG [RequestProcessingThread] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:59) - mtables = [file1 file1 file1 TABLE /scratch/k2/dqp/data/file1.data /scratch/k2/dqp/data/file1.data.schema ]
[file2 file2 file2 TABLE /scratch/k2/dqp/data/file2.data /scratch/k2/dqp/data/file2.data.schema ]
[ipars ipars ipars TABLE /scratch/k2/dqp/data/ipars-mini.data /scratch/k2/dqp/data/ipars.data.schema ]

DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file1.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = binary
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file1.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F1, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F2, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F3, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (F4, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/file2.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/file2.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A1, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A2, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A3, 4, INTEGER, 5)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (A4, 6, FLOAT, 6)
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:66) - going to read tableschema from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = binaryle
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:57) - File is little endian swap bytes effective
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/data/ipars.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 10
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (RID, 4, INTEGER, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (TIME, 4, INTEGER, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (X, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Y, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Z, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (VX, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (VY, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (VZ, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - FLOAT has sql code 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (SOIL, 6, FLOAT, 4)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARBINARY has sql code -3
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (BLOB, -3, VARBINARY, 48)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/tablestatus.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 6
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Name, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Row_format, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Rows, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Avg_row_length, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Data_length, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Index_length, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 6
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 90
DEBUG [RequestProcessingThread] (InMemoryResultSet.java:49) - Added 3 rows to inmemorytable
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:88) - mtableStatus = [file1 FIXED 4 30 121313 1212 ]
[file2 DYNAMIC 4 40 1213232 1212 ]
[ipars FIXED 4 30 121313 1212 ]

DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:40) - binary line = text
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:62) - Reading metadata from /scratch/k2/dqp/variables.data.schema
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:63) - ncols = 2
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - VARCHAR has sql code 12
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Variable_name, 12, VARCHAR, 10)
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:91) - INTEGER has sql code 4
DEBUG [RequestProcessingThread] (FileResultSetMetaData.java:74) - added field (Value, 4, INTEGER, 10)
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 2
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 48
DEBUG [RequestProcessingThread] (InMemoryResultSet.java:49) - Added 2 rows to inmemorytable
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:104) - mVariables = [max_join_size 33434343 ]
[join_buffer_size 121212 ]

DEBUG [RequestProcessingThread] (SimpleJDBCDataResourceImplementation.java:112) - Exiting getConnection
DEBUG [RequestProcessingThread] (SQLActivity.java:487) - Expression retrieved. Expression : select * from ipars
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:177) - Using a normal Statement
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:186) - Exiting startProcessing
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:205) - Entering getResult
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:247) - Execute normal Statement
DEBUG [RequestProcessingThread] (FileStatement.java:19) - SQL statement = select * from ipars
DEBUG [RequestProcessingThread] (FileStatement.java:29) - command parser has produced [ tablename = ipars
null]
DEBUG [RequestProcessingThread] (FileDatabaseMetaData.java:138) - tablefilename map = {file2=/scratch/k2/dqp/data/file2.data, file1=/scratch/k2/dqp/data/file1.data, ipars=/scratch/k2/dqp/data/ipars-mini.data}
DEBUG [RequestProcessingThread] (Row.java:30) - row is assumed to have ncols  = 10
DEBUG [RequestProcessingThread] (Row.java:40) - Number of bytes available = 55050240
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:131) - Constructor: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:145) - Getting properties and meta-data
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:153) - Constructing synchronized pipe
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:162) - Creating RunAhead thread
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:879) - Constructor: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:884) - Constructor: stop
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:165) - Thread started
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:168) - Constructor: end
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:265) - Exiting getResult
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [ReadAheadThread] (ResultSetToWebRowSetXMLStream.java:893) - run: start
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:282) - Entering processBlock
DEBUG [http-8080-Processor24] (ActivityEngine.java:181) - The engine has received a terminate call.
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:904) - getRow: start
DEBUG [RequestProcessingThread] (ResultSetToWebRowSetXMLStream.java:914) - getRow: stop
DEBUG [RequestProcessingThread] (SQLQueryStatementActivity.java:386) - Exiting processBlock
DEBUG [http-8080-Processor24] (Activity.java:356) - Terminating activity: statement
 INFO [http-8080-Processor24] (ObservableStatus.java:83) - statementStatus : TERMINATED
DEBUG [http-8080-Processor24] (Activity.java:356) - Terminating activity: delivery
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - deliveryStatus : COMPLETED
DEBUG [RequestProcessingThread] (Activity.java:309) - Completed processing activity: delivery
 INFO [http-8080-Processor24] (ObservableStatus.java:83) - deliveryStatus : TERMINATED
DEBUG [RequestProcessingThread] (ActivityRequest.java:274) - setFinalStatus: start
 INFO [RequestProcessingThread] (ObservableStatus.java:83) - RequestStatus : COMPLETED
 INFO [RequestProcessingThread] (ActivityRequest.java:382) - Request processed in 299 milliseconds. 
DEBUG [RequestProcessingThread] (ActivityRequest.java:305) - setFinalStatus: stop
 INFO [http-8080-Processor24] (ObservableStatus.java:83) - RequestStatus : TERMINATED
DEBUG [http-8080-Processor24] (ActivityEngine.java:194) - Request terminatation complete.