Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,603 questions
Posting Business Central Json data from blob using adf
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 28.000000000000004%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKO%3C/text%3E%3C/svg%3E)
Kayode Ogidan
90
Reputation points
Job failed due to reason: at Sink 'RESTAPIOutput': Job aborted due to stage failure: Task 3 in stage 108.0 failed 1 times, most recent failure: Lost task 3.0 in stage 108.0 (TID 148) (vm-0cf09028 executor 1): java.lang.NullPointerException
at org.apache.spark.sql.execution.datasources.rest.RestClient.executeSingleRowRequest(RestClient.scala:197)
at org.apache.spark.sql.execution.datasources.rest.RestClient.$anonfun$savePartitionSingle$5(RestClient.scala:163)
at org.apache.spark.sql.execution.datasources.rest.RestClient.$anonfun$savePartitionSingle$5$adapted(RestClient.scala:160)
at scala.collection.Iterator.foreach(Iterator.scala:941)
at scala.collection.Iterator.foreach$(Iterator.scala:941)
at scala.collection.AbstractIterator.foreach(Iterator.scala:1429)
at org.apache.spark.sql.execution.datasources.rest.RestClient.$anonfun$savePartitionSingle$1(RestClient.scala:160)
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)
at scala.util.Try$.apply(Try.scala:213)
at org.apache.spar
@PRADEEPCHEEKATLA-MSFT @phemanth @Harishga Please help, I am posting data to business central, I have about 20 csv files in a copy activity, total input rows of 331, I am getting the error, what could be wrong, it fails on the sink
Azure Data Factory
{count} votes
-
Kayode Ogidan 90 Reputation points
2024-05-24T03:27:13.71+00:00 Job failed due to reason: at Sink 'RESTAPIOutput': Job aborted due to stage failure: Task 3 in stage 108.0 failed 1 times, most recent failure: Lost task 3.0 in stage 108.0 (TID 148) (vm-0cf09028 executor 1): java.lang.NullPointerException
at org.apache.spark.sql.execution.datasources.rest.RestClient.executeSingleRowRequest(RestClient.scala:197) at org.apache.spark.sql.execution.datasources.rest.RestClient.$anonfun$savePartitionSingle$5(RestClient.scala:163) at org.apache.spark.sql.execution.datasources.rest.RestClient.$anonfun$savePartitionSingle$5$adapted(RestClient.scala:160) at scala.collection.Iterator.foreach(Iterator.scala:941) at scala.collection.Iterator.foreach$(Iterator.scala:941) at scala.collection.AbstractIterator.foreach(Iterator.scala:1429) at org.apache.spark.sql.execution.datasources.rest.RestClient.$anonfun$savePartitionSingle$1(RestClient.scala:160) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at scala.util.Try$.apply(Try.scala:213) at org.apache.spar -
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator2024-05-24T05:54:38.0233333+00:00 Hi Kayode Ogidan,
Thank you for posting query in Microsoft Q&A Platform.
Are you using
Copy Activityordataflow? Could you please share more details on how to posting data, and how your source and sink datasets and configurations in copy activity look like?
Are you using REST API here, if yes, where and how it configured. Please recheck once. Thank you. -
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2024-05-27T05:37:10.8166667+00:00 Hi Kayode Ogidan, Just checking if you get chance to share updates? Thank you.
Sign in to comment
Sign in to answer