Failed to execute query - SAP Work Manager 6.2 ESRI GIS

[Former Member]

Hi;

I am working on implementing the standard SAP Work Manager 6.2 implementation. I'm using SMP 3.0 SP05. I have maintained the config panel Geospatial Service Info, which points to an ESRI server that is within the LAN environment and I have defined the port as 80. I have also gone to customise the Client globals for the PREF_BASEMAP_URL_GREY/SATELITTE/STREET/TOPO to point to the local ESRI server and this seems to be working fine, I can see the base map on the device under the locations tab, BUT, with no points plotted, even though I have maintained the /SMFND/OID01_GS table. I have maintaned this table as follows :

The SPATIAL_OBJECTID I got from the ESRI guys together with the base map URL.

1. When I sync from the device and debug the /SYCLO/IF_CORE_DO_HANDLER~GET method in the /SMFND/CL_GIS_OBJ_GEODATA_DO class, I notice that  ls_mdo_input_vals-it_objkey_list structure contains only the OBTYP and OBJKEY and does not include the SPATIAL_OBJECTID and LOGSYS even though this is maintained in the mapping table.

2. I go on to maintain the LOGSYS and SPATIAL_OBJECTID values during debug and I get a Response code of 200 with the Response "Failed to Execute Query". When I execute the query that I have defined on the Geospatial Service Definition, on a browser, I get a form, on this form I maintain the OBJECTID and click on the POST button and get a response with coordinates, this doesn't seem to be the same behaviour when the request is coming from ABAP, what could be wrong here?

3. The  ls_mdo_input_vals-it_query_param structure is empty when I debug, is this meant to be behaving this way, or I need to maintain query parameters in the config panel?

Your input is appreciated!

Thanks and Regards;

Sizo Ndlovu

[Former Member · Accepted solution]

Hi;

Ok, so it seems like there was a couple of issues causing the failed to execute query:

1. Under Geospatial Service Info, under service host, I had the ESRI server host name maintained together with the "http://" and this was being done again in the EXEC_OP_QUERY code, so eventually the code was being sent with 2 http's, "http://http://maps......"

2. I used server port 80 instead of 06080

3. The parameter value "OBJECTID, GLOBALID", under Parameter - Output Fields was meant to be empty for my case, see below screenshot:

Thanks and Regards;

Sizo Ndlovu

[bill_froelich · Accepted solution]

If your question has been answered, please mark this Discussion with a Correct Answer and Helpful Answer where appropriate.  See http://scn.sap.com/community/support/blog/2013/04/03/how-to-close-a-discussion-and-why   Even if you discovered the solution without any outside contributions, it helps others to understand what the solution turned out to be.

--Bill

[resmi_sadasivan2]

Hello,

Please refer the following:

1982598 - GIS Integration Support for Mobile AddOn 6.10

2094371 - Standard GIS OID mapping routine for work order or notification should support external format technical object mapping entries

Thanks

Resmi

[Former Member]

Hi Resmi;

I have the documents that you are referring me to and have followed them.

Regards;

Sizo Ndlovu

[former_member113639]

1. Can you share the configuration settings in the configuration panel.

2. Have you tried debugging the method EXEC_OP_QUERY

3. Also can you turn on traces to monitor http call from the SAP System to the ArcGIS System

[Former Member]

Hi Muralidharan;

1. Please see configuration settings below:

Is there anything that I need to maintain on the parameters?

2. Yes I have been debugging the EXEC_OP_QUERY method for a while now and I do not seem to be seeing anything wrong except that on the receive method   lref_http_client->receive I get a "Failed to execute query" message

3. I have activated the http trace and I get the following:

Thanks and Regards;

Sizo Ndlovu

[former_member113639]

Sometimes the reason the query fails to execute is that the ECC 6.0 doesn't allow connections to external systems. Can you check if you have a proxy and if the proxy is setup is correct in SICF transaction.

Another thing that I would try is to open the Browser from he same network on which ECC is installed and paste the REST query and try to use the options to retrieve the lat long for the object id.

What is the error message you are getting after the http call?

[Former Member]

Hi Muralidharan;

The SICF proxy setting seems fine. So, the ArcGIS server that I am using is within the same network as the ECC server (LAN), so a proxy is not required. On a browser I can access the form, and if I supply the the OBJECTID and do a POST I do get a response of coordinates and as well I have not maintained a proxy on the browser, if I mantain a proxy, then I cannot access the REST query.

The error message that I am getting after is "Failed to execute query".

Thanks and Regards;

Sizo Ndlovu

[former_member113639]

Okay we need to see the failure to execute the query occurred. Can you use icm monitor transaction & turn the trace to the lowest level and see what is the error that occurs. the transaction is smicm and then you can set the trace and after performing the debug you will get more details on the http request to ArcGIS System and why it failed.

Try to set the break point at the http request send call.

[Former Member]

Hi Muralidharan;

I see the below errors in the trace files:

[Thr 1286] Wed Feb 25 11:47:44 2015

[Thr 1286] *** WARNING => Connect to P25214:1090 failed: NIEHOST_UNKNOWN(-2) {00044d9f} [icxxconn.c 2162]

[Thr 2314] Wed Feb 25 11:48:59 2015

[Thr 2314] *** WARNING => Connect to http:80 failed: NIEHOST_UNKNOWN(-2) {00044da6} [icxxconn.c 2162]

[Thr 772] Wed Feb 25 11:49:14 2015

[Thr 772] *** WARNING => Connect to nxdci01:1090 failed: NIECONN_REFUSED(-10) {00044daa} [icxxconn.c 2162]

Thanks and Regards;

Sizo Ndlovu

[former_member113639]

There you go there definitely is a problem connecting from SAP ECC 6.0 to ArcGIS System. You will need to analyse this and correct the error. There should be more details on the error. It looks like there is some sort of a network issue.

[former_member113639]

Also why is your host name not complete if you look at the error message it's connecting to P25214:1090.

Can you further analyse this.

[former_member113639]

Can you check the below link http://sapbasisinfo.com/blog/2014/12/04/smicm-errors-niehost_unknown/

[Former Member]

Hi Muralidharan;

I do not think that these ICM errors are related to the ArcGIS server access as I have specified its host name on the config panel and this would be showing as such on the ICM log.

Thanks;

Sizo Ndlovu

[former_member113639]

  I think you need to look at the deeper in the logs of the icm logs. Can you investigate this further. What you can also do is write  a simple report program by hard coding the call to ArcGIS and see if you are able to get some response back.