Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About SimonEarnshaw
SimonEarnshaw
New Contributor III
since
07-04-2014
11-11-2020
32
Posts created
11
Kudos given
1
Solutions
4
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by SimonEarnshaw
|
POST
|
Nana, It's all gone a bit quiet from ESRI Inc - is anyone actively looking into this issue - it is a very important issue for us here. Thanks Simon
... View more
03-18-2015
04:58 AM
|
0
|
2
|
1220
|
|
POST
|
Hi Nana, I have attached the sql trace for a single connection via ArcCatalog to our PostgreSQL database. Also find the db config file attached too. In summary for the sql trace: At 11:13:04 the connect to ArcSDE (geology user) is issued. At 11:13:06 there are hundreds of simple queries on each table which amounts to 5 seconds (I think this is to confirm whether or not the tables exist e.g SELECT 1 FROM geology.ae230s230_005m5000p01m010 LIMIT 0). On closer inspection this tallies with number of featureclasses/rasters that we have. At 11:13:10 There are some different queries issued (think they are doing something with privileges. Doesn't take long. At 11:13:11 the simple queries are issued again! Taking another 5 seconds. At 11:13:14 Queries are made that take hardly any time but....a huge query that takes 6+ seconds that finishes at 11:13:21. At 11:13:21 Another huge query takes over 8 seconds, again something to do with working out privileges. At 11:13:33 Connection completed. I have also logged this problem with ESRI UK - the case number for this is: CAS-09709-L6L0C8. I am unsure whether we will get any closure on this from the UK side after speaking to our contact, so if ESRI Inc could help out on this, or anyone to be quite frank! - we would be very grateful. Regards Simon Earnshaw
... View more
03-13-2015
04:37 AM
|
0
|
0
|
1220
|
|
POST
|
Hi Vince - I think I alluded to the hardware being the same for both databases by virtue of both being Hyper-V instances. See my comments in underneath the response. Cheers. Simon.
... View more
03-12-2015
02:52 AM
|
0
|
5
|
1220
|
|
POST
|
Hi, We are also getting this problem see my link on Stack Exchange: Database connection times - PostGreSQL vs Oracle (ArcSDE) - Geographic Information Systems Stack Exchange I have turned up nothing yet - but if I find out anything I will let you know. Also if you have found out anything with this issue please let me too. Kind regards Simon Earnshaw
... View more
03-10-2015
10:42 AM
|
0
|
7
|
1220
|
|
POST
|
What is the best way to delete a schema/user from ArcSDE/Oracle? Sure you can create a user using ArcToolbox, but there is no delete user!?
... View more
01-06-2015
03:47 AM
|
0
|
1
|
4225
|
|
POST
|
I figured it out now. Basically missing this line of code: ArcMap.Document.PageLayout.ReplaceMaps(maps);
... View more
11-05-2014
05:48 AM
|
1
|
0
|
441
|
|
POST
|
I have code that creates new Data Frames, using IMaps.Create() and when you right click->Properties on the new Data Frames in ArcMap TOC, it never opens up the Properties window?! Anyone know whats going on here, have I missed something in the code? The code is fairly basic: internal static void AddNewMap(string mapName) { //Makes the new map the active focus map too. IMxDocument mxd = ArcMap.Document; IMaps maps = mxd.Maps; IMap map = null; if (maps.Count == 1 && maps.Item[0].Name != "Foo Name") { map = maps.Item[0]; } else { map = maps.Create(); maps.Add(map); } map.Name = mapName; IActiveView pActiveView = ArcMap.Document.ActiveView; if (pActiveView is IPageLayout) ArcMap.Document.ActiveView.FocusMap = map; else ArcMap.Document.ActiveView = (IActiveView)map; ArcMap.Document.UpdateContents(); }
... View more
11-05-2014
02:36 AM
|
1
|
2
|
2163
|
|
POST
|
I would like to know how to do this too (funnily enough)
... View more
08-26-2014
07:08 AM
|
0
|
0
|
152
|
|
POST
|
If I do a ListDatasets() in python, then I don't get the correct result in the list except for datasets belong to other schema owners, so why can I still see the datasets in ArcCatalog. The code is staightforward: workspace = r'Database Connections\\enidb.sde'
arcpy.env.workspace = workspace
dslist = arcpy.ListDatasets() The dslist is empty bar the CULTURAL.ESRI_DATASETS - I should be able to see all the ENIDB ones as I am logged in as that schema owner: [ATTACH=CONFIG]27872[/ATTACH][ATTACH=CONFIG]27873[/ATTACH]
... View more
09-30-2013
05:23 AM
|
0
|
1
|
1845
|