Latest Contributions by ScottFierro2

‎01-26-2017

Short answer, no, 1 schema owner can not have authority over an object owned by a different schema and can only have read/select access. This is a huge issue with ESRI's security model and is one that we have made multiple attempts over several years now to get resolved with no luck. It's tied to ESRI's database security model that seems to have been morphed from the days of Microsoft Access databases into more current Enterprise databases without ever expanding or changing to allow the Enterprise databases to do some of the core things they are needed for. Here was a post I submitted back in the ESRI ideas page early days with included break down of why/how their model was more of a security issue for organizations and included the MS page discussing the use of these options for transferring ownership to allow for these types of scenarios https://community.esri.com/ideas/10736 Here is another example https://community.esri.com/ideas/9589 In order to successfully get the FC to register with the database you would need to login using the "cad" database username and associated password. You are then logging into the database as the CAD user which is the only user that by ESRI's existing models has the ownership level permissions to do these tasks.

‎01-24-2017

I would start by forcing a rebuild of your normal.mxt file. This is a base template that is generated for every ArcMap user and is what the application uses to define your viewer on launch. Navigate to the path below and delete the normal.mxt file located in the folder. Re-launch ArcMap. Your viewer will look brand new as if its first time it's ever been used and a new normal.mxt is built into the folder. Try adding back in the toolbar after all this. C:\Users\<user_name>\AppData\Roaming\ESRI\Desktop<version#>\ArcMap\Templates Based on latest pages it is supported out through 10.5 so if other users in your shop are using the same installer package you are and it's working fine then, in theory, you are set but still may be worth re-downloading the latest installer and running from it if that hasn't been done. Attribute Assistant | ArcGIS Solutions Not the same error but potentially something else to watch for https://community.esri.com/thread/179305

‎01-24-2017

Trying to piece a few of these items together. We use inline variables in over 100 ETL's but we do not define the current workspace or scratch as environment variables. If all your users are going to be running this out of some flavor of Arc then because they have Arc installed you should be able to leverage ESRI's scratch space without defining anything on your own. ESRI will recognize and use the same user dependent location when you make use of %scratchWorkspace%\ or %scratchFolder%. You can read up more about it and depending on systems and data size making use of the "in_memory" call might be useful https://blogs.esri.com/esri/arcgis/2012/10/19/the-new-scratchgdb-and-scratchfolder-environments/ The user based paths will look like this C:\Users\<user_name>\AppData\Local\Temp\5\arcBC74 but the last 2 folders will vary so you may see something like C:\Users\<user_name>\AppData\Local\Temp\2\arcDT51 or C:\Users\<user_name>\AppData\Local\Temp\7\arcFG26 Hopefully that can work to resolve your scratch concerns, you can build these directly into the model without needing to define model parameters and it will work for all your users. Moving on to the current workspace need. We essentially define our current workspaces without the use of defining a model parameter but it does mean where/when you need a workspace call that you simply connect it to the tool as an input. We assign a workspace (for us a .sde connection) as a data type = workspace and inline variable name of %TargetWorkspace%. This variable we then map into our tools that call for it. No model level environment variables set: Connected use of inline variable for %TargetWorkspace% (would be your current workspace) to 3 tools:

‎01-19-2017

Yeah I understand and why I suggested the workflow we use as an option because it works to systematically step through the use of the versioning process. As I said might be overkill for your workflow and needs. Another few base checks to look at as well: 1) Are there un-reconciled versions floating out at the DB level on the data set you are working with? 2) Look into those A_xxxx and D_xxxx tables for the FC in use, if there are records in there but no versions appear at the DB level that are needing to be versioned then this is the only time I have hit a true break in the process and seems to occur when 1 of our automated processes crashes completely mid run leaving the edits in these tables. When this occurs though there is a version left out at the DB that must be deleted along with the need to run a compress to clean up the SDE_States and SDE_State_Lineages tables.

‎01-19-2017

OK, so I will give you an overview of the general workflow we have tied to over 100 ETL's we use for our biggest public facing front end application all built in model builder and python. 1) Input Feature Class 2) Create new timestamped named version [python script] 3) Change version (model is inherently using default version so must change model to use version created in #2) [python script] 4) Perform slew of different GP/python processes as each ETL is different 5) Rec & Post (timestamp named version back to default) [deprecated tool version from 10.0] 6) Change version (changes model back to using default from new version) [python script] 7) Delete version (deletes the timestamp named version from the SQL Server DB) We perform the equivalent of trunk and loads, simple edits and more all within this framework and many of which are automated tasks via batch files run in Windows Task scheduler and can say we have never hit the hanging version issue you are referencing. I can't say that deploying a similar strategy is best or works based on your needs and workflows. For us, this method was key because there is a built-in rollback functionality that occurs during rec & post when errors occur and we would rather push out day old stale data until we can resolve any issues than to use a non-versioned direct to default method that could leave empty, corrupted or partial data. If you do decide you want to try that route then I suggest establishing the workflow using your current versions tools for create new version, change version, rec/post, delete version before venturing down paths like ours.

‎01-19-2017

If all you are running is a GET Count statement then yes I'd expect the GP to be dynamic with recognition of your edits. So starting with some overly simplified checks: 1) ensure the database is registered with the server you have the GP hosted on 2) not sure how you are getting your count back (json, txt, etc.) but check cache settings on servers and web browsers 3) modify the published GP processes refresh interval (default is once every 24 hours) to be shorter window 4) review models environment variables to ensure nothing in there is causing this Just a side note, if it's only a process to perform a GET Count and you are using SQL Server SDE do you have the ability to install SQL Server Management Studio (SSMS)? It's included as part of the SQL Server suite so no extra cost and writing the SQL statement for the SELECT and COUNT is really simple and is a query that can be easily saved for recall needs. Not to mention there is a world of options you can do behind the scenes of ESRI directly in the DB with this tool.

‎01-19-2017

Based on what you are describing it sounds like you are missing a reconcile & post task in your GP or as a manual step in your workflow. Essentially, your first edits are stored in a change log and in SQL server these tables are identified as <schema name>.a_1234 and <schema name>.d_1234, where the A table holds appends (this includes both new records and edits to existing records) and the D table holds deletes. Additionally, the 4 digits in the table name will be consistent for a single Feature Class (i.e. FC = PLANS.Test which has related tables of a_3754, d_3754 and i_3754). In order to take the edits you made in your first edits and have them show as the updated values for your second pass you must run the reconcile & post (to default) process explained here (after making your first edits before starting second): http://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/reconciling-a-version.htm Won't dive too far into options for conflict resolution and some of the other pieces of versioning because it sounds as though you are acting as the admin authority on the data and your workflow means you accept your edits to always be correct, therefore taking precedence over any other version edits that would produce conflict, which means you can do a post to default directly skipping conflict resolution.

‎01-04-2017

You said this occurs during syncing? So it occurs after each edit because you are working in an online mode or you are taking the map offline and receiving this error when you attempt to sync edits back to the DB?

‎12-16-2016

We generally always stand up a new VM for the upgraded database environment. Once we are confident its configured as intended then we migrate a backup of the SDE. Post migration we run some checks and rebuild the stats & indexes on everything (265GB database full compressed) and it usually takes under an hour to complete all that. Thus far we have done this for 2008 R2 -> 2012 for 3 different server/DB environments (DEV, TEST & PROD all migrated same way) and are doing it again for 2012 -> 2016 (doing all 3 environments again).

‎12-14-2016

Been working through some interesting testing and scenarios with the use of ESRI's security model options and configurations. One such scenario we are seeing mixed results with. Use of some of our Active Directory (AD) service accounts (no AD attributes populated for first/last names, e-mail, etc.) fails to authenticate while all other things considered they are identical to valid user accounts we have (these have nearly all of AD's attribute fields populated) which successfully authenticate. Sent this up through ESRI support channels and it reached one of ESRI's senior support advisors who seemed to have a wealth of knowledge on Server present and past but he wasn't certain on these details. So wondering if anyone can point to a site or knows of the specific AD attributes that are implicitly required to exist for successful authentication when using a web-tier configuration on IIS 7.5 in conjunction with AD?

‎12-05-2016

So running into similar issue again and digging back into things we saw that we had actually applied the below: <requestFiltering> <requestLimits maxAllowedContentLength="2147483648" /> </requestFiltering> Attempted to add in the limits suggested by jebu23‌ but those made zero impact to the issue.

‎11-17-2016

The Editor Widget provides the user functionality to draw lines and polygons. It would be such a more well rounded tool if it was given a toggle that allowed the measurements tooltips to be displayed as users drew or modified the features. Line: From start point user draws a single end point. Pop-up measure tooltip displays the distance from start to end converted into whatever calculation the user has chosen (i.e. km, miles, ft, etc.). In multiple vertices line features at draw the newest segment measure along with total line distance are displayed. At editing the same segment and total measures can be displayed and segment is determined by original drawing direction of the feature. Polygons (all geometric shapes): From center user expands the circle/triangle or other shape outward. Pop-up measure tooltip displays the distance from center to the edge (radius) along with the polygon area (sq) again all based off user selectable measurements Polygon (freehand): As user draws the tooltip displays the polygon area (sq) for the feature. Not sure a use case for radius from an interpolated center makes sense or is relevant so if someone can present that use case in comments for justification that'd be great.

‎11-02-2016

I see. It's an Interesting use case and can't say I have had a need or heard of anyone attempting it before. Your logic behind it is sound I just am not sure what to expect at publishing on the other end because I would expect at publishing it would error out due to no database details and it wouldn't prompt for a connection. If it did let you publish then it might prompt for the connection details but worse case you could always dive into the published directory folders and re-map the sources as needed.

‎11-02-2016

Ah OK that makes a bit more sense. So then it might be something worth posting your python code to the "Python" discussions and someone can help you pinpoint things if it's a code issue. Doing a Google search on the code ssl.c:590 will quickly give you some possible troubleshooting steps though. Perhaps take a look at these as well https://confluence.atlassian.com/sourcetreekb/resolving-ssl-self-signed-certificate-errors-284368425.html#ResolvingSSLSelf-SignedCertificateErrors-SSLcertificatesandMercurial https://access.redhat.com/articles/2039753

‎11-02-2016

Just trying to follow this scenario. So build the service based off tables in SQL Instance A. Publish a service but have edits that are occurring via published service occur against SQL Instance B? Any reason not to simple migrate a copy of the table(s) from SQL Instance A over to SQL Instance B. Build service in ArcMap based off connections to SQL Instance B and then be done? Only reason I can think of for attempting your workflow is because SQL Instance A and SQL Instance B reside on 2 separate LAN's that have no ability to communicate thus preventing the pre-staging of the tables. It still almost sounds like running a SQL DB Backup and then loading the backup to the new location is much faster/easier/more reliable even if you had to build a new DB instance just to migrate a single table into, backup and load to new location over trying to migrate an ESRI .sd file.

Online Status	Offline
Date Last Visited	‎03-07-2022 02:41 PM

My Ideas

Latest Contributions by ScottFierro2

Re: Feature class stored in another schema than the schema of the owner

Re: Attribute assistant installed but toolbar shows all fields as "missing"

Re: Modelbuilder workspace problem

Re: Are GP services useless on ArcGIS server with versioned data?

Re: Are GP services useless on ArcGIS server with versioned data?

Re: Are GP services useless on ArcGIS server with versioned data?

Re: Are GP services useless on ArcGIS server with versioned data?

Re: Collector maps not syncing - invalid credentials for map layer features.

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

ArcGIS for Server Active Directory Attrbiutes Required?

Re: Collector fails to upload all but small attachments

Measurments as part of Editor Toolbar in Editor Widget

Re: Publish service definition with database connection

Re: Server SSL Error

Re: Publish service definition with database connection

Re: Bad login problem with database connection in ...

Re: Specific Windows 10 permissions to run .py scr...

Re: Restrict administrative permissions on certain...

Re: Updating SSL Certificate

Re: Restrictive administrative permissions on cert...

Roads and Highways User Group (RHUG)

Ohio GIS