Latest Contributions by MarcoBoeringa

Many thanks guys for the help, All what I did is giving the user �??never notify�?� property in the user account control (UAC). And it did work. I could edit the applications [ATTACH=CONFIG]24048[/ATTACH] What do you think? Best Jamal "Never notify" means that you also will no longer receive messages when any malicious software attempts to make changes to your server. Making a more "surgical" change by following the instructions in the link posted by PietaS175 and only allow the minimum necessary to solve your issue is a more appropriate action if you like to follow "best practices". ... View more

Problem: There will be 10 field guys with laptops with a stripped down ArcGIS on it. They will click on a point (Pole) and a access database form will appear with nested (relationships?) form for the field guys to fill out. The updating features, all the poles are GPS located in the database and have a xy and pole number. This inventory system will have the field crew out and they will fill in the data asked on the nested form. This data will be "new data" added to access columns and selected from drop downs on the forms. Sometimes, the forms will already have data such as "last maintenance" and the field will be updated with the current date. The current data is in a SQL geodatabase. Do I understand it right you are using a Microsoft Access database as a fore front to a SQL Server enterprise database, and call these Access forms from a custom ArcGIS Engine application? To be honest, if so, this might be a better question to pose on a Microsoft Access/SQL Server forum. I don't think to many people here have dealt with this specific setup and will be able to answer this Access specific question. Thanks for your response. I know how to make drop downs, but need nested drop downs. For example, we want logical drop downs, when selecting a utility pole, if you select a wood pole it will give you the wood pole manufacturers and not the metal pole manufacturers and so on. This specific requirement sounds like you want Geodatabase subtypes with their own domains. Start looking into that: A quick tour of subtypes ... View more

Besides installing SP1 for 10.1, there is also a patch you probably want to install. Although you didn't mention it, I assume you are running SQL Server based on the "DBO" type error. It is always good practice to mention all the details of the platform you are working with here on the forums. There is a patch for 10.1 that adresses an issue with replication: ArcGIS 10.1 SP1 for (Desktop, Engine, Server) SQL Server 2012 Support Patch http://support.esri.com/en/downloads/patches-servicepacks/view/productid/160/metaid/1954 The issue described is not yours, but might be related. Can't hurt to install the patch. ... View more

I'm am trying to create new replicas for our new 10.1 Geodatabase. All data is registered as versioned and I have added Global ID's. I am creating a One Way Parent to Child Replica....Register Existing Data only.... I keep getting this error: Create Replica Failed                                      The item was not found                                      Version not found [DBO.sync__send_593_0] (the number changes everytime) Any suggestions?? Was this database upgraded from an earlier versions of ArcGIS? I do see a couple of known and fixed issues listed with the same "Version not found" error on the ESRI website concerning replication: Bug:  Upgrading geodatabases with replicas to version 10 causes the synchronization process to fail ArcGIS 10.0 (Desktop, Engine, Server) Geodatabase Replication Upgrade Patch It may be time to call ESRI technical support... Anyway, maybe this Forum thread is of some help: http://forums.arcgis.com/threads/44790-Synchronize-Replica-Failed-Version-not-found-issue And maybe this is of some help, see the text below from this help page with error messages from ArcSDE: Version not found (-126) "The specified geodatabase version does not exist for this geodatabase. Be sure the geodatabase version you specified is valid for the geodatabase to which you are connecting. This is most often encountered when connecting to a dbo-schema geodatabase in SQL Server. In these geodatabases, the DEFAULT version is owned by dbo, not sde; therefore, to connect to the default version, you must specify dbo.DEFAULT." Is your parent database DBO owned (are the SDE system tables in the DBO schema)? ... View more

I think the length and complexity of this thread make a VERY good case for someone overhauling BOTH the ArcSDE and ArcGIS Server installation documentation. Well, it isn't an overhaul, but I now published a document describing "The ESRI Geodatabase Framework" (as I call it and see it) in another forum thread. It may be a good read for people interested in the contents of this thread and help out with a better understanding of 2-tier Direct Connect and 3-tier Application Server connections to geodatabases: "The ESRI Geodatabase Framework" PDF Please post any comments to the document in that thread and not here. Marco ... View more

This was finally the trick - I didn't realize that the -r -v combos were actually the type of thing being modified and then the actual entry.  I couldn't make sense of that in the instructions anywhere.  So once we figured out that you could only run one combo of -r and -v that did the trick, but we had to do both, one for the database name, another for the User.  Thanks. Good to hear you got it running. I admit the examples given in the Help page I linked, although this page gives a quite comprehensive overview of the actual "sdeservice" command and all its options, aren't the best. The examples and the way they are represented, are confusing. Marco ... View more

What sort of solutions for such very challenging issue? At the end of the day, I need to have a safe copy for my mdf files Best Jamal Jamal, The solution is not to rely on synch software, but to use the build-in options of the DBMS to do the job in an automated scheduled way. Here are some links that may be of use for SQL Server, but you can find a ton others by Googling: http://msdn.microsoft.com/en-us/library/ms186289.aspx http://technet.microsoft.com/en-us/library/ms187510.aspx http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx http://outcoldman.com/en/blog/show/214 ... View more

Why would a software vendor not make this easier.  Oh, so dummies can't muck it up? Or so the administrators can't get the systems to work? This has been a complaint for years, and ESRI more or less finally listened by providing the Geodatabase Administration dialogs and tools at 10.1, and, as you already understood, by making "Direct Connect" default as of 10.1, which takes away the burden of getting your ArcSDE Application Server service running. On the other hand, I do think to many organizations take the geodatabase administrator role to lightly, often, the role is often historically just fulfilled by anyone who happens to know "a little more" than the rest. In the land of the blind, the one eyed man is king... I am not suggesting this applies to you, just in general. To be a really good geodatabase administrator, you need to be both versed in DBA work, and know the GIS side of it all. That may require professional training through ESRI courses. "4. If you are using a dbo-schema geodatabase, type the sdeservice command with the register operation to register the user with which the giomgr will connect to the database. sdeservice -o register -d SQLSERVER,MYSERVER\SSINSTANCE -r SDE_DBA_USER -v esri_sde -i esri_sde" What is not clear is a) if SDE_DBA_USER is a specific username or is this some kind of keyword?  Or you're supposed to put in an actual user name how do you do it.  I tried mine and it wouldn't accept it. I think this Help page will help you out on the answer of your question (scroll down to "Options" - yes, it is a keyword) and any others you might have: The sdeservice command http://resources.arcgis.com/en/help/install-guides/arcsde-application-server-microsoft-sql-server/10.1/index.html#//00950000004m000000 As the above help page says, the "-r" determines which Windows registry key you are going to set. The "-v" is where you put the actual value that the registry key should take on, in your case the name of the DBA user. E.g., in your case, if you have DBO schema, the commands are probably going to look something like this. Replace everything starting with "Your" by values based on your instance. "YourDBOLoginName" is the name of the login associated with your DBO user in your SQL server instance: sdeservice -o create -d SQLSERVER,YourSQLServerInstanceName -p YourDBOpassword -i esri_sde sdeservice -o register -r SDE_DBA_USER -v YourDBOLoginName -i esri_sde -p YourDBOpassword -d SQLSERVER,YourSQLServerInstanceName sdeservice -o register -r ADMIN_DATABASE -v YourDatabaseName -i esri_sde -p YourDBOpassword -d SQLSERVER,YourSQLServerInstanceName You may need to use "-o modify" instead of "-o register" since you already made an attempt at setting these registry keys. ... View more

I also used the following command to define RASTERBUFSIZE sdeconfig -o alter -v RASTERBUFSIZE=1048576 -u sde -p SDE@INFRASIG11G_TEST -i sde:oracle11g To be honnest, this is not clear how to pick up the best value for this parameter. Can you provide a sample how to calculate using this source file. But I tried also with higher values but nothing works. If I understand it well from the Help text below: "The uncompressed size of a raster tile can be determined by multiplying the tile width by the tile height and adjusting for the pixel depth. For instance, if you use the default values of 128 by 128 for the tile width and tile height, the product of these two values is 16,384. Multiply this product by the pixel depth factor from the table below to obtain the raster tile's uncompressed size. If the pixel depth is 32, the uncompressed size would be calculated as 65,536 bytes. This is well under the 200 KB default value. However, if you decide to increase the tile size to 256 by 256, it would increase the uncompressed size to 262,144 bytes." each band of your 4 band imagery would occupy 262Kb in the buffer. So 4x262 would already mean a minimum required buffer size of 1048Kb, the one you set. But I imagine having some "overhead" is necessary too, so I would try setting a bigger value than that for a tile size of 256x256. Anyway, I have heard of issues with SDO_GEORASTER before, I don't know if ESRI actually ironed out all the issues. I don't have a setup available to test, maybe someone else with real experience with native SDO_GEORASTER on Oracle will join the thread and be able to help you out. ... View more

If I connect to 256x256 table, I see my raster in Arc Catalog, but black lines appears depending used scale. When using 512x512, this is not possible to view it. I played with RASTERBUFSIZE increasing memory, but nothing change. I am using Esri 10.1 �?? patchset 1 (last available). What type of imagery are you using (how many bands, pixel depth per band - 8bit, 16bit etc.) and what values for RASTERBUFSIZE did you try? If you are using imagery that has many bands or high pixel depth, you could still run out of ArcSDE buffer memory, even when adjusting buffer size. Have you build statistics and pyramids? Do you get the "SE_RASTER_BUFFER_TOO_SMALL (-294)" error as mentioned in the Help topic below Loading large raster datasets into ArcSDE Do you have any specific reason to use GDAL for the loading of your raster data and not using ArcGIS? Have you tried loading using ArcGIS? ... View more

None of the examples seem to address how to create ArcSDE services on DBO schema.  What are the real parameters? I've edited the sdeservices.sde file and the windows services file.  I'm using a custom named service.  It creates the service but it won't start. This is such an archaic system.  Why not a GUI?  I know you don't want us to use services anymore but I've got a bunch of things created that use them and I want to upgrade the geodb's and SDE to 10.1.  I've got 10.1 of ArcGIS, ArcGIS server, ArcGIS SDE, Windows 2008 R2, SQL Server 2008 R2, on a test server. I tried doing: sdeservice -o create sqlserver,servername -i service_name It created something but still wouldn't start. sdeservice -o register -d sqlserver,servername -r SDE_DBA_USER -v service_name -i service_name It registered something but the service still won't create.  Is SDE_DBA_USER something real?  Should I put something else there?  I tried using my DBO login but no dice.  Desperate. Karen, Whether ArcSDE Command Line is archaic or not, is up to you, but many scientific or administrator utilities still use "command line" type of operation for at least some of their functionality, or as an option to allow unattended batch operation... If you're not familiar with command line applications or geodatabase administration specifically, I really recommend you to get some ESRI training, unless you're highly experienced with diverse projects and software environments and usually "can figure it out yourself". There is just to much at stake with handling enterprise geodatabases in multi-user environments. That said, you may find this ESRI Australia blog of some help concerning setting up ArcSDE services at 10.1: Creating an ArcSDE Service on Windows using ArcGIS 10.1 (ESRI Australia) ... View more

i downloaded Arcgis explorer.. then i searched for the place that i want to digitalise. I got an aerial view.. then i am lost.. how do i proceed from then? i want to digitalise my city and extract the coordinates...:( ArcGIS Explorer Desktop isn't meant for extensively creating new data, just for viewing existing data layers. If you wish to create your own data, I recommend you to get either an affordable ArcGIS for Home Use licence for ArcGIS for Desktop or, in case you are looking for a free solution, to have a look at Quantum GIS (QGIS): ArcGIS for Home Use Program Quantum GIS The ArcGIS for Home Use licence will give you more tools and more advanced possibilities compared to Quantum GIS, and is a tremendous deal for the price and what you get, but QGIS may satisfy your needs and have a lower learning curve. ... View more

If that's the case, why does the documentation hint that it is possible (albeit more involved)? I think the main reason the documentation hinted on this option, is that it is possible to extract a binary geometrie's coordinates using a SQL command line application, or in programming, using SQL accessor functions of the spatial type on the command line, or methods related to geometry objects in your programming language. This allows you to get to the geometrie's coordinates, and possibly loop through a set of features to process them. This isn't likely to help you out with SQL view generation though. Just an example taken from the "Working with the geodatabase effectively using SQL" PDF from the Developer Summit 2009, showing the extraction of coordinate data as text from a Well Known Binary geometry using SQL accessor functions on the command line. SELECT ST_ASTEXT(ST_GEOMFROMWKB(ST_ASBINARY(SHAPE),1)) FROM districts ST_ASTEXT(ST_GEOMFROMWKB(ST_ASBINARY(SHAPE),0)) --------------------------------------- POLYGON ((10.0 10.0, 50.0 10.0, 50.0 50.0, 10.0 50.0, 10.0 10.0)) ... View more

I am working with an Oracle DBA to copy/paste all our production data to a new Oracle-SDE database with SDO_GEOMETRY and ArcSDE 10 and we are trying to use the Geodatabase Designer 2, added to an ArcCatalog 10 client, to do this. In the past, working with ArcSDE 9 and v.9 client this has worked. But now it doesn't. We have followed the recommendations in replies 4,6,and 7. Butat the very start of the process, trying to copy the first dataset which is our GISADM.200 Annual_2004_Roll, we are getting this error:     Failed to paste GISADM.Annual_2004_Roll     Underlying DBMS error [ORA-0001:unique constraint (SDE.R2_SDE_ROWID_UK) violated][SDE_GDB_Items]     The index passed was not within the valid range     The index passed was not within the valid range     .... Does anyone have an idea what is causing this? Doug Olcott, GIS Software Engineer Santa Clara County ISD There have been some major changes to the ArcSDE Repository at 10.x, especially a consolidation of the Geodatabase System Tables (down from dozens of normal tables at 9.x, to a few XML based ones at 10.x). Since I see the SDE_GDB_Items mentioned, it may have to do with that change. See this Help page for information about the changes. I really recommend you to start looking at 10.x specific tools for vital work on your geodatabases, instead of trying to run unsupported and maybe outdated tools. ... View more

Another observation: I had attempted to edit an EXISTING version by skipping the "dbo/sde.create_version" stored procedure and specifying an already existing version created in ArcMap that wasn't being edited by anyone else. It appears this is the primary cause of the issue, as adding a EXEC MyDatabaseName.dbo.create_version 'MyUser.MyVersionName', 'MyEditVersion', 1, 2, 'version for my mv edits'; line in the first step, DOES allow you to run "dbo/sde.set_current_version" command with good results when pointing to the newly created version. It seems the "create_version" stored procedure sets some vital context for running the "set_current_version". In addition, ESRI seems to recommend to always create you own named version in a SQL edit session. From the Help: Create a named geodatabase version. If you are editing named versions (versions other than DEFAULT), always edit your own, separate version; multiple editors cannot edit the same named version using versioned views. ... View more