Update record is not working in OFBiz latest head

[Divesh Dutta]

Hello Developers,

I just found a weird problem while updating records in demo.ofbiz.org. I
tried it by following three ways:

1) Processed sql query from sql processor.
    Results : 1) It shows me "1 row affected"
                   2) But record does not get updated
 
2) Also tried to overwrite from "XML data import"
    Result : Record is not updated when I go that particular entity in
webtools

3) Also tried to update directly by going to that particular entity.

    Result: But the result is same as above given.

Anyone else is coming across same problem? Also found same result in
local machine.

Thanks
--
Divesh

[Scott Gray-2]

An update using the sql processor worked fine for me on demo.ofbiz.org

Regards
Scott

On 4/09/2009, at 8:44 PM, Divesh Dutta wrote:

> Hello Developers,
>
> I just found a weird problem while updating records in  
> demo.ofbiz.org. I tried it by following three ways:
>
> 1) Processed sql query from sql processor.
>   Results : 1) It shows me "1 row affected"
>                  2) But record does not get updated
> 2) Also tried to overwrite from "XML data import"
>   Result : Record is not updated when I go that particular entity in  
> webtools
>
> 3) Also tried to update directly by going to that particular entity.
>
>   Result: But the result is same as above given.
>
> Anyone else is coming across same problem? Also found same result in  
> local machine.
>
> Thanks
> --
> Divesh
>

[Sumit Pandit-3]

Hello Divesh,

Please name the entity and field for which you are trying to update  
the values.

Thanks And Regards
Sumit Pandit

On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:

> Hello Developers,
>
> I just found a weird problem while updating records in  
> demo.ofbiz.org. I tried it by following three ways:
>
> 1) Processed sql query from sql processor.
>   Results : 1) It shows me "1 row affected"
>                  2) But record does not get updated
> 2) Also tried to overwrite from "XML data import"
>   Result : Record is not updated when I go that particular entity in  
> webtools
>
> 3) Also tried to update directly by going to that particular entity.
>
>   Result: But the result is same as above given.
>
> Anyone else is coming across same problem? Also found same result in  
> local machine.
>
> Thanks
> --
> Divesh
>

[Divesh Dutta]

Hello Scott,

 Have you checked entity again, after running your query ? Have you
cross-checked that your changes are reflecting back?

Thanks
--
Divesh


Scott Gray wrote:

> An update using the sql processor worked fine for me on demo.ofbiz.org
>
> Regards
> Scott
>
> On 4/09/2009, at 8:44 PM, Divesh Dutta wrote:
>
>> Hello Developers,
>>
>> I just found a weird problem while updating records in
>> demo.ofbiz.org. I tried it by following three ways:
>>
>> 1) Processed sql query from sql processor.
>>   Results : 1) It shows me "1 row affected"
>>                  2) But record does not get updated
>> 2) Also tried to overwrite from "XML data import"
>>   Result : Record is not updated when I go that particular entity in
>> webtools
>>
>> 3) Also tried to update directly by going to that particular entity.
>>
>>   Result: But the result is same as above given.
>>
>> Anyone else is coming across same problem? Also found same result in
>> local machine.
>>
>> Thanks
>> --
>> Divesh
>>
>

[Divesh Dutta]

Hi Sumit,

This is not the problem with any particular entity or field. This is the
case with all the entities.

Thanks
--
Divesh


Sumit Pandit wrote:

> Hello Divesh,
>
> Please name the entity and field for which you are trying to update
> the values.
>
> Thanks And Regards
> Sumit Pandit
>
> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>
>> Hello Developers,
>>
>> I just found a weird problem while updating records in
>> demo.ofbiz.org. I tried it by following three ways:
>>
>> 1) Processed sql query from sql processor.
>>   Results : 1) It shows me "1 row affected"
>>                  2) But record does not get updated
>> 2) Also tried to overwrite from "XML data import"
>>   Result : Record is not updated when I go that particular entity in
>> webtools
>>
>> 3) Also tried to update directly by going to that particular entity.
>>
>>   Result: But the result is same as above given.
>>
>> Anyone else is coming across same problem? Also found same result in
>> local machine.
>>
>> Thanks
>> --
>> Divesh
>>
>

[Pranay Pandey-2]

It doesn't show you any error message and at the same time doesn't  
update a specific record in the db.

Thanks & Regards
--
Pranay Pandey
HotWax Media | www.hotwaxmedia.com
Ext: 442 | Direct: [phone] | Skype: pranay.pandey

On Sep 4, 2009, at 2:37 PM, Divesh Dutta wrote:

> Hi Sumit,
>
> This is not the problem with any particular entity or field. This is  
> the case with all the entities.
>
> Thanks
> --
> Divesh
>
>
> Sumit Pandit wrote:
>> Hello Divesh,
>>
>> Please name the entity and field for which you are trying to update  
>> the values.
>>
>> Thanks And Regards
>> Sumit Pandit
>>
>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>
>>> Hello Developers,
>>>
>>> I just found a weird problem while updating records in  
>>> demo.ofbiz.org. I tried it by following three ways:
>>>
>>> 1) Processed sql query from sql processor.
>>>  Results : 1) It shows me "1 row affected"
>>>                 2) But record does not get updated
>>> 2) Also tried to overwrite from "XML data import"
>>>  Result : Record is not updated when I go that particular entity  
>>> in webtools
>>>
>>> 3) Also tried to update directly by going to that particular entity.
>>>
>>>  Result: But the result is same as above given.
>>>
>>> Anyone else is coming across same problem? Also found same result  
>>> in local machine.
>>>
>>> Thanks
>>> --
>>> Divesh
>>>
>>
>

[Sumit Pandit-3]

Hello Divesh,

I tried to update directly the field firstName of Person entity, and  
it is updated successfully.

You  can see it at - https://demo.ofbiz.org/webtools/control/FindGeneric?entityName=Person&find=true&VIEW_SIZE=50&VIEW_INDEX=0
Where I have changed the firstName of partyId = 10000 and assign it to  
"Rishi". You can also change it and assign some other name like  
"Sumit" to it.
Please verify.

Are you trying to change description field of any entity ?

--
Thanks And Regards
Sumit Pandit

On 04-Sep-09, at 2:37 PM, Divesh Dutta wrote:

> Hi Sumit,
>
> This is not the problem with any particular entity or field. This is  
> the case with all the entities.
>
> Thanks
> --
> Divesh
>
>
> Sumit Pandit wrote:
>> Hello Divesh,
>>
>> Please name the entity and field for which you are trying to update  
>> the values.
>>
>> Thanks And Regards
>> Sumit Pandit
>>
>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>
>>> Hello Developers,
>>>
>>> I just found a weird problem while updating records in  
>>> demo.ofbiz.org. I tried it by following three ways:
>>>
>>> 1) Processed sql query from sql processor.
>>>  Results : 1) It shows me "1 row affected"
>>>                 2) But record does not get updated
>>> 2) Also tried to overwrite from "XML data import"
>>>  Result : Record is not updated when I go that particular entity  
>>> in webtools
>>>
>>> 3) Also tried to update directly by going to that particular entity.
>>>
>>>  Result: But the result is same as above given.
>>>
>>> Anyone else is coming across same problem? Also found same result  
>>> in local machine.
>>>
>>> Thanks
>>> --
>>> Divesh
>>>
>>
>

[Sumit Pandit-3]

Hello Divesh,

Please refer *EntityLabels.xml before updating anything. You need to  
update the entry as well(if there is any).

--
Thanks And Regards
Sumit Pandit


On 04-Sep-09, at 2:37 PM, Divesh Dutta wrote:

> Hi Sumit,
>
> This is not the problem with any particular entity or field. This is  
> the case with all the entities.
>
> Thanks
> --
> Divesh
>
>
> Sumit Pandit wrote:
>> Hello Divesh,
>>
>> Please name the entity and field for which you are trying to update  
>> the values.
>>
>> Thanks And Regards
>> Sumit Pandit
>>
>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>
>>> Hello Developers,
>>>
>>> I just found a weird problem while updating records in  
>>> demo.ofbiz.org. I tried it by following three ways:
>>>
>>> 1) Processed sql query from sql processor.
>>>  Results : 1) It shows me "1 row affected"
>>>                 2) But record does not get updated
>>> 2) Also tried to overwrite from "XML data import"
>>>  Result : Record is not updated when I go that particular entity  
>>> in webtools
>>>
>>> 3) Also tried to update directly by going to that particular entity.
>>>
>>>  Result: But the result is same as above given.
>>>
>>> Anyone else is coming across same problem? Also found same result  
>>> in local machine.
>>>
>>> Thanks
>>> --
>>> Divesh
>>>
>>
>

[Divesh Dutta]

Oh!

Thanks Sumit. I got this now. Actually I was updating the description
for ProductFeatureCategory entity. So I went to "Label Manager" and
updated the value for the "Key", I was working on. But I have another
concern here is:

We should prepare UILabels only for seed data. Not In case of other
entities having "description" fields.

If we need to manage "description" field for many languages, then we can
do some thing like it is done in 'DemoProductI18nData.xml'. WDYT?

Thanks
--
Divesh


Sumit Pandit wrote:

> Hello Divesh,
>
> Please refer *EntityLabels.xml before updating anything. You need to
> update the entry as well(if there is any).
>
> --
> Thanks And Regards
> Sumit Pandit
>
>
> On 04-Sep-09, at 2:37 PM, Divesh Dutta wrote:
>
>> Hi Sumit,
>>
>> This is not the problem with any particular entity or field. This is
>> the case with all the entities.
>>
>> Thanks
>> --
>> Divesh
>>
>>
>> Sumit Pandit wrote:
>>> Hello Divesh,
>>>
>>> Please name the entity and field for which you are trying to update
>>> the values.
>>>
>>> Thanks And Regards
>>> Sumit Pandit
>>>
>>> On 04-Sep-09, at 2:14 PM, Divesh Dutta wrote:
>>>
>>>> Hello Developers,
>>>>
>>>> I just found a weird problem while updating records in
>>>> demo.ofbiz.org. I tried it by following three ways:
>>>>
>>>> 1) Processed sql query from sql processor.
>>>>  Results : 1) It shows me "1 row affected"
>>>>                 2) But record does not get updated
>>>> 2) Also tried to overwrite from "XML data import"
>>>>  Result : Record is not updated when I go that particular entity in
>>>> webtools
>>>>
>>>> 3) Also tried to update directly by going to that particular entity.
>>>>
>>>>  Result: But the result is same as above given.
>>>>
>>>> Anyone else is coming across same problem? Also found same result
>>>> in local machine.
>>>>
>>>> Thanks
>>>> --
>>>> Divesh
>>>>
>>>
>>
>