IBM Support

Cannot add Items to Storeroom using Item Master application

Technical Blog Post


Abstract

Cannot add Items to Storeroom using Item Master application

Body

Problem:
While trying to add Items to Storeroom using Item Master application, the Add Items to Storeroom dialog is opened empty.


Steps to replicate:

1. Go to Item Master application.
2. Create a new Item.
3. Select action > Add Items to Storeroom.

The Add Items to Storeroom dialog is opened empty.

 

Resolving the problem:

Run the query below to check if the maxvar 'DFLTINVSTATUS' has a value which does not exist in the synonymdomain table under domainid 'ITEMSTATUS'. This maxvar is site-level.

SELECT * FROM MAXVARS WHERE VARNAME = 'DFLTINVSTATUS' AND VARVALUE IS NOT NULL AND VARVALUE NOT IN (SELECT MAXVALUE FROM SYNONYMDOMAIN WHERE DOMAINID = 'ITEMSTATUS');

The recommendation is to either set the varvalue for the maxvar 'DFLTINVSTATUS' to null, or to a value with exists in the synonymdomain table under domainid 'ITEMSTATUS'.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11112445