Hi,

Im trying to integrate Maximo with open arcgis. For beginning ,testing with  one objectid.

Map manger link :-  https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/MapServer

Cron task url :-https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/query?where=objectid=1920118&outFields=*&f=pjson

Cron task properties are in this screenshot.

Json Mapping have some simple fields.

Issue :-  Cron task is running successfully however its giving error message [FIDs must not be negative]   in the systemout.log. Please find error log below. I have seen online that FID error can't be fixed or may be related to arcgis side. Please let me know if this can be fixed or have to go with some other sampleserver feature.

Error message in systemout :- 

[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] tokenAuthSecurityEnabled = false
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] tokenValue: 
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775]  In ArcGISHTTPHandler -- invoke Override function
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] invoke Override -- metadata: {FEATURE_OP_TYPE=updateFeatures, HTTPMETHOD=POST, ARCGISDATASYNCPROCESSOR=true, HEADER=application/x-www-form-urlencoded, URL=https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/updateFeatures?f=pjson}
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] invoke Override data: [{"attributes":{"OBJECTID":null,"requestid":"2"}}]
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775]  In ArcGISHTTPHandler -- getURL Override function -- URL: https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/updateFeatures?f=pjson
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] mxe.pluss.services.authentication.singleaccount = 0
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] In invoke Override function -- fromQueueToDestManagerProcessor: false and fromArcGISDataSyncProcessor: true
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] analyzeMetaData -- metadata: {FEATURE_OP_TYPE=updateFeatures, HTTPMETHOD=POST, ARCGISDATASYNCPROCESSOR=true, ENDPOINTNAME=FFX_GIS_SR, HEADER=application/x-www-form-urlencoded, URL=https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/updateFeatures?f=pjson}
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] ArcGISHTTPHandler -- analyzeMetaData(this.metaData) returned false, Mapping/Sync operation is occuring
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] ArcGISHTTPExit-getURLProperties -- metadata: {FEATURE_OP_TYPE=updateFeatures, HTTPMETHOD=POST, ARCGISDATASYNCPROCESSOR=true, ENDPOINTNAME=FFX_GIS_SR, GETURLPROPS={FEATURE_OP_TYPE=updateFeatures, HEADERS=accept=application/json, HEADER=application/x-www-form-urlencoded}, HEADER=application/x-www-form-urlencoded, URL=https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/updateFeatures?f=pjson}
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] Asking for token from  ArcGISHTTPHandler.getUrl()
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] getConnection from free pool for user: MAXADMIN  Connection  = 172.99.1.73.50987.240910200904 count = 1
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [INFO] [MAXIMO] [CID-CRON-3807775] BMXAA6719I - USER = (MAXADMIN) SPID = ( .240910200904) app (null) object (MAPSITES) : select * from mapsites  where mapname in (select mapname from mapmanager where mapname in (select mapname from plussmapservicelayer where objectname= 'FFX_GIS_SR' ) and active=1) for read only
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] freeConnection for user: MAXADMIN  Connection spid = 172.99.1.73.50987.240910200904 count = 0
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] freeConnection - Used pool size :3 - Free pool size :8

tokenAuthSecurityEnabled = false
[9/10/24 20:23:01:789 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:789 [DEBUG] [MAXIMO] [CID-CRON-3807775] tokenValue: 
[9/10/24 20:23:01:789 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:789 [DEBUG] [MAXIMO] [CID-CRON-3807775] ArcGISHTTPExit metaUrl: https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/updateFeatures?f=pjson
[9/10/24 20:23:01:789 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:789 [DEBUG] [MAXIMO] [CID-CRON-3807775] ArcGISHTTPExit-getURLProperties -- metadata: {FEATURE_OP_TYPE=updateFeatures, HTTPMETHOD=POST, ARCGISDATASYNCPROCESSOR=true, ENDPOINTNAME=FFX_GIS_SR, GETURLPROPS={FEATURE_OP_TYPE=updateFeatures, HEADERS=accept=application/json, HEADER=application/x-www-form-urlencoded}, HEADER=application/x-www-form-urlencoded, URL=https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/updateFeatures?f=pjson}
[9/10/24 20:23:01:789 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:789 [DEBUG] [MAXIMO] [CID-CRON-3807775] ArcGISHTTPExit--transformPayloadToFormData data: {features=[{"attributes":{"OBJECTID":null,"requestid":"2"}}]}
[9/10/24 20:23:01:804 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:804 [ERROR] [MAXIMO] [CID-CRON-3807775] ArcGISHTTPExit -- Error Code: 400 Description: Unable to complete operation.
[9/10/24 20:23:01:804 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:804 [ERROR] [MAXIMO] [CID-CRON-3807775] ArcGISHTTPExit -- Error Details: [FIDs must not be negative]
[9/10/24 20:23:01:804 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:804 [INFO] [MAXIMO] [CID-CRON-3807775] Error response.Response Code :400. Response Message:Unable to complete operation.
[9/10/24 20:23:01:804 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:804 [ERROR] [MAXIMO] [CID-CRON-3807775] Crontask Name: ArcGISDataSync Instance Name: FFX_SR_INBOUND Arcgis cron task processing failed. please check log file for more details.
psdi.util.MXSystemException: BMXAA1482E - The response code received from the HTTP request from the endpoint is not successful.
    Unable to complete operation.
    at psdi.iface.router.DefaultHTTPExit.processResponseData(DefaultHTTPExit.java:263) ~[businessobjects.jar:?]
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISHTTPExit.processResponseData(ArcGISHTTPExit.java:225) ~[businessobjects.jar:?]
    at psdi.iface.router.HTTPHandler.invoke(HTTPHandler.java:534) ~[businessobjects.jar:?]
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISHTTPHandler.invoke(ArcGISHTTPHandler.java:202) ~[businessobjects.jar:?]
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISDataSyncProcessor.updateRecords(ArcGISDataSyncProcessor.java:419) ~[businessobjects.jar:?]
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISDataSyncProcessor.process(ArcGISDataSyncProcessor.java:291) ~[businessobjects.jar:?]
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISDataSyncCronTask.cronAction(ArcGISDataSyncCronTask.java:170) [businessobjects.jar:?]
    at psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java:2594) [businessobjects.jar:?]
    at psdi.server.CronTaskManager.access$1100(CronTaskManager.java:107) [businessobjects.jar:?]
    at psdi.server.CronTaskManager$CronThread.run(CronTaskManager.java:3512) [businessobjects.jar:?]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522) [?:1.8.0]
    at java.util.concurrent.FutureTask.run(FutureTask.java:277) [?:1.8.0]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:191) [?:1.8.0]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:1.8.0]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160) [?:1.8.0]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:1.8.0]
    at java.lang.Thread.run(Thread.java:825) [?:2.9 (09-08-2023)]
Caused by: java.lang.Exception: Unable to complete operation.
    ... 17 more

------------------------------
kumar v
------------------------------

Reading thrugh the log entries it looks as though the Arc GIS server has refused the request presumably because Maximo did not provide all the informaton that it needs.

Have you gonr through the arcgis documentation e.g. the pages starting here https://developers.arcgis.com/rest/services-reference/enterprise/feature-service/ ?

it looks like you need to talk to ESRII to get their help to understand what information needs to be provided.

Another place to look would be any ArcGIS forums to see if people have discussed this there ... the error message is from ArcGIS and you shuld get more help frm the GIS experts... once you havae identified what the missing data is then you can figure out how you get Maximo to provide it

Maximo 7.6.1.2 allow you to store copies of outbound messages so it would be worth enabling that to see what the crontask is actually sendng to the arcgis server...

https://www.ibm.com/support/pages/message-tracking-synchronous-requests

To view the messages coming via REST API, Go to Integration > Message Tracking and click on Select Action - Synchronous Message Tracking. 

if you enable this then you will need to manage the records manually because Maximo does not have a system to delete old messages

------------------------------
Mark Robbins
Support Lead/Technical Design Authority / IBM Champion 2017 - 2023
Cohesive (previously Vetasi Limited)
https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
------------------------------

Hi kumar,

There's no record with ObjectID = 1920118 in the GIS service. If you use this URL it will list all records and their fields from the GIS service https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/query?where=1%3D1&outFields=*&f=html .

From the log (see below) it's trying to update the GIS service but the OBJECTID = null so the GIS service won't know which record to update. This may be why it's throwing the "Error Code: 400 Description: Unable to complete operation." & "Error Details: [FIDs must not be negative]" errors as the FID is the OBJECTID in GIS and there's no value for it.

URL=https://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/FeatureServer/0/updateFeatures?f=pjson}
[9/10/24 20:23:01:773 UTC] 00000117 SystemOut     O 10 Sep 2024 20:23:01:773 [DEBUG] [MAXIMO] [CID-CRON-3807775] invoke Override data: [{"attributes":{"OBJECTID":null,"requestid":"2"}}]

------------------------------
Mark Peacey
------------------------------