I am getting following error when an order is placed and the system sends an order confirmation mail. As a result of this error I keep getting same order confirmation mail multiple times.
Here is ther error log 2014-04-11 14:51:53,039 (OFBiz-JobQueue-1) [ DataServices.java:562:INFO ] imageDataResource(C):[GenericEntity:ImageDataResource][dataResourceId,10010(java.lang.String)][imageData,[B@780f96eb([B)] 2014-04-11 14:51:53,216 (OFBiz-JobQueue-1) [ GenericDelegator.java:923:ERROR] Failure in create operation for entity [ImageDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob. Rolling back transaction. 2014-04-11 14:51:53,219 (OFBiz-JobQueue-1) [ TransactionUtil.java:378:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in create operation for entity [ImageDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob. Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in create operation for entity [ImageDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob. Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:378) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:319) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:924) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:767) org.ofbiz.entity.GenericValue.create(GenericValue.java:72) org.ofbiz.content.data.DataServices.createImageMethod(DataServices.java:564) org.ofbiz.content.data.DataServices.createImage(DataServices.java:546) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.content.ContentManagementServices.persistDataResourceAndDataMethod(ContentManagementServices.java:681) org.ofbiz.content.ContentManagementServices.persistContentAndAssoc(ContentManagementServices.java:261) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:95) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:217) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:307) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:454) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:271) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:290) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:48) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.party.communication.CommunicationEventServices.createAttachmentContent(CommunicationEventServices.java:1022) org.ofbiz.party.communication.CommunicationEventServices.updateCommEventAfterEmail(CommunicationEventServices.java:648) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:138) org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:159) org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:190) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:485) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.common.email.EmailServices.sendMailFromScreen(EmailServices.java:589) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.order.order.OrderServices.sendOrderNotificationScreen(OrderServices.java:2630) org.ofbiz.order.order.OrderServices.sendOrderConfirmNotification(OrderServices.java:2477) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:744) -------------------------------------------------------------------------------- 2014-04-11 14:51:53,220 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:523:ERROR] Error in Service [createImage]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) 2014-04-11 14:51:53,221 (OFBiz-JobQueue-1) [ TransactionUtil.java:383:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2014-04-11 14:51:53,221 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:589:INFO ] Sync service [default/createImage] finished in [190] milliseconds 2014-04-11 14:51:53,221 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:523:ERROR] Error in Service [persistContentAndAssoc]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) 2014-04-11 14:51:53,221 (OFBiz-JobQueue-1) [ TransactionUtil.java:383:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2014-04-11 14:51:53,222 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:589:INFO ] Sync service [default/persistContentAndAssoc] finished in [1206] milliseconds 2014-04-11 14:51:53,223 (OFBiz-JobQueue-1) [ CallService.java:314:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.lang.Exception Message: Error: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) ---- stack trace --------------------------------------------------------------- java.lang.Exception: Error: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:314) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:307) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:454) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:271) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:290) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:48) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.party.communication.CommunicationEventServices.createAttachmentContent(CommunicationEventServices.java:1022) org.ofbiz.party.communication.CommunicationEventServices.updateCommEventAfterEmail(CommunicationEventServices.java:648) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:138) org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:159) org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:190) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:485) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.common.email.EmailServices.sendMailFromScreen(EmailServices.java:589) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.order.order.OrderServices.sendOrderNotificationScreen(OrderServices.java:2630) org.ofbiz.order.order.OrderServices.sendOrderConfirmNotification(OrderServices.java:2477) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:744) -------------------------------------------------------------------------------- 2014-04-11 14:51:53,223 (OFBiz-JobQueue-1) [ TransactionUtil.java:383:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2014-04-11 14:51:53,224 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:523:ERROR] Error in Service [createCommContentDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) 2014-04-11 14:51:53,224 (OFBiz-JobQueue-1) [ TransactionUtil.java:383:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2014-04-11 14:51:53,224 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:589:INFO ] Sync service [default/createCommContentDataResource] finished in [1252] milliseconds 2014-04-11 14:51:53,224 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:589:INFO ] Sync service [default/updateCommEventAfterEmail] finished in [1339] milliseconds 2014-04-11 14:51:53,224 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:589:INFO ] Sync service [default/sendMailMultiPart] finished in [9308] milliseconds 2014-04-11 14:51:53,225 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:589:INFO ] Sync service [default/sendMailFromScreen] finished in [14250] milliseconds 2014-04-11 14:51:53,225 (OFBiz-JobQueue-1) [ ServiceEcaRule.java:157:INFO ] Running Service ECA Service: createOrderNotificationLog, triggered by rule on Service: sendOrderConfirmation 2014-04-11 14:51:53,300 (OFBiz-JobQueue-1) [ TransactionUtil.java:148:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.begin] active transaction marked for rollback in place, so no transaction begun; this stack trace shows when the exception began: Exception: java.lang.Exception Message: Tx Stack Placeholder ---- stack trace --------------------------------------------------------------- java.lang.Exception: Tx Stack Placeholder org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:743) org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:169) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:302) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:744) -------------------------------------------------------------------------------- 2014-04-11 14:51:53,320 (OFBiz-JobQueue-1) [ UtilProperties.java:1069:INFO ] ResourceBundle MiniLangErrorUiLabels (en_US) created in 0.02s with 4 properties 2014-04-11 14:51:53,320 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:523:ERROR] Error in Service [createOrderNotificationLog]: Error trying to begin transaction, could not process method: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ImageDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob. Rolling back transaction.java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) 2014-04-11 14:51:53,320 (OFBiz-JobQueue-1) [ TransactionUtil.java:383:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2014-04-11 14:51:53,320 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:589:INFO ] Sync service [default/createOrderNotificationLog] finished in [95] milliseconds 2014-04-11 14:51:53,510 (OFBiz-JobQueue-1) [ TransactionUtil.java:287:ERROR] ---- exception report ---------------------------------------------------------- Rollback Only was set when trying to commit transaction here; throwing rollbackOnly cause exception Exception: javax.transaction.RollbackException Message: Unable to commit: transaction marked for rollback ---- cause --------------------------------------------------------------------- Exception: org.apache.geronimo.transaction.manager.SetRollbackOnlyException Message: setRollbackOnly() called. See stacktrace for origin ---- stack trace --------------------------------------------------------------- org.apache.geronimo.transaction.manager.SetRollbackOnlyException: setRollbackOnly() called. See stacktrace for origin org.apache.geronimo.transaction.manager.TransactionImpl.setRollbackOnly(TransactionImpl.java:126) org.apache.geronimo.transaction.manager.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:243) org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:380) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:319) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:924) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:767) org.ofbiz.entity.GenericValue.create(GenericValue.java:72) org.ofbiz.content.data.DataServices.createImageMethod(DataServices.java:564) org.ofbiz.content.data.DataServices.createImage(DataServices.java:546) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.content.ContentManagementServices.persistDataResourceAndDataMethod(ContentManagementServices.java:681) org.ofbiz.content.ContentManagementServices.persistContentAndAssoc(ContentManagementServices.java:261) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:95) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:217) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:307) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:454) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:271) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:290) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:48) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.party.communication.CommunicationEventServices.createAttachmentContent(CommunicationEventServices.java:1022) org.ofbiz.party.communication.CommunicationEventServices.updateCommEventAfterEmail(CommunicationEventServices.java:648) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:138) org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:159) org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:190) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:485) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.common.email.EmailServices.sendMailFromScreen(EmailServices.java:589) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.order.order.OrderServices.sendOrderNotificationScreen(OrderServices.java:2630) org.ofbiz.order.order.OrderServices.sendOrderConfirmNotification(OrderServices.java:2477) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:744) -------------------------------------------------------------------------------- 2014-04-11 14:51:53,512 (OFBiz-JobQueue-1) [ ServiceDispatcher.java:538:ERROR] ---- exception report ---------------------------------------------------------- Could not commit transaction for service [sendOrderConfirmation] call Exception: org.ofbiz.entity.transaction.GenericTransactionException Message: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ImageDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob. Rolling back transaction.java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) ---- cause --------------------------------------------------------------------- Exception: java.lang.ClassCastException Message: [B cannot be cast to java.sql.Blob ---- stack trace --------------------------------------------------------------- java.lang.ClassCastException: [B cannot be cast to java.sql.Blob org.ofbiz.entity.jdbc.JdbcValueHandler$BlobJdbcValueHandler.castAndSetValue(JdbcValueHandler.java:300) org.ofbiz.entity.jdbc.JdbcValueHandler.setValue(JdbcValueHandler.java:259) org.ofbiz.entity.jdbc.SQLProcessor.setValue(SQLProcessor.java:536) org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:783) org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:762) org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:476) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:183) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:126) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:70) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:901) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:767) org.ofbiz.entity.GenericValue.create(GenericValue.java:72) org.ofbiz.content.data.DataServices.createImageMethod(DataServices.java:564) org.ofbiz.content.data.DataServices.createImage(DataServices.java:546) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.content.ContentManagementServices.persistDataResourceAndDataMethod(ContentManagementServices.java:681) org.ofbiz.content.ContentManagementServices.persistContentAndAssoc(ContentManagementServices.java:261) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:95) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:217) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:307) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:454) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:271) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:290) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:48) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.party.communication.CommunicationEventServices.createAttachmentContent(CommunicationEventServices.java:1022) org.ofbiz.party.communication.CommunicationEventServices.updateCommEventAfterEmail(CommunicationEventServices.java:648) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:138) org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:159) org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:190) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:485) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.common.email.EmailServices.sendMailFromScreen(EmailServices.java:589) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.order.order.OrderServices.sendOrderNotificationScreen(OrderServices.java:2630) org.ofbiz.order.order.OrderServices.sendOrderConfirmNotification(OrderServices.java:2477) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:388) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:744) -------------------------------------------------------------------------------- 2014-04-11 14:51:53,512 (OFBiz-JobQueue-1) [ GenericServiceJob.java:118:ERROR] ---- exception report ---------------------------------------------------------- Async-Service failed. Exception: org.ofbiz.service.GenericServiceException Message: Could not commit transaction for service [sendOrderConfirmation] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ImageDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob. Rolling back transaction.java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) ---- stack trace --------------------------------------------------------------- org.ofbiz.service.GenericServiceException: Could not commit transaction for service [sendOrderConfirmation] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ImageDataResource]: java.lang.ClassCastException: [B cannot be cast to java.sql.Blob. Rolling back transaction.java.lang.ClassCastException: [B cannot be cast to java.sql.Blob ([B cannot be cast to java.sql.Blob) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:542) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:220) org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83) org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:744) -------------------------------------------------------------------------------- 2014-04-11 14:51:54,098 (OFBiz-JobQueue-1) [PersistedServiceJob.java:259:INFO ] Persisted Job [10943] Failed. Re-Scheduling : 1397208293513 2014-04-11 14:55:08,982 (OFBiz-JobQueue-0) [PersistedServiceJob.java:189:INFO ] Job [1397208091806] Id [10944] -- Next runtime: Thu Jan 01 05:29:59 IST 1970 -- View this message in context: http://ofbiz.135035.n4.nabble.com/B-cannot-be-cast-to-java-sql-Blob-while-sending-order-confirmation-mail-tp4650301.html Sent from the OFBiz - User mailing list archive at Nabble.com.
