IBM Support

Loading data with the Integration Framework using autokey or sequences

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.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"MEA: Generic","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}},{"Product":{"code":"SSLKYL","label":"Maximo Enterprise Adapter"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"7.1;7.1.1","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
17 June 2018

UID

swg21423732