Latest Contributions by VinceAngelo

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

You should set the CONNECTIONS parameter to the number you need (plus a few more). The N-I desktop heap issue is documented in the Knowledge Base (found by search on "arcsde desktop heap"). It only applies to application server connections, so you'd need 110+ 3-tier connects before you'd need to take more exotic action. - V ... View more

No, each instance is independent with respect to connection count. However, the Windows heap issue is cumulative. - V BTW: The 'sdeping' utility of se_toolkit can be used to diagnose connection count issues -- It has a "-c" option to make multiple connections and a "+DELAY" option to hold onto them (if it succeeds): C:\>set SDEUSER=XXXXX C:\>set SDEPASSWORD=***** C:\>set SDEINSTANCE=5153 C:\>sdeping -c 80 -v +DELAY 17:10 ArcSDE 9.3 Connection Test Utility       Thu Jun 10 17:05:23 2010 ------------------------------------------------------------------------          Server: YYYYY        Instance: 5153        Database: eval93        Username: XXXXX           RDBMS: PostgreSQL         Version: 9.3.1     Description: PostgreSQL Build 2784(PostgreSQL)      Build Date: Tue Oct 27 10:51:14  2009         Release: 93005     Connections: 1   2   3   4   5   6   7   8   9   10  11  12                  13  14  15  16  17  18  19  20  21  22  23  24   Connect Delay: 333.33 ms (avg)   Connect Stats: 312.00 ms (min) / 656.00 ms (max) / 69.32 ms (stddev)      Connection attempt 25 failed --           Error: Operation Failed (-1)   Disconnecting: 24  23  22  21  20  19  18  17  16  15  14  13                  12  11  10  9   8   7   6   5   4   3   2   1 ... View more

The SDE.PROCESS_INFORMATION table tracks connections.  You can use a number of ways to process this information (including 'sdemon', SQL, and a trigger on the table). - V ... View more

Yes, absolutely, the CONNECTIONS parameter controls the number of total connections (sum of app server and Direct Connect). You can update the value with the 'sdeconfig' utility or by correctly updating the row in SDE.SERVER_CONFIG. Keep in mind that Windows hosts have their own upper limit of application server processes (the "non-interactive desktop heap" issue), which is independent of both Oracle and ArcSDE (generating a strange error message somewhere after 66 connections on boxes without the registry hack, and ~110 connections with it). - V ... View more

That product is documented as being limited to 3 seats (see the table two pages down under "How is ArcSDE technology included in ArcGIS?"). - V ... View more

SQL-Server is certainly more forgiving than Oracle, but it also has a completely different storage architecture.  It still takes a little work to obtain optimal performance; I'd like to say I'm amazed that more folks don't make the effort, but when ease of administration is emphasized, tuning is always going to take a back seat. - V ... View more