Latest Contributions by MarcoBoeringa

I think we might be close.  The Enterprise gdb is a SQL db.  The IT person that is helping created a new SQL table in that gdb and connected it to the Oracle db.  I can see the SQL table in ArcCatalog and am able to Geocode it selecting the Dynamic option.  For the test, we populated the table with 60 records then geocoded it.  We then added 14 additional records.  Now trying to figure out how to get those to automatically geocode. The "Create dynamic feature class related to table" option should create a relationship class automatically, if I understood the Help page I referred well. So you theoretically should not have to manually create one any more if the geocoding operation successfully finished. Success with further tries. Hope you get it right. ... View more

I also see the error message talks about "table attachments". Maybe excluding some offending columns containing ESRI unsupported attachments / column types from the "mirror" your IT folks created, will solve the issue of not being able "register with geodatabase". By the way, as it not entirely clear from your posts, is your own "enterprise geodatabase" also in Oracle like the customer database, or in Microsoft SQL Server? ... View more

I'm not sure if this is something that can be corrected or maybe the manner in which we are trying to do this (mirroring the Oracle in SQL) is not going to work. Any ideas? Dave, this is probably as far as I can get you, I think it is time Vince Angelo of ESRI or one of the other ESRI folks joins the thread to shed light. Yes, there may be an issue with the current manner you are trying this, as I think that, to register your table with the geodatabase, most likely requires some database rights to the SDE admin user that your "mirrored" table may not provide, like being able to add a geodatabase ObjectID column. See this Help topic also: Registering a table with the geodatabase But again, I hope some others will join the thread that may be able to help you out here. There should be some possibility, especially if you are already able to see and access the table in ArcGIS. ... View more

I have only used it sparingly, but from the different "standard" IDEs I installed and tried, I also found PyScripter one of the more useful ones to work with while debugging. Nice interception and launch of PyScripter once debugging is setup and you try to run a script from ArcGIS that needs debugging. ... View more

It ought to be exactly the same, as you are just working with a table. Only difference is that you access it directly from the Oracle DB, instead of with some export. *** EDIT ***: There may be some obstacle with having a fully dynamic solution. At least it seems you need a relationship class for full automatic re-matching, see the text below from one of the Help pages: "Alternatively, a relationship class between the input address table and output feature class can be created so that edits to the addresses in the input address table are automatically updated in the output feature class. This option is supported only if the input address table and output feature class are in the same geodatabase workspace." This requires the original table also to be part of an ESRI Geodatabase. That may require Enable Enterprise Geodatabase on the existing database that contains the address information. I don't know if that is acceptable in your shop. To make such a relationship class automatically, if your addresses are indeed part of an ESRI Geodatabase or can be made so by Enabling, you can simply choose the "Create dynamic feature class related to table" option, see the text below from this Help page. "6. Select the option Create static snapshot of table inside new feature class or Create dynamic feature class related to table. The Create dynamic feature class related to table option is only available if you have an ArcGIS for Desktop Standard or Advanced license and the input address table and output feature class are in the same geodatabase workspace." ... View more

Sounds to me you actually don't want a static spatial layer added or imported to the ArcSDE managed SQL Server DB, based on your customer list in the original Oracle DB, but just a dynamically geocoded one in ArcMap based on those addresses (maintained by your colleagues), so that it is current at any point in time. For that, you don't need ArcSDE or ArcGIS for Server, you only need access to the original table with customer addresses in ArcGIS. If on ArcGIS 10.0 or below, that can be accomplished by creating an OLE DB connection to your database. First create an ODBC data source using the Windows tools available for that and than use ArcCatalog's "Add OLE DB Connection" option to add a connection to this ODBC data source (expand the "Database Connections" option). If you personally don't know how to setup an ODBC data source in Windows, ask your local network administrators / IT staff, they will definitely be able to help you out. Please note that in ArcGIS 10.1, the "Add OLE DB Connection" option is still available, but no longer by default visible in ArcCatalog. This Help page states how to add it in 10.1: http://resources.arcgis.com/en/help/main/10.1/index.html#//006600000452000000 In 10.1 you may also try to simply connect to the original Oracle DB by using the generic "Database Connection" dialog that replaces the previous options under "Database Connections", and access the table from there. This option doesn't require setting up an ODBC data source, but it may require a database client installed. See this Help page for more information about that dialog: Database connections in ArcGIS for Desktop After you created either an OLE DB or normal Database Connection, you still need to add the data itself. This can be accomplished by either simply opening the connection in ArcCatalog and dragging a visible table "as is" to ArcMap, or using the Query Layer tool in ArcToolbox for more sophisticated SQL based selection query layers. See What is a query layer? in the Help. Using this method, you should be able to setup a fully dynamic geocoded layer, which will be current at any point in time (e.g. each time you open ArcMap, the layer will reflect the edits of your colleagues). By the way, be aware there is a Windows 7 issue with setting up ODBC data sources that at least some people including myself have run into. See the details here in a thread I started. ... View more

A comprehensive overview of current limitations / requirements of Spatial Data Server is also in this Help topic: A quick tour of authoring feature services for ArcGIS Spatial Data Server ... View more

I just found that there is a product called ArcGIS spatial data server. And reading about it, found it is very similar to ArcGIS for server (just subset of it). So, what is the difference between the two? is it just a subset of the full server, so maybe it is cheaper? If ArcGIS Server and ArcGIS Spatial Data Server (SDS) actually share any programming code is something only ESRI can tell, so your question of "whether it is a subset of the full server" is unanswerable... ESRI presents them as two separate products. From a functionality point of view, SDS does not support any of the advanced geodatabase functionality like topologies, network datasets, parcel fabrics etc. So if your goal is to build a geodatabase incorporating any of this, and create a webapplication having some of this advanced functionality, than SDS is NOT the way to go, you will need ArcGIS for Server. In addition, Spatial Database Server was primarily designed to access and serve editable Feature Service layers from non-Geodatabase repository containing Spatial databases with native spatial types, although you can access and serve Geodatabase layers in a read-only mode - and as Simple Features only - too. Please note it also is primarily targeted at serving web Feature Services, not Image Services, which it can't even create according to the documentation I saw. IDK, but performance is likely not to be on par with fast cached Image Services of the same data. ... View more

Is there any way to trace the source that causes HANG ? Log Files etc ? -AS Since the -9 error indicates possible issues with database login, maybe taking a look at RDBMS error logs may give some idea of what is going on: View the SQL Server Error Log (SQL Server Management Studio) Using Trace and Error Logs (Oracle) Vince can probably give you better instruction or insight if this is useful in this specific case... EDIT: I now see -9 actually just says "login", so maybe having a look at the server OS (Windows?) error logs could be of some use too, primarilly for SQL Server, where database authentication is usually derived from Windows. Additional possibly useful link in this SQL Server contect: SQL SERVER �?? A Quick Look at Logging and Ideas around Logging. ... View more

Googling for "Error (-9):Couldn't Start Server Task." yielded the following old ESRI links that may be of some use. Especially see Danny Krouk's remarks in the discussion thread: http://forums.esri.com/Thread.asp?c=2&f=59&t=81786 http://support.esri.com/es/knowledgebase/techarticles/detail/19035 Also, these two links might be of some use: http://oracledbatips.com/arcsde/ArcSDE-error-codes-0-20.html http://edndoc.esri.com/arcsde/9.1/capi_functions/returncodes_incl.htm From the second link: SE_INVALID_USER     (-9) The user attempting to access the ArcSDE server does not have a valid login account on the ArcSDE host machine. Returned by the SE_connection_create call only. SE_DB_IO_ERROR     (-51) A database-level I/O error occurred. You can call the extended error code immediately after this code is returned to inquire about the specific database error code. ... View more

Thank you for the contribution Marco. I couldn�??t do this check on the sql server database. Jamal, Could you be a little bit more specific as to why you "... couldn't do this check ..."?? Were you unable to check the "Binary-code point" option in the dialog you made a screenshot of and that I attached below again? If so, this might be due to the fact that you also checked/selected "Case insensitive" and "Accent insensitive" or any of the other available options. If I understand it well, "Binary-code point" collations more or less use a predefined table with the sorting order fully determined (this is the code point/page, see this page and this page about character encoding and code pages on Wikipedia). This means you can't add options like "Case insensitive". Also see the following small remark below from this MSDN page, which confirms this incompatibility. So you will probably need to uncheck all other collation options before checking the "Binary-code point" collation option: "If BIN or Binary-code point is selected, the Case-sensitive, Accent-sensitive, Kana-sensitive, and Width-sensitive options are not available." Please, have a look on the screenshot below, am I in the right place to stick (as an example) �??ALTER TABLE myTable ALTER COLUMN mycol NVARCHAR(10) COLLATE Greek_CS_AI�?� [ATTACH=CONFIG]22117[/ATTACH] I guess you are in the right place, but in your case the statement is probably going to look a bit more like: "ALTER TABLE dbo.Communities_24 ALTER COLUMN CommunityName_Points_Arabic COLLATE Arabic_BIN2" In case you wish to try to set a "Binary-code point" (BIN2) collation on this specific column. ... View more

Thank you Marco for the input. That�??s exactly what I did! You should be able to find this on my previous screenshot (enterprise geodatabase with that feature class) 1. I added the �??Arabic�?� as Collation designator (adding feature to an existing instance) 2. Then I created an enterprise geodatabase 3. I copied the feature class to it 4. I tried the sql search! But no luck! It didn�??t work without the �??N�?� Best Jamal Jamal, did you also try to set a "Binary-code point" collation? This should force Unicode comparison in SQL Server. See this text from the MSDN page: "Binary-code point (_BIN2) Sorts and compares data in SQL Server tables based on Unicode code points for Unicode data. For non-Unicode data, Binary-code point will use comparisons identical to binary sorts. The advantage of using a Binary-code point sort order is that no data resorting is required in applications that compare sorted SQL Server data. As a result, a Binary-code point sort order provides simpler application development and possible performance increases. For more information, see Guidelines for Using BIN and BIN2 Collations." ... View more

Using the �??N�?� is sufficient without the need to install the collation designator. What do you think Marco? However, installing the �??Arabic�?� collation might be still needed referring to the fact that my database includes Arabic fonts. It should be necessary to avoid other types of error and weird behaviour. Best Jamal Jamal, I still think it would be worthwhile to set the collation to Arabic and try to re-load the data in your geodatabase (re-loading to force setting of Arabic collation on the Arabic unicode column). If I understand it well, your queries should than not need the "N" prefix, which is more consistent with the normal ArcGIS usage and less confusing to you or your geodatabase users. As the ArcGIS troubleshooting page also states: "No results are returned by ArcMap unless the SQL Server instance being queried is using a (Thai) locale or collation." Alternatively, you might still try to change the collation of specifically the Arabic character column in SQL Server Managent Studio by using the ALTER statement against the column, as explained on this page (scroll down to see it under "Column-level collations"): Collation and International Terminology Example from the page: ALTER TABLE myTable ALTER COLUMN mycol NVARCHAR(10) COLLATE Greek_CS_AI And as you also say, it should potentially give a more consistent behaviour with the sorting of the data in different applications and SQL Server. There also seem to be some new things with SQL Server 2008 and collations and a recommendation and push by Microsoft to use "BIN2" binary collations by checking the "Binary-code point" checkbox in the dialog you made a screenshot of. See this Microsoft MSDN page under "Binary collations": Windows Collation Sorting Styles But anyway, as I wrote before this is all a bit outside my knowledge base. I think Vince or Shannon might be able to give better informed answers on this specific subject. ... View more

Hi Hardolph, When generalizing the ellipses I just get triangles, no matter what maximum allowable offset is given. Is that what You meant by playing with the parameters? Hi Jeroen, Although Hardolph points in the right direction regarding his remarks about how the geodatabase stores true ellipses (mathematically instead of a dense line of vertices), I think you will need to use the Densify tool instead of the Generalize tool. Generalize removes access vertices based on tolerances, Densify adds them, and this last thing is what you want when converting to a Shapefile. See the Help topic: Densify (Editing) ... View more

In addition, if you have older datasets (originally created prior to ArcGIS 9.2) in "basic precision", take notice of the following warning ESRI makes in the Help link Vince posted, it is probably also wise to take this into account when doing a simple "manual" transition as I suggested by creating a new Feature Class with different storage type: "If you are converting the spatial column type, the data must be stored in high precision. If your data is currently stored with basic precision, you must first migrate it to high precision before you migrate the storage type. This can be done with either the Upgrade Spatial Reference geoprocessing tool or the sdelayer command with the alter operation. See Migrating to high precision for information on migrating the precision of a dataset." ... View more