Hello,
I'm running RTC 6.0.2 with websphere 8.5.5, I have a report in RS, and when I do click on the chart, I'm getting this error message:
CRRGW5612E An com.microsoft.sqlserver.jdbc.SQLServerException error caused by A processing error "'TIMESTAMP' is not a recognized built-in function name." occurred. occurred when parsing the query string SELECT DISTINCT T1.REQUEST_TYPE AS REQUEST_TYPE, T1.REFERENCE_ID AS REFERENCE_ID, T2.VAL AS VAL, T1.SUMMARY AS SUMMARY, T3_1.LITERAL_NAME AS LITERAL_NAME6, T1.REQUEST_STATE AS REQUEST_STATE, ...
any idea why?
Comments
Donald Nong
Jan 03 '17, 8:32 p.m.You will need to get the complete SQL statement. Check the log file and see if it's there. If the SQL statement is written by hand, correct it. If the SQL statement is generated by JRS, report the issue to IBM Support and explain how the report is constructed - a potential defect.
Rafael Rodriguez Montes
Jan 05 '17, 11:52 a.m.Hello, I had change the chart because the quantities were not consistent with the actual number of work items, even when I had the warehouse updated, I change some filters and now looks better the presentation, but now my problem is when I do click on the bars of the chart, it wont take to the list results for the specific segment selected on the chart bars.
Rafael Rodriguez Montes
Jan 05 '17, 6:33 p.m.I was able to reproduce the error and here is the full text
Donald Nong
Jan 05 '17, 9:39 p.m.Open a ticket with IBM Support. We can't do much about it on this forum.
1 vote