newly created PartyGroup not searchable by web service findPartiesById

[Rajesh Mallah]

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.

[Renuka Srishti-2]

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 <[hidden email]>
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.
>

[Rajesh Mallah]

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 <[hidden email]
> 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 <[hidden email]>
> 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.
> >
>

[Rajesh Mallah]

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 <[hidden email]>
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 <
> [hidden email]> 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 <[hidden email]>
>> 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.
>> >
>>
>
>

[Rajesh Mallah]

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 <[hidden email]>
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 <[hidden email]>
> 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 <
>> [hidden email]> 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 <[hidden email]
>>> >
>>> 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.
>>> >
>>>
>>
>>
>

[Renuka Srishti-2]

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 <[hidden email]>
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 <[hidden email]>
> 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 <[hidden email]>
> > 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 <
> >> [hidden email]> 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 <
> [hidden email]
> >>> >
> >>> 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.
> >>> >
> >>>
> >>
> >>
> >
>

[Rajesh Mallah]

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 <[hidden email]>
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 <[hidden email]>
> 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 <[hidden email]>
> > 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 <
> [hidden email]>
> > > 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 <
> > >> [hidden email]> 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 <
> > [hidden email]
> > >>> >
> > >>> 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.
> > >>> >
> > >>>
> > >>
> > >>
> > >
> >
>

[Jacques Le Roux]

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 <[hidden email]>
> 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 <[hidden email]>
>> 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 <[hidden email]>
>>> 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 <
>> [hidden email]>
>>>> 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 <
>>>>> [hidden email]> 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 <
>>> [hidden email]
>>>>>> 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.
>>>>>>>
>>>>>

[Rajesh Mallah]

Thanks I will go through it .

On Sun, Aug 27, 2017 at 12:51 AM, Jacques Le Roux <
[hidden email]> 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 <
>> [hidden email]>
>> 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 <[hidden email]>
>>> 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 <[hidden email]
>>>> >
>>>> 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 <
>>>>>
>>>> [hidden email]>
>>>
>>>> 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 <
>>>>>> [hidden email]> 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 <
>>>>>>>
>>>>>> [hidden email]
>>>>
>>>>> 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.
>>>>>>>>
>>>>>>>>
>>>>>>
>