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

Posted by Si Chen-2 on Jun 20, 2006; 10:13pm
URL: http://ofbiz.116.s1.nabble.com/Users-XML-data-import-fails-when-importing-more-than-10000-products-tp140028p140040.html

Are you saying this worked with an earlier version of OFBIZ?  How  
long ago?  This may have to do with the new Geronimo transactions  
managers.

Maybe you should open a JIRA issue and attach the entire log (yes,  
all of it -- don't be shy... Sometimes the clues are not obvious.)

Si


On Jun 20, 2006, at 2:12 PM, Nick Olson wrote:

> 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.InheritableTransactionContex
>>> t.rollbackAndThrow(InheritableTransactionContext.java:308)
>>> at  
>>> org.apache.geronimo.transaction.context.InheritableTransactionContex
>>> t.complete(InheritableTransactionContext.java:199)
>>> at  
>>> org.apache.geronimo.transaction.context.InheritableTransactionContex
>>> t.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

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