Maximo

 View Only
  • 1.  MAXIMO Mobile 8.11 - SQL Errors while executing cron task MobileDbGeneration

    Posted Fri November 17, 2023 04:34 PM

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


  • 2.  RE: MAXIMO Mobile 8.11 - SQL Errors while executing cron task MobileDbGeneration

    IBM Champion
    Posted Mon November 20, 2023 08:21 PM

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



  • 3.  RE: MAXIMO Mobile 8.11 - SQL Errors while executing cron task MobileDbGeneration

    Posted Tue November 21, 2023 10:30 AM

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



  • 4.  RE: MAXIMO Mobile 8.11 - SQL Errors while executing cron task MobileDbGeneration

    IBM Champion
    Posted Tue November 21, 2023 05:31 PM

    That's right. I should apply the latest IFIX for 7.6.1.3.



    ------------------------------
    Maycon Belfort
    Consultant
    BPD Zenith
    Melbourne
    Australia
    ------------------------------