You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by BJ Freeman <bj...@free-man.net> on 2007/10/09 06:25:57 UTC

svn commit: r582468 - in /ofbiz/trunk/applications/party: webapp/partymgr/party/viewprofile.ftl widget/partymgr/PartyScreens.xml

had a later 4.0 release and upgraded to current.

after doing a find on the partymgr I click on any of my partyid's and
get this




I belive this may be causing

org.ofbiz.base.util.GeneralException: Error rendering screen
[component://party/widget/partymgr/PartyScreens.xml#viewprofile]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
location
[component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
line [86]: Sourced file:
component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
: Method Invocation delegator.findByAnd : at Line: 86 : in file:
component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
: delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
"targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )

Target exception: org.ofbiz.entity.GenericDataSourceException: SQL
Exception while executing the following:SELECT PN.PARTY_ID AS
TARGET_PARTY_ID, ND.NOTE_ID AS NOTE_ID, ND.NOTE_NAME AS NOTE_NAME,
ND.NOTE_INFO AS NOTE_INFO, ND.NOTE_DATE_TIME AS NOTE_DATE_TIME,
ND.NOTE_PARTY AS NOTE_PARTY FROM public.PARTY_NOTE PN INNER JOIN
public.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (TARGET_PARTY_ID =
?) ORDER BY NOTE_DATE_TIME DESC (ERROR: column "target_party_id" does
not exist)
(Sourced file:
component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
: Method Invocation delegator.findByAnd) (Error running BSH script at
[component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
line [86]: Sourced file:
component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
: Method Invocation delegator.findByAnd : at Line: 86 : in file:
component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
: delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
"targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )

Re: svn commit: r582468 - in /ofbiz/trunk/applications/party: webapp/partymgr/party/viewprofile.ftl widget/partymgr/PartyScreens.xml

Posted by Scott Gray <le...@gmail.com>.
New database, but either way the view definition is good so there really
shouldn't be any problems.

Regards
Scott

On 09/10/2007, BJ Freeman <bj...@free-man.net> wrote:
>
> Scott: did you did this with an existing dB or new one?
> mines is an existing one
>
>
> Scott Gray sent the following on 10/9/2007 2:25 AM:
> > Hi BJ
> >
> > I just had a go and I'm not having any problems...
> >
> > Regards
> > Scott
> >
> > On 09/10/2007, BJ Freeman <bj...@free-man.net> wrote:
> >> found this in the log
> >> java.sql.SQLException: ERROR: column "target_party_id" does not exist
> >>
> >>
> >> BJ Freeman sent the following on 10/8/2007 9:25 PM:
> >>> had a later 4.0 release and upgraded to current.
> >>>
> >>> after doing a find on the partymgr I click on any of my partyid's and
> >>> get this
> >>>
> >>>
> >>>
> >>>
> >>> I belive this may be causing
> >>>
> >>> org.ofbiz.base.util.GeneralException: Error rendering screen
> >>> [component://party/widget/partymgr/PartyScreens.xml#viewprofile]:
> >>> org.ofbiz.base.util.GeneralException: Error running BSH script at
> >>> location
> >>>
> >>
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh]:
> >>> org.ofbiz.base.util.GeneralException: Error running BSH script at
> >>>
> >>
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
> >>> line [86]: Sourced file:
> >>>
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> >>> : Method Invocation delegator.findByAnd : at Line: 86 : in file:
> >>>
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> >>> : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
> >>> "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> >>>
> >>> Target exception: org.ofbiz.entity.GenericDataSourceException: SQL
> >>> Exception while executing the following:SELECT PN.PARTY_ID AS
> >>> TARGET_PARTY_ID, ND.NOTE_ID AS NOTE_ID, ND.NOTE_NAME AS NOTE_NAME,
> >>> ND.NOTE_INFO AS NOTE_INFO, ND.NOTE_DATE_TIME AS NOTE_DATE_TIME,
> >>> ND.NOTE_PARTY AS NOTE_PARTY FROM public.PARTY_NOTE PN INNER JOIN
> >>> public.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (TARGET_PARTY_ID
> =
> >>> ?) ORDER BY NOTE_DATE_TIME DESC (ERROR: column "target_party_id" does
> >>> not exist)
> >>> (Sourced file:
> >>>
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> >>> : Method Invocation delegator.findByAnd) (Error running BSH script at
> >>>
> >>
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
> >>> line [86]: Sourced file:
> >>>
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> >>> : Method Invocation delegator.findByAnd : at Line: 86 : in file:
> >>>
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> >>> : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
> >>> "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> >>>
> >>>
> >>>
> >
>

Re: svn commit: r582468 - in /ofbiz/trunk/applications/party: webapp/partymgr/party/viewprofile.ftl widget/partymgr/PartyScreens.xml

Posted by BJ Freeman <bj...@free-man.net>.
Scott: did you did this with an existing dB or new one?
mines is an existing one


Scott Gray sent the following on 10/9/2007 2:25 AM:
> Hi BJ
> 
> I just had a go and I'm not having any problems...
> 
> Regards
> Scott
> 
> On 09/10/2007, BJ Freeman <bj...@free-man.net> wrote:
>> found this in the log
>> java.sql.SQLException: ERROR: column "target_party_id" does not exist
>>
>>
>> BJ Freeman sent the following on 10/8/2007 9:25 PM:
>>> had a later 4.0 release and upgraded to current.
>>>
>>> after doing a find on the partymgr I click on any of my partyid's and
>>> get this
>>>
>>>
>>>
>>>
>>> I belive this may be causing
>>>
>>> org.ofbiz.base.util.GeneralException: Error rendering screen
>>> [component://party/widget/partymgr/PartyScreens.xml#viewprofile]:
>>> org.ofbiz.base.util.GeneralException: Error running BSH script at
>>> location
>>>
>> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh]:
>>> org.ofbiz.base.util.GeneralException: Error running BSH script at
>>>
>> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
>>> line [86]: Sourced file:
>>> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
>>> : Method Invocation delegator.findByAnd : at Line: 86 : in file:
>>> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
>>> : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
>>> "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
>>>
>>> Target exception: org.ofbiz.entity.GenericDataSourceException: SQL
>>> Exception while executing the following:SELECT PN.PARTY_ID AS
>>> TARGET_PARTY_ID, ND.NOTE_ID AS NOTE_ID, ND.NOTE_NAME AS NOTE_NAME,
>>> ND.NOTE_INFO AS NOTE_INFO, ND.NOTE_DATE_TIME AS NOTE_DATE_TIME,
>>> ND.NOTE_PARTY AS NOTE_PARTY FROM public.PARTY_NOTE PN INNER JOIN
>>> public.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (TARGET_PARTY_ID =
>>> ?) ORDER BY NOTE_DATE_TIME DESC (ERROR: column "target_party_id" does
>>> not exist)
>>> (Sourced file:
>>> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
>>> : Method Invocation delegator.findByAnd) (Error running BSH script at
>>>
>> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
>>> line [86]: Sourced file:
>>> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
>>> : Method Invocation delegator.findByAnd : at Line: 86 : in file:
>>> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
>>> : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
>>> "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
>>>
>>>
>>>
>

Re: svn commit: r582468 - in /ofbiz/trunk/applications/party: webapp/partymgr/party/viewprofile.ftl widget/partymgr/PartyScreens.xml

Posted by Scott Gray <le...@gmail.com>.
Hi BJ

I just had a go and I'm not having any problems...

Regards
Scott

On 09/10/2007, BJ Freeman <bj...@free-man.net> wrote:
>
> found this in the log
> java.sql.SQLException: ERROR: column "target_party_id" does not exist
>
>
> BJ Freeman sent the following on 10/8/2007 9:25 PM:
> > had a later 4.0 release and upgraded to current.
> >
> > after doing a find on the partymgr I click on any of my partyid's and
> > get this
> >
> >
> >
> >
> > I belive this may be causing
> >
> > org.ofbiz.base.util.GeneralException: Error rendering screen
> > [component://party/widget/partymgr/PartyScreens.xml#viewprofile]:
> > org.ofbiz.base.util.GeneralException: Error running BSH script at
> > location
> >
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh]:
> > org.ofbiz.base.util.GeneralException: Error running BSH script at
> >
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
> > line [86]: Sourced file:
> > component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> > : Method Invocation delegator.findByAnd : at Line: 86 : in file:
> > component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> > : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
> > "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> >
> > Target exception: org.ofbiz.entity.GenericDataSourceException: SQL
> > Exception while executing the following:SELECT PN.PARTY_ID AS
> > TARGET_PARTY_ID, ND.NOTE_ID AS NOTE_ID, ND.NOTE_NAME AS NOTE_NAME,
> > ND.NOTE_INFO AS NOTE_INFO, ND.NOTE_DATE_TIME AS NOTE_DATE_TIME,
> > ND.NOTE_PARTY AS NOTE_PARTY FROM public.PARTY_NOTE PN INNER JOIN
> > public.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (TARGET_PARTY_ID =
> > ?) ORDER BY NOTE_DATE_TIME DESC (ERROR: column "target_party_id" does
> > not exist)
> > (Sourced file:
> > component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> > : Method Invocation delegator.findByAnd) (Error running BSH script at
> >
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
> > line [86]: Sourced file:
> > component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> > : Method Invocation delegator.findByAnd : at Line: 86 : in file:
> > component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> > : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
> > "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> >
> >
> >
>

Re: svn commit: r582468 - in /ofbiz/trunk/applications/party: webapp/partymgr/party/viewprofile.ftl widget/partymgr/PartyScreens.xml

Posted by BJ Freeman <bj...@free-man.net>.
found this in the log
java.sql.SQLException: ERROR: column "target_party_id" does not exist


BJ Freeman sent the following on 10/8/2007 9:25 PM:
> had a later 4.0 release and upgraded to current.
> 
> after doing a find on the partymgr I click on any of my partyid's and
> get this
> 
> 
> 
> 
> I belive this may be causing
> 
> org.ofbiz.base.util.GeneralException: Error rendering screen
> [component://party/widget/partymgr/PartyScreens.xml#viewprofile]:
> org.ofbiz.base.util.GeneralException: Error running BSH script at
> location
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh]:
> org.ofbiz.base.util.GeneralException: Error running BSH script at
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
> line [86]: Sourced file:
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> : Method Invocation delegator.findByAnd : at Line: 86 : in file:
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
> "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> 
> Target exception: org.ofbiz.entity.GenericDataSourceException: SQL
> Exception while executing the following:SELECT PN.PARTY_ID AS
> TARGET_PARTY_ID, ND.NOTE_ID AS NOTE_ID, ND.NOTE_NAME AS NOTE_NAME,
> ND.NOTE_INFO AS NOTE_INFO, ND.NOTE_DATE_TIME AS NOTE_DATE_TIME,
> ND.NOTE_PARTY AS NOTE_PARTY FROM public.PARTY_NOTE PN INNER JOIN
> public.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (TARGET_PARTY_ID =
> ?) ORDER BY NOTE_DATE_TIME DESC (ERROR: column "target_party_id" does
> not exist)
> (Sourced file:
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> : Method Invocation delegator.findByAnd) (Error running BSH script at
> [component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh],
> line [86]: Sourced file:
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> : Method Invocation delegator.findByAnd : at Line: 86 : in file:
> component://party/webapp/partymgr/WEB-INF/actions/party/viewprofile.bsh
> : delegator .findByAnd ( "PartyNoteView" , UtilMisc .toMap (
> "targetPartyId" , partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
> 
> 
>