Latest Contributions by VinceAngelo

What command did you use to create the layer?  One of the grid options (the default used by Desktop) is to compute the gridsize during loading, then apply it later (SE_SPATIALINDEX_AUTOMATIC), but failure during load could leave that option present with no follow-on step to change the gridsize. At this point you'd be better off defining a grid size or using ArcCatalog to rebuild the index. - V ... View more

ArcSDE supports five different RDBMSes that use SQL, all of which have different syntax for referring to dates and date functions.  Even using just Microsoft SQL-Server, there are multiple possible flavors (2005, 2008, 2008R2).  Dates can also be difficult due to variability of precision -- does a time reference to a day without hour imply midnight or noon, and in what timezone? What you're looking for probably involves the SYSDATETIME() function and some variant of DATEADD or DATEDIFF -- where date_col > DATEADD(day,-7,SYSDATETIME()) or where DATEDIFF(day,date_col,SYSDATETIME()) < 7 but that depends on the exact types involved.  This documentation page is probably a good starting point, but you'll likely need to experiment, since different variants of the same expression are likely to give different performance, depending on how the index interacts with the expression. - V ... View more

While 9.2 SP5 & SP6 can connect to 9.3 servers, Oracle 11g is not supported for layer creation (though from connect failure, it's possible you're not even using SP5 or newer). Try using a homogeneous client for layer registration (or just registering on the server). Keep in mind that registration is unlikely to succeed if 'sdetable -o describe' doesn't report SE_INT32_TYPE on the prospective registered rowid column. - V ... View more

No, ArcSDE is not designed so that the ArcSDE application server can failover.  The documented solution is to use Direct Connect and rely on the database API, but even this is not a perfect solution, since none of the databases support this seamlessly -- you'll need to reconnect when the primary database fails. You didn't provide the database product or ArcSDE version, so I can't steer you to the correct documentation, except to suggest searching with "direct connect failover {database}". - V ... View more

Did you create or populate data in that filegeodatabase using the Beta C++ FileGDB API? The contents of the directory is very incomplete. I doubt any recovery is possible. - V ... View more

Oracle 10.2.0.1 (Enterprise/Standard) is not supported with any release of ArcSDE -- It is known to have both performance and reliability issues.  Oracle 10g XE (Express) is supported (only available as 10.2.0.1), but not for production use. Try patching to 10.2.0.3 (with the most recent CPU patchset), and see if this doesn't help. If using Direct Connect, and your server is 10.2.0.3 or 10.2.0.4, then try patching the Clients to match. - V ... View more

If you don't need a GUI to populate tnsnames.ora, your can probably get by with just the Runtime client; I've done a custom install and managed to get ArcSDE working with less than the packages installed with Administrator.  Instant client is *not* enough. - V ... View more

The error states "could not create a connection" -- can that same user connect with an 'sdetable -o describe -t tbl_equipment1'? Since 11g support was introduced at 9.3, seeing a banner that states "ArcSDE 9.2 for Oracle11g" makes me wonder what else may be odd... What version of Oracle do you have installed?  What exact patchset (A.B.C.D notation)? What version of ArcSDE? What service pack is reported by the patch finder? What does DESCRIBE in SQLPLUS return on the table? What is the contents of USER_SDO_GEOM_METADATA for TBL_EQUIPMENT1? Is there a primary key constraint on the table?  Does the OID column exist, is it NOT NULL, and does it map to SE_INT32_TYPE? - V ... View more

I haven't ever used 'sdelayer' or 'sdetable' with '-u sde' (I was certified as an SDE instructor over 15 years ago, before the 'sde' user was introduced at 3.0). Conversely, I've never used 'sdedbtune' or 'sdeconfig' as any user other than "sde". The "sde" account exists to manage ArcSDE server configuration. All table management (DDL and registration) should be done as the data table owner(s) (which should not ever be "sde"). Any user with sufficent access (granted by the owner) can do DML operations. - V ... View more

1) Uninstall, then reinstall without spaces 2) Use the 8.3 name for Program Files (if available) 3) Use double-quotes around the string - V ... View more

If you don't have a layer with the desired coordref, create one (dummy table, sdelayer -add...). Hacking the SRTEXT is a much riskier activity; doing so is likely to corrupt your ArcSDE instance. 4326 is PE_GCS_WGS_1984. - V ... View more

Rather than changing the SRTEXT, I change the SRID in layers and geometry_columns to match the coordref with the SRTEXT I'm trying to match. I haven't tried using a '-R' to work around this, but I doubt it would work. pe_coordsys_eq does a string comparison. - V ... View more

For good or for bad (more the latter IMHO), ArcSDE ignores the '-G' coordsys in favor of the Oracle coordinate string.  {UNSUPPORTED  RISK="MediumLow"} If it causes me too much grief,  I manually edit the layer's SRID to point to a coordinate reference with the appropriate PE coordsys (just make sure the other parameters are appropriate){/UNSUPPORTED} - V ... View more

Does the contractor have ArcGIS 10?  ArcGIS 9.x cannot read ArcGIS 10 geodatabases. The workaround is to create an empty 9.3 FGDB, and have the 10.0 user populate it (without upgrading it, of course). - V ... View more

Raster catalogs are not displayed as rasters until the minimum tile threshold is reached (by either zooming in or raising the default threshold). You really shouldn't load *any* spatial data as the SDE user.  It should be treated as a privileged account with limited access (a la SYSTEM, SYS, sa, root, Adminstrator,...).  You also don't want to overfill the storage container assigned to the SDE user (Oracle TABLESPACE), since this can cause ArcSDE service failure. - V ... View more