I need to copy over feature classes from another entities SDE. The user account I am using is allowed to see feature classes, but not the related tables. Therefore most methods are out for copying data.
What I am doing is writing a script to copy over the data into a file geodatabase. What i am running into is:
"WARNING: Failed to convert: {insert feature class here} ERROR 999999: Error executing function. Insufficient permissions {insert feature class's related table(s)}.
WARNING: Failed to convert: Database Connections\Utilities.sde\Utilities.GIS.ElectricUtility\Utilities.GIS.Switchgear. ERROR 999999: Error executing function.
Insufficient permissions [Insufficient permissions[Utilities.GIS.UndergroundDistributionInspection]]
Failed to execute (CopyFeatures).
It fails then to bring over that feature class with a related table into the file geodatabase. Is there a way around the permissions issue?
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Database Connections\Utilities.sde\Utilities.GIS.ElectricUtility"</SPAN>
muE <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN>feature_type<SPAN class="operator token">=</SPAN><SPAN class="string token">'point'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>muE<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> muEFS <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN>feature_type<SPAN class="operator token">=</SPAN><SPAN class="string token">'point'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>FeatureClassToGeodatabase_conversion<SPAN class="punctuation token">(</SPAN>muEFS<SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">"Z:\MXDs\Services\Utilities_EF.gdb"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="keyword token">pass</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>