Getting error when going to Find Approved Requirements screen

[Shereen]

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?

[BJ Freeman]

Syntax error: Encountered "*" at line 1, column 45.
of the sql that was sent to the  derby.

this should not  happen if your using OOTB and using the normal patterns
in code.


=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Shereen sent the following on 12/14/2010 11:03 AM:

>
> 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?

[Shereen]

Also when I navigate to "Find approved requirements" I face the following exception
does anyone have a clue about that?
2010-12-14 21:17:40,156 (http-0.0.0.0-8443-3) [FlexibleStringExpander.java:509:W
ARN ]
---- exception report ----------------------------------------------------------

Error evaluating BSH scriptlet [${bsh: org.ofbiz.party.party.PartyHelper.getPart
yName(delegator, partyId, false);}], inserting nothing; error was: Sourced file:
 inline evaluation of: `` org.ofbiz.party.party.PartyHelper.getPartyName(delegat
or, partyId, false);'' : Undefined variable or class name while evaluating: org.
ofbiz.party.party.PartyHelper : at Line: 1 : in file: inline evaluation of: `` o
rg.ofbiz.party.party.PartyHelper.getPartyName(delegator, partyId, false);'' : or
g .ofbiz .party .party .PartyHelper .getPartyName ( delegator , partyId , false
)

Exception: bsh.EvalError
Message: Sourced file: inline evaluation of: `` org.ofbiz.party.party.PartyHelpe
r.getPartyName(delegator, partyId, false);'' : Undefined variable or class name
while evaluating: org.ofbiz.party.party.PartyHelper
---- stack trace ---------------------------------------------------------------

Sourced file: inline evaluation of: `` org.ofbiz.party.party.PartyHelper.getPart
yName(delegator, partyId, false);'' : Undefined variable or class name while eva
luating: org.ofbiz.party.party.PartyHelper : at Line: 1 : in file: inline evalua
tion of: `` org.ofbiz.party.party.PartyHelper.getPartyName(delegator, partyId, f
alse);'' : org .ofbiz .party .party .PartyHelper .getPartyName ( delegator , par
tyId , false )
bsh.UtilEvalError.toEvalError(Unknown Source)
bsh.UtilEvalError.toEvalError(Unknown Source)
bsh.BSHMethodInvocation.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.Interpreter.evalParsedScript(Unknown Source)
bsh.Interpreter.eval(Unknown Source)
bsh.Interpreter.eval(Unknown Source)
bsh.Interpreter.eval(Unknown Source)
org.ofbiz.base.util.BshUtil.eval(BshUtil.java:72)
org.ofbiz.base.util.string.FlexibleStringExpander$BshElem.get(FlexibleStringExpa
nder.java:500)
org.ofbiz.base.util.string.FlexibleStringExpander.expandString(FlexibleStringExp
ander.java:386)
org.ofbiz.base.util.string.FlexibleStringExpander.expandString(FlexibleStringExp
ander.java:356)
org.ofbiz.widget.form.ModelFormField$DisplayField.getDescription(ModelFormField.
java:2101)
org.ofbiz.widget.form.MacroFormRenderer.renderDisplayField(MacroFormRenderer.jav
a:190)
org.ofbiz.widget.form.ModelFormField$DisplayField.renderFieldString(ModelFormFie
ld.java:2084)
org.ofbiz.widget.form.ModelFormField.renderFieldString(ModelFormField.java:595)
org.ofbiz.widget.form.ModelForm.renderItemRow(ModelForm.java:1665)
org.ofbiz.widget.form.ModelForm.renderItemRows(ModelForm.java:1593)
org.ofbiz.widget.form.ModelForm.renderListFormString(ModelForm.java:1105)
org.ofbiz.widget.form.ModelForm.renderFormString(ModelForm.java:839)
org.ofbiz.widget.screen.ModelScreenWidget$Form.renderWidgetString(ModelScreenWid
get.java:840)
org.ofbiz.widget.screen.MacroScreenRenderer.renderScreenletSubWidget(MacroScreen
Renderer.java:710)

[BJ Freeman]

inline evaluation of: ``
org.ofbiz.party.party.PartyHelper.getPartyName(delegat
or, partyId, false);'' : Undefined variable or class name while evaluating:


=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Shereen sent the following on 12/14/2010 11:24 AM:

>
>
> Also when I navigate to "Find approved requirements" I face the following
> exception
> does anyone have a clue about that?
> 2010-12-14 21:17:40,156 (http-0.0.0.0-8443-3)
> [FlexibleStringExpander.java:509:W
> ARN ]
> ---- exception report
> ----------------------------------------------------------
>
> Error evaluating BSH scriptlet [${bsh:
> org.ofbiz.party.party.PartyHelper.getPart
> yName(delegator, partyId, false);}], inserting nothing; error was: Sourced
> file:
>   inline evaluation of: ``
> org.ofbiz.party.party.PartyHelper.getPartyName(delegat
> or, partyId, false);'' : Undefined variable or class name while evaluating:
> org.
> ofbiz.party.party.PartyHelper : at Line: 1 : in file: inline evaluation of:
> `` o
> rg.ofbiz.party.party.PartyHelper.getPartyName(delegator, partyId, false);''
> : or
> g .ofbiz .party .party .PartyHelper .getPartyName ( delegator , partyId ,
> false
> )
>
> Exception: bsh.EvalError
> Message: Sourced file: inline evaluation of: ``
> org.ofbiz.party.party.PartyHelpe
> r.getPartyName(delegator, partyId, false);'' : Undefined variable or class
> name
> while evaluating: org.ofbiz.party.party.PartyHelper
> ---- stack trace
> ---------------------------------------------------------------
>
> Sourced file: inline evaluation of: ``
> org.ofbiz.party.party.PartyHelper.getPart
> yName(delegator, partyId, false);'' : Undefined variable or class name while
> eva
> luating: org.ofbiz.party.party.PartyHelper : at Line: 1 : in file: inline
> evalua
> tion of: `` org.ofbiz.party.party.PartyHelper.getPartyName(delegator,
> partyId, f
> alse);'' : org .ofbiz .party .party .PartyHelper .getPartyName ( delegator ,
> par
> tyId , false )
> bsh.UtilEvalError.toEvalError(Unknown Source)
> bsh.UtilEvalError.toEvalError(Unknown Source)
> bsh.BSHMethodInvocation.eval(Unknown Source)
> bsh.BSHPrimaryExpression.eval(Unknown Source)
> bsh.BSHPrimaryExpression.eval(Unknown Source)
> bsh.Interpreter.evalParsedScript(Unknown Source)
> bsh.Interpreter.eval(Unknown Source)
> bsh.Interpreter.eval(Unknown Source)
> bsh.Interpreter.eval(Unknown Source)
> org.ofbiz.base.util.BshUtil.eval(BshUtil.java:72)
> org.ofbiz.base.util.string.FlexibleStringExpander$BshElem.get(FlexibleStringExpa
> nder.java:500)
> org.ofbiz.base.util.string.FlexibleStringExpander.expandString(FlexibleStringExp
> ander.java:386)
> org.ofbiz.base.util.string.FlexibleStringExpander.expandString(FlexibleStringExp
> ander.java:356)
> org.ofbiz.widget.form.ModelFormField$DisplayField.getDescription(ModelFormField.
> java:2101)
> org.ofbiz.widget.form.MacroFormRenderer.renderDisplayField(MacroFormRenderer.jav
> a:190)
> org.ofbiz.widget.form.ModelFormField$DisplayField.renderFieldString(ModelFormFie
> ld.java:2084)
> org.ofbiz.widget.form.ModelFormField.renderFieldString(ModelFormField.java:595)
> org.ofbiz.widget.form.ModelForm.renderItemRow(ModelForm.java:1665)
> org.ofbiz.widget.form.ModelForm.renderItemRows(ModelForm.java:1593)
> org.ofbiz.widget.form.ModelForm.renderListFormString(ModelForm.java:1105)
> org.ofbiz.widget.form.ModelForm.renderFormString(ModelForm.java:839)
> org.ofbiz.widget.screen.ModelScreenWidget$Form.renderWidgetString(ModelScreenWid
> get.java:840)
> org.ofbiz.widget.screen.MacroScreenRenderer.renderScreenletSubWidget(MacroScreen
> Renderer.java:710)