How to resolve "Error writing media file..." error in data hub?

[Former Member]

We have a requirement in data hub wherein we need to process a file and transform it into impex script through data hub. When we try to process this file it is showing as FAILURE in the publicationaction table and the error mentioned in the publicationerror table is shown below.

Error writing media file (mediaId: 8796257386526, file:C:\hybris\data\media\sys_master\impex\h91\h77\8796257386526.bin, dir:C:\hybris\data\media\sys_master\impex\h91\h77)

If we get the generated impex from the ymedia table and manually import that in hybris admin console it has no issues importing. We attempted to run process again the file through data hub but it is still showing as FAILURE with similar error above. Tried processing a different file and it is showing as SUCCESS.

In the hybris console logs here is what we see:

INFO | jvm 1 | main | 2015/09/09 18:06:09.663 | INFO [TaskExecutor-master-185-Task [8796093121462]] [ImpexDataImportClient] Response status from http://localhost:8080/datahub-webapp/v1/core-publications/2: 200 INFO | jvm 1 | main | 2015/09/09 18:06:09.663 | ERROR [TaskExecutor-master-185-Task [8796093121462]] [DefaultTaskService] Failed to execute task #8796093121462. INFO | jvm 1 | main | 2015/09/09 18:06:09.663 | de.hybris.platform.servicelayer.exceptions.SystemException: de.hybris.platform.tx.RollbackOnlyException: transaction rolled back because it has been marked as rollback-only[VC:-1] INFO | jvm 1 | main | 2015/09/09 18:06:09.664 | at de.hybris.platform.task.impl.DefaultTaskExecutionStrategy.run(DefaultTaskExecutionStrategy.java:112) INFO | jvm 1 | main | 2015/09/09 18:06:09.664 | at de.hybris.platform.task.impl.DefaultTaskService.processTask(DefaultTaskService.java:1128) INFO | jvm 1 | main | 2015/09/09 18:06:09.664 | at de.hybris.platform.task.impl.DefaultTaskService.process(DefaultTaskService.java:1027) INFO | jvm 1 | main | 2015/09/09 18:06:09.664 | at de.hybris.platform.task.impl.DefaultTaskService.processInTenant(DefaultTaskService.java:987) INFO | jvm 1 | main | 2015/09/09 18:06:09.665 | at de.hybris.platform.task.impl.DefaultTaskService$3.run(DefaultTaskService.java:892) INFO | jvm 1 | main | 2015/09/09 18:06:09.665 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) INFO | jvm 1 | main | 2015/09/09 18:06:09.665 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) INFO | jvm 1 | main | 2015/09/09 18:06:09.666 | at java.lang.Thread.run(Thread.java:745) INFO | jvm 1 | main | 2015/09/09 18:06:09.666 | Caused by: de.hybris.platform.tx.RollbackOnlyException: transaction rolled back because it has been marked as rollback-only[VC:-1] INFO | jvm 1 | main | 2015/09/09 18:06:09.667 | at de.hybris.platform.tx.Transaction.commit(Transaction.java:662) INFO | jvm 1 | main | 2015/09/09 18:06:09.667 | at de.hybris.platform.tx.Transaction.finishExecute(Transaction.java:1218) INFO | jvm 1 | main | 2015/09/09 18:06:09.667 | at de.hybris.platform.tx.Transaction.execute(Transaction.java:1205) INFO | jvm 1 | main | 2015/09/09 18:06:09.667 | at de.hybris.platform.tx.Transaction.execute(Transaction.java:1160) INFO | jvm 1 | main | 2015/09/09 18:06:09.667 | at de.hybris.platform.task.impl.DefaultTaskExecutionStrategy.run(DefaultTaskExecutionStrategy.java:80) INFO | jvm 1 | main | 2015/09/09 18:06:09.667 | ... 7 more INFO | jvm 1 | main | 2015/09/09 18:06:09.668 | ERROR [TaskExecutor-master-185-Task [8796093121462]] [ItemImportTaskRunner] ItemImportTaskRunner.handleError() INFO | jvm 1 | main | 2015/09/09 18:06:09.668 | de.hybris.platform.servicelayer.exceptions.SystemException: de.hybris.platform.tx.RollbackOnlyException: transaction rolled back because it has been marked as rollback-only[VC:-1] INFO | jvm 1 | main | 2015/09/09 18:06:09.668 | at de.hybris.platform.task.impl.DefaultTaskExecutionStrategy.run(DefaultTaskExecutionStrategy.java:112) INFO | jvm 1 | main | 2015/09/09 18:06:09.668 | at de.hybris.platform.task.impl.DefaultTaskService.processTask(DefaultTaskService.java:1128) INFO | jvm 1 | main | 2015/09/09 18:06:09.668 | at de.hybris.platform.task.impl.DefaultTaskService.process(DefaultTaskService.java:1027) INFO | jvm 1 | main | 2015/09/09 18:06:09.669 | at de.hybris.platform.task.impl.DefaultTaskService.processInTenant(DefaultTaskService.java:987) INFO | jvm 1 | main | 2015/09/09 18:06:09.669 | at de.hybris.platform.task.impl.DefaultTaskService$3.run(DefaultTaskService.java:892) INFO | jvm 1 | main | 2015/09/09 18:06:09.669 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) INFO | jvm 1 | main | 2015/09/09 18:06:09.669 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) INFO | jvm 1 | main | 2015/09/09 18:06:09.670 | at java.lang.Thread.run(Thread.java:745) INFO | jvm 1 | main | 2015/09/09 18:06:09.670 | Caused by: de.hybris.platform.tx.RollbackOnlyException: transaction rolled back because it has been marked as rollback-only[VC:-1] INFO | jvm 1 | main | 2015/09/09 18:06:09.670 | at de.hybris.platform.tx.Transaction.commit(Transaction.java:662) INFO | jvm 1 | main | 2015/09/09 18:06:09.671 | at de.hybris.platform.tx.Transaction.finishExecute(Transaction.java:1218) INFO | jvm 1 | main | 2015/09/09 18:06:09.671 | at de.hybris.platform.tx.Transaction.execute(Transaction.java:1205) INFO | jvm 1 | main | 2015/09/09 18:06:09.671 | at de.hybris.platform.tx.Transaction.execute(Transaction.java:1160) INFO | jvm 1 | main | 2015/09/09 18:06:09.671 | at de.hybris.platform.task.impl.DefaultTaskExecutionStrategy.run(DefaultTaskExecutionStrategy.java:80) INFO | jvm 1 | main | 2015/09/09 18:06:09.671 | ... 7 more Need some experts in hybris/data hub to assist in this issue.

[rafal_gdowski]

What version of the Data Hub and commerce suite?

[Former Member]

The Data Hub version is 5.5 and the commerce suite is 5.4

[rafal_gdowski]

We cannot guarantee that that will work. You should be on the same version of both.

[Former Member]

We downgraded our Data Hub version to 5.4 so that it matches the hybris version. When we process the file it still gives us a FAILURE status but when I go to the PublicationError table, there is nothing logged in this table.

[Former Member]

NFO | jvm 1 | main | 2015/11/10 15:45:38.731 | ERROR [TaskExecutor-master-1656-Task [8796093776822]] [DefaultTaskService] Failed to execute task #8796093776822. INFO | jvm 1 | main | 2015/11/10 15:45:38.731 | de.hybris.platform.servicelayer.exceptions.SystemException: de.hybris.platform.tx.RollbackOnlyException: transaction rolled back because it has been marked as rollback-only[VC:-1]