Latest Contributions by VinceAngelo

Placing join tables in the FROM list hasn't been best practice since Oracle 8. I strongly urge you to use JOIN syntax.  And "!=" best written "<>".  The optimizer might prefer placing the point in the first argument, but if Table2 is indexed on t2.field3, and that has higher selectivity, you might want to specify the non-spatial constraints first (though NOT is usually an awful JOIN constraint). - V ... View more

The answer that this quoted was probably a better candidate for "Solution" marking. ... View more

It was right there: (i.e., generate SQL on the fly to execute in the database through a cursor) I also wrote "much more difficult". If you haven't spent the past six months generating `psql` INSERT statements in a Python DA SearchCursor query, it's still "possible", just a heck of a lot of work. Way more work than dragging and dropping a FGDB feature class into a connection file with a Standard or Advanced seat license (against a properly prepared PG database with a lower-case schema that matches the login and has the correct permissions). - V ... View more

There are a number of enterprise geodatabase platforms, even if you don't consider the four different flavors of each RDBMS, so your problem statement is missing critical information. Please specify the exact RDBMS in use (major and minor version, at least), the geodatabase release of the EGDB, the table definition, the exact attribute rule, and the exact Arcade expression in use. - V ... View more

Shapefiles aren't going to give Oracle ORA-29902 errors, either.  It might help to start over, explaining what you have, and what you're trying to do. Oh, and while we are trying to help, please don't state "please help" or that your situation is "urgent" (these are often counterproductive). It looks, from the errors (which should always be posted as text, not images, since the point of helping you is to help anyone else with that problem too, and by posing images, you hide the question from others), as if you are trying to load features into an Oracle instance with a specific loading tool. We need to know: The source file format(s) The name of the loader tool Whether the target Oracle instance has been correctly configured according to the documentation (it's been nearly a decade since I last used 10.4 with Oracle, but I remember that there were system configuration prerequisites that involved raising the number of cursors). Note that ArcGIS 10.4  has been retired for 27 months now, so it's unlikely that others will able to reproduce your environment, so we'll all be guessing here, trying to recall procedures and configurations from the twenty-teens. - V ... View more

Again, PostgreSQL and file geodatabase are different, and support different SQL implementations. CreateDatabaseView uses the native SQL support. If it's not there, it wont work. I'm not a fan of using UNION ALL joins -- too wasteful of resources. If the tables are so compatible, they ought to be partitions of a single table, and then the singleton "tables" are views of the parent. - V ... View more

Views in file geodatabase do not support UNION ALL joins -- the SQL implementation in FGDB is a subset of those used in actual databases. You should not expect file geodatabase to be a prototyping environment for PostgreSQL (they have little in common). Note that even in PostgreSQL, UNION ALL could have issues due to non-unique rowid values (overlapping objectid ranges). - V ... View more

The other option is to use a true JOIN clause in a VIEW, but doing so is tricky, since you need to preserve a unique rowid column. - V ... View more

Just for clarity, what data storage format do the two feature classes share?  If enterprise geodatabase, which RDBMS? - V ... View more

There isn't really an answer for this, and asking for an Esri response from the user forums isn't the right approach -- Even if employees do respond, they aren't speaking for the corporation (and asking them to actually reduces participation). That said, the recommendation is to use a server adequate to the task. Is that a standalone server? Well, maybe. But give the DBA the benefit of the doubt, since requiring that they add a box they don't want to use (and that has to be paid for) isn't likely to make their life easier. In the end, the "best" solution is the one that works for everybody. If the shared server is overloaded, adding GIS to the mix isn't going to help, but you'll be able to benchmark that. Sometimes everything seems fine in the TEST system, but moving into PRODUCTION demonstrates a scaling issue, even with a standalone server. And increasing the number of servers doesn't always improve performance, either, because sometimes the network or the SAN is the bottleneck. Each deployment is different, and can have wildly varying "best" solutions. - V ... View more

The third option is an ON INSERT OR UPDATE trigger to preserve the contents of the actual column. - V ... View more

This is more like a religious issue than a technical one. The DBA should have a say in the process, since they'll be the one supporting the configuration. Esri supports both (provided you're using the release documented as supported [and recognize "and higher" where appropriate]). Benchmarking both for your requirements is not a bad idea. - V ... View more

Okay, it could be the Esri DLL that's at fault, but it's more likely the FME code. The best way to explore this is with FME tech support (Safe Software -- https://support.safe.com/knowledgesubmitcase ). It's best to build as small of a test dataset as exhibits the issue (and if size impacts it, be sure to let them know where the cutoff is). ... View more

Is this the FME extension to ArcGIS or FME which is crashing? Esri doesn't support FME software. Does it work with a file geodatabase target (which you could then process with less complexity)? - V ... View more