Latest Contributions by VinceAngelo

I believe this was a known issue -- possibly addressed by SP1 -- Spatial views weren't inheriting the secondary coordref (for the initially encoded BASIC precision geometry).  If SP1 doesn't fix this, try updating the SDE.LAYERS table for the view to match the base table. - V ... View more

I wish the 'C' API didn't have the SE_coordref_set_xy_by_envelope function, because it creates more problems than it solves. If you look at the coordref x/y offsets and scale that are generated, you're likely to see that the actual integer value generated on the Y member overflows the 2^31-1 limit. Best practice for ArcSDE coordinate reference creation calls for generating a buffer around your expected data space, to allow for search circles and other objects that exceed the data space.  I haven't had many occasions where I haven't used "SE_coordref_set_xy(coordref,-210,-120,1000000)" when working with PE_GCS_WGS_1984 data. See http://forums.esri.com/Thread.asp?c=2&f=1720&t=287575&mc=4#894148 for information on the storage impacts of using a scale factor in excess of the actual precision. - V ... View more

Modern annotation is more geodatabase than ArcSDE.  You can't use ArcSDE tools to manipulate annotation featureclasses directly, so I'd vote "not supposed to work". - V ... View more

Google shows half a dozen different InfoNets.  Which one are you using?  What formats does it support for export?  ArcSDE dosn't support a great many formats directly, but supports dozens of standards through ArcGIS.  Getting data into a database configured with ArcSDE is generally a simple exercise. Necessary privileges for ArcSDE use are determined by relational database -- which one are you planning to use? - V ... View more

For what kind of information are you looking? A search on "Personal ArcSDE" at www.esri.com returns 308 documents, many of which would appear to be useful.  The documentation also covers this topic: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n00000007000000.htm -V ... View more

Windows passes environment variables when a process is started.  The parent process for xp_cmdshell is the SQL-Server instance, which didn't have the SDEHOME and PATH set at the time it started, hence your problem. Yes, restarting the service should have accomplished the same as a reboot. -  V ... View more

Have you tried executing a "Set" command, to see what the PATH contains?  It's possible that the process is stripped of non-essential environment for security reasosns. Have you tried running a batch script from 'xp_cmdshell' with the ArcSDE command inside the .BAT file? Might as well tuck a "Set" in there too. - V ... View more

ArcSDE isn't generating this message, so I have no idea what is going on. I'm assuming you're using Desktop to load.  Have you tried a command-line loading tool with the same data?  Have you tried enabling tracing, and looking at the sequence of functions?  Have you tried using 'sdetable -o describe' on the table to see if the attributes agree (the rowid column cannot allow NULLs, and must be SDE-set for ArcGIS to load it)? - V ... View more

Client applications use the getservbyname() function to map service name to port number. Depending on how your server is configured, this may include a lookup in /etc/services, but certainly not in $SDEHOME/etc/services.sde. The "insufficient permissions" error is unrelated to your port issue.  If you enable tracing by setting SDETRACELOC and SDETRACEMODE variables, you might get more information about what is happening.  http://edndoc.esri.com/arcsde/9.1/capi_concepts/trace_functions.htm - V ... View more

ArcSDE requires that the geometry column permit NULL values.  Registered rowid columns are required to be NOT NULL. - V ... View more

Is the etc/sevices entry the last line in the file? Are you connecting from the same host, or a different one?  If different, does *it* have a services entry? What does 'sdemon -o status' report? What does 'sdelayer -o describe' report? - V ... View more

Don't grant SELECT to PUBLIC on these other schemas - V ... View more

Before deleting the database, delete the ArcSDE service it serves.  This should be as simple as stopping the service and using 'sdeservice -o delete -i esri_sde'. Once the service is gone, you can just detach the database and delete the datafiles. - V ... View more

Benchmarking of spatial index parameters tends to be specific to individual installs. I've found that the "best" parameters vary from site to site.  While there isn't much value in publishing the results, there is benefit in doing your own testing with "large" layers which might produce the most improvement. Keep in mind that there is no one "ArcSDE" index -- there are probably a dozen different rough guidelines that will produce different "best" performance with different data and query methodologies, and optimizing the data can greatly impact the net performance. Finally, you should make sure that the tests closely correspond to the operations being performed -- No amount of spatial index tuning will improve a full table scan query.  There may in fact be times where you want to use scale dependency from the application client to query different tables, tuned differently, at different scales. If you want to do your own benchmarking, there are utilities in 'se_toolkit' that provide individual layer performance calculations, and well as statistical analysis tools that could provide feedback for spatial index grid sizing.  See the old Forums for details -- http://forums.esri.com/Thread.asp?c=158&f=2290&t=303576&mc=1#949714 Good luck. - V ... View more

Yes -- http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=36459 - V ... View more