Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC 6.0.2: CRRGW5612E An com.microsoft.sqlserver.jdbc.SQLServerException error caused by A processing error "'TIMESTAMP' is not a recognized built-in function

Questions
Tags
Users
Badges
Rafael Rodriguez Montes
(230●14●130●258) edited
Jan 05 '17, 3:20 a.m.
 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? 

0 votes

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 CRRGW5612E An com.microsoft.sqlserver.jdbc.SQLServerException error caused by A processing error "'TIMESTAMP' is not a recognized built-in function name." ID = JRS_PAC_LOOKUP_1.RESOURCE_ID) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = '....com')))))) AND ((((T3_1.PROJECT_ID IS NULL) OR (T3_1.PROJECT_ID = -1)) OR 

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

0 answers
4,023 views
0 votes

Be the first one to answer this question!

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 485

Question asked: Jan 03 '17, 1:33 p.m.

Question was seen: 4,023 times

Last updated: Jan 05 '17, 9:39 p.m.

Confirmation Cancel Confirm