Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » SQL error #1: Incorrect syntax near ','.
SQL error #1: Incorrect syntax near ','. [message #559926] Mon, 20 September 2010 12:28 Go to next message
djudgeman  is currently offline djudgeman Friend
Messages: 4
Registered: September 2010
Junior Member
When I click on the link type drill thru I get this SQL error.
SQL error #1: Incorrect syntax near ','.

Example is when I click on production or development below I get the error.
Manager Environment Events Group Pct. Total Pct.
VENDOR
Production 2,933 69.16 44.83
Development 1,308 30.84 19.99

here is the sql statement in link program

<xml-property name="queryText"><![CDATA[select CWAF_EVENT.EVENT_ID,
CWAF_EVENT.PROGRAM_NAME,
CWAF_EVENT.NAME,
CWAF_EVENT.TYPE,
CWAF_EVENT.APPLICATION,
CWAF_EVENT.LINK,
CWAF_EVENT.MACHINE_NAME,
CWAF_EVENT.USER_ID,
CWAF_EVENT.OS_NAME,
CWAF_EVENT.OS_RELEASE,
CWAF_EVENT.CPU_TIME,
CWAF_EVENT.ELAPSED_TIME,
CWAF_EVENT.TS_UTC,
CWAF_EVENT.TS_UTC as NORMALIZED_TS,
CWAF_FAULT.PRIMARY_FAULT_CODE,
CWAF_FAULT_OS390.JOB_NAME,
CWAF_FAULT_OS390.JOB_CLASS,
CWAF_FAULT_OS390.JOB_PRIORITY,
CWAF_FAULT_OS390.JOB_JES_ID,
CWAF_FAULT_OS390.STEPNAME,
CWAF_FAULT_OS390.JOB_CPU_TIME,
CWAF_FAULT_OS390.JOB_ELAPSED_TIME
from CWAF_FAULT_OS390
left join CWAF_EVENT on CWAF_FAULT_OS390.EVENT_ID = CWAF_EVENT.EVENT_ID
left join CWAF_FAULT on CWAF_FAULT_OS390.EVENT_ID = CWAF_FAULT.EVENT_ID
where TS_UTC >= ?
and TS_UTC <= ?]]></xml-property>

Any help is sure appreciated.
Re: SQL error #1: Incorrect syntax near ','. [message #559933 is a reply to message #559926] Mon, 20 September 2010 12:55 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 199
Registered: July 2009
Location: Houston TX
Senior Member

Please clarify. Is your drillthrough going to a different BIRT report? Have you validated that report first and have you verified that the parameters are being passed correctly?
Re: SQL error #1: Incorrect syntax near ','. [message #560173 is a reply to message #559933] Tue, 21 September 2010 12:53 Go to previous messageGo to next message
djudgeman  is currently offline djudgeman Friend
Messages: 4
Registered: September 2010
Junior Member
yes it is going to a different birt report. how can I validate that the parameters are being passed if I'm getting the SQL error?
Re: SQL error #1: Incorrect syntax near ','. [message #560195 is a reply to message #560173] Tue, 21 September 2010 14:04 Go to previous message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 199
Registered: July 2009
Location: Houston TX
Senior Member

The two questions are, what parameters (and data types) does your target report expect, and how are you passing them in the hyperlink property?

If you haven't read the BIRT guides (either the Field Guide from Addison Wesley or Practical Data Analysis and Reporting from PACKT Publishing) then you need to start there.
Previous Topic:How do debug AssertionError cannot be cast to Exception?
Next Topic:more customize report viewer
Goto Forum:
  


Current Time: Mon Dec 22 05:01:35 GMT 2014

Powered by FUDForum. Page generated in 0.02732 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software