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