Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.6.01
-
None
-
Linux ,
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Oracle JDBC driver
11.2.0.1.0
Description
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
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