Latest Contributions by VinceAngelo

All ArcSDE instances have a limit on the number of concurrent users. If you reach the limit you will get that message. If you have an Enterprise license, you can change CONNECTIONS to a larger value (see the 'sdeconfig' command documentation), though you will eventully start getting Windows errors instead of SE_CONNECTIONS_EXCEEDED if you set it too high. Note: The non-interactive desktop heap OS connection limit is only on Windows server hosts, and applies only to application server connections (not Direct Connect). - V ... View more

The only option I can see is creating a new 9.2.0.8 instance *without* the problematic CPU, upgrading there, then using exp/imp to re-integrate.  Ugly, but it might work. Keep in mind that Oracle 9.2 is no longer supported by Oracle (in fact 10gR2 is now in limbo as well), and ArcSDE 9.3 is the last ESRI release to support 9iR2 (ArcSDE 10 only supports 10gR2 and 11g [32- and 64-bit]).  You may need to consider moving your GIS data to a more modern database, and rigging some backward export mechanism to support the 9i-bound application until you can transition it. - V ... View more

All ArcSDE servers support a full SQL security model (thanks to the databases, which provide this functionality).  Keep in mind that versioned geodatabase tables are limited to {no access, SELECT, SELECT/UPDATE/INSERT/DELETE}, since versioned updates and deletes are really inserts. - V ... View more

A search in the upper bar (of arcgis.com, not just forums) on "multiple ArcSDE services" pulled up at least half a dozen likely links in the first page (of 1100+ matches). If you remember to use the proper product name, the search engine should be reliable. Keep in mind that you're likely to run into the non-interactive desktop heap limitation on Windows hosts if you run more than 66-70 total application server clients across the three instances. - V ... View more

It is generally unwise to separate the ArcSDE application server from the database to which it is tightly coupled, unless you also intend to create a dedicated point-to-point network between the ArcSDE server and the database (crossover cable, backplane to backplane, gigabit speed).  This was especially true way back when 9.0 was released. The only real reason to configure a distributed install is to handle a clustered database configuration, in which case all connections should be Direct Donnect, and the application server component isn't really necessary. I urge you to learn a bit more about ArcSDE, and a lot more about GIS.  Once you start using a modern database,  you'll see that the division between roles of DBA and GIS database administrator has become moot (all modern databases have native spatial datatypes). - V ... View more

Neither Access nor Excel are relational database management systems (RDBMS); since they can keep all data in memory and just rewrite, there isn't any real magic involved. If your source table is spatially fragmented (that is, there is no correspondence between location and row number -- when you draw a single layer at 1/4-1/10 of the total extent and features render in apparently random order), then there could still be a large benefit to draw (and other spatial search) performance with row optimization.  It only becomes obvious on tables with a 300k+ rows or more, but the difference is measureable with as little as 10k rows. - V ... View more

Short answer: No. Essay form: ArcSDE isn't a database, it's an interface to databases. The only way to change table column order with the ArcSDE API is to export in the desired order and create a new table with the result.  If, as in your example, you can coax the database to reorder the columns, then ArcSDE will present them in that order, but a brief web search indicates that SQL-Server, PostgreSQL and Oracle do not permit this as a trivial operation.  Many of the referenced links recommend using a view, which will work, but ArcGIS puts limits on geodatabase participation by views.  If you're going to have to reload the table anyway, consider doing some row-order optimization as well, by exporting in spatial index order. - V ... View more

This sort of information is not normally collected by ArcSDE. While you can use either database or ArcSDE logging and trace capabilities to collect much of what you want, the performance burden on your server will be noticeable (possibly annoyingly so for end users), and you'll have a significant task in reducing the raw data to usable form (grep/awk/sed, Perl, or Python skill would be invaluable). Good luck. - V ... View more

No, I have little experience with ArcObjects, so I'm not a resource in this area. You may want to try the ArcObjects forum or just contact Tech Support directly. If you post, be sure to specify which version (and service pack) of ArcGIS and ArcSDE you are using. - V ... View more

No, you don't need a view to accomplish this.  All you need is a geometry column on the table being updated (which can be accessed directly).  Your previous post indicated you've already done this.  If you can't access the geometry column directly, it's unlikely that a view will function as desired. If you want my help with view construction, you'll need to provide the 'sdetable' output I requested and the exact 'sdetable -o create_view' command (without password), so I can understand how you've configured your solution.  The output from 'sdelayer -o describe_long' on the table with the geometry column and the view is also necessary (sorry for the typo). I can't recommend changes without understanding what you have done so far. - V ... View more

If you placed the geometry in the table with the lat/lon columns, why do you need a view? A properly constructed view should be visible to ArcGIS as a simple feature class. What does 'sdetable -o describe' report on each of the tables and the view, what does 'sdetable -o describe' report on the the geometry table and view, and what command did you use to create the view? ArcGIS does not permit the registration of views.  - V ... View more

That's pretty bizarre behavior.  I can't lay it at the feet of Windows 2008 R2 wtihout knowing whether you're using the PostgreSQL 8.3.0 which ships in the ArcSDE install media. It is generally unwise to use a database or OS which wasn't available when the "current" ArcSDE service pack was produced (figure two months before release). 9.3.1 SP2 release is imminent; you might have better luck with that. - V ... View more

There is no 64-bit PostgreSQL or ArcSDE for PostgreSQL build, just 32-bit. You'd probably be *way* better off configuring that host as a Linux server. There's a number of degrees of functionality between "certified" and "won't work". The likelihood of complete failure depends on how far you stray from the support umbrella. - V ... View more

There's no real difference in the install process. See the old Forums post by TB for details. - V ... View more

I haven't tested Windows 2008, but it was still present at 2003 R2 (64-bit). I convinced my client to run a Linux ArcSDE server; I ran one of them to 400 connections, just for thrills (but had to raise the Oracle processes parameter to 420 first). Direct Connect is more forgiving, to a point, but you still need to have the compatible DLLs available (which is another install, of sorts). - V ... View more