Latest Contributions by AhmadSALEH1

‎01-22-2018

I have upgraded to 10.6 and it seems there is a connectivity issue when trying to connect to SQL server.

‎01-22-2018

Thank you Asrujit, I will reach them out today.

‎01-19-2018

I can summarize the issue with the following picture: For The Same Database "CL" when I login using OS authentication I cannot view the data, while if I login using the DB authentication I can view it !. Everything was working fine before upgrading form 10.5.0 to 10.6.0. I used another machine that runs 10.5.0 with the same login info and it worked fine just to eliminate any permissions or privileges change issue. I assumed that the issue from my machine so I went further and a upgraded a new machine but unfortunately I had the same issue !. The same issue happen with me with I upgraded form 10.5.0 to 10.5.1 and here is the link for the post Features inside the Enterprise Geodatabase not showing after upgrading to ArcGIS 10.5.1 Asrujit SenGupta provided the following links ArcGIS 10.5.1 & ArcGIS Pro 2 bug connecting to sql server ? ArcGIS 10.5.1 (Desktop, Engine, Server) SQL Server Permissions Patch it seems that was a bug in 10.5.1 so installed the patch but it didnt solve the issue so I downgraded!. Did anyone noticed the same behavior?

‎01-12-2018

Your right, but the issue is that Preserve Global ID works only in ArcGIS Pro. What do you think?

‎01-12-2018

Hi Jamal, Mainly the Tool is using "Copy features (data management)" . So I tried to Copy any F.C using Copy Features tool and it failed to move the GlobleID's too, it seems to be that there is a limitation from ESRI (FAQ: Which data loading scenarios will preserve Global ID values? ) But the good news is that the tool "Copy (data management)" can move the GlobleID's so give it a try and let me know the results then I can edit the Tool and send it back. Thanks

Re: User defined select query widget · ‎01-05-2018

I dont agree, I think its important for every user to define his own query. Thanks

‎12-06-2017

After re-projecting the data, we had to recalculate the spatial index of each feature class in the database. this solves the performance issue.

‎12-06-2017

Randy, After you compress your database and before going to SQL server to view the business table, Try to disconnect the database from the ArcCatalog (By right click on the DB and select Disconnect), then try to open the business table and see what happens.

‎12-01-2017

Try to use an admin user with Database Authentication not OS Authentication, it might work with you.

‎11-30-2017

Hi Jamal, I am attaching a tool that I wrote which iterates in a folder were the sde connection files are saved then copies the data to a new Geodatabase. its working fine with me, make sure that every database connection has its own unique name to avoid overwriting the geodatabase.

‎11-28-2017

Thanks Rebecca, This was helpful. Here below how the script looks now. import arcpy, sys, os inFolder=r'C:\1\test' outFolder=r'C:\1\test2' print "Connecting to geodatabase" arcpy.env.workspace=inFolder arcpy.env.overwriteOutput=True Workspace=arcpy.ListWorkspaces("*","SDE") for DBConn in Workspace: print DBConn‍‍‍‍‍‍‍‍‍‍‍

‎11-28-2017

Hi Alla, What is the error message that you got? I see that you didn't define a value for the location of the Log file variable (Reconcile_Versions_Log_2 = """) it should be something like Reconcile_Versions_Log_2_ ="D:/Db/myLog.txt"

‎11-22-2017

Hi, I am trying to get a list of database connections stored in the folder, the script runs successfully but it gives wrong results! For example, "inFolder=r'C:\1\test'" has only one database connection which is u'C:\\1\\test\\Urbab.sde', but when I run the script it displays it 9 times every time! I tried to run the script from the python window in the ArcMap and I also used PyScripter and both of them gives the same result. import arcpy, sys, os inFolder=r'C:\1\test' outFolder=r'C:\1\test2' print "Connecting to geodatabase" arcpy.env.workspace=inFolder arcpy.env.overwriteOutput=True for DBConn in inFolder: x=arcpy.ListWorkspaces("*","SDE") print x ‍‍‍‍‍‍‍‍‍‍‍ What might be the issue here? Thanks, Ahmad

‎11-22-2017

Hi Alla, I see that you have draged "U.sde" form "Database Connections" category then doped it in your model, is that right? If you did this The model will work fine but when you export it as a script and run it form windows it will not work. the solution will be by saving your SDE connection to a local folder and drag it to your model then export as python.

‎10-20-2017

Hello, Is there any method to export the map layers in the WAB to KMZ other than using the Extract Data tool in the Analysis widget? I am trying to figure out a method that lets me export my map to KMZ file but not using the “Extract Data” esri out of the box tool. The reason on this: 1- The Extract tool doesn’t work with any feature layer, the layer should be a hosted feature layer. In my case I want to export features from a service hosted in my ArcGIS server. 2- I want this tool to be available for all of my app users regardless the permissions/ levels. I am thinking of using a geoprocessing service that uses the “Map to KML” tool in the arcmap, but the main issue it that this tool takes an MXD as an input and I think it will not work on the app builder. Thanks a lot,

Online Status	Offline
Date Last Visited	‎05-27-2024 05:35 PM

My Ideas

Latest Contributions by AhmadSALEH1

Re: Issues addressed Version 10.6

Re: ArcGIS 10.6.0 - Connecting to SQL Server with OS authentication issue !

ArcGIS 10.6.0 - Connecting to SQL Server with OS authentication issue !

Re: A generic tool to convert multiple mdf files to gdb,

Re: A generic tool to convert multiple mdf files to gdb,

Re: User defined select query widget

Re: Changing the projection for the data set causes a database performance issue

Re: Why does it take deleting a version to move some records from the A and D table to the business table

Re: arcpy.DisconnectUser non-administrator user

Re: A generic tool to convert multiple mdf files to gdb,

Re: Arcpy.ListWorkspaces returns wrong results

Re: The exported python of a model is not running

Arcpy.ListWorkspaces returns wrong results

Re: The exported python of a model is not running

Export map layers to KMZ - not using the Extract Data tool in the Analysis widget

Re: Change the service link when using "store cred...

Change the service link when using "store credenti...

Re: Underlying DBMS errorFail to enable database o...

Re: Azure Active Directory integration with ArcGIS...

How to call an SQL Server stored procedure from Ar...