Latest Contributions by Asrujit_SenGupta

I can suggest a workaround, but you will need to decide whether using it is feasible for you or not. You mentioned that your Database guy has made you a View based on that function. Now that View is slow to load, but does load in SQL Server Management Studio eventually. The workaround would be to create a separate Table out of this View. This Table would be static and thus will load normally in ArcGIS or SQL Server. Now, obviously the whole point of using a View is because the data will not be static. So, to see the new data, you will need to create a SQL Server job, which can run at any decided intervals, truncating the Static table and then updating it again with records from the View. The factors to consider: 1) How frequently will the data in the View change? If it hardly changes, then running the Job at the start of every day, should suffice. If it changes frequently, then you can decide upon the interval accordingly. 2) How much data are you dealing with in the View. Truncating the Table will not take much time, but updating the static table with the data from the View will take time based on the amount of data involved. Example for reference: Lets assume that the View that the Database guy gave you is View1, owned by GIS user. So it is dbname.gis.View1 SELECT * INTO dbname.schema.newtable_name FROM dbname.gis.View1 The above will create the new static table. Then use the below two SQL in the SQL Server Job: Truncate table dbname.schema.newtable_name Insert INTO dbname.schema.newtable_name SELECT * from dbname.gis.View1 ... View more

Essential geometric networks vocabulary—Help | ArcGIS Desktop  This is the 10.5 link, which mentions that same details as the old one you had found along with the same diagram. However, I feel that the "Connectivity table" in the diagram doesn't really exist as such and is just provided for representation purpose. The logical network When a geometric network is created, the geodatabase also creates a corresponding logical network, which is used to represent and model connectivity relationships between features. The logical network is the connectivity graph used for tracing and flow operations. All connectivity between edges and junctions is maintained in the logical network. The logical network is managed as a collection of tables that are created and maintained by the geodatabase. These tables record how the features involved in a geometric network are connected to one another. The logical network allows the geometric network to quickly discover and model the connectivity relationships between connected edges and junctions in a geometric network during editing and analysis. This allows fast network tracing and facilitates the generation of on-the-fly connectivity while editing. .** This is just my understanding from reading the docs and I may be wrong. ... View more

The same link that you mentioned, shows the below: N_<ID>_E<#>—Describes network edge weights; # = 2, 3, 4, or 5 N_<ID>_EDESC—Describes the edges in a network N_<ID>_ESTATUS—Describes the status of each edge including its deleted and disabled states N_<ID>_ETOPO—Describes the network edge topology or connectivity N_<ID>_FLODIR—Describes the network flow direction N_<ID>_J<#>—Describes network junction weights; # = 0 or 1 N_<ID>_JDESC—Describes the network junctions N_<ID>_JSTATUS—Describes the status of each network junction including its deleted and disabled states N_<ID>_JTOPO—Describes the connectivity of junction elements with edge elements N_<ID>_JTOPO2—Describes the connectivity of junction elements with edge elements when there are multiple edges connected to a single junction N_<ID>_T<#>*—Describes the weight values of each turn element N_<ID>_TDEFN*—Defines each turn element by listing the edges and junctions that make up the turn N_<ID>_TDEFN2*—Overflow table for the turn element definition; for example, if multiple edges make up a turn N_<ID>_TDESC*—Describes the turns in a network N_<ID>_TSTATUS*—Describes the status of each network turn, including its deleted and disabled states Is this what you are looking for? ... View more

Why do you want to avoid this? As Vince mentioned, this is an expected behavior of the software. ... View more

Anything logged in the Direct connect log file while executing this? ... View more

Is it possible to Turn-off the Firewall on the DBMS server and then check? Are you able to ping the DBMS server from the ArcGIS Desktop machine successfully? Do you have SQL Server Management Studio installed on the ArcGIS Desktop machine by any chance? If yes, can you connect to the instance successfully from there? ... View more

There is a Desktop Add-In as well, in case anyone wants to try that out: Clear Geoprocessing History If you look inside the XML under that Documentation field for 'Workspace' in the GDB_ITEMS tables, it will show you something like this: This can become so huge at one point that SQL Server Management Studio refused to open up the XML file in one of the Customer's environment. Clearing the GP History improves the connection speed in ArcCatalog and ArcPro drastically, as you observed. Bill Fox‌ ... View more

Automate the process, so that even if the users don't....it will automatically Reconcile\Post\Delete the versions unless there is conflicts at the end of the day\week. ... View more

Giving the scenario a second thought, the "Reconcile Versions" tool should do the needed for you. If you select the options of 'Abort if Conflict Detected' and 'Delete Version after post" combo, then only those versions will be deleted which have been Reconciled\Posted successfully to the Target Version selected (this part is IMPORTANT to consider) and do not have a child version of their own. So, if you kind off just need a Report or the log details, it will have something like below in case of a conflict: ... View more

There is no out of the box GP Tool for this yet. Ideas have been submitted for this: Arcpy support for version changes  Version Changes - Ability to export results  Ability to get a 'change_set' within ArcPy  Similar GeoNet posts with some kind of solutions: https://community.esri.com/message/454566?commentID=454566#comment-454566  https://community.esri.com/message/583495?commentID=583495#comment-583495  https://community.esri.com/message/654539-re-find-if-version-has-edits?commentID=654539#comment-654539  Python Script suggested in this link (not sure if this works, have to test yourself to find out): python - How can I extract the data showed in Version Changes before reconcile/post process? - Geographic Information Sy…  ... View more

I never personally setup one like the above mentioned scenario, but surely I have seen a few customers using this kind of setup while working in Tech Support. So yes, this is possible. ... View more

That should be like any other replica between two Enterprise geodatabases. Seamless. Have you observed any issues while setting this up? ... View more

The new FC creation was suggested just as a Test to make sure the all permissions are in place. That has got nothing to do with this issue in particular. ... View more

What exact error message do you observe? Tried creating a new FC after the migration and upgrade? ... View more