Question & Answer
Question
Why are autokey or sequences not working when loading data?
Answer
You must restrict the field for the system to generate an autokeyed or sequence generated id field. If it is not resricted and the field is required, the MIF expects data.
For example, assume you are loading asset data and want the assetnum field to use the autokey functionality. Creating assets through the Maximo asset application screen works fine, but loading data does not.
If you are using Base Services 7.1.1.5, you would restrict the attribute in the Database Configuration application. If you are using Base Services 7.1.1.6 or later, you can restrict the attribute in the Integration -> Object Structure application. Use the Select Action -> Inbound Setting Restriction dialog box. This allows you to override setting restrictions for id columns used in the Object Structure.
You can also modify the restricted attribute from the backend using a sql tool:
update maxattribute set restricted=1 where objectname='ASSET' and attributename='ASSETNUM';
update maxattributecfg set restricted=1 where objectname='ASSET' and attributename='ASSETNUM';
commit;
Restart application server
The data will now be loaded with the autokey or sequence.
Document Information
Modified date:
17 June 2018
UID
swg21423732