Latest Contributions by VinceAngelo

Actually, that table has a history of not being fully modified during upgrade.  If you have an older version of ArcSDE that was upgraded from something even earlier, it's doubtful that the contents are correct. The definitive authority on ArcSDE version is the output of the SE_connection_get_release function, which is what is exposed by the 'sdeping' utility of se_toolkit -- C:\>sdeping -u ***** -p ***** -i sde_eval93 ArcSDE 9.3 Connection Test Utility       Fri Apr 30 14:03:04 2010 ------------------------------------------------------------------------          Server: localhost        Instance: sde_eval93        Database: eval93        Username: *****           RDBMS: PostgreSQL         Version: 9.3.1     Description: PostgreSQL Build 2784(PostgreSQL)      Build Date: Tue Oct 27 10:51:14  2009         Release: 93005 As Eric mentioned, the ArcSDE command-line utilities expose the 'desc' member of the SE_RELEASE structure (which 'sdeping' splits for readability): C:\>sdelayer -o describe -u foo -p ***** -i sde_eval93 -O bar ArcSDE 9.3.1  for PostgreSQL Build 2784 Tue Oct 27 10:51:14  2009 Layer    Administration Utility ----------------------------------------------------- Bar does not own any layers OR user foo does not have access to any of bar's layers. - V ... View more

"sdelayer -o register" is the correct command to notify ArcSDE you wish to use a table with SQL geometry (ST_GEOMETRY or SDO_GEOMETRY) as an ArcSDE layer. "sdelayer -o add" creates a new geometry column in an existing non-spatial table (which may be SDELOB, ST_GEOMETRY, or SDO_GEOMETRY storage, depending on DBTUNE parameters). You *cannot* use "sdelayer -o add" on a table which has had "sdelayer -o register" executed on it.  It sounds like your SDE registry has been corrupted by a failed "register" -- time to contact Tech Support for assistance. - V ... View more

There is usually more than one way to accompish any task.  If you detach, you can toss the files into an archive / burn them to DVD before deletion, for the times when the answer to the question "Are you sure you want to delete?" Is "Yes, oops no - #%@^!" - V ... View more

Please help us to help you by giving a more complete description of the problem -- What database are you using?  Which version, service pack/patches? What version of ArcSDE are you using?  Which service pack and/or patches? What ArcSDE client are you using to pan & zoom? Which version, service pack/patches? What geometry storage type are you using?  What does 'sdelayer -o describe_long' report? How did you populate the data?  What does 'sdetable -o describe' report for the table?  Has this never worked, or did the failures start recently? Have you received any relevant database error messages recently? - V ... View more

The ArcSDE instance metadata tables are owned by "SDE" if 1) You use the SDE user to run the sdesetup utility, and 2) SDE is not registered as the database owner. The data owner will be the user who loaded the data, unless that user is a member of the Administrators role, or has otherwise been granted DBO rights, in which case the owner maps to DBO.  "Best practices" guidelines recommend reserving your SDE schema for ArcSDE instance administration, so you you should not ever load spatial data as the SDE user. - V ... View more

It's sometimes useful to run 'sdetable -o describe' on the target table, since this will show how the columns will get mapped to ArcSDE datatypes.  For example, the "ID" col will be mapped to SE_FLOAT64_TYPE, and is not eligible to be a registered rowid column (even if it were defined NOT NULL). I'll second the recommendation to use "shape", "geometry" or some descriptive name (e.g., "polygon") for the geometry column. - V BTW: Keep in mind that "-e l" will only permit single-part simple_line features -- a safer declaration would be "-e nsl+" (nil or multi-part line or simple_line). ... View more

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