Re: Users - XML data import fails when importing more than ~10000 products

Posted by Jacopo Cappellato on
URL: http://ofbiz.116.s1.nabble.com/Users-XML-data-import-fails-when-importing-more-than-10000-products-tp140028p140031.html

Nick, all,

I probably know the cause of this issue (but maybe not how to resolve
this): this issue has been introduced when that import page has been
converted to from jsp to screen widget; in fact 2 minutes is the default
transaction timeout set for screens.
In the "EntityImport" screen definition there is the following entry:

<set field="parameters.TRANSACTION_TIMEOUT" value="7200"/>

that should set the transaction timeout to 2 hours; if this doesn't work
it is probably too late to set the timeout there (or the timeout is
overriden by one of the screen's decorator)... any hints?

Jacopo

PS: Nick, you can always import your products using the command line:

http://ofbizwiki.go-integral.com/Wiki.jsp?page=SeedData



Nick Olson wrote:

> It takes about 2 minutes before it comes back with this error. I've
> tried increasing the timeout in the services.xml file, but it doesn't
> seem to make a difference.
>
> David Welton wrote:
>> On 6/20/06, Nick Olson <[hidden email]> wrote:
>>> I am trying to import 40k products into the database (I'm running
>>> postgres), but when I try to import, I get an error message that says:
>>> ERROR parsing Entity Xml file: Commit transaction failed.
>> How long is it taking?  No idea if this is the cause, but there is a
>> transaction timeout.
>>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users