This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Error getting user information when debugging Azure Synapse Analytics pipeline with Synapse notebook executing statement mssparkutils.env.getUserName().
{
"errorCode": "6002",
"message": "Py4JJavaError: An error occurred while calling z:mssparkutils.env.getUserName.\n: org.json.JSONException: JSONObject[\"signaturePayload\"] not found.\n\tat org.json.JSONObject.get(JSONObject.java:520)\n\tat mssparkutils.env$$anonfun$extractField$2.$anonfun$applyOrElse$1(env.scala:28)\n\tat scala.util.Try$.apply(Try.scala:213)\n\tat mssparkutils.env$$anonfun$extractField$2.applyOrElse(env.scala:28)\n\tat mssparkutils.env$$anonfun$extractField$2.applyOrElse(env.scala:26)\n\tat scala.runtime.AbstractPartialFunction.apply(AbstractPartialFunction.scala:38)\n\tat scala.util.Failure.recoverWith(Try.scala:236)\n\tat mssparkutils.env$.extractField(env.scala:26)\n\tat mssparkutils.env$.getUserName(env.scala:44)\n\tat mssparkutils.env.getUserName(env.scala)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)\n\tat py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)\n\tat py4j.Gateway.invoke(Gateway.java:282)\n\tat py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)\n\tat py4j.commands.CallCommand.execute(CallCommand.java:79)\n\tat py4j.GatewayConnection.run(GatewayConnection.java:238)\n\tat java.lang.Thread.run(Thread.java:748)\n\nTraceback (most recent call last):\n\n File \"/home/trusted-service-user/cluster-env/env/lib/python3.8/site-packages/notebookutils/mssparkutils/env.py\", line 8, in getUserName\n return envc.getUserName()\n\n File \"/home/trusted-service-user/cluster-env/env/lib/python3.8/site-packages/py4j/java_gateway.py\", line 1304, in call\n return_value = get_return_value(\n\n File \"/opt/spark/python/lib/pyspark.zip/pyspark/sql/utils.py\", line 111, in deco\n return f(*a, **kw)\n\n File \"/home/trusted-service-user/cluster-env/env/lib/python3.8/site-packages/py4j/protocol.py\", line 326, in get_return_value\n raise Py4JJavaError(\n\npy4j.protocol.Py4JJavaError: An error occurred while calling z:mssparkutils.env.getUserName.\n: org.json.JSONException: JSONObject[\"signaturePayload\"] not found.\n\tat org.json.JSONObject.get(JSONObject.java:520)\n\tat mssparkutils.env$$anonfun$extractField$2.$anonfun$applyOrElse$1(env.scala:28)\n\tat scala.util.Try$.apply(Try.scala:213)\n\tat mssparkutils.env$$anonfun$extractField$2.applyOrElse(env.scala:28)\n\tat mssparkutils.env$$anonfun$extractField$2.applyOrElse(env.scala:26)\n\tat scala.runtime.AbstractPartialFunction.apply(AbstractPartialFunction.scala:38)\n\tat scala.util.Failure.recoverWith(Try.scala:236)\n\tat mssparkutils.env$.extractField(env.scala:26)\n\tat mssparkutils.env$.getUserName(env.scala:44)\n\tat mssparkutils.env.getUserName(env.scala)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)\n\tat py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)\n\tat py4j.Gateway.invoke(Gateway.java:282)\n\tat py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)\n\tat py4j.commands.CallCommand.execute(CallCommand.java:79)\n\tat py4j.GatewayConnection.run(GatewayConnection.java:238)\n\tat java.lang.Thread.run(Thread.java:748)\n\n",
"failureType": "UserError",
"target": "<notebook>",
"details": []
}
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
![](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(172.8, 45%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
We got these errors when we try to write the csv but usually it works fine in notebook directly when we run it.But using same notebook in pipeline breaks the pipeline.
![](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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
That is because the function getUserName looks for the name of a user, but a pipeline is not a user, and thus doesn't have a name. A pipeline might be started by a program, and as such, getting the user who started a pipeline does not fufill the requirements.
Although a pipeline does not have a user name, it does get assigned an id, and that is why getUserId works.
I found out this was expected behavior and can be leveraged to determine whether a pipelien or a user started the job.
Hello @CheuEngYeow-5385 and welcome to Microsoft Q&A. Thank you for bringing this issue to our attention.
I have reproduced the error, and will report it to the product group.
I also tried doing a triggered run and got the same error.
I do not believe you are doing anything wrong. I suspect the cause is on the Synapse side.
Update: I tried with getUserID() instead of getUserName() . This worked.
Then I took a closer look at the ID's and compared when I run directly from the notebook to running from a pipeline. I found the details to be different.
This tells me, that when you run directly from the notebook, it is running under your authority. When run from a pipeline, it is run under the pipeline's authority on your behalf.
Given that user ID was returned when user name was not, I speculate the cause is the pipeline not having a user name.
![](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(249.60000000000002, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
how do you fix this error? I am getting the same one