ArcMap 10.3 python code won't run in 10.4

Tonyalmeida

So i update from 10.3.1 to 10.4.1 Because i got a new PC and i am updating some scripts and addin buttons.  I have an addin button that updates points( personal SQL express database) based off of taxparcels. In 10.3.1 the addin works fine but now in 10.4.1 i am having issues. The only thing i changed was the name of the new workspace, the layer name stated the same. Not sure what's going on. Anyone have any ideas why it's not working in 10.4..1

Add-in Code:

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Database Servers\DSDGIS7WTALM_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)"</SPAN>&nbsp; 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ptSelection <SPAN class="operator token">=</SPAN> <SPAN class="string token">"TonyTwoWay.DBO.CCAP"</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pointLayer <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">+</SPAN> os<SPAN class="punctuation token">.</SPAN>sep <SPAN class="operator token">+</SPAN> <SPAN class="string token">"TonyTwoWay.DBO.CCAP"</SPAN> #target point feature <SPAN class="keyword token">class</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token class-name">parcel</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"TaxParcels1"</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parcel_lyr <SPAN class="operator token">=</SPAN> <SPAN class="string token">'In_memory\parcel_lyr'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sjpoints <SPAN class="operator token">=</SPAN> <SPAN class="string token">"In_memory\sjpoints"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; poly <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ACCOUNT_1"</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pnt <SPAN class="operator token">=</SPAN>&nbsp; <SPAN class="string token">"Account"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ptCount <SPAN class="operator token">=</SPAN> <SPAN class="token function">int</SPAN><SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetCount_management</SPAN><SPAN class="punctuation token">(</SPAN>pointLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getOutput</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; <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>

Error: I think it has to do with this line 4 "pointLayer = arcpy.env.workspace + os.sep + "TonyTwoWay.DBO.CCAP""

Traceback (most recent call last):
  File "C:\Users\talmeida\AppData\Local\ESRI\Desktop10.4\AssemblyCache\{473AD3F3-86EE-417D-A6A9-13DFBB4B2150}\AddinToolsButtons_addin.py", line 295, in onClick
    ptCount = int(arcpy.GetCount_management(pointLayer).getOutput(0))
  File "c:\program files (x86)\arcgis\desktop10.4\arcpy\arcpy\management.py", line 15779, in GetCount
    raise e
ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000732: Input Rows: Dataset Database Servers\DSDGIS7WTALM_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP does not exist or is not supported
Failed to execute (GetCount).
‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Tonyalmeida

After a days long of search i found a thread that indicated "Database Server connection to a SDE database using SQLexpress is not appropriate for editing data, only for administering it (i.e. permissions, etc.) You must connect to the same database using the Database Connections node in ArcGIS, and use that connection for editing purposes, using the appropriate Database Connection as the output workspace."

So i created a Database Servers node in the Catalog to the sql express data base in ArcCatalog.

I changed this line:

'arcpy.env.workspace = r"Database Servers\DSDGIS7WTALM_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)"'

</CODE></SPAN></P><P><SPAN style="font-size: 15px;"><CODE>To

arcpy.env.workspace = r"Database Connections\Connection to DSDGIS7WTALM_sqlexpress.sde"

</CODE></SPAN></P><P><SPAN style="font-size: 15px;"><CODE>After adding/change&nbsp; the connection i was able to get the addin to work. Not why i doesn't work in 10.4.1 but it worked fine in 10.3.1, maybe it's just me.<BR />

</CODE></SPAN></P><P><SPAN style="font-size: 15px;"><CODE>Resource.

<A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/database-servers/connections-database-servers.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/database-servers/connections-database-servers.htm" rel="nofollow noopener noreferrer">Database server connections—Help | ArcGIS for Desktop</A>&nbsp;