Latest Contributions by ChrisBeaudette

I realize that this is not an ArcSDE or geodatabase question, but I thought some Oracle types might know the answer.  Note that I also posted this question to the ArcGIS Server v10 group... We have ArcGIS Server v10.0 SP5 (32 bit) and Latitude Geographics' Geocortex Essentials (64 bit) installed on the same server (Windows Server 2008 R2). We're using a 64-bit Oracle client since we have Oracle datalinks in GTX Essentials. We also want to start using query layers in ArcGIS Server, but we have to use a 32-bit Oracle client to do so. We can configure the MXD successfully but when we publish to ArcGIS Server and attempt to start the service, we get a 'server library could not be loaded' error, most likely because AGS is 32-bit and cannot be used w/ a 64-bit Oracle client. We installed the 32-bit client as well so now both it and the 64-bit Oracle clients are on the same server with different ORACLE_HOMEs. I tried creating a logon script for the ArcGISSOC user account that sets the ORACLE_HOME environment variable and pre-pends the PATH env var with the 32-bit ORACLE_HOME/bin directory, but I'm still getting the 'server library could not be loaded' error when starting the ArcGIS Server service. Our ArcGIS REST service app pool uses the 'ApplicationPoolIdentity' which is a virtual account. I can set the app pool 'Load User Profile' setting to True for ApplicationPoolIdentity (or some new Identity that I create) and potentially set the ORACLE_HOME and PATH variables there to see if that fixes it. But this is a production environment so I want to be fairly certain that this will work before making a potentially intrusive change. (And I don't have another server with a similar setup to test it on). Is it possible to force ArcGIS Server to use the 32-bit ORACLE_HOME when all other apps on the server are using a different (64-bit) ORACLE_HOME? If so, how can this be done? ... View more

I'm attempting to use arcpy.TableCompare_management and am passing tables that have a SHAPE.STLength() field, since we're using SQL Server Native spatial types.  I include 'SHAPE.STLength()' in my "omit fields list", but it throws the error: omitFields = ["SHAPE_Length", "SHAPE.len", "SHAPE", "OBJECTID", "SHAPE.STLength()", "STLength__"] arcpy.TableCompare_management(baseTable, testTable, "OBJECTID", "SCHEMA_ONLY", "", "", omitFields, "CONTINUE_COMPARE", "") ExecuteError: ERROR 000622: Failed to execute (TableCompare). Parameters are not valid. ERROR 000800: The value is not a member of OBJECTID | AUTOCAD_LAYER | PIPENO | ASSETNUMBER | SHAPE | SHAPE.len | SHAPE.STLength(). ERROR 000800: The value is not a member of OBJECTID | AUTOCAD_LAYER | PIPENO | ASSETNUMBER | SHAPE | SHAPE.len | SHAPE.STLength(). Failed to execute (TableCompare). If I run TableCompare in ArcCatalog, the field shows up in the list of available fields to omit, and when I do so it works fine.  If I do an arcpy.ListFields on the feature classes, it correctly shows me the SHAPE.STLength() field: SHAPE.STLength() is a type of Double with a length of 0 Any thoughts on how I can get arcpy.TableCompare_management to work as I need it to? ... View more

We are having the exact problem posted at this thread from the 'Desktop General' forum.  Thought this forum might have insights. Thanks, Chris ... View more

I have a feature class that through a series of unfortunate events, I can no longer see it in ArcCatalog.  However I have a backup in another geodatabase and when I try to copy the backup fc to my original geodatabase, it complains that it already exists.  And indeed it is visible in SQL Server Mgmt Studio, but doing 'sdelayer -o describe_long' or arcpy.ListFeatureClasses does not display the feature class. I'm using SQL Server 2008 SP3 and ArcSDE v10.0.  The series of "unfortunate events" includes updating a field value using TSQL and running a delete_features tool against it. Any ideas how I can remove the feature class so that ArcSDE is no longer half aware of it? ... View more

I'm trying to add an AGS v10 layer to an OL map but it only seems to work if: - map.projection = WGS84 - map.displayProjection = WGS84 - isBaseLayer = true My end goal is to use Bing or ESRI cloud-based maps in EPSG:900913 as the base maps, so my map.projection will be EPSG:900913 and my map.displayProjection will be EPSG:4326.  But the only way I can get AGS v10 REST and WMS services to display in an OL map is to set the map.projection, map.displayProjection and layer.projection to EPSG:4326. I'm using OL v2.11. I have AGS v10 services published as both REST and WMS.  The CRS of the REST service is '102100 (3857)'. EPSG doesn't recognize 102100 which I believe is ESRI's own designation, so I experimented using 3857. If I view the service in an ESRI client (ArcMap, ArcCatalog) then it displays with the correct projection.  But the only way I can display the layer at all in an OL map, whether using a OpenLayers.Layer.ArcGIS93Rest or a OpenLayers.Layer.WMS layer, is to use 4326 for both map.projection and map.displayProjection, which of course will not overlay on top of the Bing/ESRI base layers in EPSG:90013. While I'd prefer to be able to use WMS, any workaround would be acceptable.  I wasn't able to get WFS to display at all, but that may be because I don't have all the OL layer params that are required.  I tried: var layer = new OpenLayers.Layer.WFS(             "Counties",             "http://myserver/arcgis/services/county_wm/MapServer/WFSServer?",                         { layers: "0" } ); I found this information as well and tried that solution using a map.projection of 3857 for map.projection, map.displayProjection and layer.projection, e.g.: var options = {     'units': 'm' }; var map = new OpenLayers.Map('gxmap', options); mapprj = new OpenLayers.Projection("EPSG:3857"); dspprj = new OpenLayers.Projection("EPSG:3857"); map.projection = mapprj; map.displayProjection = dspprj; var layer = new OpenLayers.Layer.WMS(     "Counties",     "http://myserver/arcgis/services/county_wm/MapServer/WMSServer?",     {         layers: "0",         format: 'image/png',         srs: 'EPSG:3857'     },     {         opacity: 0.5,         singleTile: false,         projection: 'EPSG:3857'     } ); but still no go.  My WMS capabilities file for this layer looks thus: <Layer queryable="1">     <Name>0</Name>     <Title>         <![CDATA[ county_webmerc ]]>     </Title>     <Abstract>         <![CDATA[ county_webmerc ]]>     </Abstract>     <CRS>CRS:84</CRS>     <CRS>EPSG:4326</CRS>     <CRS>EPSG:3857</CRS>     <EX_GeographicBoundingBox>         <westBoundLongitude>-90.4182892958519</westBoundLongitude>         <eastBoundLongitude>-82.4134778047652</eastBoundLongitude>         <southBoundLatitude>41.6961255799368</southBoundLatitude>         <northBoundLatitude>48.262692384982</northBoundLatitude>     </EX_GeographicBoundingBox>     <BoundingBox CRS="CRS:84" minx="-90.4182892958519" miny="41.6961255799368" maxx="-82.4134778047652" maxy="48.262692384982"/>     <BoundingBox CRS="EPSG:4326" minx="-90.4182892958519" miny="41.6961255799368" maxx="-82.4134778047652" maxy="48.262692384982"/>     <BoundingBox CRS="EPSG:3857" minx="-10065317.9228131" miny="5115568.65804322" maxx="-9174226.38372922" maxy="6150669.28758651"/>     <Style>         <Name>default</Name>         <Title>0</Title>         <LegendURL width="32" height="16">             <Format>image/png</Format>         <OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="http://gis4/arcgis/services/MI/county_wm/MapServer/WMSServer?request=GetLegendGraphic%26version=1.3.0%26format=image/png%26layer=0" xlink:type="simple"/>         </LegendURL>     </Style> </Layer> Have also tried using 'crs' for layer instead of 'srs' per this thread, but still no go. Also worried that the 'isBaseLayer=true' will be required even if I do figure out the projection issue, since I need to display these as overlays. Has anyone been able to get a non-WGS84 ArcGIS v10 layer -- either REST or WMS -- to display in an OL map? ... View more