Latest Contributions by TaraDeRosa

‎08-29-2018

Touché! And yes I will be rewriting in Python obviously but will be on leave from work beginning in a couple of weeks and simply do not have the time to. Will make for a fun project when I return:)

‎08-29-2018

This is an old article however I recently ran into this issue and wanted to post a workaround. In lieu of rewriting code in Python, I was able to change my Python scripts to continue to run in 32-bit mode. Per https://community.esri.com/thread/171670, you can get a python script to run as 32-bit by following the below steps: 1. Right-click on your script in Windows Explorer > Open With > Choose Default Program 2. Browse to the python.exe file located under the 32-bit installation (i.e. C:\Python27\ArcGIS10.4\python.exe) 3. Check the option 'Always use the selected program to open this kind of file' The 32-bit IDLE can be found here if you are used to working in IDLE: C:\Python27\ArcGIS10.4\Lib\idlelib\idle.bat

‎12-07-2017

Hi Darryl. We are actually still battling this problem and have opened an ESRI support ticket. The arcpy.disconnectuser will work for several days and then unexpectedly fail with the same error as above. The script is run from a batch file using a windows-authenticated admin user and the python script references a sysadmin/processadmin SDE database connection. What we are working on now is granting the windows user SQL permissions so that the scheduled task and database connection run as the same user. We are testing that tonight to see if the scripts works successfully and will monitor for several days. I will report back our findings after that time.

‎11-02-2017

We are attempting to execute arcpy.DisconnectUser before running a nightly compression of a geodatabase. But when running arcpy.DisconnectUser, we are intermittently receiving an error stating that the connection information provided was for a non-administrative user. The geodatabase uses dbo-schema and we have confirmed that the geodatabase administrator is a member of the sysadmin and process admin server roles. Our SDE maintenance scripts fail periodically due to this issue similar to this post: https://community.esri.com/thread/180900. SDE is running v10.3.1 with a SQL Server 2012 back-end. The script runs from a batch file/scheduled task on a VM that has ArcGIS 10.4.1 installed.

Re: Disconnect user using arcpy Error · ‎11-02-2017

We are attempting to use arcpy.DisconnectUser before running a nightly compression of a geodatabase. But when running arcpy.DisconnectUser, we are intermittently receiving an error stating that the connection information provided was for a non-administrative user. The geodatabase uses dbo-schema and we have confirmed that the geodatabase administrator is a member of the sysadmin server role. Our SDE maintenance scripts fail periodically due to this issue similar to this post: https://community.esri.com/thread/180900. SDE is running v10.3.1 with a SQL Server 2012 back-end. The script runs from a VM that has ArcGIS 10.4.1 installed.

‎06-10-2015

Hi everyone. Wondering if any of you have experience integrating tabular data directly from SQL Server into ESRI maps for Sharepoint? At my organization there has been a shifting focus towards the “big data” movement and business intelligence. We are a Microsoft shop here, so we’ve already begun leveraging tools such as Excel, Sharepoint and SQL Server for our BI efforts internally. But we are lacking in the area of integrating maps with our SSRS reports. We would like for users to be able to create and share maps using data from SQL server (crime data from our police records management system is one example) and published ArcGIS services or shapefiles. Has anyone mastered this type of integration before without having the tabular data pre-staged in SharePoint lists? Or does ESRI Maps for Sharepoint only allow the mapping of data from existing SharePoint lists? Thanks!

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by TaraDeRosa

Re: VB script not working on 64 bit machine?

Re: VB script not working on 64 bit machine?

Re: arcpy.DisconnectUser non-administrator user

arcpy.DisconnectUser non-administrator user

Re: Disconnect user using arcpy Error

Integration of SQL server data (non SharePoint lists) with ESRI Maps for Sharepoint

Re: VB script not working on 64 bit machine?