POST
|
Hello George, I was able to copy over our data from 10.2.2 using ArcPro 2.6. I then ran the migrate storage tool. I did some edits in Pro and no SDE_GEOMETRY tables were created. BUT, when I ran a Python script that truncates and appends to a feature class, a SDE_GEOMETRY table was created on a feature class that is not even involved in the script. I had to use Python 2.x aka ArcMap. I ran the migrate storage tool on this feature class and it said it worked but the SDE_GEOMETRY table is still there. Another thing that might be a factor is that we do not have the sde account access. We have been given a dbo account but it is not sde. Any thoughts are appreciated. Amy Rose
... View more
08-10-202001:00 PM
|
0
|
1
|
1257
|
POST
|
Thank you so much George. I think we may just need to run the migrate storage tool. I will have to wait until my colleague is back from vacation next week to run it. Thank you, Amy Rose
... View more
08-04-202001:09 PM
|
0
|
0
|
1257
|
POST
|
你好乔治,感谢。我认为problem is that the data is not being upgraded. Just copied and pasted. I had not heard of the Migrate Storage tool. I will take a look at it and the references you have provided. Thank you, Amy
... View more
08-03-202001:40 PM
|
0
|
4
|
1257
|
POST
|
Hello George, Thanks so much for replying! Our DB is SQL Server 2016 I see the SDE_GEOMETRY1 but I also see more: We are trying to upgrade to 10.6.1 from a 10.2.1 geodatabase. A colleague used basically copy/paste for their older geodatabase into their new 10.6.1 geodatabase so he wants to do the same for us, but I don't think it is working. I think we need to truly upgrade. I am not sure, but I think that the SDE_GEOMETRY tables (besides SDE_GEOMETRY1) should not be in 10.6.1, unless someone needs to keep a feature class on an older schema inside the 10.6.1. I am trying to confirm this. We also had editing errors like Trina Nair had in this post: //www.gobook3.com/message/760431-re-migrate-storage-tool?commentID=760431#comment-760431 I have asked if she was able to solve it, waiting for a reply. Any help always appreciated! Thanks, Amy
... View more
08-03-202009:58 AM
|
0
|
6
|
1257
|
POST
|
Hello Trina, I am having a similar issue. Did ESRI support give you a solution? I think ours is an upgrade problem but I am not sure. We have SDE_GEOMETRY tables showing up for a few feature classes in our 10.6.1 geodatabse but not all of them and I have also encountered the same error message. Any help appreciated, Amy Rose City of Dallas
... View more
08-03-202008:39 AM
|
0
|
0
|
437
|
POST
|
Hello, Should there be SDE_GEOMETRY tables in a 10.6.1 geodatabase? We have a 10.6.1 geodatabase that has several (not just SDE_GEOMETRY1). Does this mean the data did not properly upgrade? Any help appreciated, Amy Rose City of Dallas
... View more
08-03-202008:07 AM
|
0
|
8
|
1346
|
POST
|
Hello, I have been changing permissions on feature classes using Catalog in ArcPro 2.4. Our geodatabase is 10.6.1. When I looked at permissions on our SQL Server, I noticed that some permissions were granted with not just GRANT but WITH GRANT. I have not seen any rhyme or reason to it. All of our feature classes are simple geometry: point, lines and polygons. We don't have any networks, etc. We use just a few datasets. Is this a known bug? Is there actually a reason this might be granted? Can this permission be revoked on the SQL Server database side or will that cause problems? Any help appreciated, Amy Rose City of Dallas Storm Water GIS
... View more
06-30-202002:32 PM
|
0
|
1
|
396
|
POST
|
你好,我们有一个老钻9.3 Oracle的数据we have been successfully pushing into a SQL Server 10.2.2 geodatabase on a nightly basis using an sde connection and python. Now we are upgrading the one geodatabase to 10.6.1, but when I run the python script to truncate and then append the 10.6.1 geodatabase with the data from sde 9.3, it fails. Our information: Oracle 11g with sde 9.3 SQL Server Server 2016, 10.6.1 My question: Is it possible to transfer features from an sde 9.3 feature class to a 10.6.1 feature class with Python without having to export to a file geodatabase or shapefile first? I have tried creating a direct connection to our sde 9.3 but every combination has failed. Thoughts? Any help greatly appreciated, Amy Rose Senior GIS Analyst City of Dallas
... View more
06-15-202003:13 PM
|
0
|
0
|
399
|
POST
|
Well, What a difference a weekend makes. What worked on Friday is no longer working (I re-set a data source of a layer to see if it would work on the SQL Server point feature class that had the same name as the Oracle feature class). My initial thought was that it would not work because the data owner was not the same between the databases. So, it actually makes more sense now! I will need to change the hard-coded name value from GIS.POINTS to SDE.POINTS. If I have time and can figure it out, I would prefer having a "settings" dialog that allows for changing the feature classes via the GUI and NOT hard coded... Hope the code snippet might help someone.... Amy Rose
... View more
06-05-201708:33 AM
|
0
|
0
|
341
|
POST
|
你好,我们有一个工具,它有一个任务去看n existing feature class to find the highest number in a field called INDEX and return the next number. It then adds the next numbers to features that will be loaded into the main feature class. When the tool is used and the data source is a 9.3 Oracle SDE point feature class it works correctly by returning the next highest number, but when I tried using it on a 10.2.2 SQL Server point feature class, it returns the next "available" number. In this case a feature had been deleted freeing up a number that was not the highest. It was this number that the tool returned for the SQL Server feature class. Here is the code for the function: Any ideas why it is doing this? Is there a difference in how the code behaves between the two versions? I am going to create a point feature class that has no number gap and see if it works to confirm the possible issue. Any thoughts appreciated, Amy Rose Public Function GetNextHighestINDEX() As Long Try Dim pDS As IDataset Dim pTable As ITable Dim pCursor As ICursor Dim pRow As IRow Dim pQueryFilter As IQueryFilter Dim i As Long Dim pMxDoc As IMxDocument Dim pMap As IMap Dim pFLayer As IFeatureLayer Dim pFCls As IFeatureClass pMxDoc = My.ArcMap.Document pMap = pMxDoc.ActiveView '--- Set the input Point feature class pFCName = "GIS.POINTS" For i = 0 To pMap.LayerCount - 1 If TypeOf pMap.Layer(i) Is IFeatureLayer Then pFLayer = pMap.Layer(i) pFCls = pFLayer.FeatureClass pDS = pFCls If UCase(pDS.Name) = UCase(Trim(pFCName)) Then NodesFC = pFCls Exit For End If End If Next i If NodesFC Is Nothing Then MsgBox("No GIS.POINTS Layer Found in Map") Exit Function End If pTable = NodesFC pQueryFilter = New QueryFilter pQueryFilter.WhereClause = "INDEX is not null and (INDEX Like '1_____' or INDEX Like '2_____' or INDEX Like '3_____' or INDEX Like '4_____' or INDEX Like '5_____' or INDEX Like '6_____' or INDEX Like '7_____' or INDEX Like '8_____' or INDEX Like '9_____' or INDEX Like '10_____')" Dim pTableSort As ITableSort = New TableSortClass() 'pTableSort.Table = Table With pTableSort .Fields = "INDEX" .Ascending("INDEX") = False 'False for descending order .QueryFilter = pQueryFilter .Table = pTable End With 'apply sort pTableSort.Sort(Nothing) 'Use cursor to find highest number pCursor = pTableSort.Rows 'There's no need to loop cause you just want the highest number so the first row should be it 'Dim pRow As IRow pRow = pCursor.NextRow GetNextHighestINDEX = pRow.Value(NodesFC.Fields.FindField("INDEX")) + 1 Catch ex As Exception MsgBox(ex.Message & ex.StackTrace) End Try End Function
... View more
06-02-201712:06 PM
|
0
|
2
|
692
|
Online Status |
Offline
|
Date Last Visited |
08-09-202106:07 PM
|