SQL error #1: Incorrect syntax near ','. [message #559926] |
Mon, 20 September 2010 12:28 |
djudgeman 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 #560195 is a reply to message #560173] |
Tue, 21 September 2010 14:04 |
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.03617 seconds