Error when searching on : Event(s) within the group occur more than 1 time

Original full discussion : See: https://groups.google.com/forum/?fromgroups#!topic/i2b2-install-help/7-bZN54GLIw

I have confirmed that this error also occurs for Children's Colorado running 1.6.02 version .

The error I'm trying to track down is when a user selects withinthe wbeclient : "Event(s) within the group occur more than 1 time" on a given field. Any Ideas as I ran the query just before the failure and it works . My UID is now my windows account ID domain\userid . We've modified the login to take our windows userid / password, but not touched any backend code. But I log in with the admin account and the error is the same : "ORA-00905: missing keyword" error. The search works great if one does not select the "Occurs more than once drop down ". Any Ideas on how to debug this ?



2012-02-14 15:38:49,873 DEBUG [edu.harvard.i2b2.common.util.jaxb.JAXBUtil] object.toString()edu.harvard.i2b2.crc.datavo.i2b2message.RequestMessageType

2012-02-14 15:38:49,874 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'appType'

2012-02-14 15:38:49,875 DEBUG [edu.harvard.i2b2.common.util.jaxb.JAXBUtil] object.toString()edu.harvard.i2b2.crc.datavo.i2b2message.RequestMessageType

2012-02-14 15:38:49,875 DEBUG [edu.harvard.i2b2.common.util.jaxb.JAXBUtil] object.toString()edu.harvard.i2b2.crc.datavo.i2b2message.RequestMessageType

2012-02-14 15:38:49,876 DEBUG [edu.harvard.i2b2.crc.dao.OracleDataSourceLookupDAO] Executing SQL query [select * from i2b2hive.crc_db_lookup where c_domain_id = ? and c_project_path like ? and (c_owner_id =? or c_owner_id = '@') order by c_project_path]

2012-02-14 15:38:49,876 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Fetching JDBC Connection from DataSource

2012-02-14 15:38:49,876 DEBUG [org.springframework.jdbc.core.StatementCreatorUtils] Setting SQL statement parameter value: column index 1, parameter value [i2b2demo], value class [java.lang.String], SQL type 12

2012-02-14 15:38:49,876 DEBUG [org.springframework.jdbc.core.StatementCreatorUtils] Setting SQL statement parameter value: column index 2, parameter value [/CDW/%], value class [java.lang.String], SQL type 12

2012-02-14 15:38:49,876 DEBUG [org.springframework.jdbc.core.StatementCreatorUtils] Setting SQL statement parameter value: column index 3, parameter value [mcw_hmgc\windowsid], value class [java.lang.String], SQL type 12

2012-02-14 15:38:49,876 DEBUG [edu.harvard.i2b2.crc.axis2.QueryService] Response in service<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ns5:response xmlns:ns2="http://www.i2b2.org/xsd/hive/pdo/1.1/" xmlns:ns4="http://www.i2b2.org/xsd/cell/crc/psm/1.1/" xmlns:ns3="http://www.i2b2.org/xsd/cell/crc/pdo/1.1/" xmlns:ns9="http://www.i2b2.org/xsd/cell/ont/1.1/" xmlns:ns5="http://www.i2b2.org/xsd/hive/msg/1.1/" xmlns:ns6="http://www.i2b2.org/xsd/cell/crc/psm/querydefinition/1.1/" xmlns:ns10="http://www.i2b2.org/xsd/hive/msg/result/1.1/" xmlns:ns7="http://www.i2b2.org/xsd/cell/crc/psm/analysisdefinition/1.1/" xmlns:ns8="http://www.i2b2.org/xsd/cell/pm/1.1/">

    <message_header>

        <i2b2_version_compatible>1.1</i2b2_version_compatible>

        <hl7_version_compatible>2.4</hl7_version_compatible>

        <sending_application>

            <application_name>CRC Cell</application_name>

            <application_version>1.601</application_version>

        </sending_application>

        <sending_facility>

            <facility_name>i2b2 Hive</facility_name>

        </sending_facility>

        <receiving_application>

            <application_name>i2b2_QueryTool</application_name>

            <application_version>1.6</application_version>

        </receiving_application>

        <receiving_facility>

            <facility_name>i2b2 Hive</facility_name>

        </receiving_facility>

        <message_control_id>

            <instance_num>1</instance_num>

        </message_control_id>

        <project_id>CDW</project_id>

    </message_header>

    <response_header>

        <info>Log information</info>

        <result_status>

            <status type="DONE">DONE</status>

            <polling_url interval_ms="100"/>

        </result_status>

    </response_header>

    <message_body>

        <ns4:response xsi:type="ns4:instance_responseType" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

            <status>

                <condition type="DONE">DONE</condition>

            </status>

            <query_instance>

                <query_instance_id>1959</query_instance_id>

                <query_master_id>2019</query_master_id>

                <user_id>mcw_hmgc\windowsid</user_id>

                <group_id>CDW</group_id>

                <start_date>2012-02-14T15:38:47.000-06:00</start_date>

                <end_date>2012-02-14T15:38:48.000-06:00</end_date>

                <message>java.sql.SQLException: ORA-00905: missing keyword

 

                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

                at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)

                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)

                at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)

                at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)

                at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)

                at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorHelperDao.executeQuery(Unknown Source)

                at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorDao.executeSQL(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.ExecRunnable.processQueryRequest(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.ExecRunnable.execute(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.QueryExecutorMDB.onMessage(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.QuerySmallExecutorMDB.onMessage(Unknown Source)

                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:597)

                at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

                at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495)

                at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)

                at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

                at org.jboss.ejb.plugins.AbstractTxInterceptor.invoedu.harvard.i2b2.common.exception.I2B2DAOException: Error while executing sql

                at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorHelperDao.executeQuery(Unknown Source)

                at edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorDao.executeSQL(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.ExecRunnable.processQueryRequest(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.ExecRunnable.execute(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.QueryExecutorMDB.onMessage(Unknown Source)

                at edu.harvard.i2b2.crc.ejb.QuerySmallExecutorMDB.onMessage(Unknown Source)

                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:597)

                at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

                at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495)

                at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)

                at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

                at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

                at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173)

                at org.jboss.ejb.plugins.MessageDrivenTxInterceptorBMT.invoke(MessageDrivenTxInterceptorBMT.java:47)

                at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:116)

                at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:109)

                at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

                at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)

                at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:402)

                at org.jboss.ejb.Container.</message>

                <query_status_type>

                    <status_type_id>4</status_type_id>

                    <name>ERROR</name>

                    <description>ERROR</description>

                </query_status_type>

            </query_instance>

        </ns4:response>

    </message_body>

</ns5:response>

 

2012-02-14 15:38:49,879 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource