Latest Contributions by MarcoBoeringa

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

OK, I now think I have gotten one step further with this. It appears the order of commands described in the Help topic "Editing versioned data in SQL Server using SQL" is incorrect, or that the ArcSDE stored procedure "SDE_getglobals" falsely doesn't allow you to set the current version when not in edit mode (at least in SQL Server, I don't know in other RDBMSs). In addition, it appears any set version, only applies to the current active Transact SQL window, meaning you can't use it to change the way the view appears to the world outside SQL Server Management Studio (e.g. in Quantum GIS). Other applications accessing the Versioned View will only see the DEFAULT. Probably not entirely illogical, as setting the version as a kind of global for the entire database, would cause all users connected to the same Versioned Views to see the same version, and get confronted with subsequent changes. It needs to be user tied, or in this case limited to the context of the Transact SQL window. It essentially means that edits against a specific version of a Versioned View is only supported straight in the Transact SQL command window, otherwise the ArcSDE C/Java API or ArcObjects is required, like for example the FDO Provider for ArcSDE in AutoCAD Map 3D does (uses C API) that does allow version switching on a user connection basis. According to the Help the order of the commands is: 1) Open a Transact-SQL query window and execute the create_version procedure to create a named version in which to perform your edits. EXEC sde.create_version 'sde.DEFAULT', 'myedits12111', 1, 2, 'version for my mv edits'; 2) Set the version for the edit session to the child version you just created. EXEC sde.set_current_version 'myedits12111'; 3) Start an edit session by executing the edit_version stored procedure and specifying 1. EXEC sde.edit_version 'myedits12111', 1; However, I discovered the "sde.setcurrent_version" command fails and returns -1 for the version_id if NOT IN EDIT MODE already, even though the command is reported back as having run successfully. This means you must run the text line: EXEC sde.edit_version 'myedits12111', 1; before running: EXEC sde.set_current_version 'myedits12111'; E.g. if I enter (please note my ArcSDE is "dbo" owned, replace with "sde" if SDE owned): EXEC MyDatabaseName.dbo.set_current_version 'MyUser.MyVersionName' than this fails... If I enter: EXEC MyDatabaseName.dbo.edit_version 'MyUser.MyVersionName', 1 EXEC MyDatabaseName.dbo.set_current_version 'MyUser.MyVersionName' EXEC MyDatabaseName.dbo.edit_version 'MyUser.MyVersionName', 2 with a start and end of an edit session, the command does run successfully. How do I know this? Well, first I entered some debugging code in the stored procedures for the "set_current_version" and "SDE_set_globals" and "SDE_get_globals". The results show the version_id is returned as a false -1 if not in edit mode, but the correct version_id for the "MyUser.MyVersionName" version if IN edit mode when setting the version. In addition, I added a SELECT statement against the Versioned View in the same Transact SQL window, and the result showed the correct, NON-Default, version data with all the edits I did. E.g.: EXEC MyDatabaseName.dbo.edit_version 'MyUser.MyVersionName', 1 EXEC MyDatabaseName.dbo.set_current_version 'MyUser.MyVersionName' EXEC MyDatabaseName.dbo.edit_version 'MyUser.MyVersionName', 2 SELECT * FROM MyDatabaseName.MyUser.MyDatasetName_VW does show the proper Spatial Result of the Versioned View in SQL Server Management Studio. ... View more

I downloaded a utility to monitor SDE activities but for some reasons it gives error (see attachment). Have I missed something during installation? Please assist. If you mean SDEMonitor, it is almost a certainty this tool is unusable with any current version of ArcSDE and ArcGIS. The last update I see is version 3 from 2004... You really need to look at for example the new 10.1 Geodatabase Administration tools for some of this functionality in GUI form. It is not a replacement for specific functions of SDEMonitor regarding Application Servers, but might fullfill some of your needs. A quick tour of administering ArcSDE geodatabases with ArcGIS for Desktop An overview of the Geodatabase Administration toolset ... View more

Don't know how to interpret this yet, but if I insert a: -- BEGIN EDIT DECLARE @i int SET @i = @g_version_id SET @error_string = 'g_version_id: ' + (SELECT LTRIM(STR(@i,10))) RAISERROR (@error_string,16,-1) -- END EDIT just before the last code lines in the set_current_version stored procedure (before the comment line "-- Finally, set the global info"), than the "g_version_id" comes up as -1. It should be 2 for the version I set if I look in the "dbo.SDE_versions" table... ... View more

Hmm... I now found this thread mentioning at least one known relatively recent (2012) issue with the set_current_version stored procedure (or the other functions it calls), although that thread mentions it being related to DEFAULT: http://forums.arcgis.com/threads/51244-Multi-versioned-Views-Not-seeing-data-in-the-A-amp-D-tables?highlight=set_current_version Still a real possibility there is an issue with my arcsde or geodatabase system tables, maybe related to the QGIS edit, but I don't see it at this point going through some of these tables (just a few records, since it is a small test database). ... View more

Hello, I am trying to set current version in SQL server using the stored procedure: EXEC sde.set_current_version 'DBO.residence' But it doesn't seem to work because when I check my MV view, it seems to be referencing the DEFAULT version still. Has anyone encountered this problem or know what the solution is? Thanks, Reuben I recently ran into similar issues with SQL Server. I have a small test setup and test database using SQL Server Express with one versioned feature dataset with a few feature classes.. My instance is SQL Server 2012 Express SP1 upgraded from SQL Server 2008 R2 Express SP2, using ArcGIS 10.1 SP1. My database is DBO owned, and I can see the set_current_version stored procedure as dbo owned. I also tried to set the current version of a multiversioned view, but kept getting the DEFAULT (which is still at state 0). I ran the code snippet below (which comes straight from the versioned view code except for replacing "SELECT l.lineage_id" with "SELECT s.state_id"), that returns the state after running the set_current_version command (you can modify it to show lineage_id as well). It consistently returned state 0 after running the set_current_version command, while the version I tried to set has state 12. The set_current_version procedure ran successfully according to the message displayed in the SQL Server Management Studio status window. Change dbo/sde in the snippet to either dbo or sde depending on who owns it: SELECT        s.state_id     FROM            YOURDATABASENAME.dbo/sde.SDE_states s INNER LOOP JOIN                                 YOURDATABASENAME.dbo/sde.SDE_state_lineages l ON l.lineage_name = s.lineage_name     WHERE        s.state_id = YOURDATABASENAME.dbo/sde.SDE_get_view_state() AND l.lineage_id <= s.state_id In my case, the version pointing to state 12 is also another user than dbo, who owns the default. The non-dbo owned version I tried to switch too from the default owned by dbo, is set "public". I haven't been able to figure this one out yet looking at things like the contents of the SDE_versions, SDE_states, SDE_states_lineages tables etc. I must admit I did make an edit through Quantum GIS (QGIS) against the multiversioned view, before actually attempting to set a version through SQL Server Management Studio and the set_current_version command. But this should not necessarily cause issues, the multiversioned views are designed for this purpose. I did notice one issue though where ArcGIS did not recognize the proper extent of the total dataset (it did display the new polygon, but didn't properly zoom out to it). This was solved with another edit in ArcMap itself, which seems to have updated the layer's extent. QGIS also consistently shows state 0, the same if I look at the "Spatial results" window in SQL Server Management Studio. ... View more

I can say that the people administering this SQL Server are pointing to ESRI as the problem because they cannot log into the renamed geodatabase using the logins/passwords that the original production sde geodatabase had and they think that ESRI security is causing the problem.  I don't even know how to respond to that. ESRI geodatabase security = RDBMS security = (most likely in case of SQL Server) Windows Authentication So if you can't login after recreating your database and nothing else changed, you've taken the wrong path (as Vince already told you: you can't rename the database with an established geodatabase in it). The path you probably should take if you really need to "rename" (note the quotes): 1) - Create a new database using the new name in your instance (or if desired an entire new instance) 2) - Re-create any database users / roles etc. of the old database you wished to "rename" in the new database 3) - Use the "Enable enterprise geodatabase" tool to create a new ArcSDE Repository in the new geodatabase (Alternatively you could have used the "Create enterprise geodatabase" tool to do steps 1 and 3) 4) - Copy over any datasets (Feature Datasets / Feature Classes) from the old geodatabase to the new one, or use One-Way Geodatabase Replication to do it. There may be some headaches here, especially if there are outstanding versions and editing is going on. See also Understanding distributed data Vince can probably give you more details and correct/supplement what I wrote. ... View more