Maximo Open Forum

 View Only

Maximo Mobile Preload Database error

  • 1.  Maximo Mobile Preload Database error

    Posted 13 days ago

    Hello All

    We are reviewing 9.2.4 in our development environment and getting this weird error while generating the Mobile preload database. Halfway through the generation it starts showing this error and job goes in forever INPROGRESS status. I checked the logs and it does not have much information either. 

    Logs : 

    Object structure: MXAPIITEM;
    Table name: ITEM;
    Select attributes: description,itemnum,itemid,itemsetid,rotating,item.unitcost--unitcost;
    Saved query: SHOWITEMS;
    **************************************
    Error to query page 2: BMXAA4210E - Database error number -805 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.
    I verified the SQL and it works fine in the browser and database. Wondering what makes it fail half way

    Thank you 

    Vineet J


    #MaximoApplicationSuite

    ------------------------------
    vineet joshi
    ------------------------------


Newest Episode
Ep. 10 | How Naviam DataStudio Makes Data Imports Easier with Lee Daley

Steven Shull and Lee Daley explore how Naviam DataStudio helps IBM Maximo teams simplify bulk data imports, validate information before loading, and improve data quality and management.

MORE by Naviam Episode 10: How Naviam DataStudio Makes Data Imports Easier with Lee Daley
Watch Episode 10
Also available: Ep. 9 | Best Maximo Resources to Stay Informed