Latest Contributions by VinceAngelo

Option B could include a 'pause' before shutdown, but then it will still be paused at restart (at least, that's the way it worked when I last tried it - circa 9.1). Similarly, if you pause before kill, you won't have a race condition window for (re)connect. - V ... View more

Are you using Direct Connect or application server connections? Have you restarted the server recently? Have you done a DELETE or TRUNCATE on the SDE.PROCESS_INFORMATION table? - V ... View more

Text error messages work best, but if you need to attach images, please do so in an format like JPEG or PNG, which are more available to folks at home on the weekend (and not vulnerable to macro-viruses). - V ... View more

If you have ArcGIS, there's little reason to use the File Geodatabase API, since ArcObjects provides a more robust interface to FGDBs. The FileGDBAPI DLLs exist for use *outside* of the ArcGIS application environment.  ArcObjects has several potential access paths to Microsoft database products, though this isn't really the place to dwell on that. - V ... View more

Oracle is the only ArcSDE-supported RDBMS that doesn't use a "multiple databases per server instance" model, so storing multiple ArcSDE instances required multiple Oracle instances. User-schema geodatabases are an attempt to reduce the cost of isolated ArcSDE instances on Oracle (though they're not really all that isolated). Using PostgreSQL, you have the option of multiple databases, which are much more useful (and truly independent) -- There's no reason to use the kludge when you have the real thing available. - V ... View more

PG 9 is not supported at ArcGIS 10.0.  10.1 questions really belong in the beta forums, but I believe the intent is to support PG 9 at ArcGIS 10.1. - V ... View more

The StrPos and SubStr classes have been updated to support the above usage, and a full setk93b41 release is now available at the FTP site.  The next release of 'se_toolkit' will be setk100. - V ... View more

Yes, it's possible, though it's also possible (even likely) to corrupt spatial databases irrevocably with those tools.  It would probably be wise to explain in detail what you have (software versions, data descriptions, etc) and what you are looking to achieve, in order to determine what access options are least likely to corrupt your data. - V ... View more

You really need to sit down with the introductory documentation. ArcSDE does not publish services, it's just a mechanism for ArcGIS clients to access spatial data and other ancillary tables in a database. The location of the ArcSDE install is more influenced by the volume of application server clients (and whether you can afford to license an additional server).  If you are not yet experienced with ArcGIS components, it's unlikely you will need any of the more exotic deployment configurations to start. - V ... View more

Enabling TCPKEEPALIVE would probably address the firewall-terminated sessions, though it's probably worth the effort to address the brief connection firewall issue. - V ... View more

Are you testing read or write operation (or both)? Can you provide your source? - V [Gotta love them race conditions!] Is this one of the sample databases?  How many tables are in the dictionary? - V ... View more

Yup, 'vi' is your friend. They never got the marking capability running on the arcgis.com Forums. - V ... View more

There are four or five different Unix shells, and all of them have more capability than DOS (it's not even close). DOS borrowed Borne shell's redirection operators, so a script to run all scripts in a directory, logging both stdout and stderr to different timestamped files in Bourne would look like: #!/bin/sh # RunAll.sh - Execute all *.sh scripts in current directory (except this one) d=`date "+%Y%m%d"` for s in `ls *.sh` do         test `basename $s` = `basename $0` && continue         echo "Executing script '$s'..."         log1=`basename $s .sh`-${d}.log         log2=`basename $s .sh`-${d}.err         ./$s > $log1 2> $log2 done There are any number of good books and websites for shell tyros (though my favorite book is no longer in print). - V PS: To put both STDOUT and STDERR in the same file, use "./$s > $log1 2>&1" ... View more

Do you have an escape character in the Unix mapping file? If it was edited on Windows it may be missing a terminal newline (or have embedded CR before the LF). - V ... View more

Do not attempt to load into the AREA and LEN shape properties. If you use 'sdetable -o describe' you'll see the column layout that 'shp2sde' sees; this should help. The types are all equivalent, so you only need 'shpname sdename' in the mapping file. Don't mention the shape column in the mapping file (-l table,COLUMN handles that). - V ... View more