Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
3.11
-
win2003
-
3.11
-
Description
"AT" is used as an alias in one of the sql statements from Jira.
see:
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
2008-04-29 16:18:53,893 http-8080-Processor20 ERROR [ext.charting.field.ResolutionDateDAO] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:
select min( at.CREATED) from jiraaction at , jiraissue it where at.issueid = ? and at.issueid = it.ID and at.actiontype = 'comment' and it.REPORTER != at.AUTHOR
(GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 13
at)
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:select min( at.CREATED) from jiraaction at , jiraissue it where at.issueid = ? and at.issueid = it.ID and at.actiontype = 'comment' and it.REPORTER != at.AUTHOR (GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 13
at)
at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:330)
at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:302)
at com.atlassian.jira.ext.charting.field.AbstractSingleDateDAO.calculateDate(AbstractSingleDateDAO.java:54)
at com.atlassian.jira.ext.charting.field.DateOfFirstResponseCFType.calculateFirstResponseDate(DateOfFirstResponseCFType.java:46)
at com.atlassian.jira.ext.charting.field.DateOfFirstResponseCFType.getValueFromIssue(DateOfFirstResponseCFType.java:34)
at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:266)