cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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...

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

Former Member
0 Kudos

We have faced same issue . Did you find any document.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

UPDATE: when we upgraded the jdbc driver to be in step with an oracle upgrade to 12c (12.1.0.2.0) we went from ojdbc6-11.2.0.3.jar to ojdbc8.jar. After reading the article mentioned in this thread we noticed that the ojdbc8.jar was for oracle v12.2. The ojdbc dsted for oracle v12.1 is ojdbc7.jar

http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

We switched the jdbc driver to ojdbc7.d the creation of a new user was successful without the batchsize error.

Former Member
0 Kudos

We too have seen this on the creation of a new user.

On save :

 NFO   | jvm 1    | main    | 2017/11/14 14:46:00.323 | ERROR [hybrisHTTP14] [172.16.54.143] [GenericItemCreateAction] create(...): Exception occured during creation process! de.hybris.platform.servicelayer.exceptions.ModelSavingException: Invalid batchsize, set to 50 instead of 1
 INFO   | jvm 1    | main    | 2017/11/14 14:46:00.323 |  de.hybris.platform.servicelayer.exceptions.ModelSavingException: Invalid batchsize, set to 50 instead of 1
 INFO   | jvm 1    | main    | 2017/11/14 14:46:00.323 |     at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.createNewItem(ItemModelConverter.java:2257) ~[coreserver.jar:?]