Latest Contributions by Kathleen_Crombez

This continues to be an issue for us. We have several scripts that have been written over the years that we either have set to run on scheduled tasks or we run annually during different times of the year. Most of these scripts now fail at version 10.3.1 due to this error. ERROR 000358: Invalid expression This error is occurring on both the MakeTableView and MakeFeatureLayer methods. All of our tables and layers have OBJECTID fields. I really hope that someone from ESRI can track the error down and fix it soon. We have already upgraded all our desktop machines to 10.3.1 and are hoping to upgrade our servers in a couple months. But this issue is going to leave us dead in the water if it isn't fixed. ... View more

The way you are declaring the checkbox, it looks like it is a dojo checkbox and would more than likely need to be access with Ken Buja solution. dijit.byId("slrbxC").set("checked", false); ... View more

Thanks for taking the time to try to figure it out. ... View more

The machine running 10.2.2 has Windows Server 2008 R2 Enterprise 64-bit OS. (Virtual) The python shell launches as Python 2.7.5 (default, May 15 2013, 22:43:36) [MSC v.1500 32 bit (Intel)] on win32 The machine running 10.3.1 has Windows 7 Professional 64-bit OS. The python shell launches as Python 2.7.8 (default, Jun 30 2014, 16:03:49) [MSC v.1500 32 bit (Intel)] on win32 I'm not certain how to test for background processing. Both machine were set up with the standard install. The script was written on the Windows 7 machine before upgrading from 10.2.2 to 10.3.1 The Summary_CondoPin table is in a file geodatabase located on a Windows Server 2012 R2 Standard 64-bit OS. print """{} > 1 AND {} IS NULL""".format(arcpy.AddFieldDelimiters(Summary_CondoPin, 'FREQUENCY'), arcpy.AddFieldDelimiters(Summary_CondoPin, 'Comment')) Returned FREQUENCY > 1 AND Comment IS NULL Using the syntax you provided me for the MakeTableView failed with the same error. Traceback (most recent call last):   File "X:\ParcelFeaturesQC\ParcelFeaturesQC.py", line 676, in <module>     startArcSDE(True)   File "X:\ParcelFeaturesQC\ParcelFeaturesQC.py", line 619, in startArcSDE     QC.runCondoPinCheck()   File "X:\ParcelFeaturesQC\ParcelFeaturesQC.py", line 519, in runCondoPinCheck     arcpy.MakeTableView_management(Summary_CondoPin,'Frequency_CondoPin', """{} > 1 AND {} IS NULL""".format(arcpy.AddFieldDelimiters(Summary_CondoPin, 'FREQUENCY'), arcpy.AddFieldDelimiters(Summary_CondoPin, 'Comment')))   File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\management.py", line 7047, in MakeTableView     raise e ExecuteError: ERROR 000358: Invalid expression Failed to execute (MakeTableView). ... View more

Joshua Bixby​, It is strange, because I have other MakeTableView statements with a where clause that run before this one and they all run fine. This is the line that throws the error in 10.3 Here is the error Here are the field properties of the Summary_CondoPin table One thing I did notice about the Summary_CondoPin table is the where clause returns zero records. So maybe that has something to do with the error. But as I mentioned before, this line runs fine without error in 10.2 ... View more

Sounds like a bug was introduced at 10.3 Can anyone at Esri Technical Support​ comment on this issue??? ... View more

I have run into the same error using the arcpy.MakeTableView_management function on a feature class that HAS and OBJECTID field. I am also using a where clause in the function. The script runs perfectly in 10.2 but fails on this function in 10.3 ... View more

Can anyone from ESRI comment on this? This is a serious show stopper for automating tasks! ... View more

The dialog box is prompting for SDE connection credentials. So far the old map documents I have been testing are so old (2005) that ArcGIS Server did not even exist yet. I manually opened one of the trouble documents and the issue is a secured layer that does not have the login credentials saved. ... View more

I am having the same problem. Did you ever find a work around? ... View more

This does not seem to work... I am using CreateDatabaseConnection_management instead of CreateArcSDEConnectionFile_management because I want to make a direct connection to SQL Server instead of an application connection. But it is NOT suppressing the dialog box. The script pauses and will not continue until I click cancel or close the dialog box. Here is my code.... sde = arcpy.CreateDatabaseConnection_management("foldername", "filename", "SQL_SERVER", "servername", "DATABASE_AUTH", "username", "password", "SAVE_USERNAME", "database", "#", "TRANSACTIONAL", "sde.DEFAULT") mxd = arcpy.mapping.MapDocument("path to mxd") Seems like arcpy.mapping.MapDocument should be rewritten to accept login credential parameters. ... View more

I am not able to use tabindex to set focus on the map. Has anyone been able to get this to work? I would really like to see a working example if it can be done. No matter what I tried, the map navigation keyboard shortcuts only seems to work when the mouse is hovering over the map. My work around solution was to set the map slider to false and create my own custom zoom and pan buttons. ... View more