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