Currently I am writing a python script that creates a feature layer from our parcel fabric and then appends that data into a different SDE feature class. The problem is that when executing arcpy.MakeFeatureLayer the 000732 error is returned; dataset does not exist or is not supported. I know the path to the fabric data is valid. The fabric data can be accessed manually using that connection without trouble. I also have a model for this type of process that uses the Make Feature Layer tool and uses the same SDE connection file which works without trouble. I have found an abundance of information about this error online, but none of the suggested fixes seem to resolve my issue.
The code I am using is as follows:
import arcpy parcels = r"\\networkMachineName\folder\projects\lgim\fabric.sde\fabric.DBO.ParcelEditing\fabric.DBO.ParcelFabric\fabric.DBO.ParcelFabric_Parcels" layer = "parcelLyr" whereClause = "SystemEndDate is null and Type = 7" arcpy.MakeFeatureLayer_management(parcels, layer, whereClause, "", "")
The parcel data from the fabric that is being input to the tool does not have any subtypes.
In the same network drive location I have other SDE connection files to different SDE geodatabases on the same server. These connection files have been used as inputs to arcpy.MakeFeatureLayer using the same raw string convention with no trouble. I only receive the 000732 error from the fabric SDE connection. The only difference that I can see between the connections is that the other SDE geodatabases are SDE owner, but the fabric SDE geodatabase is DBO owner. All of the connection files reference a user with full select, insert, update, delete privileges.
The ParcelEditing dataset is registered as versioned.
The error occurs in stand alone python script and in the ArcMap interactive python window.
When the model is first opened from ArcToolbox, the path to the fabric data shows the same error, but if the user browses to the data again the error is resolved and the model executes successfully.
Because the parcel fabric is a somewhat complex data type, I also attempted to execute arcpy.MakeParcelFabricLayer using the same connection file, but it failed with the same 000732 error.
We are using ArcGIS 10.2.2 for desktop, geodatabases, and fabric. The RDBMS is SQL Server 2012.
I feel like this should be a straightforward task in python, but cannot figure out what is going wrong for some reason. I am hoping that someone here can point me in the right direction.