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
------------------------------