Latest Contributions by danan

Good counterpoints Vince, thanks for your input. ... View more

Thanks for the correction re: 10 points per vote. My goof. But 90 votes doesn't seem too terribly bad. Thanks also for decrypting the AMI acronym. 🙂 ... View more

Here is a "reboot" of this Idea with a slightly different twist--offer such a thing in the Cloud: ArcGIS Server for Home / ArcSDE for Home use (in the Cloud) https://community.esri.com/ideas/9498 ... View more

Any thoughts on the probability and/or timeframe of implementing this? Would be wonderful to release at the next International UC. Or if you could provide an AMI for cloud-based experimentation with installing and configuring the latest ArcGIS Server / ArcSDE? ... View more

Thanks Fojo and Sean. Will take a look. The behavior you are encountering sounds very similar to a known Oracle limitation involving Datapump and ST_GEOMETRY. Here is a Knowledge Base Article describing this issue in more detail : http://support.esri.com/index.cfm?fa=knowledgebase.techArticles.articleShow&d=41252 The solution is to either move to 11.2.0.3.0 and apply the Oracle Patch or move to 11.2.0.4.0.  Contact Oracle Support Services for more information regarding this issue. Hope this helps. -Shawn ... View more

Bump. Need to potentially migrate an ArcSDE Oracle 11.2.0.2 instance (on a physical server running RHEL x86-64) to a VM host running RHEL x86-64, upgrading to Oracle 11.2.0.4 by the end of the process. What method should we use and which sequencing for the upgrade process? This is for an instance using ASM diskgroups if that helps any. So it's Grid Infrastructure (GI) "Oracle Restart" but not a RAC installation. I say "potentially migrate" because it's presently being decided (by the customer) whether to stay on physical servers (out of place same server upgrade--easy) or migrate to VMWare VMs, where most of our other Oracle instances live--and certainly any newly created Oracle instances run on VMs. Easier to manage a homogenous environment in my opinion. No more PSUs being released for Oracle 11.2.0.2. And I understand the last PSU for Oracle 11.2.0.3 for Linux x86-64 is scheduled to be July 2015. If you've had to do a similar migration, what upgrade path did you take? And what method did you use? Or if you're in planning mode for this, what method are you considering and why? Thanks in advance. ... View more

Sparx Systems has a non-beta ArcGIS UML Profile. This coming February 25th, 2014, they're offering a free webinar: How to Design a Geodatabase with Enterprise Architect http://www.sparxsystems.com/resources/webinar/webinar-registration.html "EA" is an affordable tool, ~USD $200. Well worth having a look since Esri has expressed no interest in natively supporting UML for GDB design. ... View more

No movement on this Idea in nearly two years. For personal projects, of necessity, I'll be re-investigating free open source alterative ways of serving up map services. ... View more

Hi Dana, It sounds like you might be running into an oracle problem with datapump. Check out the following oracle document and bug: Ora-22809 Nonexistent Attribute Creating Table With Sde.St_geometry Type [ID 1411854.1] Bug filed with Datapump: Bug 13693393 - ORA-600: [KPUDPXCS_CTXCONVERTSTREAM_REF_1], [SYS_TYPEID("SHAPE")] DURING IMPORT Thanks Fojo. In My Oracle Support (MOS), a search for Bug 13693393 beneath Patches & Updates > Number/Name or Bug Number (Simple) with Bug Number selected from the drop down and 13693393 in the search box revealed nothing. Does this mean the bug hasn't been fixed yet or was so recently submitted that it's not appearing the the search? Presuming User Error on my part and will keep looking. [UPDATE: MOS ID 1411854.1 reports the bug in Data Pump has not yet been fixed; and to use suggested workarounds] This all looks a bit hairy, and Esri Tech Support seems to conclusively consider this an Oracle Corp issue; not an Esri one. Wherever the truth lay, is there any easier way to handle this? Like using RMAN cloning to refresh a Recovery instance with data from a source instance? Would be interested in reading about this as a potential approach. One we eventually have Snap Manager for Oracle (SMO) configured with our NetApp storage, would SMO cloning be something worth looking into? Oracle Corp and NetApp jointly seem to tout SMO cloning as a key functionality that's a great boon to developers needing refresh data and an isolated instance to work against. That capability sounds a bit to me like ArcSDE Versioning in its approach. ... View more

Survey results are now available: Geodatabase Modeling and Design Tool Survey quantitative results ... View more