|
POST
|
When querying our SDE_spatial_references table with SQL Server Management Studio, I get the following error: "An error occurred while executing batch. Error message is: Arithmetic Overflow." We also run a DBCC CHECKDB weekly on our databases and it produces this error: "Column 'munits' value is out of range for data type "float". Update column to a legal value." It looks like the problem is with the munits field in one of our rows and I was able to identify which row this occurs in. I also took a look at our SDE_Layers table and don't see the SRID that is causing the problem listed. Has anyone seen this type of error and found a way to resolve it? Thanks, Mele
... View more
04-11-2014
10:19 AM
|
0
|
2
|
752
|
|
POST
|
We just upgraded our production ArcSDE server to Windows Server 2008 R2. We are using ArcSDE 10.1 SP1 on SQL Server 2012 with Application Server Connections for many of our users. We will be moving to more direct connects but for now, we have a lot of application server connections. After creating the windows service, I changed the login to use a domain account rather than the system account so that the Windows Service would not have to share heap memory with other processes. This was suggested to us a few versions of ArcSDE ago by ESRI Support and we are still employing this strategy. I have noticed that now we have a lot of Conhost.exe processes running under the domain account in addition to the expected gsrvr.exe processes and I am concerned that these are using up the memory that I had hoped would be dedicated to only the gsrvr.exe processes. I don't recall seeing these conhost.exe processes on Windows Server 2003 running under our Domain Account. Our SharedSection parameter on the registry key \\HKEY_LOCAL_MACHINE\ SYSTEM\CurrentControlSet\Control\Session Manager\SubSystems is set at 768. What are these conhost.exe procecesses and do I need to be concerned about using up the memory heap? Should I consider upping the SharedSection parameter? Thanks for any guidance you can provide. Mele
... View more
04-03-2014
08:54 AM
|
0
|
1
|
1214
|
|
POST
|
We have a few projects where we need to join a table to a feature class and then publish the map service with Feature Access so I am disappointed that this is not possible with 10.0 and it sounds like the capability hasn't been added in 10.2.1 either. We use a SQL table to symbolize off of and that SQL table is updated outside or our Geodatabase. What we end up doing is creating a map service that has the Feature Class with a join in it to SQL and we use that for display and then we have another service that has the Feature Access capability enabled. It ends up being tough to maintain and program around so I hope ESRI adds this functionality. Mele
... View more
02-27-2014
11:10 AM
|
0
|
0
|
442
|
|
POST
|
Did you ever find any solution to this? Unfortunately, I cannot provide any insight as I am having the exact same problem with ArcGIS Server 10. sp4 but thought I would see if you found any resolution. Thanks, Mele
... View more
02-27-2014
09:47 AM
|
0
|
0
|
2120
|
|
POST
|
When publishing a map service KML support is enabled by default. Is there a way to set the KML support for a Map Service to off by default so that each time a Map Service is published we don't have to uncheck this option? Thanks, Mele
... View more
12-05-2013
05:19 AM
|
0
|
3
|
6076
|
|
POST
|
I was able to create the Geometry in a view as shown below and then use it as a Query Layer in ArcMap Select [BlueStakeWOId], Geometry::STPointFromText('POINT (' + CAST([Longitude] as varchar(32)) + ' ' + CAST([Latitude] as varchar(32)) + ')', 4326) as shape from DBSVR.WaterWO.gis.OpenTickets There are only about 130 points in this table, so I will have to try with larger datasets and see how it performs Mele
... View more
11-22-2013
11:33 AM
|
0
|
0
|
4886
|
|
POST
|
I am attempting to upgrade a JavaScript application from 3.2 to 3.7. Changing the URL references seemed pretty strait forward, but after doing so, I have some formatting issues with the AttributeInpector and TemplatePicker in dijit.layout.ContentPane as shown in the attached image. [ATTACH=CONFIG]29290[/ATTACH] I suspect it is an CSS issue, but I don't have much in my CSS for the AttributeInspector or TemplatePicker other than the following: .esriAttributeInspector { height: 750px; width: 250px; } .templatePicker { border: none 0; height:300px; width: 250px; } I am also having an issue with the Slider Bar that I am using to change opacity on Aerials/Basemap. It does not show up since my switch to 3.7 #sliderWrapper { position:absolute; left: 20px; bottom:10px; z-Index: 40; width: 200px; height: 50px; background: transparent; -moz-box-shadow: 0 0 5px #888; -webkit-box-shadow: 0 0 5px #888; } What things should I check to correct these formatting issues? Thanks, Mele
... View more
11-22-2013
08:35 AM
|
0
|
1
|
760
|
|
POST
|
Thanks Vince for the information and clarification of terms. I would like to give it a try and compare the performance to that of an event theme as I am not sure that our agency is ready to change out tables to add SQL geometry. I am using SQL 2008 R2 SP2 with ArcGIS 10.1 SP1. The existing SQL table contains the following fields [ATTACH=CONFIG]29289[/ATTACH] I appreciate any further assistance you can provide. Thanks, Mele
... View more
11-22-2013
08:01 AM
|
0
|
0
|
4886
|
|
POST
|
I was watching an ESRI video called "Web Enabling Databases with ArcGIS for Server" and I thought I heard them say that SQL Geomety could be created on the fly in a view or in ESRI terms with a Query Layer. I have a couple of SQL tables that have LAT/LONG and I would like to used this information to create SQL geometry for each row rather than creating an event theme from the LAT/LONG values. Due to restrictions on the database table, I am not able to add a Geomtry field to the table itself so I thought I would try to do it via a view/query layer and bring it into ArcMap that way. I have not been able to find any examples of doing this. Let me know if this is possible and more importantly, if there are some examples of doing so. Thanks, Mele
... View more
11-22-2013
07:05 AM
|
2
|
6
|
9483
|
|
POST
|
Just started to play around with the 3.7 API and found the refreshInterval property very interesting. I am able to set a value on a ArcGISDynamicMapServiceLayer and watch our vehicle locations update using the code below: var wtrvehMSL = new esri.layers.ArcGISDynamicMapServiceLayer("http://arcserver/ArcGIS/rest/services/WaterWO/Water_WO_Misc/MapServer",
{
[INDENT][/INDENT]refreshInterval: .05
}); Pretty cool stuff, but when I try to use a FeatureLayer, the map does not refresh. I have tried using all different modes, but no luck. Has anyone tried this yet with a FeatureLayer and if so do you have some code that worked? Thanks, Mele
... View more
10-02-2013
01:06 PM
|
0
|
0
|
2204
|
|
POST
|
I have a .NET application that uses an ITable to input into the Append Class from the DataManagementTools Namespace. I would like to send a subset of the ITable selected rows as input to the Append Class, but am not sure how to create this. I tried using the ITable.Select Method, but this returns an ISelectionSet. I would like what amounts to a view of the ITable by applying a QueryFilter. Any ideas on how to do this? Thanks, Mele
... View more
08-28-2013
03:37 PM
|
0
|
1
|
784
|
|
POST
|
Thanks Ben, I did find the FEATURE_LAYER.fields object and its Aliases. What I would like to do is use that to substitute the field name results of getSelectedFeatures, with the Alias programmatically. Please let me know if anyone has a code sample. Thanks, Mele
... View more
07-19-2013
08:56 AM
|
0
|
0
|
752
|
|
POST
|
I am using the selectFeatures method on a Feature Layer to select features. Upon completing the selection, I am calling the .getSelectedFeatures method which returns the features and their attributes selectecd from a FeatureLayer. I would like to get the Alias and value, rather than the field name and value to display in a form. How can I get the Field Alias and Field Value after executing the getSelectedFeatures method? Thanks, Mele
... View more
07-19-2013
08:27 AM
|
0
|
3
|
1279
|
|
POST
|
Thanks for the link to the existing thread. I ended up using this code from the linked forum post in the init function and it looks promising for fixing our issue: esri.setRequestPreCallback(function (ioArgs) {
try {
if (ioArgs.url.indexOf("FeatureServer") > -1 &&
ioArgs.content.returnGeometry == true) {
ioArgs.preventCache = true;
}
return ioArgs;
} catch (e) {
console.log(e.toString());
return ioArgs;
}
});
... View more
07-19-2013
08:07 AM
|
0
|
0
|
614
|
|
POST
|
We have a JavaScript web application running on IIS that allows users to delete and add features using an ArcGIS 10.0 Feature Server and we recently encountered a new issue. When a Feature is deleted from the map, it is removed from the SDE database and from the current view. However, when zooming out, the feature can be seen at other map extents if it existed when the application was started. Also, if a feature is added, it is shown in the current view, but cannot be seen at other views. The feature remains selectable as well. To investigate the issue, we used Fiddler and IE Developer tools to see the requests. In the IE Developer Tools, we can see that the Requested Query on the Feature Layer is getting a cached copy of the Query and not going back to the Server because the Result shows a 304 code. To test this out, I changed my IE browser to ???Always refresh from server??? and this resolved the issue, but I would like the Tiled services to utilize cached data and this is an all or nothing setting. \We are using the ON_DEMAND mode on the Feature Layers used for editing We had not seen this until a recent republish of the website. I don???t think it is practical to force our users to change their browser settings. Is there a setting in IIS that can be used to change this behavior or something in the application that is making this happen? Thanks, Mele
... View more
07-12-2013
12:16 PM
|
0
|
2
|
1314
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-20-2025 05:21 AM | |
| 1 | 03-13-2015 04:39 PM | |
| 1 | 09-18-2025 08:33 AM | |
| 1 | 05-12-2025 03:17 PM | |
| 1 | 08-15-2025 03:36 PM |
| Online Status |
Offline
|
| Date Last Visited |
Wednesday
|