Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 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
85
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
{count} votes
-
Kayode Ogidan 85 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,401 Reputation points Microsoft Employee2024-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,401 Reputation points Microsoft Employee
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