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

Posted by Nick Olson on Jun 20, 2006; 10:11pm
URL: http://ofbiz.116.s1.nabble.com/Users-XML-data-import-fails-when-importing-more-than-10000-products-tp140028p140039.html

Tried bumping the memory up to 1 gig minimum, but I'm getting the same
errors.

BJ Freeman wrote:

> Possibly your running in to memory limits.
> try increasing the memory in the startofbiz.bat or sh
> if you upgraded there a new things that take up memory.
>
>
> Nick Olson sent the following on 6/20/06 1:11 PM:
>> 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.
>>
>> This appears in the log file:
>>
>> 78565324 (http-0.0.0.0-8443-Processor2) [
>> EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up
>> to 16000
>> 78570220 (http-0.0.0.0-8443-Processor2) [
>> EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up
>> to 17000
>> 78575552 (http-0.0.0.0-8443-Processor2) [
>> EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up
>> to 18000
>> 78580442 (http-0.0.0.0-8443-Processor2) [
>> EntitySaxReader.java:261:INFO ] Finished 18999 values from
>> file:/home/nick/ofbiz-7818/import/demo_products.xml
>> 78580444 (http-0.0.0.0-8443-Processor2)
>> [InheritableTransactionContext.java:311:ERROR] Unable to roll back
>> transaction
>> java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION
>> at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:438)
>> at org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:308)
>> at org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
>> at org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
>>
>>
>> I get the exact same error when I try to use a derby database instead
>> of the postgres one. This import was working when I was using an
>> earlier build of ofbiz (1-2 months ago), but it is failing now.
>>
>> What could be causing this error?
>>
>> -Nick
>>  
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>

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