The goal is not to delete but to recreate those item records that are missing. IE add to the item, itemorginfo, etc. tables and not try to delete from every other table in Maximo. Your table is INVBALANCES for example and there are other tables (INVCOST, MATUSETRANS, MATRECTRANS, etc.) that can reference those items as well.
If you want to continue down the purging path you will need to do something similar with invbalances that I provided with inventory like:
select * from invbalances where not exists(select 1 from item where itemnum=invbalances.itemnum and itemsetid=invbalances.itemsetid)
------------------------------
Steven Shull
------------------------------
Original Message:
Sent: Mon May 29, 2023 07:10 AM
From: Suhas Joshi
Subject: Error while creating preloaded DB for Maximo Mobile
Thanks Steven. We deleted such entries which are not in item table but are in inventory table. Even after this we are unable to create preloaded DB. Receiving same error.
------------------------------
Suhas Joshi
Original Message:
Sent: Wed May 24, 2023 08:27 AM
From: Steven Shull
Subject: Error while creating preloaded DB for Maximo Mobile
This query is actually invalid. I tried to get it updated a couple of times without success.
What you really want is:
select * from inventory where not exists(select 1 from item where itemnum=inventory.itemnum and itemsetid=inventory.itemsetid)
What the query on the tech note is testing is if you have an item in inventory that exists in another item set which isn't even necessarily an issue.
------------------------------
Steven Shull
Original Message:
Sent: Tue May 23, 2023 10:14 AM
From: Suhas Joshi
Subject: Error while creating preloaded DB for Maximo Mobile
Hi,
We are getting below error while creating a preloaded DB for Maximo Mobile. We have followed the suggestion given in Maximo Mobile Technician error on the device Unable to download all supporting data link but there are no records returned mentioned in the SQL in this link. So ideally it should work but it still fails.
Error:
STATUS":"ERROR","BUILDTIMESTAMP":"5\/23\/23 4:03 PM","LANGCODE":"EN","STATUSINFO":{"INVENTORY":{"ERRORMESSAGE":{"Error to query page 3":"item#invalidItem"}
"INVBALANCES":{"ERRORMESSAGE":{"Error to query page 4":"item#invalidItem"}
Any help is appreciated.
| Ibm | remove preview |
| | Maximo Mobile Technician error on the device Unable to download all supporting data | | There are times where the mobile device fails with an error, the clues to the cause will be in the mobile device logs. | | View this on Ibm > |
|
|
------------------------------
Suhas Joshi
------------------------------