Latest Contributions by VinceAngelo

What ArcGIS client are you using?  Only ArcGIS 10.0 clients can connect to a 10.0 ArcSDE server. - V ... View more

Those are 'sdesetup' messages, consistent with the expected output of a fresh install, not something 'gsrvr' would generate. If you used Direct Connect from ArcGIS, the error logs would be on the Desktop box, not the server. - V ... View more

No SP3 was ever released for 9.1. Is your old ArcSDE "9.1sp2 General Update 3"? Upgrading to 9.2sp6 on 9iR2 at this late date is setting yourself up for an imminent upgrade, since 9.2 is in mature status and 9iR2 isn't supported by Oracle. Heck, as of July, 10gR2 isn't supported either (you'd need ArcSDE 9.3.1 to support 11gR1). It's likely that the lack of logs indicates ArcSDE didn't really even start before the OS fataled the application (which in turn indicates an improper application configuration). What is the version of your Oracle 32-bit client install (required for 32-bit ArcSDE). If you imported all the users (including SDE) with exp/imp, then you certainly don't want the '-o install' option -- use '-o upgrade' instead (after you make sure that SDE has the required permissions). You might be better served by dropping the SDE user, working on installing 9.2sp6 cleanly, then imp-ing SDE again to do an upgrade. - V ... View more

What user starts the 'sdemon' application? One way to find out what's wrong with the environment is to replace 'gsrvr' with a shell script that dumps the environment (and possibly a ldd of the superceeded gsrvr). It's just about time to contact Tech Support on this issue.  The only time I've seen something similar was on a client's HP/UX host where the 64-bit install binaries had been corrupted by a silent disk failure. - V ... View more

Does the giomgr process user's .profile, .bash_profile or .bashrc clear the contents of PATH or LD_LIBRARY_PATH? By the time the dbinit.sde is consulted, it's too late to set the SDEHOME or LD_LIBRARY_PATH. My ArcSDE boot script executes $SDEHOME/etc/.profile to establish database-specific environment variables before executing 'sdemon -o start'. This way I only need to put the ORACLE_SID or TWO_TASK (and possibly NLS_LANG) in the dbinit.sde (and can use the same profile for all Oracle instances, regardless of ArcSDE release). My complete multi-instance Linux boot script framework is buried in the se_toolkit release tree (in all release bundles, under samples/boot/redhat_etc). - V ### $SDEHOME/etc/.profile ### ORACLE_HOME=/opt/oracle/product/10.2.0/db32 LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export ORACLE_HOME NLS_LANG LD_LIBRARY_PATH ### $SDEHOME/etc/dbinit.sde ### set ORACLE_SID=xxxx10g2 unset TWO_TASK ### /etc/init.d/arcsde ### Start_SDE() { ... # .. Set environment variables # SDEHOME=$2 PATH=$SDEHOME/bin:$origPATH LD_LIBRARY_PATH=$SDEHOME/lib:$origLD SDEVERBOSE=$3 export SDEHOME PATH LD_LIBRARY_PATH SDEVERBOSE # .. Retrieve password # if [ -f $SDEHOME/etc/.passwd ]; then sdepass=`cat $SDEHOME/etc/.passwd` else report_error ERROR && printf "\t--> $SDEHOME/etc/.passwd not found\n" return 1 fi # .. Execute etc/.profile (if present) # if [ -f $SDEHOME/etc/.profile -a ! -x $SDEHOME/etc/.profile ]; then report_error ERROR && printf "\t--> $SDEHOME/etc/.profile not executable\n" return 1 fi test -x $SDEHOME/etc/.profile && . $SDEHOME/etc/.profile # .. Execute command # sdemon -o start -i $1 -p $sdepass >> $logFile 2>&1 ... } ... View more

Never, never, never use LZ77 compression for a lossy source image.  If the source was MrSID or JPEG2000 use JP2 compression (otherwise you increase image size by a factor of 10-40 [yes, 1000% to 4000% storage increase], with no benefit).  NEAREST is most likely to increase "snow" since it doesn't try for a best fit (as a rule, it should only be used with colormapped rasters).  You need to experiment with BILINEAR and BICUBIC (which use weighted averages of neighbors to better blend the resampled pixels), to see which produces better pyramids with your images. - V ... View more

It is generally not recommended to use lossy-compressed image sources for loading into ArcSDE. You can do so, but you must be careful on which compression algorithm you use in the database, and which algorithm is used in the pyramid (they can be different). What algorithms are you using? With what parameters? What pyramid interpolation method did you choose? Is the image quality issue only with pyramid tiles, or at the base resolution as well. - V ... View more

Given that base64 MIME encoding is going to increase file size by 1/3, it's probably wise to always zip before e-mailing data (including .mdb files) -- this will also give you a way to detect corruption in transfer. The one file solution has a drawback as well -- File geodatabases do not have any real size limitation, while PGDB are limited to 2Gb. - V ... View more

ST_GEOMETRY doesn't have triggers like SDEBINARY and SDELOB, though I'm sure there's an equivalent within the object behavior (one that's not subject to external tampering). - V ... View more

ST_GEOMETRY does not have F or S tables, so it's not just the triggers that are missing. There is an S table analog, but the F table is implemented as a LOB object type in the business table (see the online doc for ST_GEOMETRY storage architecture details). - V ... View more

Shapefiles suffer from a number of defects, most related to the limitations of dBase: 1) Lack of numeric NULLs 2) Lack of second precision on date types (limited to YYYY-MM-DD) 3) Column name clipping at 11 characters 4) 254 character limit on strings (and lack of NSTRING, and fixed width transfer) File geodabases have none of these issues. For consistency's sake (with either format), you should be transferring zipfiles, not individual file components. - V ... View more

There are several storage methods possible with ArcSDE, not all of which are available on all database platforms. The only significant change between 9.2 and 9.3 was a change to the default storage type on Oracle 9i/10g from SDEBINARY to ST_GEOMETRY. You have always had the option of specifying storage location (via DBTUNE file, which every site should modify for their environment). Default storage type is also a property of the DBTUNE file. There are multiple copies of this documentation online via a Resource Center search (UR search window); the most recent of which is avaliable here. Placing custom triggers on ArcSDE-managed tables is unsupported, and moderately risky. You'd be much better off using the DBTUNE mechanism for storage management. - V ... View more

I always manage permissions by role (create a role, grant table access to the role, grant the role to users), so editing access through users would make my life much harder, but if you don't have any roles, then you could do it that way.  You might need to revoke all access first, just to clear the previously granted access. - V ... View more

I generally manage permissions through roles from creation scripts, so I know exactly what permissions should exist on each table.  Exploring this from the database side is a rather involved task; I would need to review the entire database security architecture, consult experts (as found in a database vendor's forums), and then once I had the database matrix of tables/users/roles/permissions, I'd need to reconcile that with feature datasets and ancillary/support tables.  It's not an impossible task, but it is likely to be tedious and painstaking. 😞 Good luck. - V ... View more

It's common to see "table does not exist" errors during initial creation, since it's best practice to check if something already exists before creating it.  SQL doesn't generally have an "exists" function, so you query permissions and let the "table not found" error stand as an answer.  It's perhaps misleading to use a single error-handling function when you *expect* an error, but we're just talking about a setup log, after all. - V ... View more