Export to fGDB fails

3769
3
06-09-2015 05:52 AM
PaulaBond
New Contributor

Good morning.  I am having trouble exporting a feature layer to a fGDB and am hoping someone may have some suggestions.  The feature layer is pretty large - there are around 500 points with a photo for each point.  I am able to export the layer to a CSV file without any problems, but I need to export it to a fGDB because of the photos.  When I run the export, after a few minutes it will fail and give me an error message that says: "Error updating file item".  The failed export produces an incomplete fGDB that is around 800-900mb.  Does anyone have any suggestions for completing the export?

Thank you

0 Kudos
3 Replies
JakeSkinner
Esri Esteemed Contributor

Hi Paula,

You can try using the ArcREST python package to do this.  Here are the steps:

1.  Download the python package as a zip and extract

2.  Copy the 'arcrest' folder to your C:\Python27\ArcGIS10.x\Lib\site-packages directory

3.  You can then use the following sample.  You will just need to update the username, password, url, and the layers.  Ex:

from arcrest.security import AGOLTokenSecurityHandler
from arcrest.agol import FeatureService
from arcrest.common.filters import LayerDefinitionFilter

if __name__ == "__main__":
    username = "jskinner"
    password = "esri"
    url = "http://services.arcgis.com/Fz6BBJUji5ArUSDM/arcgis/rest/services/Damage_Assessment_Residential/Featu..."
    proxy_port = None
    proxy_url = None
    agolSH = AGOLTokenSecurityHandler(username=username,
                                      password=password)
    fs = FeatureService(
        url=url,
        securityHandler=agolSH,
        proxy_port=proxy_port,
        proxy_url=proxy_url,
        initialize=True)
    result = fs.createReplica(replicaName='Demo', layers='0', keep_replica=False, 
                              layerQueries=None, 
                              geometryFilter=None, 
                              returnAttachments=True, 
                              returnAttachmentDatabyURL=False, 
                              returnAsFeatureClass=True, 
                              out_path='C:\\temp')

    print result

The output will be written to your C:\temp directory.

MiguelParedes
Esri Contributor

Greetings Jake,

I am having the same issue as Paula.  However, I have noticed that the issue is intermittent. I am also working on downloading a Feature service that contains attachments. Basically, the FS supports a Collector implementation, so it can have multiple images per point feature.

I have been able to download the Feature service twice in the past (before the July update).  The resulting FGDB was shy of 2GB.  Today I have tried again, twice, and both occasions I did get the same error message as Paula, "Error updating file item".  This happened roughly about 10 minutes after starting the Export process.

Could this issue be related to the number of credits remaining?  Unfortunately, I am only a Publisher in the organisation I am attempting to download the data from, so do not know how many credits remain.  But surely this should not have any bearing since I do believe  that there is no charge for exporting to FGDB.

Anyway, I will try the script and see how I get on, and report my findings.

Miguel
0 Kudos
TrilliumLevine1
Occasional Contributor

Hi Jake,

Thanks for posting this.  I just have a quick question about the proxy Information, I'm having problems with that part.  I have another python script that I've been testing that uses urllib2 proxy handlers, with the following Information:

opener = urllib2.build_opener(
        urllib2.HTTPHandler(),
        urllib2.HTTPSHandler(),
        urllib2.ProxyHandler(
            {'https': 'http://user:Password@ipAddress:8080',
            'http': 'http://user:Password@ipAddress:8080'}
    ))

What information and syntax do I need to enter for the proxy_port and proxy_url variables in the code you posted?  I've tried a few variations and nothing seems to work.  Please let me know if you have a minute.  Thanks!

Trill

0 Kudos