Skip to main content
Solved

Geodatabase lock error when uploading to Google Drive

  • November 21, 2020
  • 2 replies
  • 40 views

damian6105
Participant
Forum|alt.badge.img

I'm trying to export feature layers from ArcGIS Online to Geodatabase, then upload the Geodatabase to Google Drive. I'm using a 'Choice with Alias (multiple)' user parameter to select and export one or more feature layers. If I select one feature layer my FME script works fine. If I select more than one layer then I get a geodatabase lock error while uploading the Geodatabase to Google Drive. This is the error message:

 

PermissionError: [Errno 13] Permission denied: 'C:\\\\MyDirectory\\\\MyGeodatabase.gdb\\\\_gdb.JD2344.18360.9116.sr.lock'

Error encountered while calling method `input'

GoogleDrive_Geo_CALLER (PythonFactory): PythonFactory failed to process feature

 

I'm hoping someone can suggest a solution. My FME script is attached.

Regards, Damian

Best answer by hkingsbury

The .lock file indicates that the GDB is open. Could you try putting a featureHolder or Decelerator after your featureWriter to ensure that FME has fully completed writing to the GDB.

 

Also if you have any other applications/processes accessing the GDB you will need to close these.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+65
  • Celebrity
  • Best Answer
  • November 22, 2020

The .lock file indicates that the GDB is open. Could you try putting a featureHolder or Decelerator after your featureWriter to ensure that FME has fully completed writing to the GDB.

 

Also if you have any other applications/processes accessing the GDB you will need to close these.


damian6105
Participant
Forum|alt.badge.img
  • Author
  • Participant
  • November 24, 2020

Thank you for your suggestions @hkingsbury​ , greatly appreciated. I tried the Featureholder but unfortunately I still got the same error. However the Decelerator did work. I guess the only issue is that I sometimes run the script on up to 80 feature layers, which means I have to set a very long delay time for the Decelerator (2 hours maybe). So if I'm only running a couple of feature layers, I still have to wait all that time for the script to run - unless I calculate a clever variable for the delay time.

Regards, Damian