That's right. I should apply the latest IFIX for 7.6.1.3.
Original Message:
Sent: Tue November 21, 2023 10:30 AM
From: Pankaj Bhide
Subject: MAXIMO Mobile 8.11 - SQL Errors while executing cron task MobileDbGeneration
Hello Maycon,
Thanks for your reply. In one of the posts, you suggested going to https://www.ibm.com/support/pages/node/6855299.
I browsed the link: https://maximo.dev.lbl.gov/maximo/oslc/graphite/mobile/db?info=1&user=IT-BS-MXINTADM
It showed me:
{"INFO":[{"GENERATIONTRACE":[{},{},{},{},{},{},{},{},{"SYNONYMDOMAIN_metricsInsertionTime":16,"SYNONYMDOMAIN_pageRetrievalTime":[78]
,"SYNONYMDOMAIN_totalTableProcessingTime":110,"Warnings":"Unable to set internalvalues flag on BulkJSONSerializer because
the Tpae\/Manage fix for DT223537 is missing. Install the latest 7.6.1.3 or Manage patch.",
"SYNONYMDOMAIN_pageInsertionTime":[16]},{},{},{},{},{"INVBALANCES_metricsInsertionTime":16,
"INVBALANCES_pageRetrievalTime":[17704,34688,50048,64565,78316,92066,106332,118161,128693,139163,147163,157585,
165601,177726,185851],"INVBALANCES_totalTableProcessingTime":187834,
"INVBALANCES_pageInsertionTime":[47,110,203,328,406,484,593,702,811,1030,1202,1389,1514,1702,1858],
"Warnings":"Unable to set internalvalues flag on BulkJSONSerializer because the Tpae\/Manage fix for DT223537 is missing.
Install the latest 7.6.1.3 or Manage patch."},
{"ASSET_totalTableProcessingTime":2204139,"ASSET_pageInsertionTime":
[93,202,312,438,563,750,906,1093,1265,1468,1656,1859,2047,2235,2438,2642,2845,3064,3329,3376],"ASSET_metricsInsertionTime":0,"Warnings":"Unable to set internalvalues flag on BulkJSONSerializer because the Tpae\/Manage fix for DT223537 is missing. Install the latest 7.6.1.3 or Manage patch.","ASSET_pageRetrievalTime":[180521,297416,420670,546844,664955,779554,894026,1012904,1119391,1216237,1322349,1426929,1533309,1643311,1748361,1859864,1970319,2076212,2191059,2199481]},{},{"ITEMCONDITION_pageInsertionTime":[0],"ITEMCONDITION_metricsInsertionTime":16,"Warnings":"Unable to set internalvalues flag on BulkJSONSerializer because the Tpae\/Manage fix for DT223537 is missing. Install the latest 7.6.1.3 or Manage patch.","ITEMCONDITION_pageRetrievalTime":[0],"ITEMCONDITION_totalTableProcessingTime":16},{},{},{}],"STATUS":"ERROR","BUILDTIMESTAMP":"11\/21\/23 6:37 AM","LANGCODE":"EN","STATUSINFO":{"ALNDOMAIN":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"ALNDOMAIN","USERID":"IT-BS-MXINTADM","SAVEDQUERY":null,"OBJECTSTRUCTURE":"MXAPIALNDOMAIN","SELECT":"value, description, domainid, valueid, siteid, orgid"},"LOCATIONS":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"LOCATIONS","USERID":"IT-BS-MXINTADM","SAVEDQUERY":"MOBILELOCATION","OBJECTSTRUCTURE":"MXAPIOPERLOC","SELECT":"locationsid, location, description, failurecode, glaccount, locpriority, parent, locationchildren, syschildren._dbcount--childcount, locsystem.primarysystem--primarysystem, systemid, type, status, siteid, orgid, plussgeojson, rel.failurelist{failurelist,failurecode.description,failurecode.failurecode}, rel.locationmeter{metername,active,rollover,lastreading,readingtype,lastreadingdate,measureunitid,meter.measureunit.description--unitdescription,sequence}, serviceaddress.latitudey, serviceaddress.longitudex"},"INSPFORMUSEWITH":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"INSPFORMUSEWITH","USERID":"IT-BS-MXINTADM","SAVEDQUERY":null,"OBJECTSTRUCTURE":"MXAPIINSPFORMUSEWITH","SELECT":"inspformusewithid, inspformnum, objectname, objectid, inspectionform.name, inspectionform.revision"},"WORKTYPE":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"WORKTYPE","USERID":"IT-BS-MXINTADM","SAVEDQUERY":"WOWORKTYPE","OBJECTSTRUCTURE":"MXAPIWORKTYPE","SELECT":"worktype, wtypedesc, woclass, orgid, promptdown, startstatus, completestatus"},"PERSON":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"PERSON","USERID":"IT-BS-MXINTADM","SAVEDQUERY":"SERVICEREQUEST","OBJECTSTRUCTURE":"MXAPIPERSON","SELECT":"personid, firstname, lastname, displayname, primaryphone, primaryemail, department"},"TOOLITEM":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"TOOLITEM","USERID":"IT-BS-MXINTADM","SAVEDQUERY":"USERTOOLLIST","OBJECTSTRUCTURE":"MXAPITOOLITEM","SELECT":"description, itemnum, itemid, rotating"},"LABORCRAFTRATE":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"LABORCRAFTRATE","USERID":"IT-BS-MXINTADM","SAVEDQUERY":"LABORSITEMOB","OBJECTSTRUCTURE":"MXAPILABORCRAFTRATE","SELECT":"craft, craft.description--craftdescription, craftskill.skilllevel--skillleveldata, craftskill.description--skillleveldescdata, defaultcraft, rate, laborcraftrateid, laborcode"},"INSPECTIONFORM":{"ERRORMESSAGE":{"Error to generate table":null},"TABLENAME":"INSPECTIONFORM","USERID":"IT-BS-MXINTADM","SAVEDQUERY":null,"OBJECTSTRUCTURE":"MXAPIINSPFORM","SELECT":"inspectionformid, inspformnum, name, orgid, revision, status, description_longdescription, rel.inspquestionsgrp{description,groupid,groupseq,inspquestionid,inspquestionnum,hasld,rel.inspquestionchild{description,groupid,groupseq,inspquestionid,inspquestionnum,hasld,rel.inspfield{rel.domain{rel.alndomainvalue{*},rel.synonymdomain{*}},description,fieldtype,inspfieldid,inspquestionid,inspquestionnum,inspfieldnum,required,visible,metertype,metername,rel.alndomain{value,description},rel.inspfieldoption{description,inspfieldoptionid,color,icon,inspectorfeedback,requireaction}}},rel.inspfield{rel.domain{rel.alndomainvalue{*},rel.synonymdomain{*}},description,fieldtype,inspfieldid,inspqu
Based upon another IBM tech, it seems I need to request my cloud provide apply the required patch on 7.6.1.3 before proceeding further on this.
I am going to request the same.
Thanks again
------------------------------
Pankaj Bhide
Original Message:
Sent: Mon November 20, 2023 08:21 PM
From: Maycon Belfort
Subject: MAXIMO Mobile 8.11 - SQL Errors while executing cron task MobileDbGeneration
Hi Pankaj,
Have you checked the Maximo logs? You can try changing the log level to DEBUG for the GRAPHITE log on the Logging application in Maximo.
Check if Maximo is not generating heap dumps and out of memory in SystemOut log files.
------------------------------
Maycon Belfort
Consultant
BPD Zenith
Melbourne
Australia
Original Message:
Sent: Fri November 17, 2023 04:34 PM
From: Pankaj Bhide
Subject: MAXIMO Mobile 8.11 - SQL Errors while executing cron task MobileDbGeneration
Hello,
We are trying to implement Maximo Mobile "IBM Maximo Mobile 8.11.0 Build 20230913-0100 DB Build V81100-50" with release 7.6.1.3.
I setup a crontask instance for MobileDbGeneration and it executed a few times. At every cycle it is giving errors suggesting something following:
=========================
Template user: IT-BS-MXINTADM;
Template user insert site: FAC;
Person groups associated: LBL_MOBADMIN;
--------------------------------------
Error list:
--------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Object structure: MXAPIALNDOMAIN;
Table name: ALNDOMAIN;
Select attributes: value, description, domainid, valueid, siteid, orgid;
**************************************
Error to generate table: null
**************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Object structure: MXAPIOPERLOC;
Table name: LOCATIONS;
Select attributes: locationsid, location, description, failurecode, glaccount, locpriority, parent, locationchildren, syschildren._dbcount--childcount, locsystem.primarysystem--primarysystem, systemid, type, status, siteid, orgid, plussgeojson, rel.failurelist{failurelist,failurecode.description,failurecode.failurecode}, rel.locationmeter{metername,active,rollover,lastreading,readingtype,lastreadingdate,measureunitid,meter.measureunit.description--unitdescription,sequence}, serviceaddress.latitudey, serviceaddress.longitudex;
Saved query: MOBILELOCATION;
**************************************
Error to generate table: null
**************************************
**************************************
Error to generate table: null
**************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Object structure: MXAPIINSPFORMUSEWITH;
Table name: INSPFORMUSEWITH;
Select attributes: inspformusewithid, inspformnum, objectname, objectid, inspectionform.name, inspectionform.revision;
**************************************
Error to generate table: null
**************************************
I associated the user IT-BS-MXINTADM user as the runtime user for that crontask,
This user belongs to the MAXADMIN group. I also made sure that the underlying object structure (shown above e.g. MXAPIOPERLOC, MXAPIALNDOMAIN) have all privilges to maxadmin group, The user belongs to the user group (primary) required for this crontask.
I am not able to understand why these errors are reported? What is the reasons for these errors? The above 3 errors are representative and not the exhaustive errors list.
I tried running these requests using Postman, for example -
curl --location 'https://<host>maximo/api/os/MXAPIALNDOMAIN?lean=1&oslc.select=value%2C%20description%2C%20domainid%2C%20valueid%2C%20siteid%2C%20orgid%0A&ignorecollectionref=1&ignorers=1&ignorekeyref=1&apikey=<of the user IT-BS-MXINTADM>"
It correctly rendered me the json.
If it is the case, then, why it is reporting the error?
Can someone help me to understand these errors and provide with some guidance on fixing them?
Thanks in advance.
------------------------------
Pankaj Bhide
------------------------------