Latest Contributions by VinceAngelo

If you use SQL-Server 2008, you can use the native GEOMETRY type. - V ... View more

ArcObjects can specify a USER-set objectid, it's just not in the GUI. - V ... View more

I don't think so. This has been discussed extensively in the past (search forums.esri.com). It comes down to a design constraint -- If Desktop had to check for the existance of every table referenced by any FDS before the initial "open" returned data, some sites would be taking 30+ minute coffee breaks upon initial connect. Your only options are to either forgo FDS membership (i.e., you're using it as a container, not to edit related tables with shared topology) or to be less explicit in your FDS naming scheme. - V ... View more

Feature Datasets and Relationships are not RDBMS objects which can have access defined (just rows in SDE-owned tables).  The actual tables ("feature classes") can have GRANTs applied, so the contents of the meta-objects can be restricted to specific users (if you look inside a FDS as an unprivileged user, it will be empty). - V ... View more

If you make a clone via replication, then detach it and run it standalone, then you should apply the license and start the giomgr. If the instance is a standby database (physical or logical) you can't apply the license file without breaking replication.  The license installed in the primary will function for this use.  You can't run the giomgr when the database is standby, so read-only access to a logical standby instance can be achieved through Direct Connect. - V ... View more

You need to use the date functions and/or operators appropriate to your RDBMS to implement date ranges, not copy my conceptual notation literally.  It might help to work on this in SQL, without ArcGIS involved at all.  Once you know how to build a valid query, integrating it with ArcGIS will be less difficult. - V ... View more

Generally "update" means something different when referring to SQL. Do you mean 30k *rows* or 30k *tables*? If you replace the table contents daily you should consider registering the table with a USER-set rowid. Why don't you just take the extra step to make a point layer from the table?  Event layers don't have a spatial index, which means they are generally slower.  Loading 30k points into ArcSDE takes just seconds, and the API takes care of the registered column. - V ... View more

This is where we leave the technical and begin the legal. You can start the service if the database is not a standby server instance (physical or logical), AND if you've licensed ArcGIS Server Basic (or higher) on the host. - V ... View more

Keep in mind that ArcSDE has three components: 1) The database tables (and configuration, like ST_GEOMETRY library references in the listener) 2) The ArcSDE application server software 3) The ArcSDE client API If you move 1 and 2 to a new host intact, they will function.  In the case of Direct Connect, where 2 and 3 exist on the client, all you need is the network configuration for the database (TNSNAMES.ORA in the case of Oracle) to change servers. You should of course make sure the new host has /etc/hosts and /etc/services compatible with the old server (part of the "intact" condition), but Unix transfer is very simple (Windows transfer is only complicated by service creation). - V ... View more

Not everyone has Word on their computer, and even those that do might not be willing to open documents posted on the web (macro virus threat), and even if they are, there may be compatibility issues. The best format for posting screenshots is JPEG; yes, it requires a bit more work to save a "bump" as .jpg, but if you're looking for assistance, it makes it easier for the folks you want to read the documents to open them. Date types always have a certain level of imprecision to them -- especially when the database leaves it to the client app to determine timezone.  Equivalence tests are unlikely to result in a TRUE evaluation unless they are exact to the second (or even millisecond).  The safe way to do date comparisons is to construct a range test ( "datecol >= {date}00:00:00 AND datecol < {date+1}00:00:00" ).  You can sometimes use the BETWEEN SQL operator (e.g., "WHERE expr BETWEEN v1 AND v2"), but on some implementations BETWEEN evaluates as "expr > v1 AND expr < v2", which would miss values equal to v1. - V ... View more

You wouldn't ever run 'sdesetup -o install' on a database already configured with ArcSDE (and if you did, it would fail due to the existing instance). Re-running the authorization process isn't necessary either (and would fail if the instance wasn't read/write).  Even Windows service creation should be managed with care, since you can't start the service if the instance is in standby mode. - V ... View more

There are no ArcSDE command-line utilities to manage geodatabase objects. If the table is viewed by ArcSDE as having a SE_UUID_TYPE, but ArcGIS does not acknowledge it as a GlobalID, then you'll need to use either the ArcGIS GUI or ArcPy to do the registration, though it's not obvious what that method might be -- Have you tried a "register with geodatabase" after the ArcSDE layer registration and 'sdetable -o add_uuid_column'? If you don't need to use existing values, then waiting until after geodatabase registration is probably the path of least resistance. - V ... View more

What version of Oracle are you using? Which patchset? Have you applied the most recent CPU? What version of ArcSDE are you using? What service pack/patches? What does your table creation SQL look like? What does 'sdetable -o describe' report for the table? You can't register a column as a UUID type. It either is a UUID or it's something else. ArcSDE uses a NOT NULL VARCHAR2(38) on Oracle, with the leading and training braces, and the hyphens in the right places.  A registered rowid column is also required (as it is to register an SDO_GEOMETRY -- you should have a '-C' parameter in the 'sdelayer' command line). The programmatic way to define a UUID column in Oracle with ArcSDE is to create the table with 'sdetable' or some other 'C' or Java API application.  I can't think of any supported means to convince the table registration code that an existing column is SE_UUID_TYPE. - V ... View more

The documentation link in my first post *is* the complete list of all ArcSDE error codes. You'd have to consult the RDBMS vendors' pages for their error codes. You can try filing an incident with Tech Support, but you're much more likely to address the issue by applying the most recent CPU for 10.2.0.3 and/or 9.3.1sp1/sp2. - V ... View more

Error macros are a superset from previous releases.  While a 9.3 version of that document certainly exists, there wouldn't be anything in it not in the 10.0 list. By definition, OCI errors are those returned by Oracle API functions (Oracle Call Interface), so the errors would correspond to the ORA-nnnnn codes associated with those values (e.g.,  ORA-00936 == missing expression).  The errors the codes represnt don't make much sense, probably because the communication channel apears to have been scrambled. What version of Oracle are you using (10.x.y.z)?  On what platform?  Have you applied the most recent CPU (Critical Patch Update) bundle? Are you using SDEBINARY (LONG RAW) geometry?  What ArcSDE service packs and/or patches have you applied? - V ... View more