Latest Contributions by MarcoBoeringa

ArcGIS supports so called "Configuration Keywords" that determine the spatial storage type in an ArcSDE geodatabase. You set the configuration keyword when creating a new Feature Class. If you create a new Feature Class, and set the spatial type to SDO by using the "SDO_GEOMETRY" configuration keyword, and than import the existing Feature Class's geometries / features to the new one, you will have converted the data to SDO_GEOMETRY. ... View more

This is my understanding of what is present: sde: oracle10g <-> Oracle 11g client <-> Oracle 11g Server My understanding too. The "sde: oracle10g" invokes Oracle's 10g libraries (oci.dll), for which Oracle provides reverse compatibility in the 11g client.  This is not an Esri-tested and certified configuration.  It may work, but it cannot take advantage of any 11g capabilities present in the sdeora11gsrvr101 DLL. Do I understand it well that the 10g libraries are separately included with the 11g Client install?, or is the oci.dll just "equipped" with the capability to handle 10g type connection requests ("sde: oracle10g"), invoking a different path in the code? Any known 11g specific capabilities in the sdeora11gsrvr101 DLL? Do I need to think in terms of support for newly introduced native Oracle data types via ArcSDE configuration keywords, and not so much in terms of actual geodatabase functionality, as that is more depended on the geodatabase level (9.x, 10.x etc.), and not so much the database? ... View more

Esri supports Oracle 10g with the 10g client and Oracle 11g with the 11g client, using Oracle's client drivers.  While 10g clients may be able to connect to 11g servers, I doubt you'll always have a fault-free path. Vince, the OP isn't using Oracle Client 10g against an 11g Oracle server. Just read the first post again: I have an environment where the Oracle SDE database has been upgraded to 11g from 10g, but the desktop clients remained at 10g due to the huge number of mxd layers that would need to be converted to 11g in the connection parameters.  I have started writing python code to convert these layers in a batch mode.  While performing this testing I noticed that even though a test computer has no 10g Oracle Client software but it does have 11g Oracle Client software installed, the connections to SDE still work. As such, it would appear from the surface that this big conversion job is not necessary.  My question would then be what functionality would I be missing if I leave the Oracle 10g client connections (--> EDIT: Probably the ArcGIS connection files) in place, even though the desktop computers would have the 11g Oracle Client software installed on them? If I understand it well, it is just the ArcGIS connection files that have originally been created while the Oracle Client 10g was still installed, and that the OP thought needed reconfiguration. ... View more

Derek, A couple of quick remarks. One thing I think ESRI is slightly forgetting in the new design of the last couple of years, is that one of the most frequent ESRI website user groups are the developers and advanced (geodatabase) GIS managers, not just the ordinary ArcGIS or GIS webapplication users, the last group may not even know they are using ESRI software at all, nor have ever heard of the company or know what the ESRI acronym means! Developers and data managers may visit the site on a daily basis to find important data and information to help them get along with their latest project. They aren't so much interested in "Communities", as each project they do may actually be in an entirely different "Community"... such is developer work... they simply want the quickest access to API, Help, whitepapers, technical papers there is to solve urgent issues they have and find out how to do things. And in terms of "Communities", the only thing they are probably really interested in, is the Forum pages, to get direct help of peers... One example that could use improvement, is the link to the API (Help) references that is "hidden" under the "Help" menu option in the ArcGIS Resources section (http://resources.arcgis.com/en/home/), while I think many developers would prefer a separate direct API's menu option in the same main menu. This would also cut back on the great amount of links under the "Help" section. The same link to the API's list could be under the important: http://support.esri.com/en/ page, which already gives direct access to many important things for developers and GIS geodatabase administrators. I think separating out the "Developer Help" from the other help sections ("ArcGIS Help", "Application Help" etc.), and giving a more prominent position to the API references with all the object models, interfaces etc, via a direct link in the main menu's of the Support and Resources pages would at least be one change of use to many. I also think "API (References)" is a better name for this than "Developer Help", as most developers are more used to that first term when searching for details on object models, classes, methods and interfaces. ... View more

The role of the Oracle Client in ArcGIS Geodatabase behaviour and functionality is actually quite minimal to nil to my knowledge. Oracle Client is just necessary to make an ODBC connection to your database and send back and forth SQL transaction data, it acts as a kind of "bridge" between the ArcGIS client and your RDBMS, just like any normal ODBC driver. It is the Geodatabase level (ArcGIS 9.x, 10.0, 10.1 etc.) that mainly determines what you can or can't do on a Geodatabase and in ArcGIS. ... View more

Jamal, When you get to the grant privliges window have you selected grant from the drop down list under select? Regards Anthony My idea too when looking at the screenshots. ... View more

Have you verified you have all required privileges, especially those listed under the "Geodatabase administrator" section in the Help link below?: User privileges for geodatabases in DB2 http://resources.arcgis.com/en/help/main/10.1/index.html#//00290000003m000000 ... View more

That's nice but the problem is that the lake is shrinking not expanding and the DEM doesn't tell me the elevation under water so I can't get the elevation under water body !! The only reliable way in case of a shrinking lake would be to determine the bottom surface by means of sounding, for example using a multi-beam sonar, and than use that to fill up the gap in the DEM. A crude alternative is to determine some weighted centre point of the smallest circumference, and than model the shrinkage in let's say each degree direction of 360 degree round based on your existing shapes, and than use that somehow as input for an ArcGIS spatial adjustment rubbersheeting operation to automatically define "displacement links". But this isn't going to be an "easy" solution and modelling operation... ... View more

Jamal, You probably have, but since you don't state it, I ask it here explicitly anyway: have you run the same SQL statement in SQL Server Management Studio without the redundant "TOP 1000" keyword text? Did you get the same results (it should, but who knows...)? I think you can simply remove the "TOP 1000" text in the edit / SQL window visible in your screenshot, and than hit "Execute" to do this. I also think it may be time to have a closer look at all the new tools in the Geodatabase Administration toolset, and see if you can figure out if there are any differences in the reported geodatabase state before and after each run of the script. I know you already looked at some of these options, as it is in your screenshots, but have you checked everything? ... View more

Because in all case, in my particular database the number of records is less than 1000! This is why I aimed at using that option. Still don't get it... If you only have a test database with a couple of records like yours, TOP can be left out. I think there is not much use for this option anyway, unless in very specific cases or running test queries against very large datasets. And your target was to determine if all edits of the database were properly reconciled & posted & compressed to the base table, so you want all records. And if you entered "SELECT TOP 50 PERCENT" in the query that I can't read from your screenshot, that would definitely explain 20 records of 41 being returned from the feature layers base table even with a successful operation... :rolleyes: But I figure I don't have to explain that to you! 😉 Best, Marco ... View more

Jamal, Although the first screenshot is not fully displaying your SQL statement, I think I see a "SELECT TOP" statement being used in SQL Server Management Studio. Why do you use the "TOP" keyword, as it is normally used to restrict the number of records returned in case of very large tables and query results? This option shouldn't be used if you want to return all records of the feature layer's base table after having run the Python script, you should use a plain "SELECT" statement. ... View more

Jamal, The Help says that the Input database connection defaults "to use the workspace defined in the environment". Since I already see the versions filled out in the dialog, I don't think there is any need to fill in the "Input database connection", as it probably just uses the connection information from the context from which you opened the option (in your case I guess the Geodatabase Administration dialog). I think the "Input database connection" text line is just an "extra" available for when you use the Reconcile Versions option straight from ArcToolbox, in a ModelBuilder model, or in Python scripting, when the connection isn't yet defined. It would have been better if unnecessary options were hidden in specific cases like this, but I guess this is the small price we need to pay for something like the flexible ModelBuilder and ArcToolbox framework. ... View more

How was this data loaded in your ArcSDE geodatabase? ArcSDE normally runs a thorough check during loading of data using ArcGIS tools, preventing self-intersecting geometries in your database, but if this was an already existing spatial database without ArcSDE geodatabase repository that you "enabled" as a geodatabase, there may be invalid geometries / shapes in the database. Anyway, running the Check Geometry and Repair Geometry tools is likely to fix these issues. ... View more

@ldonahue: It is registered as versioned but without the option to move edits to base. I've corrected my first post. @vangelo: with mv_view I can't create a join between two tables. I'm using ArcGIS 10.0 SP 5. I was under the impression that if you were creating sde views on versioned data that once you reconcile/post/synchronize, that your sde view will be updated. This section of the ArcGIS Help page "What are versioned views?" may be of relevance: "Versioned views do not work with functionality implemented at the geodatabase level. Therefore, they should not be used to edit data that participates in geodatabase behavior. See What type of data can be edited using SQL for more information. If you query a versioned view without setting the version and state, you are referencing the current state of the DEFAULT version. If other users are committing edits to the DEFAULT version (thereby changing the state that the DEFAULT version references), your subsequent queries will see the latest state of DEFAULT and their edits. If you specify version to query using the set_current_version function or procedure (names vary slightly depending on your database management system), you are referencing the state that the specified version was referencing when you set the version. For example, if you run the set_current_version function to set the version to a named version called decedits and decedits is pointing to state 4 in the state tree, all subsequent SQL queries you make against decedits will see state 4 of the data even if other users are posting edits to decedits, causing the current state of decedits to be state 25. To see state 25, run the set_current_version function again to set the version to the current state of decedits." ... View more