amazonaws.datapipeline.taskrunner.TaskExecutionException

Error copying record

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web189

  • via Unknown by Unknown author,
  • via Geographic Information Systems by user17653
    ,
  • Stack trace

    • amazonaws.datapipeline.taskrunner.TaskExecutionException: Error copying record at amazonaws.datapipeline.activity.copy.SingleThreadedCopyActivity.processAll(SingleThreadedCopyActivity.java:65) at amazonaws.datapipeline.activity.copy.SingleThreadedCopyActivity.runActivity(SingleThreadedCopyActivity.java:35) at amazonaws.datapipeline.activity.CopyActivity.runActivity(CopyActivity.java:22) at amazonaws.datapipeline.objects.AbstractActivity.run(AbstractActivity.java:16) at amazonaws.datapipeline.taskrunner.TaskPoller.executeRemoteRunner(TaskPoller.java:128) at amazonaws.datapipeline.taskrunner.TaskPoller.executeTask(TaskPoller.java:97) at amazonaws.datapipeline.taskrunner.TaskPoller$1.run(TaskPoller.java:74) at private.com.amazonaws.services.datapipeline.poller.PollWorker.executeWork(PollWorker.java:76) at private.com.amazonaws.services.datapipeline.poller.PollWorker.run(PollWorker.java:53) at java.lang.Thread.run(Thread.java:701) Caused by: java.lang.RuntimeException: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO table_revenue_daily_fact (id,account_id,video_id,publisher_id,placement_id,country_id,deal_id,device_id,platform_id,date_id,impressions_cnt,clickthroughs_cnt,clickthrough_rate,ecpm,revenue,inventory_pre,insert_ts) VALUES('2897','2','5','8','5','236','3','8','1','20130226','514','40','50.00','41.78','82.93','21','2014-10-31 08:49:43.469004') was aborted. Call getNextException to see the cause. at private.com.google.common.base.Throwables.propagate(Unknown Source) at amazonaws.datapipeline.connector.SqlOutputConnector.flushStmt(SqlOutputConnector.java:106) at amazonaws.datapipeline.connector.SqlOutputConnector.writeRecord(SqlOutputConnector.java:68) at amazonaws.datapipeline.activity.copy.SingleThreadedCopyActivity.processAll(SingleThreadedCopyActivity.java:53) ... 9 more Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO table_revenue_daily_fact (id,account_id,video_id,publisher_id,placement_id,country_id,deal_id,device_id,platform_id,date_id,impressions_cnt,clickthroughs_cnt,clickthrough_rate,ecpm,revenue,inventory_pre,insert_ts) VALUES('2897','2','5','8','5','236','3','8','1','20130226','514','40','50.00','41.78','82.93','21','2014-10-31 08:49:43.469004') was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2590) at org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:348) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1830) at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1084) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:398) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2713) at amazonaws.datapipeline.connector.SqlOutputConnector.flushStmt(SqlOutputConnector.java:101)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    6 more bugmates