Latest Contributions by ApurvDanke

Hi, The workflow manager configuration deployment is becoming a big challenge for us. We have many different custom job types, Maps(MXD's), Workflows, Notifications, Queries, step types, job filters which we're using in our Workflow Manager configuration. Initially we used to export the entire Workflow Manager configuration as a JXL file and then this file would get installed into target environments such as testing and production environments. After installing, we would need to import this JXL file into Workflow Manager Administrator, but we would need to do a lot of post installation activities, such as setting the target data workspace, adding/removing users according to target environments, setting the data workspaces for job types, subscribing users to notifications etc. These post installation steps would take a lot of time and there is always a chance that some mistakes would be committed during these steps. However we found that we can also export individual entities like job types, workflows, notifications, queries etc. as JXL files and import these in target environment as part of deployment. This approach works fine for new additions in the WFM configuration such as new workflow, new job type, new step type etc. However if we need to make changes to existing entity such as a workflow, or a job type, then we cannot overwrite the existing entity in WFM administrator by choosing to import the JXL file. For example if we need to make changes to an existing job type, then in the target environment we first need to delete the existing job type and then import the JXL for the updated job type. However at the time of deleting the existing job type, we get an error message as given below. Now it is understood that there are jobs which currently exist in WFM for this particular job type. However there are a huge number of jobs for this particular job type. As we're using OS Authentication for WFM, the jobs and their job versions need to be deleted by the respective users. Before deleting the jobs, they should reconcile and post their edits in their job versions to SDE.Default to ensure their edits are not lost. Once all the jobs and versions are deleted, then it would be possible to delete the job type in WFM and import the updated job type JXL. This is a huge time-consuming activity. It would be great if there was a way to get around this and be able to simply overwrite the changes for this job type in WFM Administrator, without needing to delete any jobs. I know that there is an option to import the entire WFM configuration JXL file, and while doing that we do get an option whether to clear the existing jobs or to retain them. But we do not want to import the entire WFM configuration, for updating just one job type. Any suggestions are greatly appreciated. We are using ArcGIS Desktop 10.4.1 with Workflow Manager. Database used is Oracle 12G, and the users connect via OS authentication to WFM. Regards, Apurv ... View more

I am trying to see the print preview of a map layout using data driven pages in ArcGIS Desktop 10.4.1. I have used Grid Index features and when I try to see the print preview, for first page it shows the preview correctly but when I click on Next and see the preview, it is displayed as given below. When I click on Previous, Next or Last after this, I see the same kind of preview. This is happening for some MXD's not all. What could be the possible reason for this? ... View more

We are using ArcGIS Workflow Manager extension for ArcGIS Desktop in 10.4.1 with Oracle 12C geodatabase. We have created the Workflow Database (JTX tables) in a separate user schema in Oracle geodatabase called “WORKFLOWMANAGER”. So all the JTX tables have the prefix – “WORKFLOWMANAGER.<JTX Table Name>”.   We also have other user schemas where we have different business datasets. In Workflow Manager Administrator we connect using the “WORKFLOWMANAGER” user and select the schema as “SDE” as that is the schema where all the geodatabase tables are stored. We have configured many Job Types, Maps, Workflows, Users and User Groups. As far as users are concerned we have used the “Traditional” user store by using Windows Active Directory users. They have been added in different groups.   We also configured MXD’s for different job types. Each MXD uses the respective user schema owner database connection. We have also given the required privileges to “WORKFLOWMANAGER” user on the user-schema datasets in the geodatabase. In this way, when we create jobs and open the job in ArcMap, there is a step in the workflow used by the job which creates a version under “WORKFLOWMANAGER” user and switches all the layers in the MXD to point to that version and database connection. In this way we’re able to execute the Job Workflow without any issues.   Now coming to OS authentication, we have created different roles in Oracle database where Windows AD users have been added as external users. So these users login with their AD ID and are able to connect to the Oracle geodatabase using ArcCatalog and view the datasets on which they have privileges. Now we have created MXD’s which use OS authentication instead of database authentication, and configured those MXD’s for the different Job Types in Workflow Manager Administrator. When we create a job, and open the job and then it comes to the step where a version is created; the version still gets created under “WORKFLOWMANAGER” schema, and then automatically all the layers in the MXD are re-pointed to database authentication. This is where the issue is, we don’t want the layers to be re-pointed, the version should get created under the logged in Windows AD user. Normally when such a version is created it is in the format - <AD Username>.<Version Name>   We tried another way when we logged in to Workflow Manager Administrator using OS authentication instead of database authentication. This was done after providing the necessary privileges in Oracle geodatabase to the Oracle role to which the AD user belongs to; on all the JTX tables in WORKFLOWMANAGER schema. After logging in, the MXD’s were configured using OS authentication for different job types. Then after creating a job in Workflow Manager(which uses the same default connection of OS authentication), when we try to open the “Job List” in ArcMap on the Workflow Manager toolbar, we don’t see anything come up. Later we tried to run the “User Queries” in Workflow Manager for “All Jobs”, “Unassigned Jobs” etc. but we get the following error as given below.     We also tried to change the SQL query in the Workflow Administrator to use the prefix “WORKFLOWMANAGER.” for the JTX tables and verified the SQL and saved it there, but after creating the job we’re still not able to see the Job List in ArcMap, and also in Workflow Manager when we try to perform any of these queries, we’re still getting the same error message.   The main intention is to make OS authentication work with Workflow Manager, and the once the job is opened in ArcMap the version should be created under the Windows AD user rather than “WORKFLOWMANAGER” database user.   Is it worth creating the Workflow Database using OS authentication in the first place? Any assistance is greatly appreciated. Regards, Apurv Danke ... View more

Hi, In the last couple of weeks we are facing lot of issues in our development and testing environments for connections to Oracle geodatabase through ArcCatalog. We have different databases for Asset and Basemap. There is not a huge amount of data in the asset database, still it takes too much time to connect to it, like maybe 2 minutes or so. It connects through SQLPlus in 1 or 2 seconds. While connecting to Basemap database, it causes ArcCatalog to hang and go into a not responding state. This was not the case couple of months ago when the databases and schemas were newly created and data was loaded. At worst we were able to connect in 10 seconds through ArcCatalog. Since then there have been many changes related to data model in the geodatabase and also many times the database was refreshed with new set of data. Any suggestions will help. We're using ArcGIS Desktop 10.4.1 on Windows 2012 VM servers. We have 12 GB RAM and quad core processor. Another thing which I want to highlight is that we're using versioning for spatial data editing through Workflow Manager. In many cases, during the development, the versions which were created haven't been deleted. Will deleting the unnecessary versions help? One more thing is that we have installed the full Oracle Client as the DBMS client to allow ArcCatalog to connect to Oracle geodatabase. Is the full version required or is Instant Client sufficient? Regards, Apurv ... View more

Hi, I am trying to define an AOI for a job which I'm trying to create in ArcGIS Workflow Manager. I'm using the tool - Define AOI by rectangle. When I finally say OK, it gives me the error message given below. I'm using many layers in my basemap MXD which is configured in my job type. All the layers are pointing to Oracle Geodatabase. The geometry type we've used is SDO_Geometry.  Can anyone throw light on this, what may be the reason? Regards, Apurv ... View more

Hi, The scenario which we're trying to implement is that we have a web service which would receive certain parameters from another system, and based on the parameters, zoom to a particular location on the map, take the snapshot of it and return the image to the source system. So we have gone with the approach of using ExportMap function which is available in REST API for map service. We're able to export and display the image and return it to the source system. However, there is a slight problem here, the image is attached for reference. This is a line layer in pink color and what I need is to show a red cross symbol at each line vertex.  I've used the line decoration property in the symbology to show a red cross as given below. The problem is I'm not able to see the cross at the exact vertex position, rather I see two cross symbols left and right side of each vertex. Another thing is that I only want to see the cross marks at the end points of the queried line feature, and not for the line features next to it, though I still want those features available in the exported image. Hence I'm thinking of an alternative way to add a graphic at the line vertices using REST API. Can the graphic be added while using ExportMap function? Regards, Apurv ... View more