Latest Contributions by VinceAngelo

Feature classes haven't been "in an SDE" since SDE 3.0 was released. The current term of art is "enterprise geodatabase in {name of RDBMS}". Please provide the RDBMS name (and version), and the CREATE TABLE statement for the feature class in question. Generally, Shape_AREA is a computed column that doesn't even exist in the database, and therefore can't be defined NOT NULL. - V ... View more

There are no effective limits on file geodatabase (two billion or four quintillion features). It would help if you could document your exact steps, to the point of describing the feature counts in the eight tables, and specifying the exact geoprocessing command in the Analysis log. - V ... View more

@yockee wrote: The survey user is portal user and it does not have any connection with database user. Am I wrong ? The Portal user has nothing to do with the connection that was used to make the map service. The map service should NOT be published using table owner authentication. Which means that you need to validate your trigger function in pgAdmin while logged in as the publishing user. - V ... View more

Frankly, this requirement makes no sense. Using HTTP is inherently insecure. Many browsers refuse to use HTTP. Forcing processes to use HTTP for "security reasons" is bizarre. Since Portal was created after HTTPS was standardized, and Portal messages include authentication, running HTTP would compromise your Portal instance. I'd expect there is no legacy wiring to revert Portal into feeble security mode. With the volume of GIS data flowing, it's probably for the best for the scanner people that they can't process it (especially because the HTTP data from Server is being forwarded, so you get it twice). - V ... View more

Well, you certainly shouldn't be connecting a web app to a table as the table owner (huge security risk), so you need to make sure that the trigger works when logged in as the survey user. If the table is versioned, you won't see the UPDATEs until the version is posted to the business table (and detecting UPDATE events becomes problematic, since the Adds and Deletes tables both change on an update. You'd probably be better off adding Editor Tracking on the table, then using a SQL batch job to LEFT OUTER JOIN to the survey table, driving an INSERT into the id tracking table. - V ... View more

You really shouldn't have any need to create any logins that map to the sde schema, because you should never, ever load user data with the sde schema. Enterprise geodatabases actually have a requirement that the schema be the same as the login/user for any tables to be edited with ArcGIS tools (the only exception is when the geodatabase is owned by DBO, at which point it really has no security model at all). There is a Create Database User (Data Management) tool to help you create working enterprise geodatabase logins. This has the feel of an XY Problem. What were you attempting that made creating multiple logins that mapped to the sde schema seem necessary? Maybe we can help with that problem, instead. - V ... View more

That sounds like a firewall, VPN, or other port manager issue. It's possible there's an Oracle switch for this, but there's no place in the geodatabase API to set a timeout, and I've had Oracle connections up over weekends. - V ... View more

That makes more sense. You should be able to use SQL to update the lat/lon geometry component, if you just isolate the lat/lon coords and project them. - V ... View more

I've done this in PG13, PG14, and PG15 with no difficulty.  Except that one time when  I didn't grant access to the sequence in the target table to the role as which the inserts were running.  Then INSERTs silently failed.  I only found the problem by connecting to pgAdmin as the insert script user, generating an appropriate INSERT statement, and getting a useful error message. - V  ... View more

Can you query the rows in a DA SearchCursor and output the Geometry.WKT for each?  Does that display the correct projected values?  I have no idea how the layer could project on the fly to correct units if it didn't have correct SRID metadata. - V ... View more

If CAD objects are involved, Pro will render the CAD objects, not the geometry out of the database. It would be quite odd to get there, but that's the only reason that makes sense. - V ... View more

"Updates real time" is tricky in an interface that doesn't support parallel processing. This is less a Data Management issue than an ArcMap one. The ArcGIS Pro interface would let you do this easier (and that isn't a Data Management issue either). I'm not clear what you mean by "add a selection," but it seems like this isn't a real-time issue, per se, and you're really looking for a script tool that interacts with a UI (which is doable in either interface, and doesn't have a significant Data Management component). - V ... View more

Well, it should just work out of the box, but if you install/uninstall/reinstall Pro in different locations on a regular basis (like I do), sometimes the registry keys get out of whack. At that point you need to use RegEdit to repair the paths (there's three locations in two different keys where the current Pro install location needs update). I'm not going to walk you through something that has the potential to completely corrupt your host. If you're comfortable with RegEdit, you know why. And if you aren't, you probably shouldn't do so, and should turn it over to your IT admin staff. Good luck! - V ... View more