Maximo

 View Only

  • 1.  ArcGISDataSync is throwing a null error when trying to run

    Posted Wed September 29, 2021 03:15 PM
    Edited by System Tue August 22, 2023 04:38 PM
    Hello Everyone,
    I am setting up a spatial integration(7.6.1.0) and have done others in the past so I am familiar with how the process works however in this instance I am getting an unusual error when trying to run ArcGISDataSync Cron to load assets.
    It appears to connect to GIS and pull bck the single record I requested but then throws a null error.
    At first I thought it must be an issue with the JSON mapping but it tested fine and all the required fields are in the mapping so it seems the null error is maybe internal to the ArcGISDataSync cron running.
    anyone seen an error like this?

    Crontask Name: ArcGISDataSync Instance Name: PIPELINE_TRI Arcgis cron task processing failed. please check log file for more details.
    java.lang.NullPointerException
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISDataSyncProcessor.process(ArcGISDataSyncProcessor.java:104)
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISDataSyncCronTask.cronAction(ArcGISDataSyncCronTask.java:158)
    at psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java:2566)



    Here's the rest of the log:
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] tokenValue:
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] PERFORMANCE TESTING: Attempting to start ArcGIS Data Sync process for GIS Object PIPELINE_TRI using the url https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid = 1&&outFields=*&f=pjson
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] In ArcGISHTTPHandler -- invoke Override function
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] invoke Override -- metadata: {HTTPMETHOD=GET, ARCGISDATASYNCPROCESSOR=true, HEADERS=accept=application/json, URL=https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid+%3D+1&&outFields=*&f=pjson&returnCountOnly=true}
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] In ArcGISHTTPHandler -- getURL Override function -- URL: https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid+%3D+1&&outFields=*&f=pjson&returnCountOnly=true
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] mxe.pluss.services.authentication.singleaccount = 0
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] In invoke Override function -- fromQueueToDestManagerProcessor: false and fromArcGISDataSyncProcessor: true
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] analyzeMetaData -- metadata: {HTTPMETHOD=GET, ARCGISDATASYNCPROCESSOR=true, HEADERS=accept=application/json, ENDPOINTNAME=PIPELINE_TRI, URL=https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid+%3D+1&&outFields=*&f=pjson&returnCountOnly=true}
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] ArcGISHTTPHandler -- analyzeMetaData(this.metaData) returned false, Mapping/Sync operation is occuring
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [DEBUG] [MAXIMO] [CID-CRON-25612] Asking for token from ArcGISHTTPHandler.getUrl()
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (106) app (null) object (MAPSITES) : select * from mapsites where mapname in (select mapname from mapmanager where mapname in (select mapname from plussmapservicelayer where objectname= 'PIPELINE_TRI' ) and active=1) OPTION (FAST 1000)
    [9/29/21 11:52:17:653 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:653 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (61) app (null) object (MAPMANAGER) : select * from mapmanager where mapname in (select mapname from mapmanager where mapname in (select mapname from mapsites where siteid= 'GPX' ) and active=1 and ismobile=0) OPTION (FAST 1000)
    [9/29/21 11:52:17:668 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:668 [DEBUG] [MAXIMO] [CID-CRON-25612] tokenAuthSecurityEnabled = true
    [9/29/21 11:52:17:668 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:668 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (82) app (null) object (PLUSSMAPSERVICE) : select * from plussmapservice where mapname= '1003' and url= 'https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer' OPTION (FAST 1000)
    [9/29/21 11:52:17:700 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:700 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (63) app (null) object (PLUSSMAPSERVICE) : select * from plussmapservice where mapname= '1003' and url= 'https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/MapServer' OPTION (FAST 1000)
    [9/29/21 11:52:17:715 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:715 [DEBUG] [MAXIMO] [CID-CRON-25612] AUTHENTICATION_TOKENEXPIRE_TIME_RESET_LIMIT_PROPERTY : mxe.pluss.services.authentication.tokenExpireTimeResetLimit = 5
    [9/29/21 11:52:17:715 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:715 [WARN] [MAXIMO] [CID-CRON-25612] BMXAA7785W - Property mxe.pluss.services.authen.NonSecureTimeResetLimit does not exist.
    [9/29/21 11:52:17:715 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:715 [DEBUG] [MAXIMO] [CID-CRON-25612] AUTHENTICATION_NONSECURE_TIME_RESET_LIMIT_PROPERTY : mxe.pluss.services.authen.NonSecureTimeResetLimit = 10
    [9/29/21 11:52:17:715 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:715 [DEBUG] [MAXIMO] [CID-CRON-25612] url of urlService in tokenAuthentication(String url): https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid+%3D+1&&outFields=*&f=pjson&returnCountOnly=true
    [9/29/21 11:52:17:715 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:715 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (66) app (null) object (MAPMANAGER) : select * from mapmanager where mapname= '1003' OPTION (FAST 1000)
    [9/29/21 11:52:17:715 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:715 [DEBUG] [MAXIMO] [CID-CRON-25612] mxe.pluss.services.authentication.singleaccount = 0
    [9/29/21 11:52:17:715 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:715 [DEBUG] [MAXIMO] [CID-CRON-25612] getContentFromURL from URL: https://XXXXXXXX.YYYYY.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer?f=json
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] Testing for the need of a token for url: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer Message returned: Token Required
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] Checking Token on urlService: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] dateMSecNow in milliseconds: 1632934637738
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] Token expires in milliseconds: 1632935166503
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] mxe.pluss.services.authentication.singleaccount = 0
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] getContentFromURL from URL: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer?f=json
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] in tokenAuthenticationViaJS -- tokenValue returned: wzMuUEPri8ENvz-sAXt-AisKfgfJ92KjG5uZbCdzczUJIebRUhBdSi4DDD6IUgJDcKBn14WjRYhln9SPp4al5pfe6rSumrsjVsyUcKIVdz0p-8cO8lCJn0cEYP31NcY9v2JdBxm4Xrfqu87EYSZOOg7-bYzzTAgyv4EpG4aYC1e9bS0FK1IwO2Cg1GRRe5xJPc1uqa7xv4JiDesds5SSWSmA9lW4_sWKGIHb1TqCtKGzdE4HiVqbl64Nh6yugpWMRlxADyUKXiX51ZGWrqir-Q..
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] tokenValue: wzMuUEPri8ENvz-sAXt-AisKfgfJ92KjG5uZbCdzczUJIebRUhBdSi4DDD6IUgJDcKBn14WjRYhln9SPp4al5pfe6rSumrsjVsyUcKIVdz0p-8cO8lCJn0cEYP31NcY9v2JdBxm4Xrfqu87EYSZOOg7-bYzzTAgyv4EpG4aYC1e9bS0FK1IwO2Cg1GRRe5xJPc1uqa7xv4JiDesds5SSWSmA9lW4_sWKGIHb1TqCtKGzdE4HiVqbl64Nh6yugpWMRlxADyUKXiX51ZGWrqir-Q..
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] return urlUpdate with token if applicable: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid+%3D+1&&outFields=*&f=pjson&returnCountOnly=true&token=wzMuUEPri8ENvz-sAXt-AisKfgfJ92KjG5uZbCdzczUJIebRUhBdSi4DDD6IUgJDcKBn14WjRYhln9SPp4al5pfe6rSumrsjVsyUcKIVdz0p-8cO8lCJn0cEYP31NcY9v2JdBxm4Xrfqu87EYSZOOg7-bYzzTAgyv4EpG4aYC1e9bS0FK1IwO2Cg1GRRe5xJPc1uqa7xv4JiDesds5SSWSmA9lW4_sWKGIHb1TqCtKGzdE4HiVqbl64Nh6yugpWMRlxADyUKXiX51ZGWrqir-Q..
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [DEBUG] [MAXIMO] [CID-CRON-25612] ArcGISHTTPExit --Asking for token from ArcGISHTTPExit.getUrl() for End Point
    [9/29/21 11:52:17:747 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:747 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (103) app (null) object (MAPSITES) : select * from mapsites where mapname in (select mapname from mapmanager where mapname in (select mapname from plussmapservicelayer where objectname= 'PIPELINE_TRI' ) and active=1) OPTION (FAST 1000)
    [9/29/21 11:52:17:793 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:793 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (129) app (null) object (MAPMANAGER) : select * from mapmanager where mapname in (select mapname from mapmanager where mapname in (select mapname from mapsites where siteid= 'GPX' ) and active=1 and ismobile=0) OPTION (FAST 1000)
    [9/29/21 11:52:17:840 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:840 [DEBUG] [MAXIMO] [CID-CRON-25612] tokenAuthSecurityEnabled = true
    [9/29/21 11:52:17:840 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:840 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (60) app (null) object (PLUSSMAPSERVICE) : select * from plussmapservice where mapname= '1003' and url= 'https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer' OPTION (FAST 1000)
    [9/29/21 11:52:17:840 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:840 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (106) app (null) object (PLUSSMAPSERVICE) : select * from plussmapservice where mapname= '1003' and url= 'https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/MapServer' OPTION (FAST 1000)
    [9/29/21 11:52:17:872 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:872 [DEBUG] [MAXIMO] [CID-CRON-25612] AUTHENTICATION_TOKENEXPIRE_TIME_RESET_LIMIT_PROPERTY : mxe.pluss.services.authentication.tokenExpireTimeResetLimit = 5
    [9/29/21 11:52:17:872 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:872 [WARN] [MAXIMO] [CID-CRON-25612] BMXAA7785W - Property mxe.pluss.services.authen.NonSecureTimeResetLimit does not exist.
    [9/29/21 11:52:17:872 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:872 [DEBUG] [MAXIMO] [CID-CRON-25612] AUTHENTICATION_NONSECURE_TIME_RESET_LIMIT_PROPERTY : mxe.pluss.services.authen.NonSecureTimeResetLimit = 10
    [9/29/21 11:52:17:872 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:872 [DEBUG] [MAXIMO] [CID-CRON-25612] url of urlService in tokenAuthentication(String url): https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid+%3D+1&&outFields=*&f=pjson&returnCountOnly=true
    [9/29/21 11:52:17:872 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:872 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (61) app (null) object (MAPMANAGER) : select * from mapmanager where mapname= '1003' OPTION (FAST 1000)
    [9/29/21 11:52:17:872 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:872 [DEBUG] [MAXIMO] [CID-CRON-25612] mxe.pluss.services.authentication.singleaccount = 0
    [9/29/21 11:52:17:872 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:872 [DEBUG] [MAXIMO] [CID-CRON-25612] getContentFromURL from URL: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer?f=json
    [9/29/21 11:52:17:887 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:17:887 [INFO] [MAXIMO] [] BMXAA6378I - USER = (MAXADMIN) SPID = (82)BMXAA6379I - Application (CrontaskManager) :select seed,servertimestamp,lastrun, lastend from taskscheduler where taskname = 'DepreciationFinTransCronTask.InstDepreciationCronTask'
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] Testing for the need of a token for url: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer Message returned: Token Required
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] Checking Token on urlService: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] dateMSecNow in milliseconds: 1632934637878
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] Token expires in milliseconds: 1632935166503
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] mxe.pluss.services.authentication.singleaccount = 0
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] getContentFromURL from URL: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer?f=json
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] in tokenAuthenticationViaJS -- tokenValue returned: wzMuUEPri8ENvz-sAXt-AisKfgfJ92KjG5uZbCdzczUJIebRUhBdSi4DDD6IUgJDcKBn14WjRYhln9SPp4al5pfe6rSumrsjVsyUcKIVdz0p-8cO8lCJn0cEYP31NcY9v2JdBxm4Xrfqu87EYSZOOg7-bYzzTAgyv4EpG4aYC1e9bS0FK1IwO2Cg1GRRe5xJPc1uqa7xv4JiDesds5SSWSmA9lW4_sWKGIHb1TqCtKGzdE4HiVqbl64Nh6yugpWMRlxADyUKXiX51ZGWrqir-Q..
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] tokenValue: wzMuUEPri8ENvz-sAXt-AisKfgfJ92KjG5uZbCdzczUJIebRUhBdSi4DDD6IUgJDcKBn14WjRYhln9SPp4al5pfe6rSumrsjVsyUcKIVdz0p-8cO8lCJn0cEYP31NcY9v2JdBxm4Xrfqu87EYSZOOg7-bYzzTAgyv4EpG4aYC1e9bS0FK1IwO2Cg1GRRe5xJPc1uqa7xv4JiDesds5SSWSmA9lW4_sWKGIHb1TqCtKGzdE4HiVqbl64Nh6yugpWMRlxADyUKXiX51ZGWrqir-Q..
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] ArcGISHTTPExit metaUrl: https://XXXXXXX.yyyyyyyyy.com/arcgis/rest/services/MaximoServices/MaximoAssetsService/FeatureServer/5/query?where=objectid+%3D+1&&outFields=*&f=pjson&returnCountOnly=true&token=wzMuUEPri8ENvz-sAXt-AisKfgfJ92KjG5uZbCdzczUJIebRUhBdSi4DDD6IUgJDcKBn14WjRYhln9SPp4al5pfe6rSumrsjVsyUcKIVdz0p-8cO8lCJn0cEYP31NcY9v2JdBxm4Xrfqu87EYSZOOg7-bYzzTAgyv4EpG4aYC1e9bS0FK1IwO2Cg1GRRe5xJPc1uqa7xv4JiDesds5SSWSmA9lW4_sWKGIHb1TqCtKGzdE4HiVqbl64Nh6yugpWMRlxADyUKXiX51ZGWrqir-Q..
    [9/29/21 11:52:17:887 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:887 [DEBUG] [MAXIMO] [CID-CRON-25612] ArcGISHTTPExit--transformPayloadToFormData data returns null
    [9/29/21 11:52:17:918 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:918 [INFO] [MAXIMO] [CID-CRON-25612] HTTP Response from External System is sucessessful.Response Code :200. Response Message:OK
    [9/29/21 11:52:17:918 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:918 [DEBUG] [MAXIMO] [CID-CRON-25612] PERFORMANCE TESTING: Starting process for 1 record keys.
    [9/29/21 11:52:17:918 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:918 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (63) app (null) object (MAXUSER) : select * from maxuser where userid = 'MAXADMIN' and status in (select value from synonymdomain where domainid = 'MAXUSERSTATUS' and maxvalue = 'ACTIVE') OPTION (FAST 1000)
    [9/29/21 11:52:17:918 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:918 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (66) app (null) object (PERSON) : select * from person where personid = 'MAXADMIN' OPTION (FAST 1000)
    [9/29/21 11:52:17:918 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:17:918 [INFO] [MAXIMO] [] BMXAA6378I - USER = (MAXADMIN) SPID = (103)BMXAA6379I - Application (CrontaskManager) :update taskscheduler set servername = ? , seed = ? , lastrun = ? , servertimestamp = ? where taskname = ? and seed <= ? and (lastend < ? or lastend is null)
    [9/29/21 11:52:17:965 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:17:965 [INFO] [MAXIMO] [] BMXAA6719I - USER = (MAXADMIN) SPID = (60) app (null) object (CRONTASKINSTANCE) : select * from crontaskinstance where crontaskname= 'DepreciationFinTransCronTask' and instancename= 'InstDepreciationCronTask' OPTION (FAST 1000)
    [9/29/21 11:52:17:965 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:965 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (106) app (null) object (EMAIL) : select * from email where personid= 'MAXADMIN' and isprimary=1 OPTION (FAST 1000)
    [9/29/21 11:52:17:965 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:17:965 [INFO] [MAXIMO] [] BMXAA6719I - USER = (MAXADMIN) SPID = (61) app (null) object (CRONTASKPARAM) : select * from crontaskparam where crontaskname= 'DepreciationFinTransCronTask' and instancename= 'InstDepreciationCronTask' OPTION (FAST 1000)
    [9/29/21 11:52:17:965 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:965 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (63) app (null) object (PHONE) : select * from phone where personid= 'MAXADMIN' and isprimary=1 OPTION (FAST 1000)
    [9/29/21 11:52:17:965 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:17:965 [INFO] [MAXIMO] [] BMXAA6719I - USER = (MAXADMIN) SPID = (82) app (null) object (CRONTASKDEF) : select * from crontaskdef where crontaskname= 'DepreciationFinTransCronTask' OPTION (FAST 1000)
    [9/29/21 11:52:17:981 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:981 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6719I - USER = (MAXADMIN) SPID = (66) app (null) object (MAPMANAGER) : select * from mapmanager where active=1 and mapname in (select mapname from mapsites where siteid= 'YGP' ) and ismobile=0 OPTION (FAST 1000)
    [9/29/21 11:52:17:981 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:981 [ERROR] [MAXIMO] [CID-CRON-25612] Crontask Name: ArcGISDataSync Instance Name: PIPELINE_TRI Arcgis cron task processing failed. please check log file for more details.
    java.lang.NullPointerException
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISDataSyncProcessor.process(ArcGISDataSyncProcessor.java:104)
    at com.ibm.tivoli.maximo.fdmbo.arcgis.ArcGISDataSyncCronTask.cronAction(ArcGISDataSyncCronTask.java:158)
    at psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java:2566)
    at psdi.server.CronTaskManager.access$1100(CronTaskManager.java:106)
    at psdi.server.CronTaskManager$CronThread.run(CronTaskManager.java:3476)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522)
    at java.util.concurrent.FutureTask.run(FutureTask.java:277)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:191)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.lang.Thread.run(Thread.java:811)
    [9/29/21 11:52:17:997 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:997 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6378I - USER = (MAXADMIN) SPID = (103)BMXAA6379I - Application (CrontaskManager) :select lastrun from taskscheduler where taskname =ArcGISDataSync.PIPELINE_TRI
    [9/29/21 11:52:17:997 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:997 [INFO] [MAXIMO] [CID-CRON-25612] ArcGISDataSync.PIPELINE_TRI lastRun=2021-09-29 11:52:17.44
    [9/29/21 11:52:17:997 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:17:997 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6378I - USER = (MAXADMIN) SPID = (103)BMXAA6379I - Application (CrontaskManager) :update taskscheduler set lastend = ? , servertimestamp = ? where servername = ? and taskname = ?
    [9/29/21 11:52:18:012 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:012 [INFO] [MAXIMO] [] BMXAA6719I - USER = (MAXADMIN) SPID = (129) app (null) object (CRONTASKPARAM) : select * from crontaskparam where crontaskname= 'DepreciationFinTransCronTask' and instancename= 'InstDepreciationCronTask' OPTION (FAST 1000)
    [9/29/21 11:52:18:043 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25613] Correlation started.
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [ERROR] [MAXIMO] [CID-CRON-25612] BMXAA6359E - A runtime error for host ArcGISDataSync.PIPELINE_TRI:Crontask Name: ArcGISDataSync Instance Name: PIPELINE_TRI Arcgis cron task processing failed. please check log file for more details. occurred. Increase the amount of memory that is available to the Java Virtual Machine (JVM).
    [9/29/21 11:52:18:043 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25613] Correlation started, correlation data added: TaskName:DepreciationFinTransCronTask
    [9/29/21 11:52:18:043 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25613] Correlation started, correlation data added: InstanceName:InstDepreciationCronTask TaskName:DepreciationFinTransCronTask
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] Crontask Name: ArcGISDataSync Instance Name: PIPELINE_TRI Arcgis cron task processing failed. please check log file for more details.BMXAA6361I - caused by:null
    [9/29/21 11:52:18:043 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25613] Correlation started, correlation data added: InstanceName:InstDepreciationCronTask TaskName:DepreciationFinTransCronTask Activity:ACTION
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] BMXAA6378I - USER = (MAXADMIN) SPID = (60)BMXAA6379I - Application (CrontaskManager) :update crontaskhistory set runtimeerror=?, endtime=? where crontaskname=? and instancename=? and serverhost=? and servername=? and activity=? and starttime=?
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] Crontask Name: ArcGISDataSync Instance Name: PIPELINE_TRI Arcgis cron task processing failed. please check log file for more details.BMXAA6361I - caused by:null
    [9/29/21 11:52:18:043 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25613] BMXAA6378I - USER = (MAXADMIN) SPID = (106)BMXAA6379I - Application (CrontaskManager) :select lastrun from taskscheduler where taskname =DepreciationFinTransCronTask.InstDepreciationCronTask
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] 2021-09-29 11:52:18.03
    [9/29/21 11:52:18:043 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25613] DepreciationFinTransCronTask.InstDepreciationCronTask
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] ArcGISDataSync
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] PIPELINE_TRI
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] 10.2.10.85
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] MAXIMO
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] ACTION
    [9/29/21 11:52:18:043 CDT] 000009ec SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25612] 2021-09-29 11:52:17.51
    [9/29/21 11:52:18:043 CDT] 000009f2 SystemOut O 29 Sep 2021 11:52:18:043 [INFO] [MAXIMO] [CID-CRON-25613]


    #MaximoSpatial
    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: ArcGISDataSync is throwing a null error when trying to run

    Posted Thu September 30, 2021 08:26 AM
    Can you confirm a record is returned when you run this:

    select * from mapmanager where active=1 and mapname in (select mapname from mapsites where siteid= 'YGP' ) and ismobile=0

    That's trying to get the MapManager record which is then used to retrieve the layers. If no map is returned then it'd have a null value for the MBO and fail with a null pointer exception. If you've already setup the map I'd make sure you made it ACTIVE and associated it to that site.

    ------------------------------
    Steven Shull
    ------------------------------

    Original Message


  • 3.  RE: ArcGISDataSync is throwing a null error when trying to run

    Posted Thu September 30, 2021 10:21 AM
    Steven,
    The sql you referenced for site YGP is for an inactive map. above in the logs you will see the same sql but for site GPX which is an active map and the sql returns a record.
    I went ahead and deleted the YGP map as it was a test map.
    We now only have one map and it is active.
    cron still throws the same error.

    thanks,
    doug

    ------------------------------
    doug carrington
    ------------------------------

    Original Message


  • 4.  RE: ArcGISDataSync is throwing a null error when trying to run

    Posted Thu September 30, 2021 10:42 AM
    Is MAXADMIN's default insert site YGP? The cron task pulls the user's default insert site to determine the map to get. Looking at the query that was executed, it looks like MAXADMIN's default insert site was YGP when it ran.

    ------------------------------
    Steven Shull
    ------------------------------

    Original Message


  • 5.  RE: ArcGISDataSync is throwing a null error when trying to run

    Posted Thu September 30, 2021 11:06 AM
    Steven,
    The default site of maxadmin was not a site in my map so I added it and the process kicked off.
    Thanks for the assistance!

    doug

    ------------------------------
    doug carrington
    ------------------------------

    Original Message