POST
|
Hi Kevin, Thanks for your reply. There is a lot of shortage of ESRI documentation in this particular area i.e. data model changes as to what are the standard/best practices to be used when working in a versioned geodatabase. I have a few queries. 1. You mentioned that new feature class creation inside a versioned dataset does not require versioning to be disabled. Normally, whenever a dataset is registered as versioned, when we right click on it, we only have 1 option available i.e. to "unregister as versioned". "Register as versioned" option is greyed out. Now if we directly create a new feature class in this dataset, what options will we have enabled? Will both the options be enabled? 2. Similar to the question above, how does adding a new feature class directly in a dataset which has archiving enabled, affect the options "Enable Archiving" and "Disable Archiving" for the dataset? 3. If we're modifying an existing versioned feature class such as adding a new field or modifying existing field - if we directly do the changes without unregistering as versioned; do the changes reflect properly in any versions which still exist? Do any versions need to be deleted before doing this activity; such as posting all the edits to SDE.DEFAULT? 4. If we add or modify fields on a feature class with archiving enabled; how does this affect the corresponding H table? Will the field get added to H table as well? Thanks and Regards, Apurv
... View more
05-31-2018
01:37 AM
|
0
|
4
|
1017
|
POST
|
Hi All, I just wanted to start a discussion about data model changes. We have many instances where we need to do some or all of the following - 1. Field addition/deletion/renaming or any other field change. 2. Domain creation/modification. 3. New Feature class/Table creation. 4. New relationship class creation. 5. Enable Z-Aware or M-Aware on existing Feature Classes. 6. Unregister replica and create new replica. 7. Add/modify subtype to existing Feature Class. 8. Assign or modify privileges on feature datasets. In our case we have a database where we have datasets registered as versioned, with archiving and editor tracking enabled. We usually follow the process mentioned below to do any kind of data model change. 1. Disable editor tracking. 2. Disable archiving. 3. Unregister as versioned. 4. Do the data model changes. 5. Register as versioned. 6. Enable archiving. 7. Enable editor tracking. My query is which of the data model changes require us to disable all 3 options i.e. editor tracking, archiving and versioning and which do not? If some data model changes do not require all the options to be disabled then what is the best practice which should be followed in each instance? Regards, Apurv
... View more
05-22-2018
04:24 AM
|
0
|
6
|
1364
|
POST
|
Hi Randall, I have the exact issue which is described here. When I try in IE 11, I got the 498 error. When I try in Chrome (v66), I am unable to select the checkbox of the map service for which I want to export the statistics. When I try to check the checkbox, it get disabled for a second and becomes available for checking again. Only thing is that it is still not "checked" and remains unchecked forever, despite trying multiple times. ArcGIS Server version is 10.4.1 for Windows. Regards, Apurv
... View more
04-25-2018
07:41 AM
|
1
|
0
|
760
|
POST
|
Hi All, I am trying to write a stored procedure in Oracle to fetch data from a particular version, by using the sde.version_util.set_current_version function. When I run the following statement individually in SQL Developer, it works fine. EXEC sde.version_util.set_current_version('My Version Name'); It shows a message in SQL Developer as -> anonymous block completed After this I can query this version to get the data that I want. However when I try to use the same statement in a stored procedure it gives following error -> Error(12,8): PLS-00103: Encountered the symbol "SDE" when expecting one of the following: := . ( @ % ; The symbol ":=" was substituted for "SDE" to continue. If I use EXECUTE IMMEDIATE (as given below) instead of EXEC, then I get a different error. EXECUTE IMMEDIATE sde.version_util.set_current_version('My Version Name'); Error(12,21): PLS-00222: no function with name 'SET_CURRENT_VERSION' exists in this scope ArcGIS geodatabase is 10.4.1 and database which we're using is Oracle 12g. Can someone suggest how this function has to be used in a stored procedure? Once this statement gets executed, I want to select some data from versioned view in a cursor. Regards, Apurv
... View more
12-20-2017
09:33 AM
|
1
|
3
|
2185
|
POST
|
Hi All, I am getting a similar error in the service.log file(as given below). The ArcGIS Server version is 10.4.1 for Windows. The operating system is Windows Server 2012 R2. Due to this we're getting error while making a connection in ArcCatalog to administer ArcGIS Server. That error message is -> Tue Dec 19 06:55:00 GMT 2017:End NodeAgent.stop(true). Start invoked Tue Dec 19 09:40:01 GMT 2017:Start NodeAgent.start(). Tue Dec 19 09:40:01 GMT 2017:Loading all observers. arcgis_cloud_platform=null arcgis_cloud_platform=null Tue Dec 19 09:40:03 GMT 2017:NodeAgent loaded observer 'LogServiceObserver'. Tue Dec 19 09:40:03 GMT 2017:NodeAgent loaded observer 'ServerUninstallObserver'. Tue Dec 19 09:40:03 GMT 2017:NodeAgent loaded observer 'ServerConfigObserver'. Tue Dec 19 09:40:03 GMT 2017:NodeAgent loaded observer 'AutomaticMachineRenameObserver'. Tue Dec 19 09:40:03 GMT 2017:NodeAgent loaded observer 'VerifyMachineRegistrationObserver'. Tue Dec 19 09:40:03 GMT 2017:NodeAgent loaded observer 'Server upgrader'. Tue Dec 19 09:40:03 GMT 2017:NodeAgent loaded observer 'PlatformServicesPluginObserver'. Tue Dec 19 09:40:03 GMT 2017:Regular startup of Server. Tue Dec 19 09:40:03 GMT 2017:Starting RMI connector for NodeAgent. Tue Dec 19 09:40:04 GMT 2017 JMXServerContoller.getJMXConnector() failed to return connection - Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused: connect]20948:10 Tue Dec 19 09:40:04 GMT 2017 JMXServerContoller.getJMXConnector() failed to return connection - Failed to retrieve RMIServer stub: javax.naming.NameNotFoundException: jmxrmi20948:12 Tue Dec 19 09:40:04 GMT 2017:Invoking beforeStart() for all observers. Tue Dec 19 09:40:05 GMT 2017:Registering and starting log service on <arcgis_server_hostname>. Tue Dec 19 09:40:07 GMT 2017:Registering NodeAgent as JMX bean. Tue Dec 19 09:40:07 GMT 2017:Loading all plugins. arcgis_cloud_platform=null Tue Dec 19 09:40:07 GMT 2017:NodeAgent loaded plugin 'ProcessMonitor'. Tue Dec 19 09:40:07 GMT 2017:NodeAgent loaded plugin 'DirectoryCleaner'. Tue Dec 19 09:40:07 GMT 2017:NodeAgent loaded plugin 'UlimitMonitor'. Tue Dec 19 09:40:07 GMT 2017:NodeAgent loaded plugin 'LogFileLimiter'. Tue Dec 19 09:40:07 GMT 2017:NodeAgent loaded plugin 'ConfigSynchronizer'. Tue Dec 19 09:40:07 GMT 2017:Loading plugin.. com.esri.arcgis.discovery.admin.plugins.ServiceInstanceMonitor Tue Dec 19 09:40:07 GMT 2017:Props {PeriodicInterval=1, NodeAgentCustomPlugin=false} Tue Dec 19 09:40:07 GMT 2017:Loaded plugin com.esri.arcgis.discovery.admin.plugins.ServiceInstanceMonitor Tue Dec 19 09:40:07 GMT 2017:NodeAgent loaded plugin 'ServiceInstanceMonitor'. Tue Dec 19 09:40:07 GMT 2017:NodeAgent loaded plugin 'PlatformServicesPluginObserver'. Tue Dec 19 09:40:07 GMT 2017:Starting all plugins.z-service-gistest StartRMID - arg: -J-Djava.security.policy=file:/C:/Program%20Files/ArcGIS/Server/framework/etc/rmid.policy StartRMID - arg: -J-Dsun.rmi.activation.execPolicy=com.esri.arcgis.discovery.servicelib.impl.RMIDPolicyChecker StartRMID - arg: "-J-Djava.class.path=C:\Program Files\ArcGIS\Server\framework\lib\server\arcgis-servicelib.jar;C:\Program Files\ArcGIS\Server\framework\lib\server\arcgis-common.jar" StartRMID - arg: -J-Djava.rmi.server.useCodebaseOnly=true StartRMID - arg: -port StartRMID - arg: 1098 Constructing RMIDPolicyChecker: start Constructing RMIDPolicyChecker: done Using CATALINA_BASE: "C:\Program Files\ArcGIS\Server\framework\runtime\tomcat" Using CATALINA_HOME: "C:\Program Files\ArcGIS\Server\framework\runtime\tomcat" Using CATALINA_TMPDIR: "C:\Program Files\ArcGIS\Server\framework\runtime\tomcat\temp" Using ARCGIS_JAVA_HOME: "C:\Program Files\ArcGIS\Server\framework/runtime/jre" Using CLASSPATH: "C:\Program Files\ArcGIS\Server\framework\runtime\tomcat\bin\bootstrap.jar;C:\Program Files\ArcGIS\Server\framework\runtime\tomcat\bin\tomcat-juli.jar" Tue Dec 19 10:10:13 GMT 2017:Invoking afterStart() for all observers. Tue Dec 19 10:10:16 GMT 2017:End NodeAgent.start(). Regards, Apurv
... View more
12-19-2017
04:28 AM
|
0
|
0
|
2435
|
POST
|
Finally we found the root cause of this issue. It has got nothing to do with installation or environment etc. The problem is that our version names are quite long in length i.e. more than 50 chars. However, the char limit of the VERSION field in JTX_JOBS_DB table is only 50 chars. Hence I think WFM fails to update the version name in this field. I tried creating jobs with names such that version name would be 50 char or less than 50 chars, and it is able to populate those version names. So as a fix, we had to alter the field to increase the length to accommodate our lengthy version names. However I have following observations. 1. Why is the JTX_JOBS_DB table designed in such a way that VERSION has only 50 char limit while VERSION_OWNER has 200 char. I think it should be the opposite. In how many cases will we have an owner name more than 50 char? 2. In JTX_JOBS table the version field has 100 char limit, whearas in the JTX_JOBS_DB it is 50 char. To make it consistent, both should be 100 char. Regards, Apurv
... View more
11-06-2017
09:49 AM
|
0
|
0
|
362
|
POST
|
Hi, I am testing ArcGIS Data Reviewer 10.4.1 and I want to test the invalid geometry check against point and polygon features, which I also want to create newly in a geodatabase version. I am using Oracle 12g for the geodatabase. Also installed Data Reviewer 10.4.1 patch 6. I was able to reproduce an invalid polyline geometry which self intersects, i.e. the same feature cuts itself. However for point and polygon I'm not able create a geometry which is invalid to test against. ArcMap doesn't allow me to create any points or polygons which have invalid geometry. I think this check would be most useful for data which has been migrated from different sources, but still to test it I need to create some data in the geodatabase which is invalid. I thought of modifying the X and Y coordinates in the SDO_Geometry field (SHAPE) for that particular feature in the A table (as I created the feature in a version); or even make the value for this field as null. However I think doing something like this from backend in SQL might corrupt the feature class. Is there any safe way to create test data for invalid geometry check for points and polygons? Regards, Apurv
... View more
11-06-2017
07:21 AM
|
0
|
1
|
491
|
POST
|
Hi, I am also having the issue as given below in ArcGIS Server logs. In my case, I have a web service which calls the "ExportMap" method of ArcGIS Server REST API for a particular dynamic map service to generate a map image for a given extent. In few cases such as mentioned above, the web service fails to generate a map image because of the errors mentioned above in ArcGIS Server logs. When I checked the same scenario again, the image was retrieved successfully and generally it works. It is these one off cases where I've observed that it fails. I am using ArcGIS Server 10.4.1. Any suggestions? Regards, Apurv
... View more
11-01-2017
05:05 PM
|
0
|
0
|
2227
|
POST
|
Hi Asrujit, Yes! I managed to delete them using SDE user. Thanks! Actually I had tried this previously but the option to delete the version was not enabled, it was greyed out. However, we recently gave some privileges/roles to SDE user and then I was able to delete them. Regards, Apurv
... View more
10-12-2017
12:22 PM
|
0
|
1
|
1601
|
POST
|
Hi, We are using Oracle12c for our enterprise geodatabase at 10.4.1 and we're maintaining versions using OS authentication. All the users create their own versions using OS authentication. Now, when we want to delete some of the versions for housekeeping, we need to ask those users to delete their own versions, as (I think) only the version owner can delete their versions. Now, we may face an issue which is if someone leaves the organization, and the corresponding user id which is used to logon to the systems becomes disabled, and the user didn't delete his/her versions and they are left over, then how do we as administrators delete them. I have tried using the respective user-defined schema owners, where we have kept our datasets, and tried to delete those user versions using the schema owner, but the geodatabase still does not allow to delete them, even though the versions are marked as "Public". Bear in mind that the versions created using OS authentication are named as "WindowsLoginUserName".<VersionName>, while those created using DB authentication (schema owner) come as <SchemaOwnerName>.<VersionName>. There are no double quotes if we use database authentication. So is there a way to delete the versions, belonging to a user, whose ID may have been disabled? Regards, Apurv
... View more
10-12-2017
09:45 AM
|
0
|
3
|
2452
|
POST
|
Yes Domenico, sorry for very late reply We can use SOE for this requirement, but deployment and management of SOE's is not very straightforward in my experience. In fact I don't think nowadays many people are using SOE, rather they're using functions provided by REST API and GP services. Regards, Apurv
... View more
10-06-2017
07:40 AM
|
0
|
1
|
709
|
POST
|
We installed WFM on another machine, and connected to the same Workflow database, and installed our application in this other machine. There everything is working fine. So it could be an issue in WFM install in the original machine. Regards, Apurv
... View more
10-06-2017
04:08 AM
|
1
|
0
|
362
|
POST
|
Hi Meggie, Thanks for your reply. We tried many things such as - 1. Import entire JXL file which was exported from another environment, where everything was working fine, and set up the configurations again. This did not work. 2. Drop the WFM schema from database, and recreate it from scratch. We did this, and even after this it did not work. 3. Finally, we installed WFM on another machine, and deployed our application there and tested it, it worked! We could see the version appearing against the Job Information. So there seems to be some problem to the WFM installation in the original machine. We're planning to repair or uninstall and reinstall the WFM from original machine and then check again there. Regards, Apurv
... View more
10-06-2017
03:53 AM
|
0
|
0
|
760
|
POST
|
Hi, Since last week or so we have started facing this issue. We're using WFM 10.4.1 and we connect to WFM using OS authentication. The database is Oracle 12c. We have provided all privileges (select, insert, update, delete) on WFM tables and Feature classes to the users who use OS authentication to connect. We have some applications which use the following code to create jobs and versions. Now earlier, the version was getting attached to the job as part of Job Information. Now it simply shows "No version". What we did is that we had to modify a particular job type's workflow, and we wanted to only deploy that patricular JXL file of this workflow. But we cannot overwrite a workflow using its updated JXL file. The only way is to import the entire WFM configuration. We did not want that approach. So to test the new approach, we deleted the existing workflow in our development environment which was attached to a particular job type. Then we imported the updated workflow JXL and gave the same name to our workflow and applied it on the job type. Since then our code stopped working. The code is creating the versions in the geodatabase, but it is not updating the job information or JTX_JOBS table with the version name. With OS authentication, the version names should appear with double quotes such as "ABCUser".VersionName. But in the JTX_JOBS table it is just showing the default "JobID:ID". We have also tried following steps. 1. Importing the entire WFM configuration JXL file from another environment, where everything is working fine. 2. We also dropped the WFM schema, and recreated the schema, and workflow database and configurations. Still the issue persists. As we tried both these options, I think the problem cannot be in the database or the JXL import. It might be - 1. Problem with Workflow Manager installation. 2. Some other configuration, which got corrupt which we're not aware of. Below is the C# code. IJTXDatabaseManager databaseMan = null; IJTXDatabase2 JTXdatabase = null; IJTXActivityType pActType = null; IJTXConfigurationProperties pConfigProps = null; IJTXJobType pJobType = null; ; IJTXJobManager pJobManager = null; IJTXJob pNewJob = null; IVersion pNewVersion = null; string jobType = string.Empty; string jobName = string.Empty; string dateFormat = string.Empty; string notesInformation = string.Empty; string vesrsionName = string.Empty; try { //binding bool isBound = ESRI.ArcGIS.RuntimeManager.Bind(ESRI.ArcGIS.ProductCode.Desktop); if (isBound) { IAoInitialize aoInitialize = new AoInitializeClass(); //check for license aoInitialize.Initialize(esriLicenseProductCode.esriLicenseProductCodeStandard); aoInitialize.CheckOutExtension(esriLicenseExtensionCode.esriLicenseExtensionCodeWorkflowManager); databaseMan = new JTXDatabaseManagerClass(); JTXdatabase = (IJTXDatabase2)databaseMan.GetActiveDatabase(false); jobType = "<Our Job Type Name>"; dateFormat = "ddMMyyyy_HHmmss"; jobName = "<Our Job Name Prefix>" + DateTime.Now.ToString(dateFormat); pJobType = JTXdatabase.ConfigurationManager.GetJobType(jobType); Console.WriteLine(pJobType.ID); pJobManager = JTXdatabase.JobManager; pNewJob = pJobManager.CreateJob(pJobType, 0, true); pNewJob.Name = jobName; pActType = JTXdatabase.ConfigurationManager.GetActivityType(Constants.ACTTYPE_CREATE_JOB); if (pActType != null) { pNewJob.LogJobAction(pActType, null, ""); } pConfigProps = (IJTXConfigurationProperties)JTXdatabase.ConfigurationManager; if (pConfigProps.PropertyExists(Constants.JTX_PROPERTY_AUTO_STATUS_ASSIGN)) { string strAutoAssign = pConfigProps.GetProperty(Constants.JTX_PROPERTY_AUTO_STATUS_ASSIGN); if (strAutoAssign == "TRUE") { pNewJob.Status = JTXdatabase.ConfigurationManager.GetStatus("Created"); } } vesrsionName = pNewJob.Name; pNewJob.VersionName = pNewJob.Name; pNewVersion = pNewJob.CreateVersion(esriVersionAccess.esriVersionAccessPublic); Console.WriteLine(pNewJob.VersionName.ToString()); pNewJob.Store(); MessageBox.Show("Success"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (databaseMan != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(databaseMan); databaseMan = null; } if (JTXdatabase != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(JTXdatabase); JTXdatabase = null; } if (pActType != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(pActType); pActType = null; } if (pConfigProps != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(pConfigProps); pConfigProps = null; } if (pJobType != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(pJobType); pJobType = null; } if (pJobManager != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(pJobManager); pJobManager = null; } if (pNewJob != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(pNewJob); pNewJob = null; } } Any help is greatly appreciated. I can provide further details if necessary. Regards, Apurv
... View more
10-05-2017
12:38 AM
|
0
|
2
|
668
|
POST
|
Thanks a lot Meggie for your reply. Yes we were trying to "update" an existing job type by importing its updated JXL file. However when we tried that, nothing happened. As you suggest, we only have the option of importing the entire WFM JXL file in this scenario. However now we're facing an even more serious issue. We have many existing job types, and our custom application creates jobs of those job types. Lets say for purpose of your understanding, these job types as A, B and C, and its custom application is "ABC". Now as part of enhancements, we created one more job type D. Now the jobs for job type D are created by a different custom application, compared to job type A, B and C. Lets say this custom application is called "XYZ". Now, we also had a defect in the custom application ABC. Both ABC and XYZ applications create jobs and versions using the IJtx ArcObjects interfaces, using OS authentication connection to WFM. So versions are created in the format "OS_Username"."Version_Name". Now somehow for reasons which we're unable to understand, and we're at wits end on this; the jobs created using application ABC is showing "No Version" in WFM against the Version. Screenshot given below. What is baffling is the version is created by the application ABC and the version name exists in the Version field of JTX_JOBS table in WFM database. Previously the versions used to appear. What is even more interesting is that the jobs which are created by application XYZ, does show the version name for job type D(screenshot given below). We're using exactly the same ArcObjects code to create the job and version in both applications. We checked all the configurations in WFM Administrator for job types A, B and C. Everything seems to be fine. We were not sure of this "No Version" observations started happening due to the the changes we did for application ABC or due to adding the new job type D and application XYZ. Both applications use the same user ID (OS authentication). So we created another simple application which uses the IJtx ArcObjects and only creates jobs and versions for job types A, B, C and D. Even with this simple application, for job types A, B and C, we see "No Version" in WFM, though the version has been created in database; whereas for job type D, we see the version in WFM. What could be the reason for this, we're unable find find out the cause for this irritating issue. Regards, Apurv
... View more
09-29-2017
11:18 PM
|
0
|
2
|
760
|
Title | Kudos | Posted |
---|---|---|
2 | 08-31-2018 03:16 AM | |
1 | 04-17-2017 05:20 AM | |
1 | 04-25-2018 07:41 AM | |
2 | 04-18-2017 04:12 AM | |
1 | 03-27-2020 05:34 AM |
Online Status |
Offline
|
Date Last Visited |
03-30-2022
03:56 AM
|