You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Rajesh Mallah <ma...@gmail.com> on 2017/08/26 06:49:36 UTC
newly created PartyGroup not searchable by web service findPartiesById
Hi
We have an instance using the stock demo,seed,seed-initial data.
All the PartyGroups imported via demo are searchable using
web service method findPartiesById .
However when we create a Party Group by the UI and search
using same process the result is nil.
the RPCXML conversation is here:
https://pastebin.com/1LB9BCFd
am i missing anything ?
regds
mallah.
Re: newly created PartyGroup not searchable by web service findPartiesById
Posted by Rajesh Mallah <ma...@gmail.com>.
Thanks I will go through it .
On Sun, Aug 27, 2017 at 12:51 AM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Those are actually numbers represented as strings, see fieldtypederby.xml
> as an example (look for id)
>
> That's why Renuka's answer is correct
>
> Jacques
>
>
>
> Le 26/08/2017 à 12:08, Rajesh Mallah a écrit :
>
>> Hi Renuka ,
>>
>> Creating the Party Group was not the problem.
>> The problem was that i was not able to search the created group using
>> XMLRPC.
>>
>> When we leave group id empty it auto generates it , so IMHO its not
>> correct to say "partyID cannot be the digit"
>>
>> I was able to search the groups on specifying the id as string type during
>> making the request
>> using XMLRPC.
>>
>> Now my issue is solved.
>>
>>
>> regds
>> mallah.
>>
>>
>>
>>
>>
>>
>> On Sat, Aug 26, 2017 at 3:23 PM, Renuka Srishti <
>> renuka.srishti93@gmail.com>
>> wrote:
>>
>> Hello Rajesh,
>>>
>>> There are 2 ways to create party group:
>>> 1. If you do not enter any specific ID, it will work.
>>> 2. When you create party group with ID as the digit, it shows an error
>>> that
>>> you can not create party group, partyId can not be the digit.
>>> Alphanumeric
>>> is reserved for this. Hence part group is not created, that's why its not
>>> showing any result on search.
>>>
>>> Thanks
>>> Renuka Srishti
>>>
>>> On Sat, Aug 26, 2017 at 1:43 PM, Rajesh Mallah <ma...@gmail.com>
>>> wrote:
>>>
>>> observation:
>>>>
>>>> On passing 10000 as string by qualifying the type in XML things work as
>>>> expected.
>>>>
>>>> Eg: below works ( <value><string>10000</string></value> )
>>>>
>>>> REQ >>>>>>>>>
>>>> <methodCall><methodName>findPartiesById</methodName><
>>>> params><param><value><struct><member><name>login.username</
>>>> name><value><string><![CDATA[admin]]></string></value></
>>>> member><member><name>login.password</name><value><string>
>>>> <![CDATA[ofbiz]]></string></value></member><member><name>
>>>> idToFind</name><value><string>10000</string></value></
>>>> member></struct></value></param></params></methodCall>
>>>>
>>>> and
>>>>
>>>> below ( <value><i4>10000</i4></value> ) does not.
>>>>
>>>>
>>>> REQ >>>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> REQ >>>>>>>>>
>>>> <methodCall><methodName>findPartiesById</methodName><
>>>> params><param><value><struct><member><name>login.password</
>>>> name><value><string><![CDATA[ofbiz]]></string></value></
>>>> member><member><name>idToFind</name><value><i4>10000</i4></
>>>> value></member><member><name>login.username</name><value><
>>>> string><![CDATA[admin]]></string></value></member></
>>>> struct></value></param></params></methodCall>
>>>>
>>>>
>>>> IMHO the conversion of 10000 to 10,000 in backend is causing the
>>>>
>>> problem
>>>
>>>> .
>>>> I am not sure if there is a scope of improvement or application
>>>>
>>> programmers
>>>
>>>> should
>>>> be more careful by explicitly sending qualified types.
>>>>
>>>> regds
>>>> mallah.
>>>>
>>>>
>>>>
>>>> On Sat, Aug 26, 2017 at 1:19 PM, Rajesh Mallah <mallah.rajesh@gmail.com
>>>> >
>>>> wrote:
>>>>
>>>> I think i caught it ,
>>>>>
>>>>> The problem is occurring only for numeric id. When i explicitly
>>>>>
>>>> specify
>>>
>>>> a
>>>>
>>>>> alphanum
>>>>> id in creating a new party group then the problem is not there.
>>>>>
>>>>> This is supported by the kind of sqls being created also :
>>>>> ( note the where clause ) i had specified partyID as '10000' not sure
>>>>>
>>>> if
>>>
>>>> its' derby specific.
>>>>>
>>>>> 2017-08-26 13:10:23,767 |http-nio-8080-exec-1
>>>>> |GenericDAO |T| Ran query in 1 milli-seconds:
>>>>> EntityName: Party Sql: SELECT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
>>>>> PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
>>>>> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
>>>>> DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
>>>>> CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY WHERE ((PARTY_ID = ?))
>>>>> where clause:[PARTY_ID=10,000]
>>>>>
>>>>>
>>>>> Does it qualify to be a BUG ?
>>>>> I think the ramifications are severe as most application developers
>>>>>
>>>> would
>>>
>>>> like
>>>>> system to auto generate IDs for them.
>>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl 10000
>>>>> \ {
>>>>> partiesFound [],
>>>>> party undef
>>>>> }
>>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
>>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
>>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
>>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl MyID1000
>>>>> \ {
>>>>> partiesFound [],
>>>>> party {
>>>>> createdByUserLogin "admin",
>>>>> createdDate "20170826T13:12:47",
>>>>> createdStamp "20170826T13:12:47",
>>>>> createdTxStamp "20170826T13:12:47",
>>>>> dataSourceId undef,
>>>>> description undef,
>>>>> externalId undef,
>>>>> isUnread undef,
>>>>> lastModifiedByUserLogin "admin",
>>>>> lastModifiedDate "20170826T13:12:47",
>>>>> lastUpdatedStamp "20170826T13:12:47",
>>>>> lastUpdatedTxStamp "20170826T13:12:47",
>>>>> partyId "MyID1000",
>>>>> partyTypeId "PARTY_GROUP",
>>>>> preferredCurrencyUomId "USD",
>>>>> statusId "PARTY_ENABLED"
>>>>> }
>>>>> }
>>>>>
>>>>> Regds
>>>>> mallah
>>>>>
>>>>>
>>>>> On Sat, Aug 26, 2017 at 1:00 PM, Rajesh Mallah <
>>>>>
>>>> mallah.rajesh@gmail.com>
>>>
>>>> wrote:
>>>>>
>>>>> Hi Renuka ,
>>>>>>
>>>>>> Thanks for Response , My Steps are as follows
>>>>>>
>>>>>> (1) load seed,seed-initial,demo
>>>>>> (2) login to Ofbiz , using web ui and create a PartyGroup via
>>>>>> Application > Party > New Party Group
>>>>>> (3) execute findPartiesById using RPC eg:
>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Using+
>>>>>> XMLRPC+as+an+alternative+to+SOAP
>>>>>>
>>>>>> ( I use perl or the same https://pastebin.com/raw/UwLNq5AT ).
>>>>>>
>>>>>> (4) With new company ID the service findPartiesById does not return
>>>>>>
>>>>> any
>>>
>>>> data , whereas for old data like 'Company'
>>>>>> it does return..
>>>>>>
>>>>>> the problem seems to be with XMLRPC method only , as executing the
>>>>>> service via
>>>>>> Framework Web Tools > Run Service works fine for all PartyId.
>>>>>>
>>>>>> regds
>>>>>> mallah.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti <
>>>>>> renuka.srishti93@gmail.com> wrote:
>>>>>>
>>>>>> Hello Rajesh,
>>>>>>>
>>>>>>> Can you mention the steps you followed? As I have tried and its
>>>>>>>
>>>>>> working
>>>
>>>> fine.
>>>>>>>
>>>>>>> Yes, here I can see one improvement that after creating any party, we
>>>>>>> redirect to view profile and UI of this screen need some improvement.
>>>>>>>
>>>>>> The
>>>>
>>>>> message was shown there is not correct.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Renuka Srishti
>>>>>>>
>>>>>>> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <
>>>>>>>
>>>>>> mallah.rajesh@gmail.com
>>>>
>>>>> wrote:
>>>>>>>
>>>>>>> Hi
>>>>>>>>
>>>>>>>> We have an instance using the stock demo,seed,seed-initial data.
>>>>>>>> All the PartyGroups imported via demo are searchable using
>>>>>>>> web service method findPartiesById .
>>>>>>>>
>>>>>>>> However when we create a Party Group by the UI and search
>>>>>>>> using same process the result is nil.
>>>>>>>>
>>>>>>>> the RPCXML conversation is here:
>>>>>>>>
>>>>>>>> https://pastebin.com/1LB9BCFd
>>>>>>>>
>>>>>>>> am i missing anything ?
>>>>>>>>
>>>>>>>>
>>>>>>>> regds
>>>>>>>> mallah.
>>>>>>>>
>>>>>>>>
>>>>>>
>
Re: newly created PartyGroup not searchable by web service
findPartiesById
Posted by Jacques Le Roux <ja...@les7arts.com>.
Those are actually numbers represented as strings, see fieldtypederby.xml as an example (look for id)
That's why Renuka's answer is correct
Jacques
Le 26/08/2017 à 12:08, Rajesh Mallah a écrit :
> Hi Renuka ,
>
> Creating the Party Group was not the problem.
> The problem was that i was not able to search the created group using
> XMLRPC.
>
> When we leave group id empty it auto generates it , so IMHO its not
> correct to say "partyID cannot be the digit"
>
> I was able to search the groups on specifying the id as string type during
> making the request
> using XMLRPC.
>
> Now my issue is solved.
>
>
> regds
> mallah.
>
>
>
>
>
>
> On Sat, Aug 26, 2017 at 3:23 PM, Renuka Srishti <re...@gmail.com>
> wrote:
>
>> Hello Rajesh,
>>
>> There are 2 ways to create party group:
>> 1. If you do not enter any specific ID, it will work.
>> 2. When you create party group with ID as the digit, it shows an error that
>> you can not create party group, partyId can not be the digit. Alphanumeric
>> is reserved for this. Hence part group is not created, that's why its not
>> showing any result on search.
>>
>> Thanks
>> Renuka Srishti
>>
>> On Sat, Aug 26, 2017 at 1:43 PM, Rajesh Mallah <ma...@gmail.com>
>> wrote:
>>
>>> observation:
>>>
>>> On passing 10000 as string by qualifying the type in XML things work as
>>> expected.
>>>
>>> Eg: below works ( <value><string>10000</string></value> )
>>>
>>> REQ >>>>>>>>>
>>> <methodCall><methodName>findPartiesById</methodName><
>>> params><param><value><struct><member><name>login.username</
>>> name><value><string><![CDATA[admin]]></string></value></
>>> member><member><name>login.password</name><value><string>
>>> <![CDATA[ofbiz]]></string></value></member><member><name>
>>> idToFind</name><value><string>10000</string></value></
>>> member></struct></value></param></params></methodCall>
>>>
>>> and
>>>
>>> below ( <value><i4>10000</i4></value> ) does not.
>>>
>>>
>>> REQ >>>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>> REQ >>>>>>>>>
>>> <methodCall><methodName>findPartiesById</methodName><
>>> params><param><value><struct><member><name>login.password</
>>> name><value><string><![CDATA[ofbiz]]></string></value></
>>> member><member><name>idToFind</name><value><i4>10000</i4></
>>> value></member><member><name>login.username</name><value><
>>> string><![CDATA[admin]]></string></value></member></
>>> struct></value></param></params></methodCall>
>>>
>>>
>>> IMHO the conversion of 10000 to 10,000 in backend is causing the
>> problem
>>> .
>>> I am not sure if there is a scope of improvement or application
>> programmers
>>> should
>>> be more careful by explicitly sending qualified types.
>>>
>>> regds
>>> mallah.
>>>
>>>
>>>
>>> On Sat, Aug 26, 2017 at 1:19 PM, Rajesh Mallah <ma...@gmail.com>
>>> wrote:
>>>
>>>> I think i caught it ,
>>>>
>>>> The problem is occurring only for numeric id. When i explicitly
>> specify
>>> a
>>>> alphanum
>>>> id in creating a new party group then the problem is not there.
>>>>
>>>> This is supported by the kind of sqls being created also :
>>>> ( note the where clause ) i had specified partyID as '10000' not sure
>> if
>>>> its' derby specific.
>>>>
>>>> 2017-08-26 13:10:23,767 |http-nio-8080-exec-1
>>>> |GenericDAO |T| Ran query in 1 milli-seconds:
>>>> EntityName: Party Sql: SELECT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
>>>> PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
>>>> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
>>>> DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
>>>> CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY WHERE ((PARTY_ID = ?))
>>>> where clause:[PARTY_ID=10,000]
>>>>
>>>>
>>>> Does it qualify to be a BUG ?
>>>> I think the ramifications are severe as most application developers
>> would
>>>> like
>>>> system to auto generate IDs for them.
>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl 10000
>>>> \ {
>>>> partiesFound [],
>>>> party undef
>>>> }
>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
>>>> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl MyID1000
>>>> \ {
>>>> partiesFound [],
>>>> party {
>>>> createdByUserLogin "admin",
>>>> createdDate "20170826T13:12:47",
>>>> createdStamp "20170826T13:12:47",
>>>> createdTxStamp "20170826T13:12:47",
>>>> dataSourceId undef,
>>>> description undef,
>>>> externalId undef,
>>>> isUnread undef,
>>>> lastModifiedByUserLogin "admin",
>>>> lastModifiedDate "20170826T13:12:47",
>>>> lastUpdatedStamp "20170826T13:12:47",
>>>> lastUpdatedTxStamp "20170826T13:12:47",
>>>> partyId "MyID1000",
>>>> partyTypeId "PARTY_GROUP",
>>>> preferredCurrencyUomId "USD",
>>>> statusId "PARTY_ENABLED"
>>>> }
>>>> }
>>>>
>>>> Regds
>>>> mallah
>>>>
>>>>
>>>> On Sat, Aug 26, 2017 at 1:00 PM, Rajesh Mallah <
>> mallah.rajesh@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi Renuka ,
>>>>>
>>>>> Thanks for Response , My Steps are as follows
>>>>>
>>>>> (1) load seed,seed-initial,demo
>>>>> (2) login to Ofbiz , using web ui and create a PartyGroup via
>>>>> Application > Party > New Party Group
>>>>> (3) execute findPartiesById using RPC eg:
>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Using+
>>>>> XMLRPC+as+an+alternative+to+SOAP
>>>>>
>>>>> ( I use perl or the same https://pastebin.com/raw/UwLNq5AT ).
>>>>>
>>>>> (4) With new company ID the service findPartiesById does not return
>> any
>>>>> data , whereas for old data like 'Company'
>>>>> it does return..
>>>>>
>>>>> the problem seems to be with XMLRPC method only , as executing the
>>>>> service via
>>>>> Framework Web Tools > Run Service works fine for all PartyId.
>>>>>
>>>>> regds
>>>>> mallah.
>>>>>
>>>>>
>>>>>
>>>>> On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti <
>>>>> renuka.srishti93@gmail.com> wrote:
>>>>>
>>>>>> Hello Rajesh,
>>>>>>
>>>>>> Can you mention the steps you followed? As I have tried and its
>> working
>>>>>> fine.
>>>>>>
>>>>>> Yes, here I can see one improvement that after creating any party, we
>>>>>> redirect to view profile and UI of this screen need some improvement.
>>> The
>>>>>> message was shown there is not correct.
>>>>>>
>>>>>> Thanks
>>>>>> Renuka Srishti
>>>>>>
>>>>>> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <
>>> mallah.rajesh@gmail.com
>>>>>> wrote:
>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>> We have an instance using the stock demo,seed,seed-initial data.
>>>>>>> All the PartyGroups imported via demo are searchable using
>>>>>>> web service method findPartiesById .
>>>>>>>
>>>>>>> However when we create a Party Group by the UI and search
>>>>>>> using same process the result is nil.
>>>>>>>
>>>>>>> the RPCXML conversation is here:
>>>>>>>
>>>>>>> https://pastebin.com/1LB9BCFd
>>>>>>>
>>>>>>> am i missing anything ?
>>>>>>>
>>>>>>>
>>>>>>> regds
>>>>>>> mallah.
>>>>>>>
>>>>>
Re: newly created PartyGroup not searchable by web service findPartiesById
Posted by Rajesh Mallah <ma...@gmail.com>.
Hi Renuka ,
Creating the Party Group was not the problem.
The problem was that i was not able to search the created group using
XMLRPC.
When we leave group id empty it auto generates it , so IMHO its not
correct to say "partyID cannot be the digit"
I was able to search the groups on specifying the id as string type during
making the request
using XMLRPC.
Now my issue is solved.
regds
mallah.
On Sat, Aug 26, 2017 at 3:23 PM, Renuka Srishti <re...@gmail.com>
wrote:
> Hello Rajesh,
>
> There are 2 ways to create party group:
> 1. If you do not enter any specific ID, it will work.
> 2. When you create party group with ID as the digit, it shows an error that
> you can not create party group, partyId can not be the digit. Alphanumeric
> is reserved for this. Hence part group is not created, that's why its not
> showing any result on search.
>
> Thanks
> Renuka Srishti
>
> On Sat, Aug 26, 2017 at 1:43 PM, Rajesh Mallah <ma...@gmail.com>
> wrote:
>
> > observation:
> >
> > On passing 10000 as string by qualifying the type in XML things work as
> > expected.
> >
> > Eg: below works ( <value><string>10000</string></value> )
> >
> > REQ >>>>>>>>>
> > <methodCall><methodName>findPartiesById</methodName><
> > params><param><value><struct><member><name>login.username</
> > name><value><string><![CDATA[admin]]></string></value></
> > member><member><name>login.password</name><value><string>
> > <![CDATA[ofbiz]]></string></value></member><member><name>
> > idToFind</name><value><string>10000</string></value></
> > member></struct></value></param></params></methodCall>
> >
> > and
> >
> > below ( <value><i4>10000</i4></value> ) does not.
> >
> >
> > REQ >>>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
> > REQ >>>>>>>>>
> > <methodCall><methodName>findPartiesById</methodName><
> > params><param><value><struct><member><name>login.password</
> > name><value><string><![CDATA[ofbiz]]></string></value></
> > member><member><name>idToFind</name><value><i4>10000</i4></
> > value></member><member><name>login.username</name><value><
> > string><![CDATA[admin]]></string></value></member></
> > struct></value></param></params></methodCall>
> >
> >
> > IMHO the conversion of 10000 to 10,000 in backend is causing the
> problem
> > .
> > I am not sure if there is a scope of improvement or application
> programmers
> > should
> > be more careful by explicitly sending qualified types.
> >
> > regds
> > mallah.
> >
> >
> >
> > On Sat, Aug 26, 2017 at 1:19 PM, Rajesh Mallah <ma...@gmail.com>
> > wrote:
> >
> > > I think i caught it ,
> > >
> > > The problem is occurring only for numeric id. When i explicitly
> specify
> > a
> > > alphanum
> > > id in creating a new party group then the problem is not there.
> > >
> > > This is supported by the kind of sqls being created also :
> > > ( note the where clause ) i had specified partyID as '10000' not sure
> if
> > > its' derby specific.
> > >
> > > 2017-08-26 13:10:23,767 |http-nio-8080-exec-1
> > > |GenericDAO |T| Ran query in 1 milli-seconds:
> > > EntityName: Party Sql: SELECT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
> > > PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
> > > CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
> > > DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> > > CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY WHERE ((PARTY_ID = ?))
> > > where clause:[PARTY_ID=10,000]
> > >
> > >
> > > Does it qualify to be a BUG ?
> > > I think the ramifications are severe as most application developers
> would
> > > like
> > > system to auto generate IDs for them.
> > > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl 10000
> > > \ {
> > > partiesFound [],
> > > party undef
> > > }
> > > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> > > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> > > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> > > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl MyID1000
> > > \ {
> > > partiesFound [],
> > > party {
> > > createdByUserLogin "admin",
> > > createdDate "20170826T13:12:47",
> > > createdStamp "20170826T13:12:47",
> > > createdTxStamp "20170826T13:12:47",
> > > dataSourceId undef,
> > > description undef,
> > > externalId undef,
> > > isUnread undef,
> > > lastModifiedByUserLogin "admin",
> > > lastModifiedDate "20170826T13:12:47",
> > > lastUpdatedStamp "20170826T13:12:47",
> > > lastUpdatedTxStamp "20170826T13:12:47",
> > > partyId "MyID1000",
> > > partyTypeId "PARTY_GROUP",
> > > preferredCurrencyUomId "USD",
> > > statusId "PARTY_ENABLED"
> > > }
> > > }
> > >
> > > Regds
> > > mallah
> > >
> > >
> > > On Sat, Aug 26, 2017 at 1:00 PM, Rajesh Mallah <
> mallah.rajesh@gmail.com>
> > > wrote:
> > >
> > >> Hi Renuka ,
> > >>
> > >> Thanks for Response , My Steps are as follows
> > >>
> > >> (1) load seed,seed-initial,demo
> > >> (2) login to Ofbiz , using web ui and create a PartyGroup via
> > >> Application > Party > New Party Group
> > >> (3) execute findPartiesById using RPC eg:
> > >> https://cwiki.apache.org/confluence/display/OFBIZ/Using+
> > >> XMLRPC+as+an+alternative+to+SOAP
> > >>
> > >> ( I use perl or the same https://pastebin.com/raw/UwLNq5AT ).
> > >>
> > >> (4) With new company ID the service findPartiesById does not return
> any
> > >> data , whereas for old data like 'Company'
> > >> it does return..
> > >>
> > >> the problem seems to be with XMLRPC method only , as executing the
> > >> service via
> > >> Framework Web Tools > Run Service works fine for all PartyId.
> > >>
> > >> regds
> > >> mallah.
> > >>
> > >>
> > >>
> > >> On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti <
> > >> renuka.srishti93@gmail.com> wrote:
> > >>
> > >>> Hello Rajesh,
> > >>>
> > >>> Can you mention the steps you followed? As I have tried and its
> working
> > >>> fine.
> > >>>
> > >>> Yes, here I can see one improvement that after creating any party, we
> > >>> redirect to view profile and UI of this screen need some improvement.
> > The
> > >>> message was shown there is not correct.
> > >>>
> > >>> Thanks
> > >>> Renuka Srishti
> > >>>
> > >>> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <
> > mallah.rajesh@gmail.com
> > >>> >
> > >>> wrote:
> > >>>
> > >>> > Hi
> > >>> >
> > >>> > We have an instance using the stock demo,seed,seed-initial data.
> > >>> > All the PartyGroups imported via demo are searchable using
> > >>> > web service method findPartiesById .
> > >>> >
> > >>> > However when we create a Party Group by the UI and search
> > >>> > using same process the result is nil.
> > >>> >
> > >>> > the RPCXML conversation is here:
> > >>> >
> > >>> > https://pastebin.com/1LB9BCFd
> > >>> >
> > >>> > am i missing anything ?
> > >>> >
> > >>> >
> > >>> > regds
> > >>> > mallah.
> > >>> >
> > >>>
> > >>
> > >>
> > >
> >
>
Re: newly created PartyGroup not searchable by web service findPartiesById
Posted by Renuka Srishti <re...@gmail.com>.
Hello Rajesh,
There are 2 ways to create party group:
1. If you do not enter any specific ID, it will work.
2. When you create party group with ID as the digit, it shows an error that
you can not create party group, partyId can not be the digit. Alphanumeric
is reserved for this. Hence part group is not created, that's why its not
showing any result on search.
Thanks
Renuka Srishti
On Sat, Aug 26, 2017 at 1:43 PM, Rajesh Mallah <ma...@gmail.com>
wrote:
> observation:
>
> On passing 10000 as string by qualifying the type in XML things work as
> expected.
>
> Eg: below works ( <value><string>10000</string></value> )
>
> REQ >>>>>>>>>
> <methodCall><methodName>findPartiesById</methodName><
> params><param><value><struct><member><name>login.username</
> name><value><string><![CDATA[admin]]></string></value></
> member><member><name>login.password</name><value><string>
> <![CDATA[ofbiz]]></string></value></member><member><name>
> idToFind</name><value><string>10000</string></value></
> member></struct></value></param></params></methodCall>
>
> and
>
> below ( <value><i4>10000</i4></value> ) does not.
>
>
> REQ >>>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
> REQ >>>>>>>>>
> <methodCall><methodName>findPartiesById</methodName><
> params><param><value><struct><member><name>login.password</
> name><value><string><![CDATA[ofbiz]]></string></value></
> member><member><name>idToFind</name><value><i4>10000</i4></
> value></member><member><name>login.username</name><value><
> string><![CDATA[admin]]></string></value></member></
> struct></value></param></params></methodCall>
>
>
> IMHO the conversion of 10000 to 10,000 in backend is causing the problem
> .
> I am not sure if there is a scope of improvement or application programmers
> should
> be more careful by explicitly sending qualified types.
>
> regds
> mallah.
>
>
>
> On Sat, Aug 26, 2017 at 1:19 PM, Rajesh Mallah <ma...@gmail.com>
> wrote:
>
> > I think i caught it ,
> >
> > The problem is occurring only for numeric id. When i explicitly specify
> a
> > alphanum
> > id in creating a new party group then the problem is not there.
> >
> > This is supported by the kind of sqls being created also :
> > ( note the where clause ) i had specified partyID as '10000' not sure if
> > its' derby specific.
> >
> > 2017-08-26 13:10:23,767 |http-nio-8080-exec-1
> > |GenericDAO |T| Ran query in 1 milli-seconds:
> > EntityName: Party Sql: SELECT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
> > PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
> > CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
> > DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> > CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY WHERE ((PARTY_ID = ?))
> > where clause:[PARTY_ID=10,000]
> >
> >
> > Does it qualify to be a BUG ?
> > I think the ramifications are severe as most application developers would
> > like
> > system to auto generate IDs for them.
> > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl 10000
> > \ {
> > partiesFound [],
> > party undef
> > }
> > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> > sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl MyID1000
> > \ {
> > partiesFound [],
> > party {
> > createdByUserLogin "admin",
> > createdDate "20170826T13:12:47",
> > createdStamp "20170826T13:12:47",
> > createdTxStamp "20170826T13:12:47",
> > dataSourceId undef,
> > description undef,
> > externalId undef,
> > isUnread undef,
> > lastModifiedByUserLogin "admin",
> > lastModifiedDate "20170826T13:12:47",
> > lastUpdatedStamp "20170826T13:12:47",
> > lastUpdatedTxStamp "20170826T13:12:47",
> > partyId "MyID1000",
> > partyTypeId "PARTY_GROUP",
> > preferredCurrencyUomId "USD",
> > statusId "PARTY_ENABLED"
> > }
> > }
> >
> > Regds
> > mallah
> >
> >
> > On Sat, Aug 26, 2017 at 1:00 PM, Rajesh Mallah <ma...@gmail.com>
> > wrote:
> >
> >> Hi Renuka ,
> >>
> >> Thanks for Response , My Steps are as follows
> >>
> >> (1) load seed,seed-initial,demo
> >> (2) login to Ofbiz , using web ui and create a PartyGroup via
> >> Application > Party > New Party Group
> >> (3) execute findPartiesById using RPC eg:
> >> https://cwiki.apache.org/confluence/display/OFBIZ/Using+
> >> XMLRPC+as+an+alternative+to+SOAP
> >>
> >> ( I use perl or the same https://pastebin.com/raw/UwLNq5AT ).
> >>
> >> (4) With new company ID the service findPartiesById does not return any
> >> data , whereas for old data like 'Company'
> >> it does return..
> >>
> >> the problem seems to be with XMLRPC method only , as executing the
> >> service via
> >> Framework Web Tools > Run Service works fine for all PartyId.
> >>
> >> regds
> >> mallah.
> >>
> >>
> >>
> >> On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti <
> >> renuka.srishti93@gmail.com> wrote:
> >>
> >>> Hello Rajesh,
> >>>
> >>> Can you mention the steps you followed? As I have tried and its working
> >>> fine.
> >>>
> >>> Yes, here I can see one improvement that after creating any party, we
> >>> redirect to view profile and UI of this screen need some improvement.
> The
> >>> message was shown there is not correct.
> >>>
> >>> Thanks
> >>> Renuka Srishti
> >>>
> >>> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <
> mallah.rajesh@gmail.com
> >>> >
> >>> wrote:
> >>>
> >>> > Hi
> >>> >
> >>> > We have an instance using the stock demo,seed,seed-initial data.
> >>> > All the PartyGroups imported via demo are searchable using
> >>> > web service method findPartiesById .
> >>> >
> >>> > However when we create a Party Group by the UI and search
> >>> > using same process the result is nil.
> >>> >
> >>> > the RPCXML conversation is here:
> >>> >
> >>> > https://pastebin.com/1LB9BCFd
> >>> >
> >>> > am i missing anything ?
> >>> >
> >>> >
> >>> > regds
> >>> > mallah.
> >>> >
> >>>
> >>
> >>
> >
>
Re: newly created PartyGroup not searchable by web service findPartiesById
Posted by Rajesh Mallah <ma...@gmail.com>.
observation:
On passing 10000 as string by qualifying the type in XML things work as
expected.
Eg: below works ( <value><string>10000</string></value> )
REQ >>>>>>>>>
<methodCall><methodName>findPartiesById</methodName><params><param><value><struct><member><name>login.username</name><value><string><![CDATA[admin]]></string></value></member><member><name>login.password</name><value><string><![CDATA[ofbiz]]></string></value></member><member><name>idToFind</name><value><string>10000</string></value></member></struct></value></param></params></methodCall>
and
below ( <value><i4>10000</i4></value> ) does not.
REQ >>>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
REQ >>>>>>>>>
<methodCall><methodName>findPartiesById</methodName><params><param><value><struct><member><name>login.password</name><value><string><![CDATA[ofbiz]]></string></value></member><member><name>idToFind</name><value><i4>10000</i4></value></member><member><name>login.username</name><value><string><![CDATA[admin]]></string></value></member></struct></value></param></params></methodCall>
IMHO the conversion of 10000 to 10,000 in backend is causing the problem .
I am not sure if there is a scope of improvement or application programmers
should
be more careful by explicitly sending qualified types.
regds
mallah.
On Sat, Aug 26, 2017 at 1:19 PM, Rajesh Mallah <ma...@gmail.com>
wrote:
> I think i caught it ,
>
> The problem is occurring only for numeric id. When i explicitly specify a
> alphanum
> id in creating a new party group then the problem is not there.
>
> This is supported by the kind of sqls being created also :
> ( note the where clause ) i had specified partyID as '10000' not sure if
> its' derby specific.
>
> 2017-08-26 13:10:23,767 |http-nio-8080-exec-1
> |GenericDAO |T| Ran query in 1 milli-seconds:
> EntityName: Party Sql: SELECT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
> PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
> DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY WHERE ((PARTY_ID = ?))
> where clause:[PARTY_ID=10,000]
>
>
> Does it qualify to be a BUG ?
> I think the ramifications are severe as most application developers would
> like
> system to auto generate IDs for them.
> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl 10000
> \ {
> partiesFound [],
> party undef
> }
> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
> sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl MyID1000
> \ {
> partiesFound [],
> party {
> createdByUserLogin "admin",
> createdDate "20170826T13:12:47",
> createdStamp "20170826T13:12:47",
> createdTxStamp "20170826T13:12:47",
> dataSourceId undef,
> description undef,
> externalId undef,
> isUnread undef,
> lastModifiedByUserLogin "admin",
> lastModifiedDate "20170826T13:12:47",
> lastUpdatedStamp "20170826T13:12:47",
> lastUpdatedTxStamp "20170826T13:12:47",
> partyId "MyID1000",
> partyTypeId "PARTY_GROUP",
> preferredCurrencyUomId "USD",
> statusId "PARTY_ENABLED"
> }
> }
>
> Regds
> mallah
>
>
> On Sat, Aug 26, 2017 at 1:00 PM, Rajesh Mallah <ma...@gmail.com>
> wrote:
>
>> Hi Renuka ,
>>
>> Thanks for Response , My Steps are as follows
>>
>> (1) load seed,seed-initial,demo
>> (2) login to Ofbiz , using web ui and create a PartyGroup via
>> Application > Party > New Party Group
>> (3) execute findPartiesById using RPC eg:
>> https://cwiki.apache.org/confluence/display/OFBIZ/Using+
>> XMLRPC+as+an+alternative+to+SOAP
>>
>> ( I use perl or the same https://pastebin.com/raw/UwLNq5AT ).
>>
>> (4) With new company ID the service findPartiesById does not return any
>> data , whereas for old data like 'Company'
>> it does return..
>>
>> the problem seems to be with XMLRPC method only , as executing the
>> service via
>> Framework Web Tools > Run Service works fine for all PartyId.
>>
>> regds
>> mallah.
>>
>>
>>
>> On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti <
>> renuka.srishti93@gmail.com> wrote:
>>
>>> Hello Rajesh,
>>>
>>> Can you mention the steps you followed? As I have tried and its working
>>> fine.
>>>
>>> Yes, here I can see one improvement that after creating any party, we
>>> redirect to view profile and UI of this screen need some improvement. The
>>> message was shown there is not correct.
>>>
>>> Thanks
>>> Renuka Srishti
>>>
>>> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <mallah.rajesh@gmail.com
>>> >
>>> wrote:
>>>
>>> > Hi
>>> >
>>> > We have an instance using the stock demo,seed,seed-initial data.
>>> > All the PartyGroups imported via demo are searchable using
>>> > web service method findPartiesById .
>>> >
>>> > However when we create a Party Group by the UI and search
>>> > using same process the result is nil.
>>> >
>>> > the RPCXML conversation is here:
>>> >
>>> > https://pastebin.com/1LB9BCFd
>>> >
>>> > am i missing anything ?
>>> >
>>> >
>>> > regds
>>> > mallah.
>>> >
>>>
>>
>>
>
Re: newly created PartyGroup not searchable by web service findPartiesById
Posted by Rajesh Mallah <ma...@gmail.com>.
I think i caught it ,
The problem is occurring only for numeric id. When i explicitly specify a
alphanum
id in creating a new party group then the problem is not there.
This is supported by the kind of sqls being created also :
( note the where clause ) i had specified partyID as '10000' not sure if
its' derby specific.
2017-08-26 13:10:23,767 |http-nio-8080-exec-1
|GenericDAO |T| Ran query in 1 milli-seconds:
EntityName: Party Sql: SELECT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PARTY WHERE ((PARTY_ID = ?))
where clause:[PARTY_ID=10,000]
Does it qualify to be a BUG ?
I think the ramifications are severe as most application developers would
like
system to auto generate IDs for them.
sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl 10000
\ {
partiesFound [],
party undef
}
sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
sw@development:~/Ofbiz/XML_RPC_SCRIPTS$
sw@development:~/Ofbiz/XML_RPC_SCRIPTS$ perl test-xmlrpc.pl MyID1000
\ {
partiesFound [],
party {
createdByUserLogin "admin",
createdDate "20170826T13:12:47",
createdStamp "20170826T13:12:47",
createdTxStamp "20170826T13:12:47",
dataSourceId undef,
description undef,
externalId undef,
isUnread undef,
lastModifiedByUserLogin "admin",
lastModifiedDate "20170826T13:12:47",
lastUpdatedStamp "20170826T13:12:47",
lastUpdatedTxStamp "20170826T13:12:47",
partyId "MyID1000",
partyTypeId "PARTY_GROUP",
preferredCurrencyUomId "USD",
statusId "PARTY_ENABLED"
}
}
Regds
mallah
On Sat, Aug 26, 2017 at 1:00 PM, Rajesh Mallah <ma...@gmail.com>
wrote:
> Hi Renuka ,
>
> Thanks for Response , My Steps are as follows
>
> (1) load seed,seed-initial,demo
> (2) login to Ofbiz , using web ui and create a PartyGroup via Application
> > Party > New Party Group
> (3) execute findPartiesById using RPC eg:
> https://cwiki.apache.org/confluence/display/OFBIZ/Using+XMLRPC+as+an+
> alternative+to+SOAP
>
> ( I use perl or the same https://pastebin.com/raw/UwLNq5AT ).
>
> (4) With new company ID the service findPartiesById does not return any
> data , whereas for old data like 'Company'
> it does return..
>
> the problem seems to be with XMLRPC method only , as executing the service
> via
> Framework Web Tools > Run Service works fine for all PartyId.
>
> regds
> mallah.
>
>
>
> On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti <
> renuka.srishti93@gmail.com> wrote:
>
>> Hello Rajesh,
>>
>> Can you mention the steps you followed? As I have tried and its working
>> fine.
>>
>> Yes, here I can see one improvement that after creating any party, we
>> redirect to view profile and UI of this screen need some improvement. The
>> message was shown there is not correct.
>>
>> Thanks
>> Renuka Srishti
>>
>> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <ma...@gmail.com>
>> wrote:
>>
>> > Hi
>> >
>> > We have an instance using the stock demo,seed,seed-initial data.
>> > All the PartyGroups imported via demo are searchable using
>> > web service method findPartiesById .
>> >
>> > However when we create a Party Group by the UI and search
>> > using same process the result is nil.
>> >
>> > the RPCXML conversation is here:
>> >
>> > https://pastebin.com/1LB9BCFd
>> >
>> > am i missing anything ?
>> >
>> >
>> > regds
>> > mallah.
>> >
>>
>
>
Re: newly created PartyGroup not searchable by web service findPartiesById
Posted by Rajesh Mallah <ma...@gmail.com>.
Hi Renuka ,
Thanks for Response , My Steps are as follows
(1) load seed,seed-initial,demo
(2) login to Ofbiz , using web ui and create a PartyGroup via Application
> Party > New Party Group
(3) execute findPartiesById using RPC eg:
https://cwiki.apache.org/confluence/display/OFBIZ/Using+XMLRPC+as+an+alternative+to+SOAP
( I use perl or the same https://pastebin.com/raw/UwLNq5AT ).
(4) With new company ID the service findPartiesById does not return any
data , whereas for old data like 'Company'
it does return..
the problem seems to be with XMLRPC method only , as executing the service
via
Framework Web Tools > Run Service works fine for all PartyId.
regds
mallah.
On Sat, Aug 26, 2017 at 12:42 PM, Renuka Srishti <renuka.srishti93@gmail.com
> wrote:
> Hello Rajesh,
>
> Can you mention the steps you followed? As I have tried and its working
> fine.
>
> Yes, here I can see one improvement that after creating any party, we
> redirect to view profile and UI of this screen need some improvement. The
> message was shown there is not correct.
>
> Thanks
> Renuka Srishti
>
> On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <ma...@gmail.com>
> wrote:
>
> > Hi
> >
> > We have an instance using the stock demo,seed,seed-initial data.
> > All the PartyGroups imported via demo are searchable using
> > web service method findPartiesById .
> >
> > However when we create a Party Group by the UI and search
> > using same process the result is nil.
> >
> > the RPCXML conversation is here:
> >
> > https://pastebin.com/1LB9BCFd
> >
> > am i missing anything ?
> >
> >
> > regds
> > mallah.
> >
>
Re: newly created PartyGroup not searchable by web service findPartiesById
Posted by Renuka Srishti <re...@gmail.com>.
Hello Rajesh,
Can you mention the steps you followed? As I have tried and its working
fine.
Yes, here I can see one improvement that after creating any party, we
redirect to view profile and UI of this screen need some improvement. The
message was shown there is not correct.
Thanks
Renuka Srishti
On Sat, Aug 26, 2017 at 12:19 PM, Rajesh Mallah <ma...@gmail.com>
wrote:
> Hi
>
> We have an instance using the stock demo,seed,seed-initial data.
> All the PartyGroups imported via demo are searchable using
> web service method findPartiesById .
>
> However when we create a Party Group by the UI and search
> using same process the result is nil.
>
> the RPCXML conversation is here:
>
> https://pastebin.com/1LB9BCFd
>
> am i missing anything ?
>
>
> regds
> mallah.
>