Latest Contributions by MarcoBoeringa

Actually, in the Oracle trace, it more looks like it is being attempted to set a lock, instead of deleting one... although it might be that an attempt is made to delete a lock before setting it as part of the procedure to set it. By the way, I see the knowledgebase article also talking about an open state... have you attempted to load any data using the ArcSDE command line tools, e.g. by setting a layer to load only IO mode and loading data, and possibly forgotten to set it back to normal IO mode? If the layer wasn't taken out of load only IO mode, you may be running into issues as well. If you have the ArcSDE command line tools installed, an "sdelayer -o describe_long ..." type command output may be useful, especially for Vince once he joins here... For some syntax examples regarding IO mode, see here: http://support.esri.com/en/bugs/nimbus/TklNMDU1NDQ5 and for comprehensive sdelayer syntax including "sdelayer -o describe_long" help (10.0): http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/datamgmt/sdelayer.htm ... View more

Considering the error points to a Stored Procedure part of the SDE schema, it seems to attempt to remove a particular database lock, which fails, as Oracle returns it apparently as "non-existent". Are there multiple Feature Classes involved in the replica? You might be able to get a better view of the issue by looking up the code of the Stored Procedure named "sde.lock_util.delete_object_lock" in the SDE schema, but I strongly urge you not to make any modifications (e.g. insert debug code), unless you are a very experienced DBA. I wonder if you might be able to find out which table or row is affected by using any of the information in the  "<220772,22580,1,999,N>" string, which seems a kind of "identifier" for the lock. I guess this requires more knowledge of Oracle locks than I can provide. ArcGIS 10.1 provides options for viewing locks in the Geodatabase Administration, but that doesn't help you on 9.3.1... But there is probably a ton of information regarding Oracle locks, here is one I googled: http://www.dba-oracle.com/t_locked_rows_user_locks.htm Well, Vince is probably going to give more concrete answers... or point you to Tech Support, where the question may belong. *** EDIT *** I now found this knowledgebase article referencing ORA-20048 http://support.esri.com/fr/knowledgebase/techarticles/detail/33111 This article suggests open edit sessions created on the database level against the Multiversioned (Versioned) Views. Have you attempted to edit any of the Feature Classes in your geodabases using SQL at the database level, and maybe forgot to close a SQL edit session? ... View more

You probably already know it, but this White Paper might be of some help: Compressing ArcSDE Geodatabases That Contain Replicas -Best Practices As per the document referenced above, it almost sounds like your replication setup is Two-Way, instead of One-Way. The document describes a situation where this may result in no changes being compressed on the Child, unless the Child is synchronized with the Parent with changes being sent from Child to Parent (even if no changes were made), see page 11. ... View more

Hi Erin, I have a few remarks based on your comments: - First and foremost, I really think you should try and contact a statistician at your university to help you out on ways to analyze this data. I am not a statistician myself, nor researcher at the moment (although I have an MSc in Biology), but I have never understood the great reluctance of some researchers to call in external help on this. They spend years and tons of money collecting data, and than "forget" the need for proper analysis. Even if it is "just" a master thesis, you have collected data that may be valuable to others and your guiding professors / PhD students. Yes, the statisticians may be busy and difficult to get hold of, but may be of invaluable help in showing you the ways to handle your data. - You suggest having multiple factors influencing your growth / yield data (soil parameters, treatment types). Many of these may be correlated to each other. You may not get significant results putting one parameter (e.g. soil nitrogen content) against the yield data. Often, it may be necessary to analyse all data / multiple parameters at once, in one statistical analysis. You may either need or want to bundle multiple dependent or independent variables to get meaningful results. There are methods for that in statistical packages, e.g. like the MANOVA I wrote, but there are others as well. Have a clear look at all the options in the statistical package, or read Wikipedia pages etc., so as to understand the uses of different methods of analysing your data. - You wrote: The issue for my data is that well its kinda "parabola shaped" Often, it is necessary to normalize your data by applying a transformation, e.g. taking the log of measurements before analysing the data. Most statistical methods assume normal distributions of the datasets, if your data isn't, you should transform it before analysis. Most statistical packages, and also ESRI's Geostatistical Analyst, offer options for testing for normality, and allow you to choose a proper transformation that best fits your data. - I also think you should have clear Hypothesis in order to test your data statistically. I get the feeling you are still in the process of trying to find out what questions you exactly want to answer... while already having collected all the data! - Based on your additional information in your last post, this re-affirms my believe you should first analyse the data using normal statistical methods before venturing into the world of "geostatistics". I don't think this kind of data is well suited to geostatistical analysis. ... View more

Well, you may already know it, but the System Design Strategies Wiki pages are probably your first stop for ideas about a possible solution to this problem. There is a ton of useful information there that may help you make concrete decisions... ... View more

My question being a newcomer to the geostatistcal analysis is what tools should I use to show the relationship of texture to its nutrient holding capacity of the soil as well as its affect on plant maturity and structure. I've talked to my professors who have basically given me little to no help in where to start with my massive load of data. Any advice? To be honest, I would be very weary of using Geostatistical Analyst for something like soil data. Soils and rock types often vary very erratically, meaning the data doesn't conform very well to basic assumptions / prerequisites for interpolations. It often violates continuity prerequisites. E.g. you can have two points close together having completely different soil types (e.g. peat / sand) over a very short distance, leading to entirely different measurements as well. I think your best bet for analyzing this data, is to start out with classical statistical analysis. Forget about Geostatistical Analyst, and use a program like S-PLUS, SPSS or any of the other multitude of commercial or Open Source statistical packages to do an Analysis of Variance (ANOVA) or Multivariate Analysis of Variance (MANOVA). There may be other tests suited to your type of data as well, have a careful look at the prerequisites for each test to understand its uses, and maybe contact a statistician at your university for some good advice. It should give you a pretty good idea of whether there are any statistical relationships / correlations between your soil textures and plant maturity. I did something similar during my Biology study based on growth data of transplanted species moved to different succesional zones on a beach plane. Once statistical correlations have been determined, you might consider creating maps by simply classifying a soil type / geological map or any other base map related to your data, based on the results of the statistical analysis.  I know it isn't as "attractive" and "fancy/in vogue" as a colorful Geostatistical Analyst map, but do you want sound statistical analysis, or just wall paper? 😉 (no pun intended, I just want to make the point). By the way, I am not suggesting Geostatistical Analyst and its interpolation methods do not have its place in your type of research. There may be cases where it is entirely valid. I am just saying that you should be careful applying it and mind the prerequisites, and never forget that there is the option of "non-spatial" statistical analysis, that you may even need to consider first, before venturing into the world of geostatistics. ... View more

The first thing that comes to mind is Representations, as those are indeed stored in the geodatabase. You can even have multiple different "Representations" for a single feature or group of features. Also see: A quick tour of representations In addition, you might wish to have a look at a specialized product of ESRI like ArcGIS Schematics. ... View more

Anthony, we don't fully support AlwaysOn at 10.1. At 10.1 you can connect to a read-only database, not a geodatabase. The ability to connect to a read-only geodatabase will be part of the 10.2 release. The ability to do read-only routing via the Listener using the APPLICATIONINTENT connection parameter will be available in the following release. -Shannon For those of you like me who wanted to know more about this and what for example the ApplicationIntent keyword means, see this Microsoft link and especially the video (switch to HD and full screen to get a better view of the demos): http://www.microsoft.com/en-us/sqlserver/solutions-technologies/mission-critical-operations/high-availability.aspx ... View more

The thing that I find confusing is the link to the SQL Server Native Client 11.0 article in that it does not list Windows 8 or Windows Server 2012 as being supported.  I assume that that is just an oversight, correct? No, it isn't. It seems Microsoft recently decided to rename the SQL Server Native Client, and it is now called: "Microsoft ODBC Driver 11 for SQL Server on Windows" (/ Linux in the Linux version). See this Microsoft Blog post: Introducing the new Microsoft ODBC Drivers for SQL Server And also see the download page for the Microsoft ODBC Driver 11 for SQL Server on Windows: http://www.microsoft.com/en-us/download/details.aspx?id=36434 It lists Windows 8 under System Requirements... ... View more

is there a way to know the version name for each feature that posted in default version. please help, i need this so bad. thanks Not a direct answer to your question, but as to standard supported functionality that might fulfil your needs, 10.1 introduced "Editor tracking": http://resources.arcgis.com/en/help/main/10.1/index.html#//01m600000068000000 As long as you haven't compressed the database to state 0, I could also imagine some of the information you might need is in the geodatabase system tables, e.g. versions, states and lineages tables combined with A/D, but I can't give you any real clues as to how to get that info in terms of SQL just like that. Vince may be able to give directions, if any... ... View more

Jamal, I haven't yet had time to test the replication of a table myself, but this Help page says: "For tables the default filter is Schema Only; only the schema for the table will be replicated. To apply a filter to a table you must first create a table view setting desired filters. You can then use this as input into the Create Replica tool. See the Make Table View for more information. For more information on filters and replication see Preparing data for replication." It seems you may need to make a Table View first, and use that as input for the Create Replica tool. I don't know the reason for this, except maybe that most (or some) stand-alone non-spatial tables part of geodatabases, may actually be very big and actively maintained tables from business systems, for which it is better to only replicate a selection of the data really necessary in the child replica, to avoid excessive data traffic between parent and child. ... View more

Why tables participating in replica are found to be empty on the child geodatabase? Jamal, I think Jake Skinner (ESRI) described the issue and solution in this thread: http://forums.arcgis.com/threads/46668-Non-spatial-table-replication The screenshots in that thread are no longer there, but the setting Jake is referring to is the one under: Expand Feature Classes and Tables (optional) in the Create Replica dialog. You need to choose "ALL_ROWS" instead of "USE_DEFAULTS" to add all records in case of tables. ... View more

Does a geoprocessing tool exist that can find all DTED tiles that intersect an AOI (or Polygon feature class)? I have a area of interest represented by a polygon and DTED tiles (some of which intersect with the AOI). Is there a tool that I can use to find which tiles intersect? Thanks! If you create a Mosaic Dataset, you can than use the included Footprint layer of the Mosaic to find out which DTED tiles intersect your AOI. ... View more

What I wanted to highlight here is that the order of versions when reconciled/posted with the parent is determinant! In my previous example, if the first version is U2 and the second version is U1 then feature 10 will be deleted from the target. Correct? Not necessarily..., it may get a bit complicated now, but versions reference so called "database states". Each time you make any type of edit to a Feature Class, you create a new "database state", and the version starts referencing that state from that moment onwards until the next edit completes. The database state references a certain combination of records in the base table and A/D delta tables. Your single version may actually go through a whole set of "states" during its life-time until you delete the version once you no longer need it. Even during a single edit session (the time in between clicking Start Editing and Stop Editing in ArcMap), your version may go through multiple states, as you can perform multiple edits in a single edit session. It is the time you complete your edits (transaction closing time?) to specific records / geometries, which ultimately determines which records / geometries might be considered the "valid" or last "state" of the object they represent. It is this time and database state information that is used in the (batch) reconciliation and post process to determine if there are any conflicts due to other users having edited, saved and posted the same object to the same target version before you post it. You can than use the reconciliation tools to review the conflicting states and determine whether you favor the current target, or your own edit version. So don't confuse the creation time of the version with the save / completion times of specific edits to specific records / geometries. Jamal, I also strongly encourage you to read Derek Law's basic introduction to versioning to better understand what is going on "under the hood": Versioning 101 And for a really comprehensive overview (older 2004 document, but the mechanism of versioning described there is still highly relevant): Versioning - ESRI Technical paper ... View more

Are there any potential security issues with using a FGDB over a RDBMS? What do yo mean with "security issues"? File geodatabases are just a bunch of (binary) files stored on a drive. They differ in this in no way of a set of normal HTML files representing a basic website, or the individual files making up an ESRI Shapefile. There is no inherent security mechanism in the file geodatabase itself, like database authentication. If access to the FGDB needs to be restricted, than you need to use the normal web authentication methods to restrict access to the website hosting it (password protected HTTPS site?). In a sense, file geodatabases may be a "more" secure method of hosting the data, as there is no RDBMS system to be potentially compromised and made wrong use of. ... View more