Latest Contributions by VinceAngelo

THREE processors on the VM? Is it 2, 4, or 8?  Is the database in the same VM too? Was your benchmark on a single large table, or were you exercising multiple tables simultaneously? The *best* performance I have ever seen from a VM is a 20% performance tax. 50% is a bit steep, but not unexpected (both Oracle and ArcSDE are I/O dependent, and while both Oracle and Esri support virtual  architectures, neither recommends their use in production systems).  It's not generally recommended to run ArcGIS Server on the RDBMS host. - V ... View more

It is a bit confusing.  ArcSDE is both a product that lives in an SQL database and the API/protocol to access that data.  ArcSDE registers tables in the TABLE_REGISTRY so that it can maintain metadata about their status with respect to ArcSDE.  The geodatabase is the ArcObjects code accessing database tables via the ArcSDE API.  It, too, has a registry, implemented in many (or a few, if you're running ArcSDE 10.0 or higher) GDB_* tables (which in turn are registered with ArcSDE). When you register a table with ArcSDE, it's still not available to participate in geodatabase behavior (feature datasets, relationships,...).  ArcSDE-registered tables *are* avaiable for use as simple feature classes in the geodatabase.  If you register a new table with the geodatabase, it will force ArcSDE registration if that has not been yet accomplished.  No ArcSDE command can register a table with the geodatabase (ArcSDE is not geodatabase-aware). - V ... View more

Try putting the $ORACLE_HOME/lib directory in the LD_LIBRARY_PATH, since that's where DLLs live on Unix hosts.  The most powerful tool for resolving library path issues on Unix hosts is 'ldd', which will tell  you the list of shared libraries required by an executable or other DLL, and where it has located each (or if it has failed to locate it).  Running 'ldd $SDEHOME/lib/libgsrvr*.so' should report resolution of all libraries after you correct the LD_LIBRARY_PATH. - V ... View more

In the past, the existance of a primary key has prevented successful registration of a layer. I haven't tried to register a table with a primary key more recently than 9.2. At this point you'll probably need to work with Tech Support. - V ... View more

Does your registered rowid column map to an SE_INT32_TYPE integer (as per 'sdetable -o describe'), and is the value returned in that column: + a non-zero positive value, + distinct (non-repeating across the result set), and + unique (any given value is returned by exactly one row)? The behavior you're desribing is common when the rowid is not distinct. - V ... View more

I wonder if this may be a Windows runtime issue... What output do you get from 'ascinfo' and 'ascinfo --version'? See the 00README_WINDOWS.HTML for information on obtaining the necessary .NET Framework and/or VC 2008 runtime. - V ... View more

What output do you get from the loader? Have you tried 'ascinfo -o scan -v -f ...' on the file? - V PS: The 'SETENV TZ="UTC"' works on Unix, but isn't reliable on Windows; using a PC, it's best to put a "set TZ=UTC" before asc2sde in a .BAT. ... View more

SDE-set objectid values are managed by a sequence (or on SQL-Server, by one-row table that is incremented).  It is very inefficient to increment with each row, so ArcSDE actually increments by a larger value (200 or 400) and assigns the values in between by itself. On Oracle, the excess values are stuffed in a DBMS_PIPE for re-use; I'm not positive that an equivalent exists with Microsoft.  In the end it doesn't really matter, since the values only need to be unique (and positive) for the linkage between tables and graphics within ArcGIS (it's not an error, just an implementation quirk of the load process). - V ... View more

1) Append should be 'asc2sde -o append' ('sdeupdate' will alter existing rows). 2) You might have an issue with NOT NULL columns that automatically populate with a default value at the database (there are checks to make sure that all NOT NULL columns in a row are in the INSERT stream). Of course, with timestamp compute columns, the loader can populate those values, too. Constants can be assigned via AsString("foo") or AsInt32(12345) compute columns. 3) The dash is a place-holder for delimited text (it contains the start position with fixed format). 4) I'd need to see the 'sdetable -o describe' output for the target table for the "does not have" messages (make sure you're using setk93b41 for maximum functionality). Be careful of escape sequences in the control file. I loathe comma-delimited input because of the frequency of commas in user data. The 'Date("CURRENT_TIMESTAMP")' is probably going to generate null values if the import string isn't "CURRENT_TIMESTAMP" -- use GMTIME() to generate "now" values, StartTime(GMTIME) for the time at the start of load, or set a date into an environment variable before load, and extract it with GETENV(), then parse that with each row for a single date value for all rows in the load. - V ... View more

I was able to rebuild the setk9.3b41 source tree on my Windows build host for just the 32-bit and 64-bit Windows 10.0sp3 ArcSDE releases. I'm not likely to make Solaris/HP/IBM snapshots on 10.0sp3 until the setk10.1b10 release, but I'll try to knock out the Linux builds soon. - V ... View more

In my experience, searching through PATH on Windows for a DLL returns "not found" if the library found doesn't match in application wordsize (and it stops looking), so if it were a 32/64-bit issue, you would have received a different message.  Fortunately, even the misleading message you did receive steered you to the right app/DLL combination. - V ... View more

There didn't seem to be any significant changes to the ArcSDE libraries between SP2 and SP3. Since 'se_toolkit' apps use the dynamic libraries, I would think that using an SP3-patched SDEHOME would still allow you to Direct Connect, even if the original SDK was SP2.  Are you using an SP3 SDEHOME? I've downloaded the SDK SP3s, but don't have the 8-10 hours it would take to apply them to all the platforms and rebuild 'se_toolkit' across them.  I might be able to rebuild the current build's source tree for just Windows builds in much less than that, but making that time might be a challenge too. - V ... View more

Keep in mind that there are three parts to the ArcSDE technology -- the client application, the application server DLLs (which may deployed in two ways), and the database instance.  When you upgrade the application server binary, it does not automatically reconfigure the database -- You must also do this (as the SDE user with the required permissions). In previous releases, the ArcGIS geodatabase upgrade was a part of the 'sdesetup -o upgrade' command, but since 10.0 was released, an ArcCatalog host (or the Python equivalent thereof) must execute the database upgrade (the only exception is if the instance is effectively empty, with no tables registered with the geodatabase). The only way the application server daemon will start is if the database instance has been successfully upgraded from a compatible Catalog (or Python).  Make sure you have a stable backup of the database instance, since if the upgrade fails in unexpected fashion, the Catalog GUI may not offer you the option to upgrade (I had this happen when my VPN session terminated before CArcCatalog finished -- Not pretty). - V ... View more

I think it's there for reverse compatibility to the days when OLE was all there was. - V ... View more

Easy to make, but not as easy to restore -- keep in mind that there are limitations on the ability to restore individual files, so you really need to get the *entire* fileset in one pass and restore the *entire* fileset if necessary (then copy the contents of a single table as needed). - V ... View more