Latest Contributions by TheodoreRakel

‎02-19-2019

I think you're correct. The feature service seems to take the place of the database versioned view. Thanks

‎02-14-2019

Sorry I didn't mean using Arc Map. My client is moving to Pro. They have a console application that updates some attributes on a feature class each night. The console app uses SQL against versioned views to perform the updates to features. I am wondering if I can still use SQL to update features after they are versioned as 'branch versioned' or if I MUST use a feature service to perform the updates. If there was something like a versioned view available, I could keep most of the console application the same as it is now.

‎02-14-2019

My client is moving from traditional versioning (SDE) to branch versioning of data. We have custom code that makes use of versioned views to perform nightly updates on versioned data. Is there an equivalent to the versioned views that get created in SDE (featureclass_evw) in branch versioning? Is it even supported to make changes to branch versioned data using SQL or do I need to use a feature service? This is for Arc GIS 10.6.1.

‎10-04-2018

I submitted a case to esri about this and found that the connection I was using when running the 'Apply Asset Package' GP tool needed to have its geodatabase connection properties set to use 'Traditional' versioning. I had it set to use 'Branch' versioning. I ended up deleting the Utility Network dataset and running 'Stage Utility Network' GP tool again. Then I ran 'Apply Asset Package' and loaded the data successfully.

‎10-02-2018

I am using Pro 2.2.2 and trying to run the GP tool 'apply asset package' and load data. I get the following error that 'year 0 is out of range'. Is there any way to find out what date is causing this problem? I looked at the data in the asset package and all the dates I find are from Sep 2018. If I run 'apply asset package' and do not load the data, then the GP successfully completes. Start Time: Friday, September 28, 2018 8:17:57 AM Running script AssetPackageToUtilityNetwork... ArcGIS Pro 2.2.2.12813 untools 2.2.0 A python error occurred. EXCEPTIONTraceback (most recent call last): File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\common\wrappers.py", line 84, in wrapper return func(*args, **kwargs) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\gptools\tools.py", line 258, in run un = UtilityNetworkTools(utility_network) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\utils\utility_network.py", line 31, in __init__ self.refresh() File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\utils\utility_network.py", line 87, in refresh self.cache['describe'] = un_helper.Helper(self._un) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\un_helper.py", line 1232, in __init__ super().__init__(utility_network) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 845, in __init__ self.domainNetworks = [DomainNetworks(x) for x in d.domainNetworks or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 845, in <listcomp> self.domainNetworks = [DomainNetworks(x) for x in d.domainNetworks or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 524, in __init__ self.tiers = [Tiers(x) for x in d.tiers or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 524, in <listcomp> self.tiers = [Tiers(x) for x in d.tiers or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 450, in __init__ self.aggregatedLinesForSubnetLine = [AssetGroups(x) for x in d.aggregatedLinesForSubnetLine or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 450, in <listcomp> self.aggregatedLinesForSubnetLine = [AssetGroups(x) for x in d.aggregatedLinesForSubnetLine or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 305, in __init__ self.assetTypes = [AssetTypes(x, source) for x in d.assetTypes or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 305, in <listcomp> self.assetTypes = [AssetTypes(x, source) for x in d.assetTypes or []] File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 260, in __init__ self.creationTime = convert_time(getattr(d, 'creationTime', None)) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\untools\abstract\describe.py", line 51, in convert_time return dateutil.parser.parse(stamp) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\dateutil\parser\_parser.py", line 1356, in parse return DEFAULTPARSER.parse(timestr, **kwargs) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\dateutil\parser\_parser.py", line 653, in parse ret = self._build_naive(res, default) File "C:\Users\pe_gis\AppData\Local\ESRI\conda\envs\UN-environment\lib\site-packages\dateutil\parser\_parser.py", line 1227, in _build_naive naive = default.replace(**repl)ValueError: year 0 is out of range Failed to execute (AssetPackageToUtilityNetwork). Failed at Friday, September 28, 2018 8:18:04 AM (Elapsed Time: 7.45 seconds)

‎07-13-2018

My client has 10 Desktop Advanced licenses for ArcGIS Desktop 10.2.1. I'm testing installing ArcGIS Desktop 10.6 at the client's site. I couldn't use the existing license server, so I installed License Manager 10.6. I assume I need a new license file for at least 1 10.6 seat in order to continue. Is that correct? Can I use the client's existing license file in a 10.6 environment?

‎01-05-2018

Thank you. Someone else was connected. Once they were disconnected, compress got sde.default to state 0.

‎01-05-2018

I'm using ArcGIS 10.2.1. After deleting all versions except SDE.Default, I ran compress several times. I still have 2 states in SDE.States and SDE.Default state is not at state zero. Any ideas on how I can get Default to state zero?

‎11-10-2017

I'm using Arc Catalog 10.2 to connect to a recently refreshed Oracle geodatabase. Arc Catalog crashes when I attempt to connect to the geodatabase. I can connect using sql plus with the same user name and password that I use in Arc Catalog. I turned on sde intercept tracing, then attempted to connect to the geodatabase. I found GetConnectionError appears at the end of the sde intercept log file as shown below. Does anyone have any idea what causes the GetConnectionError message? The DBAs are off today since it's Veterans Day, so I'm looking for clues to help them when they return. Since the geodatabase was recently refreshed, it's possible there's a role missing or a tablespace issue. ======================================== [R 10:35:45.427] Command: VersionGet [R 10:35:45.427] NString: "SDE.DEFAULT" [W 10:35:45.427] Long: 0 [W 10:35:45.427] Version: Name: DEFAULT Owner: SDE Version ID: 1 Status: Public State ID: 137009 Description: Instance default version. Parent Name: Parent Owner: Parent Version ID:0 Creation Time: 6/17/2011 8:30:42 AM ======================================== [R 10:35:45.427] Command: StateLock [R 10:35:45.427] int64: 137009 [R 10:35:45.427] Long: 2 [W 10:35:45.428] Long: -172 ======================================== [R 10:35:45.428] Command: GetConnectionError [W 10:35:45.428] Long: 0

‎08-28-2017

I have a point feature class with 1.3 million point features. I have a line feature class with 70K line features. I'd like know what percentage of the line features are within 100 feet of one of the point features. What geoprocessing tool would give me this information? I'm using ArcGIS 10.2.1.

‎08-02-2017

I'm using ArcGIS 10.2.1. I have created a connection in Arc Catalog to an Oracle geodatabase. In the text box for the "instance" I put in "ddev1_linux". When I examine the connection properties, I see that it is set to "sde:oracle11g:ddev1_linux;LOCAL=gisdta". I'm curious why the LOCAL=gisdta has been appended. How do I interpret the "instance" string in the connection properties?

‎07-27-2017

I'm using ArcGIS 10.2.1. For some reason, I had it in my head that I needed to unversion a table in order to add or delete or change the size of fields in a versioned table. Then I had to version the table again after making the changes. Is that necessary?

‎07-21-2017

I'm debugging a custom ArcMap command written in C# that does a lot of tracing in ArcGIS 10.2.1. It would be helpful to see the junction and edge network element IDs (EIDs) displayed in ArcMap. Does anyone know of a way to display this information?

‎06-21-2017

Can you share how you were able to access related feature information in the pop-up configuration in ArcGIS Online? I don't see how to do that. Thanks.

‎06-19-2017

Is there a way in the Arcade Labeling profile to access the objects related to a feature?

Online Status	Offline
Date Last Visited	‎07-21-2021 05:43 PM

My Ideas

Latest Contributions by TheodoreRakel

Re: Is there an equivalent to versioned views for branch versioning?

Re: Is there an equivalent to versioned views for branch versioning?

Is there an equivalent to versioned views for branch versioning?

Re: Year zero problem when applying asset package

Year zero problem when applying asset package

Licensing 10.6 alongside 10.2.1

Re: SDE.Default not at state zero after compress

SDE.Default not at state zero after compress

What does GetConnectionError in sde intercept file indicate?

Summary of points near lines

How to interpret the "instance" in a ArcCatalog connection?

Can I add/delete fields from a versioned table?

Display network edge and junction ids in arc map

Re: Get related objects in Arcade

Get related objects in Arcade

Re: Does ArcGIS for Autocad 300 sp1 work with Port...

Re: Why does this model fail to find a .py file?

Re: SDE.Default not at state zero after compress

What does GetConnectionError in sde intercept file...

Is there an image analysis window in Pro?