Latest Contributions by VinceAngelo

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

Error codes are detailed in the documentation and in the SDK include files. Have you tried searching on the messages in the Resource Center search box? - V ... View more

Can you put 10.2.0.2 on a different box, populate the tables and view to reproduce the problem, then upgrade Oracle and try again?  I've found 10.2.0.3 to be *way* more stable than 10.2.0.2, but since Oracle isn't supporting 10g anymore, you need to be careful with upgrades (two backups wouldn't be a bad plan). - V ... View more

Back in the days of 100Mb disks, I had to do ugly things with symbolic links to run multiple copies of SDE from a single SDEHOME (faking multiple SDEHOMEs to save disk space). Now that ArcSDE supports multiple Oracle instances fom a single SDEHOME, I wouldn't consider using that feature if I was running under 15-20 instances.  Instead I copy the ora*exe directory to D:\ESRI with the instance in the folder name (e.g. D:\ESRI\sdeexe931sp1_prod), open a command window, set the SDEHOME and PATH to use %SDEOME%\bin, establish the correct ORACLE_SID/LOCAL, and run 'sdeservice' manually.  This way, when it's time to upgrade, I can apply the SP to the base install without corrupting my instances, and upgrade them each over time.  The way I see it, the space savings on a 200-500Gb disk just aren't worth the dependencies caused by using a single SDEHOME for multiple instances. - V ... View more

Nothing in Java, or in Oracle.  'se_toolkit' uses a number of different digest providers from open-source libraries (se_tools/digest.c), and calculates them across a stream as part of the Digest DAT class (dat/dat_compute.c).  The ring orienter isn't written yet. - V ... View more

I look for duplicates all the time, but I use a perfect hashing function (aka "digest") to calculate a checksum (e.g., md5sum) across a binary stream formed by concatenating the data from a list of columns. The trick is, Oracle doesn't have a perfect hashing function natively, so you'd need to use Java to achieve the same effect. Duplicate areas are much more frequent than duplicate geometries, especially in the realm of sliver polygons. Using all the vertices can cause false negatives if you don't have a strict rule about rotating the rings before passing them through the digest algorithm (e.g., the leftmost vertex with the greatest Y value is the starting point). [Hmm, that sounds like a fun piece of code to write...] - V ... View more

All applications using the ArcSDE API have an inherent ability to support homogeneous Direct Connect (provided the platform is supported be the database vendor);  Direct Connect across releases is a recent innovation (within reason).  Any app which doesn't support DC is going to be a priority for upgrade/replacement soon. I run alternate host ArcSDE 'sdesetup' sessions all the time.  So long as you've got a proper TNS configuration, there won't be any issues.  Heck, at 10.0, the instance upgrades are executed from Catalog, not 'sdesetup'. Placing an ArcSDE application server on the third party application host will likely incur an ArcGIS Server licensing requirement for that host. Esri is probably more likely to retain Direct Connect than application server if one of the protocols were to be dropped (neither is probable, so this shouldn't factor into your decisions at all). Make sure you configure the listener(s) to support ST_GEOMETRY, as per the install documentation (which is a reason to at least install ArcSDE on both RAC hosts -- It makes applying service packs easier). - V ... View more

While you can install ArcSDE on both RAC nodes, you probably shouldn't run it on either (that is, if you run the application server anywhere). Once you've committed to using RAC, you've effectively committed to using Direct Connect, so you can stop with step 3. It is not recommended to run ArcSDE (or Oracle) on a virtual host. - V ... View more

Edits to a versioned table, even one set to "move edits to base", go through the A/D tables. I once had a customer who was tweaking network weighting values on a large (200k rows) table and was complaining about poor performance -- If turns out they had 30 million rows in both the An and Dn tables.  I recommended they put modeling constants in a joined table, one edited with an ODBC connection. - V ... View more

That's not a random sample -- that's a systematic sample. For a random sample you'd need to know the actual IDs to highlight them, but for a systematic sample you just need to know the modulus operator for your database and the selection starting point, then you can select using a WHERE clause, e.g., WHERE mod(id,9) = 1. Keep in mind that the range of a modulus is [0..N-1], so mod(9,9) = 0.  - V PS: SQL-Server doesn't have a "mod" function, but it has an operator (e.g., WHERE id % 9 = 1) ... View more

Doh!  Yes. - V ... View more

I've been familiar with ArcObjects' requirements for a unique registered rowid column since 8.0 went beta. If you look at my view construction commands, both here and in the old Forums, you'll see that I always take the objectid column from the many side, which circumvents the Knowledge Base issue. Note that it's not ArcSDE which has an issue with non-unique objectids -- Desktop has to juggle the relationship between attribute metadata and graphics in the display pane; without a unique feature key to associate them, that task becomes nearly impossible. I just ran a trivial test of 1:M views with ArcSDE 10 (SQL-Server 2008) and ArcGIS 10, and my spatial views continue to function as expected -- C:\Incoming>more 1toMone.txt 1toMone.ctl 1toMmany.txt 1toMmany.ctl | cat :::::::::::::: 1toMone.txt :::::::::::::: AAAA|box:-10,6,-6,10 BBBB|polygon:6,6,10,6,8,10,6,6 CCCC|circle:0,0,3 DDDD|polygon:-6,-6,-10,-6,-8,-10,-6,-6 EEEE|box:6,-10,10,-6 :::::::::::::: 1toMone.ctl :::::::::::::: COORDSYS        GCS_WGS_1984 COORDREF_XY     -210,-120,1000000 EFLAGS          "na+" DELIMITERS      "|" REGISTER        objectid COLUMNS objectid        Sequence()                      -  10   N keyval          String                          -   4   N shape           Shape                           -   1   Y END :::::::::::::: 1toMmany.txt :::::::::::::: AAAA BBBB CCCC DDDD EEEE BBBB CCCC DDDD EEEE CCCC DDDD EEEE DDDD EEEE EEEE :::::::::::::: 1toMmany.ctl :::::::::::::: REGISTER        objectid(SDE) COLUMNS objectid        Sequence()                      -  10   N keyval          String                          -   4   N END C:\>asc2sde -o create -l otm_layer,shape -g 5 -f 1toMone.txt ASCII to ArcSDE 10.0 Loader Utility      Thu Dec 02 07:57:28 2010 ------------------------------------------------------------------------ Results:         Records read: 5         Rows created: 5          Insert time: 218.00 ms (22.94 TPS)         Elapsed time: 2.95 secs C:\>asc2sde -o create -t otm_table -f 1toMmany.txt ASCII to ArcSDE 10.0 Loader Utility      Thu Dec 02 07:58:53 2010 ------------------------------------------------------------------------ Results:         Records read: 15         Rows created: 15          Insert time: 16.00 ms (937.50 TPS)         Elapsed time: 422.00 ms C:\>sdetable -o create_view -T otm_view1 -t otm_layer,otm_table -w "otm_table.keyval = otm_layer.keyval" -c otm_table.objectid,otm_layer.keyval,otm_layer.shape ArcSDE 10.0  for SQL Server Build 775 Fri Sep 17 11:45:27  2010 Attribute        Administration Utility ----------------------------------------------------- Successfully created view otm_view1. C:\>sdetable -o create_view -T otm_view2 -t otm_layer,otm_table -w "otm_table.keyval = otm_layer.keyval" -c otm_layer.objectid,otm_table.keyval,otm_layer.shape ArcSDE 10.0  for SQL Server Build 775 Fri Sep 17 11:45:27  2010 Attribute        Administration Utility ----------------------------------------------------- Successfully created view otm_view2. C:\>sdequery -t otm_view1 ArcSDE 10.0 Generic Query Tool           Thu Dec 02 08:04:56 2010 ------------------------------------------------------------------------          1             objectid: 1               keyval: AAAA                shape: Area shape (1 part, 5 vertices)          2             objectid: 2               keyval: BBBB                shape: Area shape (1 part, 4 vertices)          3             objectid: 3               keyval: CCCC                shape: Area shape (1 part, 37 vertices)          4             objectid: 4               keyval: DDDD                shape: Area shape (1 part, 4 vertices)          5             objectid: 5               keyval: EEEE                shape: Area shape (1 part, 5 vertices)          6             objectid: 6               keyval: BBBB                shape: Area shape (1 part, 4 vertices)          7             objectid: 7               keyval: CCCC                shape: Area shape (1 part, 37 vertices)          8             objectid: 8               keyval: DDDD                shape: Area shape (1 part, 4 vertices)          9             objectid: 9               keyval: EEEE                shape: Area shape (1 part, 5 vertices)         10             objectid: 10               keyval: CCCC                shape: Area shape (1 part, 37 vertices)         11             objectid: 11               keyval: DDDD                shape: Area shape (1 part, 4 vertices)         12             objectid: 12               keyval: EEEE                shape: Area shape (1 part, 5 vertices)         13             objectid: 13               keyval: DDDD                shape: Area shape (1 part, 4 vertices)         14             objectid: 14               keyval: EEEE                shape: Area shape (1 part, 5 vertices)         15             objectid: 15               keyval: EEEE                shape: Area shape (1 part, 5 vertices) 15 rows found in 375.00 ms C:\>sdequery -t otm_view2 ArcSDE 10.0 Generic Query Tool           Thu Dec 02 08:05:04 2010 ------------------------------------------------------------------------          1             objectid: 1               keyval: AAAA                shape: Area shape (1 part, 5 vertices)          2             objectid: 2               keyval: BBBB                shape: Area shape (1 part, 4 vertices)          3             objectid: 3               keyval: CCCC                shape: Area shape (1 part, 37 vertices)          4             objectid: 4               keyval: DDDD                shape: Area shape (1 part, 4 vertices)          5             objectid: 5               keyval: EEEE                shape: Area shape (1 part, 5 vertices)          6             objectid: 2               keyval: BBBB                shape: Area shape (1 part, 4 vertices)          7             objectid: 3               keyval: CCCC                shape: Area shape (1 part, 37 vertices)          8             objectid: 4               keyval: DDDD                shape: Area shape (1 part, 4 vertices)          9             objectid: 5               keyval: EEEE                shape: Area shape (1 part, 5 vertices)         10             objectid: 3               keyval: CCCC                shape: Area shape (1 part, 37 vertices)         11             objectid: 4               keyval: DDDD                shape: Area shape (1 part, 4 vertices)         12             objectid: 5               keyval: EEEE                shape: Area shape (1 part, 5 vertices)         13             objectid: 4               keyval: DDDD                shape: Area shape (1 part, 4 vertices)         14             objectid: 5               keyval: EEEE                shape: Area shape (1 part, 5 vertices)         15             objectid: 5               keyval: EEEE                shape: Area shape (1 part, 5 vertices) 15 rows found in 250.00 ms C:\> The first attachment is a JPG of an identify on the lower-left triangle from using ArcSDE 10 with SQL-Server. I repeated the process with ArcSDE 9.3.1sp2 on Oracle 10.2.0.3, and got the same behavior (second image). If a spatial view with a unique registered rowid column doesn't behave properly while using a supported database build, please bring it to the attention of Tech Support. They'll need a copy of your data (or the smallest sanitized subset thereof which still exhibits the issue) to attempt reproduction and resolution. BTW: Robert - You probably don't need to place the layer in load_only I/O mode before a truncate and append -- the 'init' option of 'sdeimport' [nsic] does the truncate, load_only, insert, and normal_io in one command. - V ... View more

I'm running 9.2sp6, 9.3.1sp2, and 10.0sp1 on an XP host without difficulty.  Perhaps you're not using SP3 with all the roll-up patches? - V ... View more

What version of ArcGIS are you using?  Adding views to feature datasets was not supported as of 9.2.  No ArcSDE command or API function will populate geodatabase metadata like feature dataset membership. The only supported interface for this is ArcObjects (or ArcPy). - V ... View more

No, 'sdelayer -o register' *is* the way you register a table with geometry with ArcSDE. You'll probably need to contact Tech Support to work this out. - V ... View more