JLuymes

Error using select and copyfeatures from SDE to personal geodatabase

Discussion created by JLuymes on Aug 29, 2012
Latest reply on Aug 29, 2012 by clthompson
Hi,

I get the following error message:

<class 'arcgisscripting.ExecuteError'>: ERROR 000210: Cannot create output WAT_ControlValve
Failed to execute (Select)

The same thing happens when I try using copy features.

I'm trying to copy a selection from the SDE to a new personal geodatabase I created if there is a selection. I didn't include all the code but wtrue is a list of layers I want to check to copy over. I have checked and the script correctly creates the pgdb.

Is this a projection issue or some other environment setting problem?

if extype == "Personal Geodatabase":
    try:
        gp.CreatePersonalGDB(outfolder,gdbname)
    except:
        pass
    gp.WorkSpace = outfolder + os.sep + gdbname
    gp.addmessage(gp.Workspace)
elif extype == "Shapefiles":
    gp.Workspace = outfolder

for layer in wtrue:
    gp.makefeaturelayer(layer,"layer")
    selcount = int(gp.GetCount_management("layer").getoutput(0))
    totcount = int(gp.GetCount_management(gp.describe("layer").catalogpath).getoutput(0))
    if totcount <> selcount:
        gp.addmessage(layer + " has " + str(selcount) + " features selected")
        gp.select("layer",layer)
    else:
        gp.addmessage(layer + " has no selection")

Outcomes