topic ERROR 000732 View does not exist or unsupported after 10.3 upgrade in Python Questions

ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Fri, 17 Apr 2015 15:38:16 GMT

We have a few models that update a point and polygon feature class in our DB a few times a day using a view into our projects DB. We have exported this to py and made a small change "arcpy.env.overwriteOutput = True" and set to run using windows task manager. All good until we moved our beta to 10.3 earlier this week. I realized after a few days that the script was failing in task manager.

I ran the script in Idle to see if I could trace the problem. Viola... this is what we see.

ExecuteError: Failed to execute. Parameters are not valid.

ERROR 000732: XY Table: Dataset Database Connections\inserrtservername.sde\EBISDE.dbo.project_tel_new_vw does not exist or is not supported

Failed to execute (MakeXYEventLayer).

The view works. I return records when I view in SSMS and Catalog. The model works, and writes new features to the features in the DB. I even deleted my DB connection in catalog, made a new one. Opened the models and re-pointed the GP tools to the view and features hoping this would clear up any mis-matched connection names etc. and export to python.

What happened at 10.3 that python is unable to make the DB connection? Seems straight forward, but I'm stumped.

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

JoshuaBixby — Fri, 17 Apr 2015 16:38:07 GMT

You had this exact workflow working on this exact machine using an earlier version? What version?

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

MichaelVolz — Fri, 17 Apr 2015 16:41:00 GMT

Collin:

You might need to provide the full path to the database connection, if you are not already doing so.

Are you running this script on a Windows Server? If so, is the new server the same version as the old server?

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Fri, 17 Apr 2015 17:21:21 GMT

I've been digging. IT made a change in that they moved this virtual server to a new physical machine. Is that possibly in play? All variables including the SQL are located on this machine so I can't imagine it is?

Otherwise, yes same workflow. Only real change was we went from 10.1 SP1 to 10.3 where I suspect the problem is.

Full connection path:

ERROR 000732: XY Table: Dataset Database Connections\washout.sde\EBISDE.dbo.project_tel_new_vw does not exist or is not supported

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Mon, 20 Apr 2015 12:06:53 GMT

Yes, this script is being utilized from a Windows Server 2008r2 standard SP 1. Both before the physical move and afterwards. Nothing in the Virtual env. has changed.

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

SamuelTompsett — Mon, 20 Apr 2015 13:33:27 GMT

Can you please post the script? It would be easier for people to look at it directly.

Thanks.

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Mon, 20 Apr 2015 14:02:36 GMT

Whoops, sorry, that would be helpful. I have attached a zip to this entry that contains a script that is now failing in what looks to be the connection to the DB. Thanks in advance!

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

SamuelTompsett — Mon, 20 Apr 2015 14:06:31 GMT

Hello Collin,

Thanks for posting the script.

Have you tried giving the full path to the database connections? Especially for the input view?

Thanks,

Sam

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Mon, 20 Apr 2015 14:16:48 GMT

HI Sam,

No I have not tried that approach yet. I haven't done much yet, wanted to wait on what the community thought before I started anything new other than re-exporting from 10.3. I will look into your suggestion and report back later.

Thank you !!

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Mon, 20 Apr 2015 19:22:06 GMT

This was the solution. Thank you Sam.

Any ideas if this change is due to 10.3? I'd like to get a better understanding of the underlying cause.

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

MichaelVolz — Mon, 20 Apr 2015 19:25:16 GMT

What is the correct syntax for the database connection in v10.3?

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Mon, 20 Apr 2015 19:39:46 GMT

from this string. Database Connections\washout.sde\EBISDE.dbo.project_tel_new_vw

I replaced

Database Connections\\

with

C:\\Users\\username\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\

I did the same for all the features being used by this model as well. It's successful

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

TiffanySelvidge1 — Fri, 29 Jan 2016 16:48:57 GMT

Thank you very much for posting this. I was going out of my mind trying to figure out why python but not modelbuilder had a problem with my geocoder input sql table and composite locator parameters.

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

BugPie — Fri, 29 Jan 2016 17:11:52 GMT

Tiffany, sounds like you had the same experience as myself trying to figure this out. Misery loves company, so thank YOU, I feel better now!

Re: ERROR 000732 View does not exist or unsupported after 10.3 upgrade

TiffanySelvidge1 — Fri, 29 Jan 2016 17:48:53 GMT

You are welcome.

Unfortunately now that my parameters are accepted, and my overwrite code is accepted, python has decided it just will not geocode. Keep getting a generic failed to execute geocode error. Let the additional misery commence.