Latest Contributions by VinceAngelo

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

If the user is really "User_20230925" and database is really "Test_20230925", you might be having issues due to the upper-case characters. The connection code recases object names to lowercase. I've never been able to connect to mixed case named databases or as a mixed case username. - V ... View more

Are you using the "Append" tool? Is the "geodatabase"  file geodatabase or enterprise (and if so, which RDBMS)? Even if it would allow it, I wouldn't be terribly comfortable trying to project on the fly as an append. - V ... View more

Possible? Yes.  Supported? Big no. Yes (a change since I last attempted it, at 10.4) If you're familiar with how PostgreSQL works, hacking in via conf file changes might get you in,  [or you can use the supported tools to show the user/password and enable external connections], but it's possible that it won't get you too far, because you'd then need to traverse the geodatabase architecture from SQL (in psql or pgAdmin) You really want to work with Tech Support to resolve the root problem. - V ... View more