Latest Contributions by VinceAngelo

Look again at the link "Creating an ArcSDE service from a remote Windows server".  It starts out: If your database management system (DBMS) is installed on one server and ArcSDE is installed on a separate Windows server, you cannot run the ArcSDE Post Installation wizard to create the service. Instead, you must use the sdeservice command to create an ArcSDE service if you want to use one. - V ... View more

The proper variable for Oracle is ORACLE_HOME (at which point the TNS_NAMES variable would not be required). - V ... View more

The 'sdeconfig' command is used to change the CONNECTIONS parameter, but with on a Windows server, you probably want to go through the registry changes listed in the final example in the troubleshooting guide. I've occassionally seen sites that had problems with stale connections, but have never had a site that needed weekly reboots -- You should probably take this issue to Tech Support. - V ... View more

There isn't any one perfect value ATTRBUFSIZE for all datasets.  How many columns do you have in your average table, and how many in your maximum?  What is the sum of the *potential* widths in your average table, and how wide is your maximum?  What is the *actual* width of your average and widest tables?  Do you store a lot of BLOBs, CLOBs or NCLOBs?  Do you have a very large number of concurrent connections? I've never had a reason to change any parameter controlled by 'sdeconfig' beyond CONNECTIONS, INT64TYPES, TCPKEEPALIVE, and MAXGRIDSPERFEAT (and the number of changes at customer sites beyond CONNECTIONS could be measured with a single digit).  Do you have some reason to believe your site is misconfigured?  It's a lot easier to hurt performance with the *SIZE and MAX* parameters than it is to improve it (they all interrelate with one another). - V ... View more

What version of ArcSDE are you using?  Which service pack?  With which RDBMS?  Are your connections application server or Direct Connect?  Have you tried raising the number of connections? - V ... View more

Juggling both 32-bit and 64-bit clients on a single Windows host is a major PITA.  I never measured any performance benefit to 64-bit ArcSDE on a Windows host (32-bit was actually a bit faster), so if you run ArcGIS Desktop on the same host, it's just easier to use one 32-bit client for both ArcGIS and ArcSDE. [Two notes: 1) There was a benefit to 64-bit Linux on a 64-bit VM server (but multiple clients is easy on Linux) 2) ArcGIS 10.1 will flip the equation by making 64-bit easier to use than 32-bit] The points didn't make me eligible for prizes. I just like to help folks (though it's easier to help those that appreciate the effort -- Thanks!). - V ... View more

Network connectivity is required for any TCP/IP session to function (both ArcSDE and TNS use TCP/IP).  I've never successfully placed a single box on two VPNs at the same time, though it should be possible if they're not the *same* network.  I doubt an Esri forum is the best place to find help in exotic subnet configuration. Unsatisfied link errors all derive from improper DLL search path resolution.  You'll need to walk through what files are required and identify where they're coming from.  This is a trivial exercise on Unix hosts (`which`, `ldd`, and `file` are your friends), but can be a source of agony on Windows hosts, even with a tool like Dependency Walker available. - V ... View more

I believe you need to do manual installation in a remote server configuration.  I always use manual install.  The documentation has the details of what is necessary. - V ... View more

The difference on the rowid column parameter is due to the inability to create a trigger on a view (even if the source column *is* SDE-set). There's quite a disparity between the rowcounts in your two tables.  Driving from the geometry table will help performance, but make sure there's an index on the "s" table's STD_ID column. Glad you get it working. - V ... View more

Your SQL*Plus client shows Oracle 10.2.0.1, which is not supported by any Esri applications.  If you are using Direct Connect, the client should be upgraded to the server release. Try registering with a user-set rowid ("-C OBJECTID,USER") - V ... View more

Spatial is not needed to use SDO_GEOMETRY.  The Intermedia package installs all you need, and you have to go out of your way to prevent Intermedia install, so it's probably available. - V ... View more

I'd recommend you use 'sdetable -o delete' on the view, and recreate it with SQL: CREATE VIEW stn_et_springseep_v AS SELECT g.objectid, s.stn_id, s.stn_stts_cd, g.shape FROM stn_et_geom g INNER JOIN v_mv_springseep_stn s ON stn_id Do some diagnotic queries, to make sure the table and view row counts are as expected, then register the view and try querying it through ArcSDE. - V ... View more

Is it your intention to install ArcSDE?  If so, getting a working OLE connection doesn't really matter, since ArcSDE can access both spatial and non-spatial tables. What version of ArcGIS are you using?  ArcGIS 10 supports Query Layers, which is yet another protocol which supports spatial tables. Searching a Microsoft forum may help with Microsoft provider issues. - V ... View more

Did you use 'sdetable -o create_view' or SQL to make the view? Generally speaking, views on ST_GEOMETRY columns should be constructed from SQL and registered with ArcSDE via 'sdelayer -o register'. What does your join clause look like? - V ... View more

The error does refer you to the documentation, which does state that Direct Connect is necessary... You are certainly free to contact Tech Support or use the Ideas page to recommend a change. I'm not sure how a recommendation to circumvent reading the upgrade documentation would be received. - V ... View more