Technical Blog Post
Abstract
BMXAA7135E - The Boolean value of PURCHVIEW.CREATEREL cannot be retrieved
Body
Problem:
Error message while trying to create Purchase Contract using either Purchase Contracts or Purchase Requisitions application.
Resolving the problem:
Suggestion I:
1. Go to Database Configuration application.
2. Bring up PURCHVIEW object.
3. Go to Relationships tab.
4. Bring up PROPERTYDEFAULT relationship.
5. Make sure that the Where Clause is defined as below:
contracttypeid = :contracttype and orgid = :orgid
Suggestion II:
1. Go to Domains application.
2. Bring up CONTRACTTYPE domain.
3. For PURCHASE Internal Value, make sure that PURCHASE Value is set as Default.
Suggestion III:
Check if you have default value correctly defined for the PROPERTYID CREATEREL in both CONTRACTDEFAULT and PROPERTYDEFAULT objects by running the following queries:
SELECT DEFAULTVALUE FROM CONTRACTDEFAULT WHERE MAXCONTRACTTYPE = 'PURCHASE' AND PROPERTYID = 'CREATEREL';
SELECT DEFAULTVALUE FROM PROPERTYDEFAULT WHERE CONTRACTTYPEID = 'PURCHASE' AND PROPERTYID = 'CREATEREL' AND ORGID = 'EAGLENA';
(replacing EAGLENA by the Organization in question)
If the problem still persists even after trying all the suggestions above, please contact IBM Maximo Support.
UID
ibm11112421