Unwanted OrderStatus when importing

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Unwanted OrderStatus when importing

SkipDever
I am importing millions of records from an existing system.  Somehow, I am
getting multiple OrderStatus records with PAYMENT_NOT_RECEIVED for every
order imported.

Firstly, does anyone know what eca is causing this, and second, is there a
way to disable all ecas while I import these records?

Thanks in advance

Skip

Reply | Threaded
Open this post in threaded view
|

Re: Unwanted OrderStatus when importing

Varun Bhansaly
To disable EECA set entity-eca-enabled="true" in entityengine.xml's
delegator definition.
SECA may have to disabled by making a minor change in Java code AFAIK
there's no setting to disable it.

On Tue, Jul 9, 2013 at 11:55 PM, Skip <[hidden email]> wrote:

> I am importing millions of records from an existing system.  Somehow, I am
> getting multiple OrderStatus records with PAYMENT_NOT_RECEIVED for every
> order imported.
>
> Firstly, does anyone know what eca is causing this, and second, is there a
> way to disable all ecas while I import these records?
>
> Thanks in advance
>
> Skip
>
>


--
Regards,
Varun Bhansaly
Reply | Threaded
Open this post in threaded view
|

RE: Unwanted OrderStatus when importing

SkipDever
Thanks Varun, that is exactly the solution.  I believe that you should have
the option of disabling ECAs when doing WebApp-Import Dir (or maybe for any
import) to avoid a very nasty problem.  I created a jira OFBIZ-5259
describing the issue, but basically, if you export an entire ofbiz
installation, then later import it, all the ecas that run on
operation="create-store" that create new records get ids from
SequenceValueItem.  This entity is overwritten when SequenceValueItem is
imported.  Later when you ask for a number, you get a "Failure in create
operation for ..." with a duplicate key value.

In my case, the import of OrderPaymentPreference created millions of
OrderStatus records with PAYMENT_NOT_RECEIVED.  Then, when you try and
create an order, you get the failure message above because the import of
SequenceValueItem overwrote the changes made by the eca.

-----Original Message-----
From: Varun Bhansaly [mailto:[hidden email]]
Sent: Tuesday, July 09, 2013 11:36 AM
To: [hidden email]
Subject: Re: Unwanted OrderStatus when importing


To disable EECA set entity-eca-enabled="true" in entityengine.xml's
delegator definition.
SECA may have to disabled by making a minor change in Java code AFAIK
there's no setting to disable it.

On Tue, Jul 9, 2013 at 11:55 PM, Skip <[hidden email]> wrote:

> I am importing millions of records from an existing system.  Somehow, I am
> getting multiple OrderStatus records with PAYMENT_NOT_RECEIVED for every
> order imported.
>
> Firstly, does anyone know what eca is causing this, and second, is there a
> way to disable all ecas while I import these records?
>
> Thanks in advance
>
> Skip
>
>


--
Regards,
Varun Bhansaly

Reply | Threaded
Open this post in threaded view
|

Re: Unwanted OrderStatus when importing

Malin Nicolas
Try to use sequenced-id-prefix="" on your delegator definition.

like sequenced-id-prefix="R"

Nicolas

Le 09/07/2013 22:12, Skip a écrit :

> Thanks Varun, that is exactly the solution.  I believe that you should have
> the option of disabling ECAs when doing WebApp-Import Dir (or maybe for any
> import) to avoid a very nasty problem.  I created a jira OFBIZ-5259
> describing the issue, but basically, if you export an entire ofbiz
> installation, then later import it, all the ecas that run on
> operation="create-store" that create new records get ids from
> SequenceValueItem.  This entity is overwritten when SequenceValueItem is
> imported.  Later when you ask for a number, you get a "Failure in create
> operation for ..." with a duplicate key value.
>
> In my case, the import of OrderPaymentPreference created millions of
> OrderStatus records with PAYMENT_NOT_RECEIVED.  Then, when you try and
> create an order, you get the failure message above because the import of
> SequenceValueItem overwrote the changes made by the eca.
>
> -----Original Message-----
> From: Varun Bhansaly [mailto:[hidden email]]
> Sent: Tuesday, July 09, 2013 11:36 AM
> To: [hidden email]
> Subject: Re: Unwanted OrderStatus when importing
>
>
> To disable EECA set entity-eca-enabled="true" in entityengine.xml's
> delegator definition.
> SECA may have to disabled by making a minor change in Java code AFAIK
> there's no setting to disable it.
>
> On Tue, Jul 9, 2013 at 11:55 PM, Skip <[hidden email]> wrote:
>
>> I am importing millions of records from an existing system.  Somehow, I am
>> getting multiple OrderStatus records with PAYMENT_NOT_RECEIVED for every
>> order imported.
>>
>> Firstly, does anyone know what eca is causing this, and second, is there a
>> way to disable all ecas while I import these records?
>>
>> Thanks in advance
>>
>> Skip
>>
>>
>
> --
> Regards,
> Varun Bhansaly
>