POST
|
Also, something else they mentioned was installing SP2 for SQL2008R2 which included a MX hotfix for spatial indexing in SQL and then setting the traceflag to 4199. This also worked for us. It is included with SP2, else you have to install the Hotfix separately for previous versions. Below is the traceflag URL http://support.microsoft.com/kb/974006. In addition, here is the URL for the Microsoft Hot Fix (2008R2) http://support.microsoft.com/kb/2570501. Please feel free to email me separately for any questions. We have exhausted a lot of time trying to get to the bottom of this issue and have finally gotten to where we can function properly, although not optimally. Cheers, Michelle
... View more
03-24-2014
11:53 AM
|
0
|
0
|
481
|
POST
|
knoxgis & fsbusschers, if you have a test environment or some movement in your Production environment, 1) make all layers binary rather than geometry that participate in the geometric network 2) rebuild the networks, 3) begin editing. We saw a drastic improvement in editing with the geometry change. This was also confirmed by the ESRI consultant that was out here working with us. In addition, make sure no one is editing default (we never think folks are, but some do). That weighed in on the editing lag as well. However, the change in spatial storage type was the largest difference of all. ~Michelle
... View more
03-24-2014
09:30 AM
|
0
|
0
|
481
|
POST
|
So the overall answer to this ended up being the following (below) per an ESRI Incident I entered. I tested it and it works, however if you have numerous views to create and maintain on a regular basis, this is definitely NOT the best practice. In addition, ESRI does not fully support this process in that they do not support modifications on the back-end. Please keep in mind that this is for data stored in SDEBINARY. If your data is stored in the GEOMETRY type, you can use the DatabaseView tool in 10.1 to create a cross-database spatial view. 1. Import a copy of the SQL table in question into the ArcSDE database as the owner of the data. 2. Create a view on this table in the ArcSDE database using the following sde command syntax: sdetable -o create_view -T -t -c -w -i -s -D -u -p For example: sdetable -o create_view -T PLN_DEVELOP_FEE_AREAS_VIEW -t PLN_DEVELOP_FEE_AREAS,FFCIMPORT -c PLN_DEVELOP_FEE_AREAS.Shape,PLN_DEVELOP_FEE_AREAS.IDNumber,FFCIMPORT.IDNum,FFCIMPORT.ProjectNum,PLN_DEVELOP_FEE_AREAS.ObjectID -w "FFCImport.IDNumber=PLN_DEVELOP_FEE_AREAS.IDNum" -i sde:sqlserver:<server> -s <server> -D WATER 3. Grant the ArcSDE table and view owner permissions to the original non-ArcSDE database and table. 4. Edit the view design within SQL server to reference the original table stored in the non-ArcSDE database. 5. Drop the copied table within the ArcSDE database. The view should now be pointing to the original table located within the non-ArcSDE database. Verify all necessary permissions have been granted to the table within the non-ArcSDE database in order to see the contents of the view within ArcCatalog. Hope this helps some of you out there....... ~Michelle
... View more
01-30-2014
11:10 AM
|
0
|
0
|
910
|
POST
|
Nope. I just reran the query on a machine that still has ArcGIS Desktop 10.0 SP5 and ArcSDE 10.0 SP5. Ran the following query using two different databases (one spatial (WATER - SDE), one not (GIS_REPOSITORY_TABLES - non-spatial) and was able to create the spatial view. In addition, I can also create a spatial view using 10.1 SDE SP1 command line back to a 10.0 SDE database. I cannot use 10.0 SDE SP5 command line (or toolboxes) back to a 10.1 SDE database. O:\>sdetable -o create_view -T PLN_DEVELOP_FEE_AREAS_VIEW_2 -t wtr.PLN_DEVELOP_F EE_AREAS,GIS_Repository_Tables.dbo.FFCIMPORT -c wtr.PLN_DEVELOP_FEE_AREAS.Shape, wtr.PLN_DEVELOP_FEE_AREAS.IDNumber,GIS_Repository_Tables.dbo.FFCIMPORT.IDNum,GIS _Repository_Tables.dbo.FFCIMPORT.ProjectNum,wtr.PLN_DEVELOP_FEE_AREAS.ObjectID - w "wtr.PLN_DEVELOP_FEE_AREAS.IDNumber=GIS_Repository_Tables.dbo.FFCImport.IDNum" -i sde:sqlserver:GS005 -s GS005 -D WATER ArcSDE 10.0 for SQL Server Build 685 Fri May 14 12:05:43 2010 Attribute Administration Utility ----------------------------------------------------- Successfully created view PLN_DEVELOP_FEE_AREAS_VIEW_2.
... View more
01-17-2014
05:15 AM
|
0
|
0
|
910
|
POST
|
Esri hasn't supported cross-database queries in a long time. Your work-around is to make an empty table with same layout in the local database, join to that, and then edit the join. Be aware, though, that the cross-database performance cost will be daunting. - V Vince, is this a 10.1 limitation? Below is a spatial view from 10.0 SP5, SQL 2005 that works where the table is stored in a separate database from the feature class (TPW vs. CFWGIS).... SELECT sde.TRN_STREET_PMA.Shape, sde.TRN_STREET_PMA.OBJECTID, sde.TRN_STREET_PMA.SECT_NO, TPW.dbo.PMA_STREETS.Street_Name, TPW.dbo.PMA_STREETS.gis_dir AS Dir, TPW.dbo.PMA_STREETS.Divided AS Divided_Street, TPW.dbo.PMA_STREETS.Storm_Water_Needs, TPW.dbo.PMA_STREETS.Traffic_Lane FROM sde.TRN_STREET_PMA INNER JOIN TPW.dbo.PMA_STREETS ON sde.TRN_STREET_PMA.SECT_NO = TPW.dbo.PMA_STREETS.sect_no
... View more
01-16-2014
11:58 AM
|
0
|
0
|
910
|
POST
|
Currently I am running through some issues creating spatial views, and according to ESRI the only way to create them is with the sdetable -o create_view command. Reason being is that all of our data currently has to be in SDEBINARY due to a GEOMETRY storage type incompatibility with geometric networks and network datasets (ESRI proven with open-ticket). We rely on numerous views for a great number of applications within the City and I cannot imagine not being able to create those. In the case of deprecation of the command line SDE tools, has this issue been addressed at all?
... View more
01-16-2014
09:26 AM
|
2
|
0
|
691
|
POST
|
I am in the process of setting up our spatial views in ArcGIS 10.1 SP1, ArcSDE 10.1 SP1, SQLServer 2008R2. Due to some other geometric network issues, we have to have all of our data in SDEBINARY and cannot store it in Geometry at this time (currently this is non-negotiable). According to ESRI, in order to create a spatial view with SDEBINARY data you have to use the command line sdetable -o create_view. I am able to do this when both feature class and table are in the same database, same instance, but I need to be able to set up a spatial view where the feature class is in one database and the flat table is in another database, same instance. The correct syntax which created the view with one database (WATER)/two objects is: sdetable -o create_view -T PLN_DEVELOP_FEE_AREAS_VIEW -t PLN_DEVELOP_FEE_AREAS,FFCIMPORT -c PLN_DEVELOP_FEE_AREAS.Shape,PLN_DEVELOP_FEE_AREAS.IDNumber,FFCIMPORT.IDNum,FFCIMPORT.ProjectNum,PLN_DEVELOP_FEE_AREAS.ObjectID -w "IDNumber=IDNum" -i sde:sqlserver:SQL04V\GIS01 -s SQL04V\GIS01 -D WATER I thought I should be able to do the following with two databases (WATER & GIS_REPOSITORY_TABLES): sdetable -o create_view -T PLN_DEVELOP_FEE_AREAS_VIEW -t PLN_DEVELOP_FEE_AREAS,GIS_REPOSITORY_TABLES.DBO.FFCIMPORT -c PLN_DEVELOP_FEE_AREAS.Shape,PLN_DEVELOP_FEE_AREAS.IDNumber,GIS_REPOSITORY_TABLES.DBO.FFCIMPORT.IDNum,GIS_REPOSITORY_TABLES.DBO.FFCIMPORT.ProjectNum,PLN_DEVELOP_FEE_AREAS.ObjectID -w "IDNumber=GIS_REPOSITORY_TABLES.DBO.IDNum" -i sde:sqlserver:SQL04V\GIS01 -s SQL04V\GIS01 -D WATER or sdetable -o create_view -T PLN_DEVELOP_FEE_AREAS_VIEW -t WATER.DBO.PLN_DEVELOP_FEE_AREAS,GIS_REPOSITORY_TABLES.DBO.FFCIMPORT -c WATER.DBO.PLN_DEVELOP_FEE_AREAS.Shape,WATER.DBO.PLN_DEVELOP_FEE_AREAS.IDNumber,GIS_REPOSITORY_TABLES.DBO.FFCIMPORT.IDNum,GIS_REPOSITORY_TABLES.DBO.FFCIMPORT.ProjectNum,WATER.DBO.PLN_DEVELOP_FEE_AREAS.ObjectID -w "WATER.DBO.IDNumber=GIS_REPOSITORY_TABLES.DBO.IDNum" -i sde:sqlserver:SQL04V\GIS01 -s SQL04V\GIS01 -D WATER Could someone please weigh in on this? I was able to do it before we moved to 2008R2 as well as 10.1. Thank you for your help, Michelle
... View more
01-16-2014
09:18 AM
|
0
|
5
|
2842
|
POST
|
As we are continuing to work on some issues mentioned above, ESRI has emailed us the following regarding performance issues when using SQL_Geometry: http://support.esri.com/cn/knowledgebase/techarticles/detail/38871 (Our (ESRI's) kb article on bug) -discusses issues on a multiproecssor system and a bug in MS' query optimizer. Their fix is in SP2 - only problem is we are already on SP2...... http://support.microsoft.com/kb/2570501 (MS kb article on bug) -speaks to the parallel query against a large spatial table http://support.microsoft.com/kb/2591748 (specifically mentioned in this fix) Suggest having a DBA take a look and run a trace to document the issues. ~Michelle
... View more
11-25-2013
11:19 AM
|
0
|
0
|
481
|
POST
|
I've been having issues when editing a version 10 geodatabase in ArcGIS 10.1 from the network. Editing a version 9.3 seems to be fine. With ArcGIS 10, I was having zero issues editing from the network. Basically, selecting anything has a noticeable delay. Moving anything results in at least a 10 second delay. Editing the same data on my local results in zero problems. I called tech support and they initially blamed it on the network. Well, 2 days prior, it worked fine on the same network. There were no changes made to the network, only to the upgrade of version 10 to 10.1. We then tried renaming the normal.mxt and the esri folders in the registry. That didn't work either. Has anyone experienced this in 10.1? It's a bit frustrating, because we really need this to work from the network. I am editing on my local right now as a temp fix, but eventually that won't work. Thanks, Robb Robb et al, 😮 We just finished running some additional tests on our side per ESRI's request (we had our PM from ESRI on the phone looking at exactly what was happening - sluggishness, etc.) They suggested setting up a separate database on the same box (in our case Production), and changing the data storage back to SDEBINARY rather than GEOMETRY (ESRI's default). Once we did and tested while editing with numerous users for 1.5 hours, we saw an improvement. I then went back to our Production data, backed up the new geometric networks, recreated them, and then imported the data using the SDEBINARY config keyword. When I came in this morning, PERFMON (or the performance on the server and on Desktop) have vastly improved to where I am actually happy and satisfied with the outcome. We are still continuing to review the situation and make sure it stays this way. We did not have to change the data types for all of the data in the Production database, but just the networks that were giving us the problem, so we can still have the SQL Server functionality for 98% of our data in the database. It appears that ESRI has not yet caught up to the SQL Server storage types with their more advanced networks or data types. Hopefully this will help some of you as I know it has been VERY trying here, but as I mentioned, we have noticed a significant difference in our data and our editing. Cheers, Michelle
... View more
11-08-2013
04:29 AM
|
0
|
0
|
481
|
POST
|
Out of curiosity, has anyone on this thread tested or upgraded to 10.2 and attempted any of the above? Is 10.2 having the slow editing issue (or any other major issues for that matter)?
... View more
10-28-2013
11:39 AM
|
0
|
0
|
481
|
POST
|
We are going through this exact same scenario here. ESRI just came in and reworked WATER's old database model and set up 6new datasets, including two new geometric networks for water and sewer. We are on SDE 10.1 SP1, SLQ 2008R2 and everything has begun to chug. What we tried: 1) Turned off hyper-threading which made a noticeable difference to our users 2) Had them enable Classic snapping when editing, which helped 3) Enabled feature caching, which is actually suggested by ESRI when working with geometric networks (see article http://resources.arcgis.com/en/help/main/10.1/index.html#/Performance_considerations/002r00000004000000/) - this helped but is at a user level and we have over 300 users What we tested: 1) Tested the drawing of all layers and performance of the processors on the server when using the networks (SLOW!), then turned those layers off and amazingly enough, things were better. 2) Also took a look at the Performance Monitor on the server and it appears that all of the hits were to the temp locations. If you read the article from above, you will notice ESRI says that a geometric network is now "executing a separate spatial query on the server for each feature class in the network. If coincidence is discovered, then network connectivity is established. The cost of maintaining the connectivity on the fly is execution of these queries, which can be expensive." We have also checked the network (no issues), maxed database connections to over 64 (we were reaching 61 consecutive connections), and then all the basic info mentioned (normal.mxts, ESRI folders, etc.) I believe this to be a performance "enhancement" on ESRI's part (sarcasm slightly intended) and they appear to admit that there is a large overhead now for geometric networks. As for a resolution I am not sure. My thoughts at this time for us are to have a snapshot that is updated programatically on a regular basis for our general users (readers) so they aren't panning and "querying" everytime they try to locate a water main....but that's a business practice call.... I am glad to have found this post as I have been searching everywhere for information, so as I find out more information on our end I will post for everyone else. I should also mention that our geometric network was created as a 10.1 network and was not migrated from a 9.3 network.
... View more
10-09-2013
09:50 AM
|
0
|
0
|
682
|
POST
|
I have a 3rd party scheduling application that my company bought and would like me to try to use for my Python scripts, SQL tasks, jobs, etc. It appears to be Java based and although they claim it can run Python scripts, they based it off of Jython. I downloaded the Jython module, but cannot figure out how to import the arcpy module along with a few others for logging. Has anyone done this and/or can anyone provide some guidance? Thank you, Michelle Modules importing: from __future__ import absolute_import import arcpy, arcgisscripting, smtplib, sys, os, traceback, time, datetime, logging, logging.handlers, win32api, win32com.client from email.MIMEMultipart import MIMEMultipart from email.MIMEBase import MIMEBase from email.MIMEText import MIMEText from email.Utils import COMMASPACE, formatdate from email import Encoders from time import strftime
... View more
03-08-2013
07:09 AM
|
1
|
0
|
383
|
POST
|
Right now we have a separate DB group who manages the majority of the City's databases. Then we have our SDE databases. What the overall intent is, is to have the SDE databases on our own SQL Server instance apart from an instance that currently has not only our databases, but other databases in the same instance of SQL Server. In addition, the idea was to also separate out the license manager and all ArcSDE components to its own server, separate from the database server. I don't view any of that being an issue as ESRI supports the separation of ArcSDE from SQL. However, what I am trying to trouble shoot is all the peripheral montage that comes with it. Prior to our separation (or if you would like, still currently in production) are numerous SQL jobs that we run on a nightly, weekly, and monthly basis. These jobs can include SSIS packages, .exes, and python scripts. The idea was to take these "GIS-oriented" pieces and put them on the ArcSDE server (not the database server), so everything is in one (a GIS Server/non-database) location and let the jobs continue to run, but call the .exes from a different location. It seems to work just fine (on other .exes) until I get to the "GIS" executables. This is the direction management wanted to head, so I get to figure it out.....I did modify the reference paths in the .exe to use a universal naming convention so it should be able to access the .dlls on the other server, I would think. Still at a loss.....it almost seems like something very small.....
... View more
02-12-2013
11:37 AM
|
0
|
0
|
925
|
POST
|
On which machine is the .exe executing? Note that I am not asking where it physically is but rather on which machine is it running on. Sounds like it is running on the x86 machine and that machine does not have the ESRI bits installed. It won't use the assemblies on the 64 bit machine unless the .exe is executing on that machine. Thanks you for your response. I believe the ,exe is executing on the x86 machine but being called from the x64 machine. The SQL job Step syntax is an OSCmdExec, calling this executable from the x64 machine "\\GIS_LM\ArcGIS\Custom\Executables\ParcelsImport.exe" -s GS002. GS002 is the server variable that is being passed. So basically what you're saying is the "idea" of having everything on one machine and hitting the SQL database server won't work without having AT LEAST the .NET assemblies installed on the SQL databser server?
... View more
02-12-2013
10:11 AM
|
0
|
0
|
925
|
POST
|
Migrating in numerous ways..... Trying to run an .exe (VS2010), from SQLServer 2005 DB as a SQL job. SQL DB is on x86 machine (Server 2003), .exe is on x64 (Server 2008 R2)machine, as is all ArcGIS software, license manager, etc. * Note: The same job ran fine with everything loaded onto the SQL DB box. SDE and ArcGIS Desktop were installed. Migration entailed removing all ArcSDE & ArcGIS components from the SQLServer box and loading them onto the Server 2008 R2 box. When running the job, I am receiving the following error: Executed as user: Domain\XXXX. ... System.TypeInitializationException: The type initializer for 'ParcelsImport.modParcelsImport' threw an exception. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ESRI.ArcGIS.System, Version=10.0.0.0, Culture=neutral, PublicKeyToken=8fc3cc631e44ad86' or one of its dependencies. The system cannot find the file specified. File name: 'ESRI.ArcGIS.System, Version=10.0.0.0, Culture=neutral, PublicKeyToken=8fc3cc631e44ad86' at ParcelsImport.LicenseInitializer..ctor() at ParcelsImport.modParcelsImport..cctor() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. --- End of inner exception stack trace --- at ParcelsImport.modP. The step failed. I verified that the .dlls were referenced on the x64 machine and that they were in the GAC. I also read some other threads that talked about changing the build from "Any Computer" to x86, but this has not worked for me. Does anyone have any suggestions?
... View more
02-12-2013
07:39 AM
|
0
|
6
|
4096
|
Title | Kudos | Posted |
---|---|---|
1 | 09-25-2020 06:12 AM | |
1 | 07-20-2018 06:55 AM | |
1 | 05-11-2018 07:31 AM | |
7 | 03-28-2018 08:03 AM | |
1 | 02-28-2012 05:23 AM |
Online Status |
Offline
|
Date Last Visited |
06-06-2022
10:18 AM
|