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

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

Ok, I created an issue in JIRA. The full log is attached.

https://issues.apache.org/jira/browse/OFBIZ-37


Si Chen wrote:

> 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
>
>
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users