Posted by
David E. Jones on
Nov 25, 2005; 6:42pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-questions-and-suggestions-tp136582p136589.html
Have you eliminated timeout and out of memory problems? Those are the
2 most common with entity sync. Note that the tool was designed for
sending data changes from one system to another, not for dumping an
entire database or any single huge commit in a single shot. The
problem is it has to pull all data into memory for each chunk, and
send those chunks to the other system. Right now this is done based
on time stamps for a reliable progress tracking mechanism so we can
reliably keep track of what has and hasn't been sent over with a
simple value. If you have a huge number of records going into a
single commit this can cause a problem....
How big a number it can handle depends on your network speed, which
remote service engine you are using (for example the RMI one is
compressed and binary and MUCH faster than the HTTP one...), and what
the timeouts and such are set to. You may need to increase a timeout
somewhere. Memory problems are similar with various things affecting
how many records you can handle in a single shot.
-David
On Nov 25, 2005, at 11:22 AM, Andrew Sykes wrote:
> In addition to my post yesterday.
>
> I'm trying to sync about 10,000 entities at the moment. It seems
> that if
> I try just 200ish everything is fine, but when I try all 10,000 I get
> the error posted yesterday about the transaction being marked for
> rollback.
>
> Does anyone have any idea why this would be happening?
>
> Thanks
> --
> Andrew Sykes <
[hidden email]>
> Sykes Development Ltd
>
>
> _______________________________________________
> Users mailing list
>
[hidden email]
>
http://lists.ofbiz.org/mailman/listinfo/users_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users