ArcPro 2.7 failing to execute sdf.spatial.to_featureclass()

[Mungakha]

Describe the bug
Have been using ArcPro 2.6 to download feature layer from ArcGIS Online, write the resulting spatially enabled dataframe into a geodatabase on local disc to resource multiple business processes. I updated to ArcPro 2.7 and the process now returns the following error ValueError: invalid JSON data. I reinstated 2.6.2 and now it works ok

To Reproduce
Steps to reproduce the behavior:

from arcgis.gis import GIS
import arcgis
from arcgis import features
from arcgis.geoanalytics import manage_data
from arcgis.features.manage_data import overlay_layers
from arcgis.features import GeoAccessor, GeoSeriesAccessor, FeatureLayer
import arcpy
import sys, os
import pandas as pd
import datetime as dt
from arcgis.features import FeatureLayerCollection
import http.client
import mimetypes
import json
import requests
from pandas import json_normalize
from arcgis import geometry 
from copy import deepcopy
from arcgis.features.manage_data import dissolve_boundaries


gis = GIS("url.maps.arcgis.com", "UserName", "Password)

item=gis.content.get('Feature_Layer Portal ID')
l=item.layers[0] 
df=l.query().sdf

#Create Temporary Geodatabase

if arcpy.Exists(r"C:\Centroid"):
   arcpy.Delete_management(r"C:\Centroid")
arcpy.CreateFolder_management(r"C:", "Centroid")

if arcpy.Exists(r"C:\Centroid"):
   arcpy.Delete_management(r"C:\Centroid\Centroid")
arcpy.CreateFolder_management(r"C:\Centroid", "Centroid")

arcpy.CreateFolder_management(r"C:","Centroid")
if arcpy.Exists(r"C:\Centroid\Centroid\KCentroids.gdb"):
   arcpy.Delete_management(r"C:\Centroid\Centroid\KCentroids.gdb")

arcpy.CreateFileGDB_management(r"C:\Centroid\Centroid","KCentroids")

#Write spatially enabled dataframe to disk

df.spatial.to_featureclass('C:\Centroid\Centroid\KCentroids.gdb\jana')

error:

ValueError: invalid JSON data

Screenshots
If applicable, add screenshots to help explain your problem.

Expected behavior
A clear and concise description of what you expected to happen.

Platform (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Python API Version [e.g. 1.6.2] (you can get this by typing print(arcgis.__version__)

Additional context
Add any other context about the problem here, attachments etc.

[priyankatuteja]

I tried to reproduce this issue.
Screenshot below shows the same code run using ArcGIS Pro's Python command prompt (Version 2.6):

The same code is run using ArcGIS Pro (2.6) embedded notebook:

As mentioned, then I uninstalled Pro 2.6
Screenshot below shows version of Pro uninstalled:

Reinstalled Pro 2.7:

Notebook server launched using Python command prompt (Version 2.7):

The same code is run using ArcGIS Pro (2.7) embedded notebook:

[priyankatuteja]

@Mungakha Can you try the code mentioned below and see if you still get some error:

from arcgis.gis import GIS
import arcgis
from arcgis import features
from arcgis.geoanalytics import manage_data
from arcgis.features.manage_data import overlay_layers
from arcgis.features import GeoAccessor, GeoSeriesAccessor, FeatureLayer
import arcpy
import sys, os
import pandas as pd
import datetime as dt
from arcgis.features import FeatureLayerCollection
import http.client
import mimetypes
import json
import requests
from pandas import json_normalize
from arcgis import geometry 
from copy import deepcopy
from arcgis.features.manage_data import dissolve_boundaries
gis = GIS("https://geosaurus.maps.arcgis.com", "arcgis_python", "P@ssword123")

item=gis.content.get('e1979a2137ca427690b2240262a84a5b')
item
l=item.layers[0] 
df=l.query().sdf
if arcpy.Exists(r"C:\Centroid"):
   arcpy.Delete_management(r"C:\Centroid")
arcpy.CreateFolder_management(r"C:", "Centroid")

if arcpy.Exists(r"C:\Centroid"):
   arcpy.Delete_management(r"C:\Centroid\Centroid")
arcpy.CreateFolder_management(r"C:\Centroid", "Centroid")

arcpy.CreateFolder_management(r"C:","Centroid")
if arcpy.Exists(r"C:\Centroid\Centroid\KCentroids.gdb"):
   arcpy.Delete_management(r"C:\Centroid\Centroid\KCentroids.gdb")

arcpy.CreateFileGDB_management(r"C:\Centroid\Centroid","KCentroids")

#Write spatially enabled dataframe to disk

df.spatial.to_featureclass('C:\Centroid\Centroid\KCentroids.gdb\jana')

If so, please open close any already open Python command prompts and close ArcGIS Pro as well Then uninstall and reinstall pro 2.7. After that try running the code mentioned above.

[Mungakha]

@priyankatuteja Trying with a ArcPro 2.7 downloaded from MyEsri on 21/12/2020 and installed on two different computers; my pc and a Virtual Machine in Azure, the error replicated itself on both machines

Like I did on on 21/12/2020, I have uninstalled, downloaded ArcPro 2.7 , cloned a new environment and run the code and I ran into the same issue.

However, when I install ArcPro 2.6, clone a new environment the notebook does run well on both the pc and Virtual Machine.

I also made attempts to avoid writing to disc and write back to portal using ArcGIS API for Python as detailed in this code. This too worked.

Interested in understanding why 2.7 fails to write to disc but 2.6 does.

[Mungakha]

This was resolved by patch 2.7.1