on 08-08-2017 11:51 PM
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
Any idea, will this batch size = 1 creating performance issues with bulk load? If so any solution available to overcome this problem ?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:?]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.