Error: "The specified vendor is not valid"

Technote (troubleshooting)


Problem(Abstract)

Error after entering a valid company in the company field on a purchase order.

Symptom

Error: "BMXAA7094E: The entered value is not valid, enter a valid integer value" or "BMXAA3385E- The specified vendor is not valid" when entering a valid vendor on PO

IBM Logo

Cause

This error can happen during upgrade when the primarykeycolseq value somehow got changed.

Diagnosing the problem

Excerpt from the log:


select top 1000 * from companies where ((company = '17,131' and orgid= 'EAGLENA' ) and (disabled = 0 and orgid = 'EAGLENA' )) and (exists ( select orgid from siteauth a,groupuser b where a.groupname=b.groupname and b.userid = 'maxadmin' and a.orgid = companies.orgid ))

companies.company has been defined as UPPER in database configuration.
But the log references the wrong field (i.e. 17131 which is companies.companiesid) instead of companies.company


Resolving the problem

Run the select statements below against the database:


select objectname,attributename,primarykeycolseq from
maxattributeCFG where primarykeycolseq is null
and objectname = 'COMPANIES' and attributename='COMPANIESID'
order by 1,3

if no row got returned, then run the update below to fix the problem:

update maxattribute set primarykeycolseq = NULL where
objectname='COMPANIES' and attributename='COMPANIESID';

update maxattributecfg set primarykeycolseq = NULL where
objectname='COMPANIES' and attributename='COMPANIESID';

The error below might come up after running the update:
IBM Logo

Run the insert statement to fix maxlookupmap table:

insert into maxlookupmap
(target, lookupattr, targetattr,source, sourcekey, seqnum, allownull, maxlookupmapid)
values
('PO', 'VENDOR', 'VENDOR', 'COMPANIES', 'COMPANY', 1, 1, 1000001) ;


insert into maxlookupmap
(target, lookupattr, targetattr,source, sourcekey, seqnum, allownull, maxlookupmapid)
values
('PR', 'VENDOR', 'VENDOR', 'COMPANIES', 'COMPANY', 1, 1, 1000002) ;

insert into maxlookupmap
(target, lookupattr, targetattr,source, sourcekey, seqnum, allownull, maxlookupmapid)
values
('INVOICE', 'VENDOR', 'VENDOR', 'COMPANIES', 'COMPANY', 1, 1, 1000003) ;

insert into maxlookupmap
(target, lookupattr, targetattr,source, sourcekey, seqnum, allownull, maxlookupmapid)
values
('RFQVENDOR', 'VENDOR', 'VENDOR', 'COMPANIES', 'COMPANY', 1, 1, 1000004) ;

commit;

Restart the application server. Everything should be working now.


Related information

http://www-01.ibm.com/support/docview.wss?uid=swg214138

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Purchase Orders

Software version:

7.1, 7.1.1, 7.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1432413

Modified date:

2010-09-20

Translate my page

Machine Translation

Content navigation