Skip to Content
0
Former Member
Aug 08, 2017 at 10:51 PM

Error with Impex -- Invalid batchsize, set to 50 instead of 1

327 Views

The initialization failed for many impexes in our QA env with the message "Invalid batchsize, set to 50 instead of 1" . I changed the value from 50 to 1 for the property "direct.persistence.jdbc.oracle.batch.size=1" , then it did go through. I suspect the issue to be with the Oracle DB version -- Oracle 12.2.0.1; the db driver is ojdbc8.jar. Our hybris version is 6.3.0.0

https://docs.oracle.com/database/122/UPGRD/oracle-update-batching-batch-size-disabled.htm#UPGRD-GUID-82954FA7-2E3B-4E4F-8CC3-11640EC7E2EB

Any idea, will this batch size = 1 creating performance issues with bulk load? If so any solution available to overcome this problem ?