Latest Contributions by CrossrailGIS

‎05-17-2021

Hi there, I'm just wondering if it's possible to call any Oracle SDE packages, functions or procedures to register a table or view from an Oracle SQL Client using PL/SQL? I've seen a few references to grabbing an ObjectID as part of a PL/SQL script, but nothing else. Specifically I was looking at the REGISTER_UTIL package, but I can find no documentation on these about how they work. I could try calling them but I fear it will break things and I've no interest in then trying to fix this afterwards so any advice up front would be greatly appreciated! Regards Dan

‎10-26-2020

Hi Jake, Thanks for your response. This sounds exactly what we are looking for i guess. Is the script shareable to have a look, i have not seen that sort of scripts? Thanks, -Sushil

‎10-22-2020

Hi, Have you managed to use a single SD file for publishing services in multiple environments? Please let me know if you have managed to resolve it, I am very much keen on it. Many thanks, -SP

‎10-22-2020

Hi Everyone, We have ArcGIS Enterprise in multiple environments - DEV, STA, and PROD, and 3 oracle databases per environment with same schema and layer names. I am looking for a methodology to publish services in multiple environments using a single MXD and a SD file. I am sure there are some ways to that, so that we don't need to create 3 MXDs per each environment and publish them separately. If anyone has done this before or have knowledge, i would be grateful to know. Many thanks, Sushil

‎10-19-2020

Hi Dan, Thanks. I can share my full script to you if i have your email if that's ok? I thought it might be easier in that way! Thanks

‎10-16-2020

Hi Thanks, for that. This was just the typo here but i do have == and : in my script properly coded. The main challenge here is how to relate and define X and Y coordinate value is equal to coordinate values returned from user's clicked point. That means the returned coordinate value should be equal to X, Y value in the script above. I am using arcpy.da.SearchCursor(feature_record_set_layer, ['SHAPE@']) as cursor: for clicking and returning coordinate values. Thanks, -Sushil

‎10-15-2020

I am trying to develop a custom tool to be used as a widget in Web AppBuilder. The tool should be able to return x, y coordinate values using default projection system (e.g. London Survey Grid) based on user’s click on the map. Then the returned x, y coordinate values should generate another set of x, y coordinate of the same location using some criteria (If and else statement). The scenario is as below: 1. User clicks on the map and returns X, Y value (default projection system) Let’s say X = 45670 and Y = 55000 2. Re-project or convert the returned X and Y values from step 1 to another set of coordinates of the same location (P2_X, P2_Y2) using criteria below: Criteria is: (This is just a sample, but I have a long real criteria) If X == 0 and Y == 0: return Projection2 (0,0) elif X >= 44274 and X <= 45799 and Y >= 53927 and Y <= 54889: P2_X = (X * 0.999942) – (Y * 0.2519) P2_Y = (Y * 0.999942) + (X * 0.2519) return Projection2(P2_X , P2_Y) else: P2_X = (X * 0.98888) – (Y * 0.4519) P2_Y = (Y * 0.98888) + (X * 0.4519) return Projection2(P2_X , P2_Y) 3. Then display both X, Y and P2_X, P2_Y I have my python script that returns X,Y based on the user’s click on the map, but I am struggling in returning P2_X and P2_Y based on the criteria as mentioned above. I have a separate python script for the criteria. Please let me know if any one can help me on this, I can share my script if needed. Thanks for your help in advance. -Sushil

‎04-29-2019

Hi Jonathan So the errors that are popping up during this time period are as shown below. WARNING 29 Apr 2019 00:02:20 The operation timed out (WinINet Error while using HTTPS security, 12002), URL = https://xxxxxx11.onelondon.tfl.local:6443/arcgis/admin/generateToken ElizabethLine/CrossrailLorryRoutes.MapServer SEVERE 29 Apr 2019 00:06:47 Failed to construct instance of service 'ElizabethLine/CrossrailEstates.MapServer'. Service startup timeout. ElizabethLine/CrossrailEstates.MapServer The server in question gets restarted (ArcGIS Server service only, not the server itself) at 23:00, I'm not sure how long the restart takes, particularly as the Windows Application Event log records the following: The description for Event ID 5 from source ArcGIS Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: ArcGIS Server The specified resource type cannot be found in the image file Does that sound like typical behavior for ArcGIS Server?

‎04-26-2019

Is it possible to turn off logging for a period of time in ArcGIS Enterprise (10.5.1, technically still called Server in this version I think)? The reason I ask is that we have our ArcGIS Server services (4 servers + 1 server config store server, load-balanced) restarted every evening to flush out memory consumption, but the logging seems to persist during this period and records a number of errors as a result in the server logs. Is there anyway to disable logging whilst this happens so as to reduce the size of the log files? Can't see anything in the documentation you'd think the logging stops when the ArcGIS Server service is restarted but it appears not to be the case? TIA Dan

‎03-19-2019

Hi Robert, Indeed and I would if I could but unfortunately Chrome is not permitted where we are, and although Firefox is available, IT have done something to it to make it unworkable! Sort of thankfully I think I've tracked down the source of the problem (or rather a colleague of mine did), it seems that it's a known issue as per this page: https://support.esri.com/en/Technical-Article/000020226 Hopefully this might help others who come across this problem...

‎03-18-2019

So we have just started experiencing problems with web apps through Portal for ArcGIS 10.5.1 where the header controller widget is failing to load. The error I am seeing is: create [themes/FoldableTheme/widgets/HeaderController/Widget] error:Error: Access is denied. at postCreate (https://xxx/themes/FoldableTheme/widgets/HeaderController/Widget.js?wab_dv=2.1:84:11) This is only happening on IE, on Firefox it works fine. Has anyone else experienced this problem? I've also noticed that this problem is possibly related to a specific build of IE (11.0.9600.19266), we have tried on a couple of other versions of IE (notably 1.0.9600.19236) and this problem does not occur. Regards Dan

‎03-05-2019

Just an update, we've figured out the problem at it looks like it's the custom coordinate system we are using, even though it is registered on Portal, the Near Me widget doesn't recognize this coord sys.

‎01-29-2019

Hi there, I've plugged in the Near Me widget to Web AppBuilder 2.1 (sorry, older version), but I have an error when I try to use it. Initially returns result, although in the debugger (IE11), I get the following error: HTTP 400: Cannot perform query. Invalid query parameters. Regardless it shows it found some results, but when I click on one to expand the records found it hangs with the following error: TypeError: Unable to get property 'Rc' of undefined or null reference TypeError: Unable to get property 'Rc' of undefined or null reference at g.Gb (https://js.arcgis.com/3.17/esri/geometry/geometryEngine.js:531:311) at c.distance (https://js.arcgis.com/3.17/esri/geometry/geometryEngine.js:1095:55) at _getSortedFeatureList (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:709:9) at _creatFeatureList (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:597:7) at Anonymous function (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:540:11) at Anonymous function (https://js.arcgis.com/3.17/init.js:63:200) at _resolve (https://js.arcgis.com/3.17/init.js:1937:58) at Anonymous function (https://js.arcgis.com/3.17/init.js:1940:406) at c (https://js.arcgis.com/3.17/init.js:103:387) at d (https://js.arcgis.com/3.17/init.js:103:182) { [functions]: , __proto__: { }, description: "Unable to get property 'Rc' of undefined or null reference", message: "Unable to get property 'Rc' of undefined or null reference", name: "TypeError", number: -2146823281, stack: "TypeError: Unable to get property 'Rc' of undefined or null reference at g.Gb (https://js.arcgis.com/3.17/esri/geometry/geometryEngine.js:531:311) at c.distance (https://js.arcgis.com/3.17/esri/geometry/geometryEngine.js:1095:55) at _getSortedFeatureList (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:709:9) at _creatFeatureList (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:597:7) at Anonymous function (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:540:11) at Anonymous function (https://js.arcgis.com/3.17/init.js:63:200) at _resolve (https://js.arcgis.com/3.17/init.js:1937:58) at Anonymous function (https://js.arcgis.com/3.17/init.js:1940:406) at c (https://js.arcgis.com/3.17/init.js:103:387) at d (https://js.arcgis.com/3.17/init.js:103:182)" } "TypeError: Unable to get property 'Rc' of undefined or null reference at g.Gb (https://js.arcgis.com/3.17/esri/geometry/geometryEngine.js:531:311) at c.distance (https://js.arcgis.com/3.17/esri/geometry/geometryEngine.js:1095:55) at _getSortedFeatureList (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:709:9) at _creatFeatureList (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:597:7) at Anonymous function (https://ddc2gis006.onelondon.tfl.local/ElizabethMaps/widgets/NearMe/item-list.js?wab_dv=2.1:540:11) at Anonymous function (https://js.arcgis.com/3.17/init.js:63:200) at _resolve (https://js.arcgis.com/3.17/init.js:1937:58) at Anonymous function (https://js.arcgis.com/3.17/init.js:1940:406) at c (https://js.arcgis.com/3.17/init.js:103:387) at d (https://js.arcgis.com/3.17/init.js:103:182)" Any ideas? Appreciate it's an older version of Web AppBuilder, but it's what I've got (and upgrading is not straightforward where I work). Also worth noting on ArcGIS Desktop 10.6, ArcGIS Server 10.5.1 and Portal for ArcGIS 10.5.1. Regards Dan

‎10-10-2018

Hi All so just an update. I managed to find a workaround to this (well, sort of). Seeing as how the paths to the SDE connections (and the SDE connection names) are different on the source and target systems, I created a copy of the SDE connection on a local folder with the same name (but different connection details) on both systems. That way when I access the MXD from the target system the SDE connection path hasn't changed and it seemed to be ok with this. Then I simply run the Python to change the pointer from the local drive to the network share where the live SDE paths are stored and voila, all fixed . Code I use is below (which works against all mxds in a folder): import arcpy from arcpy import env sOldPath = r"<Temp SDE connection>" sNewPath = r"<Final SDE connection>" env.workspace = r"<MXD folder path>" for file in arcpy.ListFiles("*.mxd"): mxd = arcpy.mapping.MapDocument(env.workspace + '/' + file) for layer in arcpy.mapping.ListLayers(mxd): if layer.supports("WORKSPACEPATH") == True: try: print "Original workspace: " + layer.workspacePath sSource = layer.workspacePath sSource = sSource.replace(sOldPath,sNewPath) print "New datasource (before): " + sSource layer.replaceDataSource(sSource,"SDE_WORKSPACE","",False) print "New datasource (after): " + layer.workspacePath except Exception: e = sys.exc_info()[1] print(e.args[0]) print mxd.filePath.replace('.mxd','_TMP.mxd') mxd.saveACopy(mxd.filePath.replace('.mxd','_TMP.mxd') Hope this helps anyone else who might be trying to do this! Dan

Online Status	Offline
Date Last Visited	‎12-13-2021 03:23 AM

My Ideas

Latest Contributions by CrossrailGIS

SDE Registration with PL/SQL

Re: PUblish ArcGIS Services in multiple environments using a single SD file

Re: How Data registration with ArcGIS Server can help to publish 1 SD file to multiple environments?

PUblish ArcGIS Services in multiple environments using a single SD file

Re: Coordinates Conversion Based on Criteria Using Python

Re: Coordinates Conversion Based on Criteria Using Python

Coordinates Conversion Based on Criteria Using Python

Re: Setting logging time interval in ArcGIS Enterprise

Setting logging time interval in ArcGIS Enterprise

Re: Problems with IE and Portal for ArcGIS Web Apps

Problems with IE and Portal for ArcGIS Web Apps

Re: Near Me Widget Error

Near Me Widget Error

Re: mxd.findAndReplaceWorkspacePaths Performance

Re: Problems with IE and Portal for ArcGIS Web App...

Re: mxd.findAndReplaceWorkspacePaths Performance