You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Shereen <sh...@hotmail.com> on 2010/12/14 20:03:30 UTC
Getting error when going to Find Approved Requirements screen
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.
Re: Getting error when going to Find Approved Requirements screen
Posted by BJ Freeman <bj...@free-man.net>.
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)
Re: Getting error when going to Find Approved Requirements screen
Posted by Shereen <sh...@hotmail.com>.
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)
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Getting-error-when-going-to-Find-Approved-Requirements-screen-tp3087755p3087784.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting error when going to Find Approved Requirements screen
Posted by BJ Freeman <bj...@free-man.net>.
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?