on 2020 Jun 18 6:27 AM
Hi Experts,
We're getting below exception with saveAll after patch migration from SAP Commerce 6.7.0.11 to 6.7.0.23.
20.06.1517:56:15:860 ERROR Caught throwable Oracle batch API error de.hybris.platform.servicelayer.exceptions.ModelSavingException:Oracle batch API error at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.storeAttributes(ItemModelConverter.java:1755) at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.save(ItemModelConverter.java:837) at de.hybris.platform.servicelayer.internal.model.impl.wrapper.ModelWrapper.save(ModelWrapper.java:363) at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.saveOthers(ResolvingModelPersister.java:68) at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.persist(ResolvingModelPersister.java:53) at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveViaJalo(DefaultModelService.java:1185) at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.doJaloPersistence(DefaultModelService.java:744) at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.persistWrappers(DefaultModelService.java:1129) at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.performPersistenceOperations(DefaultModelService.java:721) at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAllInternal(DefaultModelService.java:715) at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAll(DefaultModelService.java:695) at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAll(DefaultModelService.java:657) at com.mirakl.hybris.core.shop.services.impl.DefaultShopImportService.importShopsUpdatedSince(DefaultShopImportService.java:75) at com.mirakl.hybris.core.shop.jobs.MiraklImportShopsJob.perform(MiraklImportShopsJob.java:39) at com.mirakl.hybris.core.shop.jobs.MiraklImportShopsJob.perform(MiraklImportShopsJob.java:1) at de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob.performCronJob(ServicelayerJob.java:38) at de.hybris.platform.cronjob.jalo.Job.execute(Job.java:1390) at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:814) at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:732) at de.hybris.platform.cronjob.jalo.Job.perform(Job.java:644) at de.hybris.platform.servicelayer.cronjob.impl.DefaultCronJobService.performCronJob(DefaultCronJobService.java:86) at de.hybris.platform.catalog.job.CompositeJobPerformable.executeCompositeEntry(CompositeJobPerformable.java:125) at de.hybris.platform.catalog.job.CompositeJobPerformable.perform(CompositeJobPerformable.java:76) at de.hybris.platform.catalog.job.CompositeJobPerformable.perform(CompositeJobPerformable.java:1) at de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob.performCronJob(ServicelayerJob.java:38) at de.hybris.platform.cronjob.jalo.Job.execute(Job.java:1390) at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:814) at de.hybris.platform.cronjob.jalo.Job.access$1(Job.java:767) at de.hybris.platform.cronjob.jalo.Job$JobRunable.run(Job.java:686) at de.hybris.platform.util.threadpool.PoolableThread.internalRun(PoolableThread.java:208) at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:134)Caused by: java.lang.IllegalStateException:Oracle batch API error at de.hybris.platform.directpersistence.impl.OracleBatchCollector$BatchConnectionCallback.setOracleExecuteBatchSettings(OracleBatchCollector.java:282) at de.hybris.platform.directpersistence.impl.OracleBatchCollector$BatchConnectionCallback.createPreparedStatement(OracleBatchCollector.java:170) at de.hybris.platform.directpersistence.impl.OracleBatchCollector$BatchConnectionCallback.doInConnection(OracleBatchCollector.java:143) at de.hybris.platform.directpersistence.impl.OracleBatchCollector$BatchConnectionCallback.doInConnection(OracleBatchCollector.java:1) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:353) at de.hybris.platform.directpersistence.impl.OracleBatchCollector.updateBatch(OracleBatchCollector.java:110) at de.hybris.platform.directpersistence.impl.OracleBatchCollector.preProcess(OracleBatchCollector.java:86) at de.hybris.platform.directpersistence.impl.DefaultBatchCollector.batchUpdate(DefaultBatchCollector.java:105) at de.hybris.platform.directpersistence.impl.DefaultWritePersistenceGateway.persistInternal(DefaultWritePersistenceGateway.java:160) at de.hybris.platform.directpersistence.impl.DefaultWritePersistenceGateway.persist(DefaultWritePersistenceGateway.java:128) at de.hybris.platform.persistence.links.jdbc.dml.context.NewTransactionContext.flush(NewTransactionContext.java:137) at de.hybris.platform.persistence.links.jdbc.dml.DmlLinkOperationExecutor$1.doInTransactionWithoutResult(DmlLinkOperationExecutor.java:88) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) at de.hybris.platform.persistence.links.jdbc.dml.DmlLinkOperationExecutor.doWithContextWithinTransaction(DmlLinkOperationExecutor.java:81) at de.hybris.platform.persistence.links.jdbc.dml.DmlLinkOperationExecutor.execute(DmlLinkOperationExecutor.java:67) at de.hybris.platform.persistence.links.jdbc.JdbcSetLinkOperation.perform(JdbcSetLinkOperation.java:71) at de.hybris.platform.jalo.link.LinkManager.setLinkedItems(LinkManager.java:994) at de.hybris.platform.jalo.link.LinkManager.setLinkedItems(LinkManager.java:976) at de.hybris.platform.jalo.Item.setLinkedItems(Item.java:2740) at com.mirakl.hybris.channelsaddon.jalo.GeneratedMiraklchannelsaddonManager.setChannels(GeneratedMiraklchannelsaddonManager.java:114) at sun.reflect.GeneratedMethodAccessor3400.invoke(UnknownSource) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at de.hybris.platform.jalo.type.ReflectionAttributeAccess$AttributeMethod.invokeSetter(ReflectionAttributeAccess.java:806) at de.hybris.platform.jalo.type.ReflectionAttributeAccess.setValue(ReflectionAttributeAccess.java:984) at de.hybris.platform.jalo.Item.setAttribute(Item.java:2360) at de.hybris.platform.jalo.Item.setAllAttributesInternal(Item.java:2193) at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2145) at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2084) at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.storeAttributes(ItemModelConverter.java:1740)...30 more Caused by: java.lang.IllegalArgumentException: java.lang.ClassCastException@60b33f20 at sun.reflect.GeneratedMethodAccessor2313.invoke(UnknownSource) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at de.hybris.platform.directpersistence.impl.OracleBatchCollector$BatchConnectionCallback.setOracleExecuteBatchSettings(OracleBatchCollector.java:276)...60 more
Thanks
Request clarification before answering.
Hi Kuldeep,
Is the issue resolved. I am facing the same issue after upgrading from 6.7.04 to 6.7.0.31.
Can you please help me in providing the solution if you have fixed it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The latest for 6.7 is 6.7.0.30. Have you tried it? Maybe there are bugfixes related to that error.
Patch releases for 6.7: https://help.sap.com/viewer/dc198ac31ba24dce96149c8480be955f/6.7.0.0/en-US/cba026d2b36c4ab18f89525df...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 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.