Hi all I'm trying to make a product requirement then approve it then go to the screen "Find approved requirements by supplier" so that I should see the requirements grouped by supplier then I face the following exception
Error getting list size Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELE T COUNT(DISTINCT *) FROM OFBIZ.REQUIREMENT RQ INNER JOIN OFBIZ.REQUIREMENT_ROL RQR ON RQ.REQUIREMENT_ID = RQR.REQUIREMENT_ID WHERE (RQR.ROLE_TYPE_ID = ? AND Q.STATUS_ID = ? AND RQ.REQUIREMENT_TYPE_ID = ? AND ((RQR.THRU_DATE IS NULL OR R R.THRU_DATE > ?) AND (RQR.FROM_DATE IS NULL OR RQR.FROM_DATE <= ?))) GROUP BY R R.PARTY_ID) TEMP_NAME (Syntax error: Encountered "*" at line 1, column 45.) ---- cause -------------------------------------------------------------------- Exception: java.sql.SQLSyntaxErrorException Message: Syntax error: Encountered "*" at line 1, column 45. ---- cause -------------------------------------------------------------------- Exception: org.apache.derby.impl.jdbc.EmbedSQLException Message: Syntax error: Encountered "*" at line 1, column 45. ---- cause -------------------------------------------------------------------- Exception: org.apache.derby.iapi.error.StandardException Message: Syntax error: Encountered "*" at line 1, column 45. ---- stack trace -------------------------------------------------------------- ERROR 42X01: Syntax error: Encountered "*" at line 1, column 45. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternal tatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnect on.java:291) org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnect on.java:291) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:362) org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1 81) org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityL stIterator.java:515) I'm using 10.04 and I didnt change anything in the file script service of the requirements has anyone used the requirements and the feature of grouping the requirements by suppliers? is their a bug or have I misused something Can anyone tell me what's the exception is about? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Getting-error-when-going-to-Find-Approved-Requirements-screen-tp3087755p3087755.html Sent from the OFBiz - User mailing list archive at Nabble.com.