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

 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

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.

 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. 

 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 

Open a ticket with IBM Support. We can't do much about it on this forum.

1 vote


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.

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
× 481

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

Question was seen: 1,519 times

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

Confirmation Cancel Confirm