This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Still working on migrating to Maximo 7.6. . .
I'm trying to import Purchase Contracts using Object Structures. When I try to import the CONTRACTSTATUS table, I consistently get "ADD is not allowed on CONTRACTSTATUS" errors. I'm using a Flat File, and I've tried using Change, AddChange, and Replace actions. All of them give the "ADD not allowed" message.
Googling eventually led me to the JavaDocs, which said ADD could only be called from the PR object?!?!?
Any ideas on how to get the data in there, short of back-end manipulation?
Travis Herron
If you include some of the status change columns in your data, I think it
would try to change the status. Maybe that's the problem?
Also: what status are you setting the new records to? I ask because,
before you can approve a contract, you have to specify which sites the
contract applies to. That may also be the problem here.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Tuesday, July 19, 2016 10:58 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] cannot import CONTRACTSTATUS
Still working on migrating to Maximo 7.6. . .
I'm trying to import Purchase Contracts using Object Structures. When I try
to import the CONTRACTSTATUS table, I consistently get "ADD is not allowed
on CONTRACTSTATUS" errors. I'm using a Flat File, and I've tried using
Change, AddChange, and Replace actions. All of them give the "ADD not
allowed" message.
Googling eventually led me to the JavaDocs, which said ADD could only be
called from the PR object?!?!?
Any ideas on how to get the data in there, short of back-end manipulation?
Travis Herron
While I may have to end up re-trying this whole import thing. . .
I ended up doing this in smaller chunks. First, a simple import of PURCHVIEW and CONTRACTLINE. That brought everything in with the Status set to DRAFT.
Next, a simple import of the bare necessities of PURCHVIEW (contractnum, revisionnum, and orgid) plus all of CONTRACTAUTH. That seems to have gone well.
Last, I'm trying to import the bare necessities of PURCHVIEW plus all of CONTRACTSTATUS. But it won't let me add.
I need to set the Status to "whatever the status happens to be in my Maximo 6.2 database." There are some that are APPR, some CAN, some SUSPND, etc.
Then, since it has been rejecting my import attempts, I tried a different approach on one record. In my 6.2 DB, this contract had been DRAFT, APPR, and CAN. So I went to the same record in 7.6 and manually changed the status from DRAFT to APPR, and then to CAN. So then I tried to import the records to CHANGE or REPLACE the records in CONTRACTSTATUS with the records from the 6.2 table. It still gives me the "ADD not allowed" error. All that I really need to do to that contract is change the ChangeBy and ChangeDate. And sadly it won't let me.
Travis Herron