Adding Spatial Index for Geometric Network? Planned maintenance scheduled April 23, 2019 at...
First paper to introduce the "principal-agent problem"
Does the transliteration of 'Dravidian' exist in Hindu scripture? Does 'Dravida' refer to a Geographical area or an ethnic group?
Did pre-Columbian Americans know the spherical shape of the Earth?
Why do C and C++ allow the expression (int) + 4*5;
How do you write "wild blueberries flavored"?
Table formatting with tabularx?
Can gravitational waves pass through a black hole?
Why can't fire hurt Daenerys but it did to Jon Snow in season 1?
Derived column in a data extension
Can the Haste spell grant both a Beast Master ranger and their animal companion extra attacks?
systemd and copy (/bin/cp): no such file or directory
Does the universe have a fixed centre of mass?
NIntegrate on a solution of a matrix ODE
Fit odd number of triplets in a measure?
2018 MacBook Pro won't let me install macOS High Sierra 10.13 from USB installer
How do I say "this must not happen"?
As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?
Is there a verb for listening stealthily?
Was the pager message from Nick Fury to Captain Marvel unnecessary?
How could a hydrazine and N2O4 cloud (or it's reactants) show up in weather radar?
Is there a spell that can create a permanent fire?
An isoperimetric-type inequality inside a cube
Understanding piped commands in GNU/Linux
Random body shuffle every night—can we still function?
Adding Spatial Index for Geometric Network?
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Analyzing Flow direction in Geometric Networks in ArcGISUnable to create a geometric network in a PostgreSQL Spatial Database ConnectionHow to create Network Dataset for Network Assistant using ArcPy?Geometric Network error in File Geodatabase<Network DatasetGeometric Network for Electric Utilities?Incremental Network Loader failing with ArcSDE Geometric NetworkHow do I add all features of a Geometric Network to the the dataframe with one parameter in a custom tool that uses python?DBMS table not found after building geometric network?Create a Geometric Network - ErrorArcGIS Trace Geometric Network Tool Trace using Find Common Ancestors gives error
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I am trying to create Spatial Indexes on all the feature classes in one of my databases. It has worked fine on most feature classes so far, but when I started on feature classes in a feature dataset suddenly I was getting errors about locks.
Runtime error Traceback (most recent call last):
File "<string>", line 2, in <module> File "c:program files (x86)arcgisdesktop10.5arcpyarcpymanagement.py", line 6448,
in AddSpatialIndex
raise e ExecuteError:
ERROR 000464: Cannot get exclusive schema lock.
Either being edited or in use by another application. Failed to execute (AddSpatialIndex).
I tested on a couple of other feature datasets, one worked, one gave the same error. Both where it failed contained geometric networks. In a test I deleted the geometric network (leaving all the same feature classes) and the Add Spatial Index tool worked as expected.
Why would the Add Spatial Index fail on a geometric network? I cannot find anything in the Geometric Network and Spatial Index (and related) docs to indicate why this would happen.
Note that I am able to add a spatial index through the right-click feature class properties.
I am using ArcGIS Desktop 10.5 with Advanced license. These feature classes are stored in a local file geodatabase.
In response to comment by @Alex Tereshenkov I have checked there are no locks. I also created a new File Geodatabase and copy/pasted a Feature Dataset that I hadn't used today. This one has feature classes both part of and separate of the geometric network. I tested using tool from ArcToolbox to rule out arcpy being difficult.
Any feature class within the geometric network fails
Any feature class external to the network succeeds (all are within the same feature dataset)
As recommended by @Alex Tereshenkov, I tried everything completely new - I created a new FGDB, Feature Dataset, 2 Feature Classes (1x point, 1x line), and added half-dozen features.
I then closed out and created new Geometric Network with those 2 feature classes.
Add Spatial Join still fails on both feature classes. I have tried with my lines both as Complex (as in my original) and Simple edges, but again it fails.
arcgis-desktop arcgis-10.5 geometric-network spatial-index error-000464
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
add a comment |
I am trying to create Spatial Indexes on all the feature classes in one of my databases. It has worked fine on most feature classes so far, but when I started on feature classes in a feature dataset suddenly I was getting errors about locks.
Runtime error Traceback (most recent call last):
File "<string>", line 2, in <module> File "c:program files (x86)arcgisdesktop10.5arcpyarcpymanagement.py", line 6448,
in AddSpatialIndex
raise e ExecuteError:
ERROR 000464: Cannot get exclusive schema lock.
Either being edited or in use by another application. Failed to execute (AddSpatialIndex).
I tested on a couple of other feature datasets, one worked, one gave the same error. Both where it failed contained geometric networks. In a test I deleted the geometric network (leaving all the same feature classes) and the Add Spatial Index tool worked as expected.
Why would the Add Spatial Index fail on a geometric network? I cannot find anything in the Geometric Network and Spatial Index (and related) docs to indicate why this would happen.
Note that I am able to add a spatial index through the right-click feature class properties.
I am using ArcGIS Desktop 10.5 with Advanced license. These feature classes are stored in a local file geodatabase.
In response to comment by @Alex Tereshenkov I have checked there are no locks. I also created a new File Geodatabase and copy/pasted a Feature Dataset that I hadn't used today. This one has feature classes both part of and separate of the geometric network. I tested using tool from ArcToolbox to rule out arcpy being difficult.
Any feature class within the geometric network fails
Any feature class external to the network succeeds (all are within the same feature dataset)
As recommended by @Alex Tereshenkov, I tried everything completely new - I created a new FGDB, Feature Dataset, 2 Feature Classes (1x point, 1x line), and added half-dozen features.
I then closed out and created new Geometric Network with those 2 feature classes.
Add Spatial Join still fails on both feature classes. I have tried with my lines both as Complex (as in my original) and Simple edges, but again it fails.
arcgis-desktop arcgis-10.5 geometric-network spatial-index error-000464
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
Just a wild guess - could there be any orphan locks left sincearcpyaccessed the dataset? Restart the machine? Could it be that a lock is created on a dataset after you've accessed another feature class adding an index there (like all datasets in FD are locked somehow?)
– Alex Tereshenkov
May 29 '17 at 17:49
I've tested creating a dummy geometric network with a feature class in a file gdb and I am able to run theAdd Spatial IndexGP tool on the feature class that participates in the geometric network. I'd probably start looking into properties of a geometric network and try to modify its properties one after one to see when it starts failing (ie create the most primitive geometric network and then come closer to how it should be while runningAdd Spatial Indexafter every modification). Does it make sense? Our environment is identical in terms of version and licensing.
– Alex Tereshenkov
May 30 '17 at 15:45
@AlexTereshenkov Thank you for that, it confirms that the tool should be working. I'll give that a test when I'm back at my computer. It is odd, the geometric network is fairly basic with no rules at all. But will test and report back.
– Midavalo♦
May 30 '17 at 16:49
@AlexTereshenkov I have updated my question with results of extra testing in response to your comments
– Midavalo♦
May 31 '17 at 1:37
Did this one ever resolve? If not, I am wondering whether creating a simple test Geometric Network using ArcPy might be a way to produce a fully documented procedure that will enable it to be reproduced without access to your data..
– PolyGeo♦
Jul 20 '18 at 3:20
add a comment |
I am trying to create Spatial Indexes on all the feature classes in one of my databases. It has worked fine on most feature classes so far, but when I started on feature classes in a feature dataset suddenly I was getting errors about locks.
Runtime error Traceback (most recent call last):
File "<string>", line 2, in <module> File "c:program files (x86)arcgisdesktop10.5arcpyarcpymanagement.py", line 6448,
in AddSpatialIndex
raise e ExecuteError:
ERROR 000464: Cannot get exclusive schema lock.
Either being edited or in use by another application. Failed to execute (AddSpatialIndex).
I tested on a couple of other feature datasets, one worked, one gave the same error. Both where it failed contained geometric networks. In a test I deleted the geometric network (leaving all the same feature classes) and the Add Spatial Index tool worked as expected.
Why would the Add Spatial Index fail on a geometric network? I cannot find anything in the Geometric Network and Spatial Index (and related) docs to indicate why this would happen.
Note that I am able to add a spatial index through the right-click feature class properties.
I am using ArcGIS Desktop 10.5 with Advanced license. These feature classes are stored in a local file geodatabase.
In response to comment by @Alex Tereshenkov I have checked there are no locks. I also created a new File Geodatabase and copy/pasted a Feature Dataset that I hadn't used today. This one has feature classes both part of and separate of the geometric network. I tested using tool from ArcToolbox to rule out arcpy being difficult.
Any feature class within the geometric network fails
Any feature class external to the network succeeds (all are within the same feature dataset)
As recommended by @Alex Tereshenkov, I tried everything completely new - I created a new FGDB, Feature Dataset, 2 Feature Classes (1x point, 1x line), and added half-dozen features.
I then closed out and created new Geometric Network with those 2 feature classes.
Add Spatial Join still fails on both feature classes. I have tried with my lines both as Complex (as in my original) and Simple edges, but again it fails.
arcgis-desktop arcgis-10.5 geometric-network spatial-index error-000464
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
I am trying to create Spatial Indexes on all the feature classes in one of my databases. It has worked fine on most feature classes so far, but when I started on feature classes in a feature dataset suddenly I was getting errors about locks.
Runtime error Traceback (most recent call last):
File "<string>", line 2, in <module> File "c:program files (x86)arcgisdesktop10.5arcpyarcpymanagement.py", line 6448,
in AddSpatialIndex
raise e ExecuteError:
ERROR 000464: Cannot get exclusive schema lock.
Either being edited or in use by another application. Failed to execute (AddSpatialIndex).
I tested on a couple of other feature datasets, one worked, one gave the same error. Both where it failed contained geometric networks. In a test I deleted the geometric network (leaving all the same feature classes) and the Add Spatial Index tool worked as expected.
Why would the Add Spatial Index fail on a geometric network? I cannot find anything in the Geometric Network and Spatial Index (and related) docs to indicate why this would happen.
Note that I am able to add a spatial index through the right-click feature class properties.
I am using ArcGIS Desktop 10.5 with Advanced license. These feature classes are stored in a local file geodatabase.
In response to comment by @Alex Tereshenkov I have checked there are no locks. I also created a new File Geodatabase and copy/pasted a Feature Dataset that I hadn't used today. This one has feature classes both part of and separate of the geometric network. I tested using tool from ArcToolbox to rule out arcpy being difficult.
Any feature class within the geometric network fails
Any feature class external to the network succeeds (all are within the same feature dataset)
As recommended by @Alex Tereshenkov, I tried everything completely new - I created a new FGDB, Feature Dataset, 2 Feature Classes (1x point, 1x line), and added half-dozen features.
I then closed out and created new Geometric Network with those 2 feature classes.
Add Spatial Join still fails on both feature classes. I have tried with my lines both as Complex (as in my original) and Simple edges, but again it fails.
arcgis-desktop arcgis-10.5 geometric-network spatial-index error-000464
arcgis-desktop arcgis-10.5 geometric-network spatial-index error-000464
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
edited Nov 20 '17 at 22:02
PolyGeo♦
54.1k1782246
54.1k1782246
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
asked May 29 '17 at 17:31
Midavalo♦Midavalo
25.9k53274
25.9k53274
Just a wild guess - could there be any orphan locks left sincearcpyaccessed the dataset? Restart the machine? Could it be that a lock is created on a dataset after you've accessed another feature class adding an index there (like all datasets in FD are locked somehow?)
– Alex Tereshenkov
May 29 '17 at 17:49
I've tested creating a dummy geometric network with a feature class in a file gdb and I am able to run theAdd Spatial IndexGP tool on the feature class that participates in the geometric network. I'd probably start looking into properties of a geometric network and try to modify its properties one after one to see when it starts failing (ie create the most primitive geometric network and then come closer to how it should be while runningAdd Spatial Indexafter every modification). Does it make sense? Our environment is identical in terms of version and licensing.
– Alex Tereshenkov
May 30 '17 at 15:45
@AlexTereshenkov Thank you for that, it confirms that the tool should be working. I'll give that a test when I'm back at my computer. It is odd, the geometric network is fairly basic with no rules at all. But will test and report back.
– Midavalo♦
May 30 '17 at 16:49
@AlexTereshenkov I have updated my question with results of extra testing in response to your comments
– Midavalo♦
May 31 '17 at 1:37
Did this one ever resolve? If not, I am wondering whether creating a simple test Geometric Network using ArcPy might be a way to produce a fully documented procedure that will enable it to be reproduced without access to your data..
– PolyGeo♦
Jul 20 '18 at 3:20
add a comment |
Just a wild guess - could there be any orphan locks left sincearcpyaccessed the dataset? Restart the machine? Could it be that a lock is created on a dataset after you've accessed another feature class adding an index there (like all datasets in FD are locked somehow?)
– Alex Tereshenkov
May 29 '17 at 17:49
I've tested creating a dummy geometric network with a feature class in a file gdb and I am able to run theAdd Spatial IndexGP tool on the feature class that participates in the geometric network. I'd probably start looking into properties of a geometric network and try to modify its properties one after one to see when it starts failing (ie create the most primitive geometric network and then come closer to how it should be while runningAdd Spatial Indexafter every modification). Does it make sense? Our environment is identical in terms of version and licensing.
– Alex Tereshenkov
May 30 '17 at 15:45
@AlexTereshenkov Thank you for that, it confirms that the tool should be working. I'll give that a test when I'm back at my computer. It is odd, the geometric network is fairly basic with no rules at all. But will test and report back.
– Midavalo♦
May 30 '17 at 16:49
@AlexTereshenkov I have updated my question with results of extra testing in response to your comments
– Midavalo♦
May 31 '17 at 1:37
Did this one ever resolve? If not, I am wondering whether creating a simple test Geometric Network using ArcPy might be a way to produce a fully documented procedure that will enable it to be reproduced without access to your data..
– PolyGeo♦
Jul 20 '18 at 3:20
Just a wild guess - could there be any orphan locks left since
arcpy accessed the dataset? Restart the machine? Could it be that a lock is created on a dataset after you've accessed another feature class adding an index there (like all datasets in FD are locked somehow?)– Alex Tereshenkov
May 29 '17 at 17:49
Just a wild guess - could there be any orphan locks left since
arcpy accessed the dataset? Restart the machine? Could it be that a lock is created on a dataset after you've accessed another feature class adding an index there (like all datasets in FD are locked somehow?)– Alex Tereshenkov
May 29 '17 at 17:49
I've tested creating a dummy geometric network with a feature class in a file gdb and I am able to run the
Add Spatial Index GP tool on the feature class that participates in the geometric network. I'd probably start looking into properties of a geometric network and try to modify its properties one after one to see when it starts failing (ie create the most primitive geometric network and then come closer to how it should be while running Add Spatial Index after every modification). Does it make sense? Our environment is identical in terms of version and licensing.– Alex Tereshenkov
May 30 '17 at 15:45
I've tested creating a dummy geometric network with a feature class in a file gdb and I am able to run the
Add Spatial Index GP tool on the feature class that participates in the geometric network. I'd probably start looking into properties of a geometric network and try to modify its properties one after one to see when it starts failing (ie create the most primitive geometric network and then come closer to how it should be while running Add Spatial Index after every modification). Does it make sense? Our environment is identical in terms of version and licensing.– Alex Tereshenkov
May 30 '17 at 15:45
@AlexTereshenkov Thank you for that, it confirms that the tool should be working. I'll give that a test when I'm back at my computer. It is odd, the geometric network is fairly basic with no rules at all. But will test and report back.
– Midavalo♦
May 30 '17 at 16:49
@AlexTereshenkov Thank you for that, it confirms that the tool should be working. I'll give that a test when I'm back at my computer. It is odd, the geometric network is fairly basic with no rules at all. But will test and report back.
– Midavalo♦
May 30 '17 at 16:49
@AlexTereshenkov I have updated my question with results of extra testing in response to your comments
– Midavalo♦
May 31 '17 at 1:37
@AlexTereshenkov I have updated my question with results of extra testing in response to your comments
– Midavalo♦
May 31 '17 at 1:37
Did this one ever resolve? If not, I am wondering whether creating a simple test Geometric Network using ArcPy might be a way to produce a fully documented procedure that will enable it to be reproduced without access to your data..
– PolyGeo♦
Jul 20 '18 at 3:20
Did this one ever resolve? If not, I am wondering whether creating a simple test Geometric Network using ArcPy might be a way to produce a fully documented procedure that will enable it to be reproduced without access to your data..
– PolyGeo♦
Jul 20 '18 at 3:20
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f242057%2fadding-spatial-index-for-geometric-network%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f242057%2fadding-spatial-index-for-geometric-network%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Just a wild guess - could there be any orphan locks left since
arcpyaccessed the dataset? Restart the machine? Could it be that a lock is created on a dataset after you've accessed another feature class adding an index there (like all datasets in FD are locked somehow?)– Alex Tereshenkov
May 29 '17 at 17:49
I've tested creating a dummy geometric network with a feature class in a file gdb and I am able to run the
Add Spatial IndexGP tool on the feature class that participates in the geometric network. I'd probably start looking into properties of a geometric network and try to modify its properties one after one to see when it starts failing (ie create the most primitive geometric network and then come closer to how it should be while runningAdd Spatial Indexafter every modification). Does it make sense? Our environment is identical in terms of version and licensing.– Alex Tereshenkov
May 30 '17 at 15:45
@AlexTereshenkov Thank you for that, it confirms that the tool should be working. I'll give that a test when I'm back at my computer. It is odd, the geometric network is fairly basic with no rules at all. But will test and report back.
– Midavalo♦
May 30 '17 at 16:49
@AlexTereshenkov I have updated my question with results of extra testing in response to your comments
– Midavalo♦
May 31 '17 at 1:37
Did this one ever resolve? If not, I am wondering whether creating a simple test Geometric Network using ArcPy might be a way to produce a fully documented procedure that will enable it to be reproduced without access to your data..
– PolyGeo♦
Jul 20 '18 at 3:20