Latest Contributions by VinceAngelo

What license class of ArcGIS Desktop are you using?  Usually ArcEditor or ArcInfo is needed to make structural changes to data like this. - V ... View more

Which documentation says you need to upgrade first? There are many possible paths for any upgrade.  Finding a process that works for your particular set of tables can be a challenge, especially if you want to change storage methodologies.  Given that your ArcSDE configuration (9.3.1sp2) is supported in both 32-bit and 64-bit at 10.2 and 11.2, this is less challenging than many other upgrades discussed in these Forums. - V ... View more

After checking the System Requirements to be sure you're running a supported service pack of  SQL-Server, and validating that ArcSDE is properly interpreting the columns with 'sdetable -o describe', you'll probably want to validate the topology in your geometry columns.  From there the next step is Tech Support. - V ... View more

All ArcSDE releases have always stored SDEBINARY, SDELOB, and ST_GEOMETRY geometries with compressed integers. The coordinate reference has always described the parameters which form the origin and scale factors in the four dimensions available to geometries (plus the coordinate system, and since 9.2, cluster tolerance). There are many ways to access the coordref, but the easiest is to use 'sdelayer -o describe_long' and search for "offset", "units", and "precision" (among others) -- C:\>sdelayer -o describe_long -i ora100 -u staff -p ***** -l census_bg1a,shape ArcSDE 10.0  for Oracle11g Build 775 Fri Sep 17 11:45:27  2010 Layer    Administration Utility ----------------------------------------------------- Layer Description ....: <None> Table Owner ..........: STAFF Table Name ...........: CENSUS_BG1A Spatial Column .......: SHAPE Layer Id .............: 14 SRID .................: 5 Auth SRID.............: 4 Minimum Shape Id .....: 1 Offset ...............: falsex:       -400.000000 falsey:       -400.000000 System Units .........: 1000000000.000000 Z Offset..............:          0.000000 Z Units ..............:          1.000000 Measure Offset .......: <None> Measure Units ........: <None> XY Cluster Tolerance .:          0.000000002 Spatial Index ........:   parameter:    SPIDX_GRID,GRID0=0.21,FULL   exist:        Yes   array form:   0.21,0,0 Layer Envelope .......:   minx:      -179.14734,        miny:       -14.60526   maxx:       179.77847,        maxy:        71.35256 Entities .............: na+ Layer Type ...........: SDE-LOB Creation Date ........: 05/24/11 16:11:57 I/O Mode .............: NORMAL Autolocking ..........: Disabled Precision.............: High User Privileges ......: SELECT, UPDATE, INSERT, DELETE Coordinate System ....: GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] Layer Configuration ..: sdelob - Vince ... View more

If there isn't an entry in the ...\etc\services file which corresponds to "NSESRIDBP01VM", then the error means exactly what it says. Given the the "instance" ends in VM, I suspect you crossed the "server" and "port" flags. Thanks to the single database model, the database ("-D") parameter isn't really used in application server connects anymore. If you review the meanings of the "-s", "-i", and "-D" flags I expect you'll be able to find the right parameter combination. - V ... View more

Esri doesn't have any control over the permissions required to kill database jobs.  The application server processes are killable by the owning service, but Direct Connect sessions require what Microsoft says is necessary to get the job done. - V ... View more

ArcSDE is a *component* of ArcGIS Server (no longer sold separately).  This component still requires install before it can be used.  Note that with ArcSDE there are *three* kinds of install:  Software on the server, database configuration, and software on the client. The client component is covered by all ArcGIS products, so you just need to install the server component (install) and database component (post-install). You probably want to reconsider the "no links" directive, since the documentation is the clearest information you will find on this topic. - V ... View more

File geodatabase is an Esri storage format.  It has nothing to do with Microsoft's SQL-Server database structure.  They are incompatible, in the same way that diesel fuel can't be used by a gasoline engine. - V ... View more

ArcSDE is a technology that bridges ArcGIS to databases.  It is not a database, so a database is required, but the choice of database for Enterprise ArcSDE is quite flexible.  However, if you don't have an ArcGIS Server license, choosing the database for your ArcSDE deployment is premature (the SQL-Server Express instance which backs Personal and Workgroup ArcSDE instances is installed by ArcGIS -- you don't get to choose the version). All the system requirements and installation documentation are online, so you can continue your research via the search fields in the upper-right corner, or via search engine (for example, a google on "arcsde archiving arcgis" returned this podcast transcript on archiving). - V ... View more

'sdetable -o export' won't work, but 'sdedbtune -o export' will. Ditto with 'sdedbtune -o import'. 😉 - V ... View more

No Esri certification test involving a 10.2.0.1 Client has ever succeeded. As a rule, your Oracle Client should be at least as high as the RDBMS Server to which you connect (which in your case happens to be the 10.2.0.3 minimum required for ArcSDE). If you apply the 10.2.0.3 patchset to your Client, the problem will likely disappear. Alternatively, you can install the 10.2.0.3 (10.2.0.4?) client certified for use with W7. - V ... View more

Direct Connect uses local Oracle client libraries, but your software list doesn't show Oracle installed on your W7 host.  Which release do you have loaded? If you have 10.2.0.3 or higher, then an Oracle forum might be more useful in tracking this issue down. - V ... View more

I generally get a different error if the database has been bounced, but 'giomgr' start will truncate the process information table, so if a manual service start was made against the wrong database instance, then this would explain it... - V ... View more

How many tables are you talking about?  It's still not recommended to use feature datasets to organize "folders", but orgainzing multiple server instances for data that need only live in one adds to complexity as well. I usually just use data ownership accounts to keep track of dozens to scores of tables, but I'm a back-end server geek, so I rarely need to visualize a long list of tables through a GUI. - V ... View more

There's no need to prove that AGS 9.3.1 can't connect to ArcSDE 10.0 -- It can't. Upgrading a 9.3.1 instance eliminates over a dozen normalized GDB_* tables, replacing them with the new XML-based denormalized dictionary.  While 9.3.1 'C' API clients *can* connect to 10.0 servers, geodatabase-aware applications (like Desktop, AGS, Python,...) can't. The usual upgrade procedure is to roll out ArcGIS 10.0 clients, which can connect to either ArcSDE 9.3 or 10.0, and once all your apps are 10.0 ready, upgrade ArcSDE to 10.0. - V ... View more