|
POST
|
Hello everyone, Environment ArcSDE 10.4. We are contemplating the option to remove all versions for a SDE database, compress, unversion layers, and then version to fix a problem we are having with versioning trees. If we make a copy of the current SDE database with all versions in a backup/copy. Then we remove all versions, compress and unversion, and version back with only Default in the main SDE database. Is there a way to copy back a few versions from the backup to the main SDE. The main question is to know if there is a way to copy a specific version from one SDE database to another SDE database. Knowing that both SDE databases have the same schema. It could be also the case of restoring a specific version from a backup. Thanks
... View more
03-22-2019
06:50 AM
|
0
|
3
|
2241
|
|
POST
|
Good afternoon, After running a "Repair Version Metadata; in Ms SQL Server ArcSDE 10.4 in an editable database with several versions we received the following error message: All versions already reference valid states. State 122209 has a parent id of 121108, which is invalid -- contact ESRI support. 0 lineage entries with invalid state ids removed. 0 mvtables modified rows with invalid state ids removed. Thanks
... View more
03-15-2019
10:39 AM
|
0
|
1
|
1127
|
|
POST
|
Good afternoon, We have 2 polygon layers: one for projects and another with properties. I am trying to find any sample in Vb or C# that shows how to find all the properties that are part of a project. Or how to find all the polygons from the property layer that are included or intersect with the main project polygon. The goal is to loop through the project layer, select all properties and check with another database if there is a match or if there are properties that need to be added from removed from the project. Thanks
... View more
01-31-2019
12:12 PM
|
0
|
0
|
790
|
|
POST
|
Good morning everyone, This console application adds features in a feature class. This behavior appears only when the feature class is versioned, if the feature class is not versioned, the application exits when running as stand alone in a command prompt window. I was able to find the reason why this behavior happens. It was caused by the "gputilities" object. Replacing gputilities.OpenFeatureClassFromString with pWorkspaceFactory.OpenFromFile(strFile, 0) worked. It looks like the "gputilities" object has some strange behavior. Hope it helps. Dim pFeatureClassParcel As IFeatureClass pFeatureClassParcel = gputilities.OpenFeatureClassFromString(strFC) By Dim pWorkspaceFactoryParcel As IWorkspaceFactory = New SdeWorkspaceFactoryClass() Dim pFeatureWorkspaceParcel As IFeatureWorkspace Dim pWorkspaceParcel As IWorkspace = Nothing pWorkspaceParcel = pWorkspaceFactory.OpenFromFile(strFile, 0) pFeatureWorkspaceParcel = CType(pWorkspaceParcel, IFeatureWorkspace) Dim pFeatureClassParcel As IFeatureClass pFeatureClassParcel = pFeatureWorkspaceParcel.OpenFeatureClass(strFC)
... View more
01-24-2019
06:58 AM
|
0
|
0
|
956
|
|
POST
|
Hello everyone, When I run vb.net Esri Console application, inside visual studio it works fine and it exist with code 0, but when I run the .exe alone it does not escape and it stays blocked in the Command Prompt window. Module Module1 Private m_AOLicenseInitializer As LicenseInitializer = New LicenseInitializer() <STAThread()> _ Sub Main() 'ESRI License Initializer generated code. If (Not m_AOLicenseInitializer.InitializeApplication(New esriLicenseProductCode() {esriLicenseProductCode.esriLicenseProductCodeAdvanced}, New esriLicenseExtensionCode() {})) Then Console.WriteLine(m_AOLicenseInitializer.LicenseMessage()) Console.WriteLine("This application could not initialize with the correct ArcGIS license and will shutdown.") m_AOLicenseInitializer.ShutdownApplication() Return End If Console.WriteLine("Start Processingon " & DateTime.Now.ToShortDateString) InitializeData() 'ESRI License Initializer generated code. 'Do not make any call to ArcObjects after ShutDownApplication() m_AOLicenseInitializer.ShutdownApplication() Console.WriteLine("Completed Processing on " & DateTime.Now.ToShortDateString) End Sub End Module
... View more
01-24-2019
06:42 AM
|
0
|
1
|
1185
|
|
POST
|
Hi Joshua, I am only interested in knowing it there are any records, not the number of records. Could you please explain the other techniques. Thanks
... View more
01-23-2019
04:41 AM
|
0
|
1
|
6667
|
|
POST
|
Is it faster than: for rowToday in srcToday: count = count + 1
... View more
01-22-2019
12:06 PM
|
0
|
1
|
6667
|
|
POST
|
Hello everyone, Is there a way to count records returned by a arcpy.da.SearchCursor? This is how I am doing the count # Initialize count = 0 srcToday = None with arcpy.da.SearchCursor(FeatureClass, fieldnames, whereClause) as srcToday: for rowToday in srcToday: count = count + 1 if count == 0: ……
... View more
01-22-2019
11:04 AM
|
0
|
6
|
7232
|
|
POST
|
I also tried this code and it also fails: dim version As IVersion = CType(pWorkspace, IVersion) Dim versionName As String = version.VersionName Dim targetVersion As IVersion = Nothing Console.WriteLine("versionName: " & versionName) ' ' working with Editor's version ' If version.VersionName <> strAEditingVersion Then Dim VrsWrkSpc = CType(pWorkspace, IVersionedWorkspace3) FAILS HERE!!!!!!!!!!! targetVersion = VrsWrkSpc.FindVersion(strEditingVersion) End If
... View more
01-16-2019
04:48 PM
|
0
|
0
|
585
|
|
POST
|
Reposted under ArcObjects group. pWorkspace = pWorkspaceFactory.OpenFromFile(prefixOutput, 0) Dim version As IVersion = CType(pWorkspace, IVersion) Dim versionName As String = version.VersionName Dim targetVersion As IVersion = Nothing ' check if working with Editor's version If version.VersionName <> strEditorVersion Then targetVersion = CType(pWorkspace.FindVersion(strEditorVersion ), IVersion) ************ It crashes here End If ERROR MESSAGE Error Message: Object reference not set to an instance of an object.Date1/16/2019
... View more
01-16-2019
04:26 PM
|
0
|
1
|
654
|
|
POST
|
pWorkspace = pWorkspaceFactory.OpenFromFile(prefixOutput, 0) Dim version As IVersion = CType(pWorkspace, IVersion) Dim versionName As String = version.VersionName Dim targetVersion As IVersion = Nothing ' check if working with Editor's version If version.VersionName <> strEditorVersion Then targetVersion = CType(pWorkspace.FindVersion(strEditorVersion ), IVersion) ************ It crashes here End If ERROR MESSAGE Error Message: Object reference not set to an instance of an object.Date1/16/2019
... View more
01-16-2019
12:29 PM
|
0
|
1
|
871
|
|
POST
|
Hello everyone, I need to change the default version to another version that is editable. How can I check if the version exists, ad also to change version from Default to my editor's version in pWorkspace and pFeatureWorkspace. I assume I have to use pWorkspace.FindVersion to check if the version exists, but how I change Default to the ew one? path_to_SDE_Connection_File = "Database Connections\SQLEditors.sde" pWorkspace = pWorkspaceFactory.OpenFromFile(path_to_SDE_Connection_File, 0) pFeatureWorkspace = pWorkspaceFactory.OpenFromFile(prefixOutput, 0) Thanks
... View more
01-16-2019
10:06 AM
|
0
|
0
|
561
|
|
POST
|
Hello everyone, How can I import a csv file to a table using ModelBuilder? Thanks
... View more
01-03-2019
05:41 AM
|
1
|
1
|
3991
|
|
POST
|
In this case layers are not versioned, so ArcSDESQLExecute runs fine.
... View more
01-03-2019
04:48 AM
|
0
|
0
|
2628
|
|
POST
|
I was looking for an option to run a Ms SQL Update statement because updating records using arcpy.da.UpdateCursor is too slow. The first option was to add the SQL code in a stored procedure and run the stored procedure. The second option, I just copy/pasted the code sample (http://pro.arcgis.com/en/pro-app/arcpy/classes/arcsdesqlexecute.htm) , added an Update SQL Statement to variable "sql_statement" , ran the code and it worked. sql_statement = " UPDATE [owner].[Property] " \ "SET [FOLIO] = APP.TCIS_GIS.FOLIO " \ …….. sql_statement_list = sql_statement.split(";") egdb_return = egdb_conn.execute(sql) Thanks
... View more
01-02-2019
12:59 PM
|
0
|
1
|
2628
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 3 weeks ago | |
| 1 | 05-01-2026 12:34 PM | |
| 1 | 12-02-2022 08:17 AM | |
| 1 | 12-26-2025 05:02 AM | |
| 1 | 08-05-2025 04:28 AM |
| Online Status |
Offline
|
| Date Last Visited |
2 weeks ago
|