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

Posted by BJ Freeman on Jun 20, 2006; 9:29pm
URL: http://ofbiz.116.s1.nabble.com/Users-XML-data-import-fails-when-importing-more-than-10000-products-tp140028p140038.html

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