Home » Archived » BIRT » Data Set Error
| Data Set Error [message #202134] |
Tue, 21 November 2006 10:55  |
Eclipse User |
|
|
|
Greetings,
As I tried to migrate reports from BIRT version 2.0.1 to 2.1.1,
I have encountered the problem with my query.
This query works fine on 2.0.1 but same query on 2.1.1 gets me the error of
ORA-01742 (Comment not terminated properly) and doesn't return a resultSet
object.
I have been scratched my head off to see if thereis any extra string or
space but I couldn't find one.
Any suggestion or help is greatly appreciated.
Here is the query
select
month||'-'||year mon_year,to_char(to_date(month||'-'||year,'MM-YYYY'),'Mon
YYYY') monyear,
disch_state_count,revoke_state_count,
nvl(round((disch_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
discharged_state_percent,
nvl(round((revoke_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
revoke_state_percent
from
(select
month,year,
round(sum(total_discharged_state)OVER( order by year,month rows between 5
preceding and current row)) disch_state_count,
round(sum(total_revoked_state)OVER( order by year, month rows between 5
preceding and current row)) revoke_state_count
from
(select
to_char(disch_dt,'MM') month,
to_char(disch_dt,'YYYY') year,
count(distinct case when (disch_type = '01' ) then inmnum else null end)
total_revoked_state,
count(distinct case when (disch_type= '02') then inmnum else null end)
total_discharged_state
from
parolees_inactive,
(select
add_months(to_date('JAN-2005','MON-YYYY'),-5) v_begin_date_b,
last_day(add_months(to_date('JAN-2006','MON-YYYY'),+5)) v_end_date_f
from dual)
where
disch_dt between v_begin_date_b and v_end_date_f
and disch_type in ('01','02')
and region < '6'
group by to_char(disch_dt,'MM'),to_char(disch_dt,'YYYY')))
where to_date(month||'-'||year,'MM-YYYY') between
to_date('JAN-2005','MON-YYYY') and to_date('JAN-2006','MON-YYYY')
order by to_date(month||'-'||year,'MM-YYYY')
|
|
|
| Re: Data Set Error [message #202157 is a reply to message #202134] |
Tue, 21 November 2006 12:59  |
| Eclipse User |
|
|
|
Can you set your log level to FINEST and attach your log. There is a
QueryText field in the log that is the query that runs.
Verify that it is correct.
Jason
"Eric" <sirericyang@gmail.com> wrote in message
news:9ae3fbe066c26cab2b49eacecad7ca62$1@www.eclipse.org...
> Greetings,
> As I tried to migrate reports from BIRT version 2.0.1 to 2.1.1, I
> have encountered the problem with my query.
>
> This query works fine on 2.0.1 but same query on 2.1.1 gets me the error
> of
> ORA-01742 (Comment not terminated properly) and doesn't return a resultSet
> object.
>
> I have been scratched my head off to see if thereis any extra string or
> space but I couldn't find one.
>
> Any suggestion or help is greatly appreciated.
>
> Here is the query
>
> select month||'-'||year
> mon_year,to_char(to_date(month||'-'||year,'MM-YYYY'),'Mon YYYY') monyear,
> disch_state_count,revoke_state_count,
> nvl(round((disch_state_count/case when
> (disch_state_count+revoke_state_count)>1 then
> (disch_state_count+revoke_state_count) else 1 end)*100,1),0)
> discharged_state_percent,
> nvl(round((revoke_state_count/case when
> (disch_state_count+revoke_state_count)>1 then
> (disch_state_count+revoke_state_count) else 1 end)*100,1),0)
> revoke_state_percent
> from
> (select month,year,
> round(sum(total_discharged_state)OVER( order by year,month rows between 5
> preceding and current row)) disch_state_count,
> round(sum(total_revoked_state)OVER( order by year, month rows between 5
> preceding and current row)) revoke_state_count
> from
> (select to_char(disch_dt,'MM') month,
> to_char(disch_dt,'YYYY') year,
> count(distinct case when (disch_type = '01' ) then inmnum else null end)
> total_revoked_state,
> count(distinct case when (disch_type= '02') then inmnum else null end)
> total_discharged_state
> from parolees_inactive, (select
> add_months(to_date('JAN-2005','MON-YYYY'),-5) v_begin_date_b,
> last_day(add_months(to_date('JAN-2006','MON-YYYY'),+5)) v_end_date_f
> from dual)
> where disch_dt between v_begin_date_b and v_end_date_f
> and disch_type in ('01','02')
> and region < '6' group by
> to_char(disch_dt,'MM'),to_char(disch_dt,'YYYY')))
> where to_date(month||'-'||year,'MM-YYYY') between
> to_date('JAN-2005','MON-YYYY') and to_date('JAN-2006','MON-YYYY')
> order by to_date(month||'-'||year,'MM-YYYY')
|
|
|
| Re: Data Set Error [message #202171 is a reply to message #202157] |
Tue, 21 November 2006 14:38 |
| Eclipse User |
|
|
|
The problem is the division in the sql. You can just overwrite the 2.1.1 with the 2.1.2
org.eclipse.birt.report.data.oda.jdbc oda-jdbc.jar
I would like to vote that 2.1.2 gets released soon as this is a fairly major sql bug.
Jason Weathersby wrote:
> Can you set your log level to FINEST and attach your log. There is a
> QueryText field in the log that is the query that runs.
> Verify that it is correct.
>
> Jason
>
> "Eric" <sirericyang@gmail.com> wrote in message
> news:9ae3fbe066c26cab2b49eacecad7ca62$1@www.eclipse.org...
>
>>Greetings,
>> As I tried to migrate reports from BIRT version 2.0.1 to 2.1.1, I
>>have encountered the problem with my query.
>>
>>This query works fine on 2.0.1 but same query on 2.1.1 gets me the error
>>of
>>ORA-01742 (Comment not terminated properly) and doesn't return a resultSet
>>object.
>>
>>I have been scratched my head off to see if thereis any extra string or
>>space but I couldn't find one.
>>
>>Any suggestion or help is greatly appreciated.
>>
>>Here is the query
>>
>>select month||'-'||year
>>mon_year,to_char(to_date(month||'-'||year,'MM-YYYY'),'Mon YYYY') monyear,
>>disch_state_count,revoke_state_count,
>>nvl(round((disch_state_count/case when
>>(disch_state_count+revoke_state_count)>1 then
>>(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
>>discharged_state_percent,
>>nvl(round((revoke_state_count/case when
>>(disch_state_count+revoke_state_count)>1 then
>>(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
>>revoke_state_percent
>>from
>>(select month,year,
>>round(sum(total_discharged_state)OVER( order by year,month rows between 5
>>preceding and current row)) disch_state_count,
>>round(sum(total_revoked_state)OVER( order by year, month rows between 5
>>preceding and current row)) revoke_state_count
>>from
>>(select to_char(disch_dt,'MM') month,
>>to_char(disch_dt,'YYYY') year,
>>count(distinct case when (disch_type = '01' ) then inmnum else null end)
>>total_revoked_state,
>>count(distinct case when (disch_type= '02') then inmnum else null end)
>>total_discharged_state
>>from parolees_inactive, (select
>>add_months(to_date('JAN-2005','MON-YYYY'),-5) v_begin_date_b,
>>last_day(add_months(to_date('JAN-2006','MON-YYYY'),+5)) v_end_date_f
>>from dual)
>>where disch_dt between v_begin_date_b and v_end_date_f
>>and disch_type in ('01','02')
>>and region < '6' group by
>>to_char(disch_dt,'MM'),to_char(disch_dt,'YYYY')))
>>where to_date(month||'-'||year,'MM-YYYY') between
>>to_date('JAN-2005','MON-YYYY') and to_date('JAN-2006','MON-YYYY')
>>order by to_date(month||'-'||year,'MM-YYYY')
>
>
>
|
|
| |
| Re: Data Set Error [message #202224 is a reply to message #202157] |
Tue, 21 November 2006 14:51 |
| Eclipse User |
|
|
|
Jason,
Thank you for the quick response. Attached is the error captured
from the log after setting the log level to FINEST. Thank you very much
for your help.
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.impl.PreparedQuery
PreparedQuery
FINE: PreparedQuery starts up.
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.impl.PreparedQuery
<init>
FINE: Start to prepare a PreparedQuery.
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.impl.PreparedQuery
<init>
FINE: Finished preparing the PreparedQuery.
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
prepare
FINE: Finished preparing query.
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
prepare
FINER: RETURN
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.impl.PreparedQuery
doPrepare
FINER: Start to prepare the execution.
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.impl.OdaDataSetRuntime <init>
FINER: OdaDataSetRuntime starts up
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager getInstance
FINER: ENTRY
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager getInstance
FINER: RETURN
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager@18b6281
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
FINER: ENTRY org.eclipse.birt.report.data.oda.jdbc
{odaURL=jdbc:oracle:thin:@consid:1521:oratest,
odaDriverClass=oracle.jdbc.driver.OracleDriver,
OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_Da ta Source,
odaPassword=tivnc33a, odaUser=lookup}
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.DriverManager
setDriverLogConfiguration
FINER: ENTRY org.eclipse.birt.report.data.oda.jdbc
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.odaconsumer.Driver
Driver
FINER: ENTRY org.eclipse.birt.report.data.oda.jdbc
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.odaconsumer.Driver
Driver
FINER: RETURN org.eclipse.birt.data.engine.odaconsumer.Driver@95a1b6
Nov 21, 2006 2:49:35 PM org.eclipse.birt.data.engine.odaconsumer.Driver
setLogConfiguration
INFO: ODA driver does not have valid trace logging defined in the plug-in
options or plugin.xml file.
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.DriverManager
setDriverLogConfiguration
FINER: RETURN
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.DriverManager getDriverHelper
FINER: ENTRY org.eclipse.birt.report.data.oda.jdbc
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.DriverManager getDriverHelper
FINER: RETURN
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDr iver @e4e6cf
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.DriverManager
getExtensionDataSourceId
FINER: ENTRY org.eclipse.birt.report.data.oda.jdbc
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.data.engine.odaconsumer.DriverManager
getExtensionDataSourceId
FINER: RETURN org.eclipse.birt.report.data.oda.jdbc
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.report.data.oda.jdbc.OdaJdbcDriver getConnection
FINE: JDBCConnectionFactory.getConnection( )
connectionClassName=org.eclipse.birt.report.data.oda.jdbc
Nov 21, 2006 2:49:35 PM org.eclipse.birt.report.data.oda.jdbc.Connection
open
FINE: Connection.open(Properties). connProperties =
OdaPropertyConfigId=org.eclipse.birt.report.data.oda.jdbc_Da ta
Source;odaDriverClass=oracle.jdbc.driver.OracleDriver;odaURL =jdbc:oracle:thin:@consid:1521:oratest;odaPassword=***;odaUs er=lookup;
Nov 21, 2006 2:49:35 PM org.eclipse.birt.report.data.oda.jdbc.Connection
close
FINE: Connection closed.
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager getConnection
FINE: Request JDBC Connection:
driverClass=oracle.jdbc.driver.OracleDriver;
url=jdbc:oracle:thin:@consid:1521:oratest; jndi name url=null
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager doConnect
FINER: Calling DriverManager.getConnection.
url=jdbc:oracle:thin:@consid:1521:oratest
Nov 21, 2006 2:49:35 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Wrap pedDriver:oracle.jdbc.driver.OracleDriver
connect
FINER: ENTRY jdbc:oracle:thin:@consid:1521:oratest
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection Connection
FINER: ENTRY
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection @14b7042
org.eclipse.birt.report.data.oda.jdbc
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection Connection
FINER: RETURN org.eclipse.birt.data.engine.odaconsumer.Connection@1b72ada
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
FINER: RETURN org.eclipse.birt.data.engine.odaconsumer.Connection@1b72ada
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection getMaxQueries
FINER: ENTRY
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection getMaxQueries
FINER: RETURN 0
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection prepareStatement
FINER: ENTRY select
month||'-'||year mon_year,to_char(to_date(month||'-'||year,'MM-YYYY'),'Mon
YYYY') monyear,
disch_state_count,revoke_state_count,
nvl(round((disch_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
discharged_state_percent,
nvl(round((revoke_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
revoke_state_percent
from
(select
month,year,
round(sum(total_discharged_state)OVER( order by year,month rows between 5
preceding and current row)) disch_state_count,
round(sum(total_revoked_state)OVER( order by year, month rows between 5
preceding and current row)) revoke_state_count
from
(select
to_char(disch_dt,'MM') month,
to_char(disch_dt,'YYYY') year,
count(distinct case when (disch_type = '01' ) then inmnum else null end)
total_revoked_state,
count(distinct case when (disch_type= '02') then inmnum else null end)
total_discharged_state
from
parolees_inactive,
(select
add_months(to_date('JAN-2005','MON-YYYY'),-5) v_begin_date_b,
last_day(add_months(to_date('JAN-2006','MON-YYYY'),+5)) v_end_date_f
from dual)
where
disch_dt between v_begin_date_b and v_end_date_f
and disch_type in ('01','02')
and region < '6'
group by to_char(disch_dt,'MM'),to_char(disch_dt,'YYYY')))
where to_date(month||'-'||year,'MM-YYYY') between
to_date('JAN-2005','MON-YYYY') and to_date('JAN-2006','MON-YYYY')
order by to_date(month||'-'||year,'MM-YYYY')
org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
FINER: ENTRY select
month||'-'||year mon_year,to_char(to_date(month||'-'||year,'MM-YYYY'),'Mon
YYYY') monyear,
disch_state_count,revoke_state_count,
nvl(round((disch_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
discharged_state_percent,
nvl(round((revoke_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
revoke_state_percent
from
(select
month,year,
round(sum(total_discharged_state)OVER( order by year,month rows between 5
preceding and current row)) disch_state_count,
round(sum(total_revoked_state)OVER( order by year, month rows between 5
preceding and current row)) revoke_state_count
from
(select
to_char(disch_dt,'MM') month,
to_char(disch_dt,'YYYY') year,
count(distinct case when (disch_type = '01' ) then inmnum else null end)
total_revoked_state,
count(distinct case when (disch_type= '02') then inmnum else null end)
total_discharged_state
from
parolees_inactive,
(select
add_months(to_date('JAN-2005','MON-YYYY'),-5) v_begin_date_b,
last_day(add_months(to_date('JAN-2006','MON-YYYY'),+5)) v_end_date_f
from dual)
where
disch_dt between v_begin_date_b and v_end_date_f
and disch_type in ('01','02')
and region < '6'
group by to_char(disch_dt,'MM'),to_char(disch_dt,'YYYY')))
where to_date(month||'-'||year,'MM-YYYY') between
to_date('JAN-2005','MON-YYYY') and to_date('JAN-2006','MON-YYYY')
order by to_date(month||'-'||year,'MM-YYYY')
org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
Nov 21, 2006 2:49:37 PM org.eclipse.birt.report.data.oda.jdbc.Connection
createStatement
FINE:
Connection.createStatement(org.eclipse.birt.report.data.oda. jdbc.JdbcSelectDataSet)
Nov 21, 2006 2:49:37 PM org.eclipse.birt.report.data.oda.jdbc.Statement
prepare
FINE: Statement.prepare( "select
month||'-'||year mon_year,to_char(to_date(month||'-'||year,'MM-YYYY'),'Mon
YYYY') monyear,
disch_state_count,revoke_state_count,
nvl(round((disch_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
discharged_state_percent,
nvl(round((revoke_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
revoke_state_percent
from
(select
month,year,
round(sum(total_discharged_state)OVER( order by year,month rows between 5
preceding and current row)) disch_state_count,
round(sum(total_revoked_state)OVER( order by year, month rows between 5
preceding and current row)) revoke_state_count
from
(select
to_char(disch_dt,'MM') month,
to_char(disch_dt,'YYYY') year,
count(distinct case when (disch_type = '01' ) then inmnum else null end)
total_revoked_state,
count(distinct case when (disch_type= '02') then inmnum else null end)
total_discharged_state
from
parolees_inactive,
(select
add_months(to_date('JAN-2005','MON-YYYY'),-5) v_begin_date_b,
last_day(add_months(to_date('JAN-2006','MON-YYYY'),+5)) v_end_date_f
from dual)
where
disch_dt between v_begin_date_b and v_end_date_f
and disch_type in ('01','02')
and region < '6'
group by to_char(disch_dt,'MM'),to_char(disch_dt,'YYYY')))
where to_date(month||'-'||year,'MM-YYYY') between
to_date('JAN-2005','MON-YYYY') and to_date('JAN-2006','MON-YYYY')
order by to_date(month||'-'||year,'MM-YYYY')" )
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
FINER: RETURN
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery @27147d
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
PreparedStatement
FINER: ENTRY
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery @27147d
org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
org.eclipse.birt.data.engine.odaconsumer.Connection@1b72ada select
month||'-'||year mon_year,to_char(to_date(month||'-'||year,'MM-YYYY'),'Mon
YYYY') monyear,
disch_state_count,revoke_state_count,
nvl(round((disch_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
discharged_state_percent,
nvl(round((revoke_state_count/case when
(disch_state_count+revoke_state_count)>1 then
(disch_state_count+revoke_state_count) else 1 end)*100,1),0)
revoke_state_percent
from
(select
month,year,
round(sum(total_discharged_state)OVER( order by year,month rows between 5
preceding and current row)) disch_state_count,
round(sum(total_revoked_state)OVER( order by year, month rows between 5
preceding and current row)) revoke_state_count
from
(select
to_char(disch_dt,'MM') month,
to_char(disch_dt,'YYYY') year,
count(distinct case when (disch_type = '01' ) then inmnum else null end)
total_revoked_state,
count(distinct case when (disch_type= '02') then inmnum else null end)
total_discharged_state
from
parolees_inactive,
(select
add_months(to_date('JAN-2005','MON-YYYY'),-5) v_begin_date_b,
last_day(add_months(to_date('JAN-2006','MON-YYYY'),+5)) v_end_date_f
from dual)
where
disch_dt between v_begin_date_b and v_end_date_f
and disch_type in ('01','02')
and region < '6'
group by to_char(disch_dt,'MM'),to_char(disch_dt,'YYYY')))
where to_date(month||'-'||year,'MM-YYYY') between
to_date('JAN-2005','MON-YYYY') and to_date('JAN-2006','MON-YYYY')
order by to_date(month||'-'||year,'MM-YYYY')
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
PreparedStatement
FINER: RETURN
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement@5e06ef
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.Connection prepareStatement
FINER: RETURN
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement@5e06ef
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement setProperty
FINER: ENTRY queryTimeOut null
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement doSetProperty
FINER: ENTRY queryTimeOut null
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement doSetProperty
FINER: RETURN
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement setProperty
FINER: RETURN
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
setColumnsProjection
FINER: ENTRY <null>
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
resetCurrentMetaData
FINER: ENTRY
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
resetCurrentMetaData
FINER: RETURN
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
getProjectedColumns
FINER: ENTRY
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
getRuntimeMetaData
FINER: ENTRY
Nov 21, 2006 2:49:37 PM org.eclipse.birt.report.data.oda.jdbc.Statement
getMetaData
FINE: Statement.getMetaData( )
Nov 21, 2006 2:49:37 PM org.eclipse.birt.report.data.oda.jdbc.Statement
executeQuery
FINE: Statement.executeQuery( )
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCException JDBCException
FINE: odajdbc.ResultSetCannotReturn
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCException logSQLException
FINE: SQL Exception #1
java.sql.SQLException: ORA-01742: comment not terminated properly
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891 )
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Proto col.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStat ement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac leStatement.java:2672)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Ora clePreparedStatement.java:589)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:527)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:340)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:388)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:356)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:259)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
at
org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelp er.executeQuery(QueryExecutionHelper.java:107)
at
org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelp er.executeQuery(QueryExecutionHelper.java:87)
at
org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHel per.getRealMetaData(DataSetMetaDataHelper.java:144)
at
org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHel per.getDataSetMetaData(DataSetMetaDataHelper.java:101)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.getDataSetMetaData(DataRequestSessionImpl.java:112)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.populateAllOutputColumns(DataSetProvider.java:211)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.execute(DataSetProvider.java:280)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.execute(DataSetProvider.java:264)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.executeProcess(ResultSetPreviewPage.java:278)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.runUpdateResults(ResultSetPreviewPage.java:247)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.access$100(ResultSetPreviewPage.java:83)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage$4.runInUIThread(ResultSetPreviewPage.java:224)
at org.eclipse.ui.progress.UIJob$1.run(UIJob.java:94)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr onizer.java:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav a:3325)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2971)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:820 )
at org.eclipse.jface.window.Window.open(Window.java:796)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.BaseDia log.open(BaseDialog.java:95)
at
org.eclipse.birt.report.designer.internal.ui.views.data.prov iders.DataSetNodeProvider.performEdit(DataSetNodeProvider.ja va:192)
at
org.eclipse.birt.report.designer.internal.ui.views.DefaultNo deProvider.performRequest(DefaultNodeProvider.java:355)
at
org.eclipse.birt.report.designer.internal.ui.views.actions.E ditAction.doAction(EditAction.java:79)
at
org.eclipse.birt.report.designer.internal.ui.views.actions.A bstractElementAction.run(AbstractElementAction.java:64)
at
org.eclipse.birt.report.designer.internal.ui.views.RenameLis tener.doubleClick(RenameListener.java:211)
at
org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredV iewer.java:796)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:843)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:14 9)
at
org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(S tructuredViewer.java:794)
at
org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSel ect(AbstractTreeViewer.java:1227)
at
org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSe lected(StructuredViewer.java:1158)
at
org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEven t(OpenStrategy.java:223)
at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.ja va:220)
at
org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrate gy.java:281)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2968)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:1914)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:419)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:149)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplicatio n.java:95)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(Pl atformActivator.java:78)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .runApplication(EclipseAppLauncher.java:92)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .start(EclipseAppLauncher.java:68)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:400)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336 )
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)
Nov 21, 2006 2:49:37 PM
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement
getRuntimeMetaData
SEVERE: Cannot get resultset metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
not return a ResultSet object.
SQL error #1: ORA-01742: comment not terminated properly
;
java.sql.SQLException: ORA-01742: comment not terminated properly
at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:344)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:388)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:356)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:259)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
at
org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelp er.executeQuery(QueryExecutionHelper.java:107)
at
org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelp er.executeQuery(QueryExecutionHelper.java:87)
at
org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHel per.getRealMetaData(DataSetMetaDataHelper.java:144)
at
org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHel per.getDataSetMetaData(DataSetMetaDataHelper.java:101)
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.getDataSetMetaData(DataRequestSessionImpl.java:112)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.populateAllOutputColumns(DataSetProvider.java:211)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.execute(DataSetProvider.java:280)
at
org.eclipse.birt.report.designer.data.ui.util.DataSetProvide r.execute(DataSetProvider.java:264)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.executeProcess(ResultSetPreviewPage.java:278)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.runUpdateResults(ResultSetPreviewPage.java:247)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.access$100(ResultSetPreviewPage.java:83)
at
org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage$4.runInUIThread(ResultSetPreviewPage.java:224)
at org.eclipse.ui.progress.UIJob$1.run(UIJob.java:94)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchr onizer.java:123)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.jav a:3325)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2971)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:820 )
at org.eclipse.jface.window.Window.open(Window.java:796)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.BaseDia log.open(BaseDialog.java:95)
at
org.eclipse.birt.report.designer.internal.ui.views.data.prov iders.DataSetNodeProvider.performEdit(DataSetNodeProvider.ja va:192)
at
org.eclipse.birt.report.designer.internal.ui.views.DefaultNo deProvider.performRequest(DefaultNodeProvider.java:355)
at
org.eclipse.birt.report.designer.internal.ui.views.actions.E ditAction.doAction(EditAction.java:79)
at
org.eclipse.birt.report.designer.internal.ui.views.actions.A bstractElementAction.run(AbstractElementAction.java:64)
at
org.eclipse.birt.report.designer.internal.ui.views.RenameLis tener.doubleClick(RenameListener.java:211)
at
org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredV iewer.java:796)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:843)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:14 9)
at
org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(S tructuredViewer.java:794)
at
org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSel ect(AbstractTreeViewer.java:1227)
at
org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSe lected(StructuredViewer.java:1158)
at
org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEven t(OpenStrategy.java:223)
at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.ja va:220)
at
org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrate gy.java:281)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2968)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:1914)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:419)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:149)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplicatio n.java:95)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(Pl atformActivator.java:78)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .runApplication(EclipseAppLauncher.java:92)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .start(EclipseAppLauncher.java:68)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:400)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336 )
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)
Caused by: java.sql.SQLException: ORA-01742: comment not terminated
properly
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891 )
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Proto col.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStat ement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac leStatement.java:2672)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Ora clePreparedStatement.java:589)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:527)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:340)
... 71 more
|
|
|
| Re: Data Set Error [message #202250 is a reply to message #202224] |
Tue, 21 November 2006 15:26 |
| Eclipse User |
|
|
|
Brad,
After replacing the
org.eclipse.birt.report.data.oda.jdbc_2.1.1.v20060922-1058 with
org.eclipse.birt.report.data.oda.jdbc_2.2.0.v20061117-1020, the query is
running successfully.
Thanks for the tips on the division inside the query. Was it treated as
escape string when binding to the JDBC?
Thanks,
Eric
|
|
|
Goto Forum:
Current Time: Thu May 15 13:26:35 EDT 2025
Powered by FUDForum. Page generated in 0.05529 seconds |
Home