POST
|
I have a temporary table created to store record id's that I then retrieve using a query task with an inner select in the where clause. This has worked fine in services created in ArcGIS 10.1 and below, but does not seem to be working the same in 10.2+ version of ArcGIS services. I can use a list of IDs as a where clause: MaterialTypeId in ('F2E55F1F-B493-422F-806A-CD8A82A5868E', 'EEF3E3DA-7B8A-447B-AE4C-B0CBDA21AED7') but I can not use an inner select that generates a list of IDs as a where clause: MaterialTypeId in (select top 2 Id from MaterialTypes) Is there a way to accomplish this in the latest versions of the web service API? This has worked fine in versions prior to 10.2. Thanks, Steve
... View more
07-07-2015
05:48 AM
|
0
|
1
|
2941
|
POST
|
Thanks for the reply Steven...both of these features looked good on the server.
... View more
12-23-2014
09:29 AM
|
0
|
0
|
2565
|
POST
|
Jake, That solved the problem. I had originally created the database using an OS user and then had the ArcCatalog database connection using the SQL Server login. I recreated the enterprise geodatabase using the SQL Server login and am not getting the error anymore during the Analysis phase of the service publish. Thanks, Steve
... View more
12-23-2014
09:27 AM
|
2
|
0
|
2565
|
POST
|
Thanks Jake. I added the local arcgis server account to the SQL Server database, assigned it the "serveradmin" and "sysadmin" roles, and mapped it to the geodatabase as a dbowner of the database. Restarted the ESRI server service and restarted the database, and am still seeing the same error. I went through the help topic and everything looks good (am using SQL Server authentication and have checked "save user/password" in the connection properties). If you think of any other ideas I would welcome them...thanks again.
... View more
12-23-2014
08:04 AM
|
0
|
4
|
2565
|
POST
|
I have ArcGIS Server 10.2 running on a Windows Server 2012 R2 Standard server with SQL Server 2012 R2. I'm able to create enterprise geodatabases fine, and import feature classes into the geodatabases with no problems. I've registered the geodatabase with the server successfully. I then created a map (with the geodatabase as the default database) and added a few of the feature classes in order to publish them as a service. When I try to publish the service, the Analyze step in the Service Editor is returning a "Feature service requires a registered database" error. I open up the data store registration page, choose Validate All, and everything checks out fine. The map is using the same connection to the database that ArcMap Catalog uses, with a SQL Server login that is a dbowner of the database. Is there anything that I'm missing here? Have not been able to solve this issue.
... View more
12-23-2014
07:07 AM
|
0
|
8
|
9852
|
POST
|
I will try adding a new graphics layer for the highlight symbols...great idea. I am clearing the added highlight graphic on mouse-out. Thanks for your help...brand new at GIS but really like the javascript api they've developed.
... View more
12-05-2014
07:22 AM
|
0
|
3
|
1035
|
POST
|
Thanks Ken. Given that the map layer is always on top, do you have any advice for how to accomplish the highlighting, etc., without adding graphics to the map layer?
... View more
12-05-2014
06:48 AM
|
0
|
5
|
1035
|
POST
|
I'm using the latest ArcGIS javascript libraries, and am finding that I can use the featureLayer.on("mouse-over", function (evt) { // code here to respond to mouse over }); script to easily respond to mouse events on the feature layers that I include in the map. I'm using these events to highlight the county, point, or line the user is hovering over by adding a graphic to the map that shows the "highlighted" version of the county, line or point. However, when I add the graphic to make the feature appear highlighted I lose the ability to respond to click events on the original feature (that was hovered over). I've tried moving the highlight graphic to the back and a few other things, but nothing has worked. How can I get the original click events to fire after I've added graphics to the layer to show the item highlighted? Here's a little example to illustrate the point: <script type="text/javascript"> var map, dialog; require(["esri/map", "esri/geometry/Extent", "esri/layers/FeatureLayer", "esri/symbols/SimpleFillSymbol", "esri/symbols/SimpleLineSymbol", "esri/symbols/SimpleMarkerSymbol", "esri/renderers/SimpleRenderer", "esri/graphic", "esri/lang", "esri/Color", "dojo/number", "dojo/dom", "dojo/dom-style", "dijit/TooltipDialog", "dijit/popup", "dojo/domReady!" ], function (Map, Extent, FeatureLayer, SimpleFillSymbol, SimpleLineSymbol, SimpleMarkerSymbol, SimpleRenderer, Graphic, esriLang, Color, number, dom, domStyle, TooltipDialog, dijitPopup) { var countiesUrl = "http://myesriserver:6080/arcgis/rest/services/Service1/FeatureServer/0"; var geoPointsUrl = "http://myesriserver:6080/arcgis/rest/services/Service1/FeatureServer/1"; var bbox = new Extent({ "xmin": 360678, "ymin": 3335262, "xmax": 698921, "ymax": 3874594, "spatialReference": { "wkid": 32616 } }); map = new Map("mapDiv", { extent: bbox, }); var counties = new FeatureLayer(countiesUrl, { mode: FeatureLayer.MODE_SNAPSHOT, outFields: ["*"] }); map.addLayer(counties); var geoPoints = new FeatureLayer(geoPointsUrl, { mode: FeatureLayer.MODE_SNAPSHOT, outFields: ["*"] }); map.addLayer(geoPoints); var highlightSymbol = new SimpleFillSymbol(SimpleFillSymbol.STYLE_SOLID, new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([100, 255, 100]), 3), new Color([255, 255, 255, 0.35])); var highlightPoint = new SimpleMarkerSymbol(SimpleMarkerSymbol.STYLE_CIRCLE, 15, new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([200, 200, 200]), 3), new Color([200, 200, 200, 0.50])); map.on("load", function () { map.graphics.enableMouseEvents(); map.graphics.on("mouse-out", clearGraphics); }); counties.on("mouse-over", function (evt) { var highlightGraphic = new Graphic(evt.graphic.geometry, highlightSymbol); // If I comment the next line then the geoPoints mouse-over event will fire. // If I leave the next line uncommented then the graphic is added to the map and the geoPoints mouse-over event does not fire. map.graphics.add(highlightGraphic); }); geoPoints.on("mouse-over", function (evt) { var highlightGraphic = new Graphic(evt.graphic.geometry, highlightPoint); map.graphics.add(highlightGraphic); }); function clearGraphics() { map.graphics.clear(); } }); </script>
... View more
12-04-2014
06:27 PM
|
0
|
7
|
5646
|
POST
|
I ended up deleting the map, deleting the feature classes in the database, deleting the database connection, and deleting the reference in the data store in order to start over. I recreated everything and now the Analyzer is not giving me the registration error. I believe I used the same steps to recreate everything, but maybe I missed something before. Nevertheless, the issue seems to be resolved. Thanks again for your replies.
... View more
10-09-2014
12:29 PM
|
0
|
0
|
743
|
POST
|
I ended up deleting the map, deleting the feature classes in the database, deleting the database connection, and deleting the reference in the data store in order to start over. I recreated everything and now the Analyzer is not giving me the registration error. I believe I used the same steps to recreate everything, but maybe I missed something before. Nevertheless, the issue seems to be resolved. Thanks again for your replies.
... View more
10-09-2014
12:29 PM
|
0
|
0
|
165
|
POST
|
I removed the Feature Access from the capabilities list so I could at least publish the map service, and took a look at the Service Workspaces within this service definition in the ArcGIS Server Manager. It lists the map service as "Copied" instead of "Referenced" in the Service Workspaces dialog. Could this be contributing to the analyzer error when Feature Access is included? I believe I should be seeing the data as "Referenced" instead of "Copied" inside the Service Workspaces dialog.
... View more
10-09-2014
11:16 AM
|
0
|
0
|
743
|
POST
|
I'm using ArcGIS 10.2.1 for Desktop (10.2.1.3497 -- license type Advanced) for the map and ArcGIS 10.2.1 for Server for the server side.
... View more
10-09-2014
10:42 AM
|
0
|
0
|
165
|
POST
|
Yes, have validated several times. When I click on the "Feature service requires a registered database" error in the Analyzer Results it pops up the Data Stores dialog, and my registered database validates fine. I've recreated this several times and the data store validation is good. I have removed the feature classes and added them again to the map to see if it might be resolved, but am still getting the same error. Thanks for the replies...if you have any other ideas I would definitely appreciate them. If some screenshots would help I can include those.
... View more
10-09-2014
09:48 AM
|
0
|
0
|
743
|
POST
|
Yeah, that's the one I've been looking at. I'm using SQL Server authentication (with a dbowner user), have created one database connection in ArcCatalog, and have used that same database connection at each step. Thought it might have something do with different versions (dbo.DEFAUT versus sde.DEFAULT or something like that), but does not look like that's the case.
... View more
10-09-2014
09:33 AM
|
0
|
4
|
743
|
POST
|
I've created an enterprise database (Microsoft SQL Server 2012 - 11.0.5058.0 (X64)) in ArcGIS 10.21, registered it as a data store, and set up the database connection in ArcCatalog using a SQL Server login that is a dbowner of the database. I've imported two shape files into the database using ArcCatalog, and created a map that references these two feature classes. When I try to publish the map as a service including feature access, I'm getting the "[00090] Feature service requires a registered database" error from the Analyzer and am unable to publish the service. I'm using the same database connection from ArcCatalog to reference the database in ArcCatalog and the map. Does anyone have any ideas on why this error might be occurring? When I double-click on the error message and the Data Stores dialog pops up, the database is listed and validates fine. Thanks, Steve Burdette srburdette@cs.ua.edu
... View more
10-09-2014
09:15 AM
|
0
|
12
|
4633
|
Title | Kudos | Posted |
---|---|---|
1 | 07-07-2015 09:30 AM | |
1 | 10-28-2016 08:14 AM | |
2 | 09-04-2015 09:55 AM | |
2 | 12-23-2014 09:27 AM |
Online Status |
Offline
|
Date Last Visited |
09-29-2021
08:48 AM
|