Latest Contributions by VinceAngelo

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

Which version of ArcSDE did you license?  "Personal ArcSDE" and "Workgroup ArcSDE" have concurrent user limits, while Enterprise ArcSDE does not (well, it does, but it's database resource configuration which is the determining factor -- once you're into hundreds of users, it doesn't really seem like a limit). - V ... View more

You need to upgrade your client to at least 10.2.0.3 (the minimum), or all to the same release as the server 10.2.0.4.  ArcSDE will not function correctly with Oracle 10.2.0.1, which is known to give spurious permission errors and to fail frequently. - V ... View more

You cannot control the allocation of SDE-set registered rowid column values in geodatabases and "in-memory workspaces" aren't, as James pointed out, full geodatabase implementations.  The task of keeping track of pieces of a database, editing them, and merging the result back into the original table is quite challenging, which is why the Disconnected Editing solution was developed.  But you can't pick and choose pieces of that solution (the restrictions it imposes were necessary to make the solution work).   If Disconnected Editing doesn't meet your requirements, you'll have to decide if the days, weeks, or even months of effort to make your own in-memory solution are worth your time, but your design will have to actively track previous objectid values in an additional column, and be prepared to update, delete, and insert appropriately when the transition back to persistent geodatabase occurs. Good luck. - V ... View more