IBM Security i2

Expand all | Collapse all

entities not able to expand after deleting and re-importing them

  • 1.  entities not able to expand after deleting and re-importing them

    Posted Mon November 09, 2020 05:11 PM
    Hi everyone. I deleted some records and after re-importing them, ibase is creating new internal keysfor them. As a consequence, if I try expand the same items in Analyst they no longer find connected records through a relationship. Is there a way to maintain ibase's internal keys after deleting and re-importing records?

    Regards!


    ------------------------------
    makcim silveira
    ------------------------------


  • 2.  RE: entities not able to expand after deleting and re-importing them

    Posted Tue November 10, 2020 03:58 AM
    Edited by Simon Griffiths Tue November 10, 2020 04:40 AM
    No, iBase will always create a new internal Record ID when creating new records.

    It can use the internal Record ID to match against existing records when importing if you expose the record ID in iBase Designer for the item type (which is very useful when using import to update existing records), but that won't help in your situation where the items have been deleted because there is no record ID to match against,and the connecting links will have been deleted too. Do you have soft delete enabled by any chance?

    Sorry I cannot be of more help.

    Simon

    ------------------------------
    Simon Griffiths
    ------------------------------



  • 3.  RE: entities not able to expand after deleting and re-importing them

    Posted Thu November 12, 2020 11:29 AM
    Makcim,

    The internal keys shouldn't be the identifiers of an entity since as Simon pointed out, they are generated on each import and will be different.  In your iBase schema you should have identifiers (DOB First Name Last Name ETC).  Check your import specifications to ensure that you are using the proper identifiers for the existing entities that uniquely identify them.  Also ensure at the end of the specification that the update settings are correct.  I would highly advise that you ensure that any import you design ,  you create a set to capture the data that is imported into iBase so it doesn't get lost on the collation system.  As a practise you should be doing this to make bulk edits/deletes etc easier.

    You can check to ensure the imports are connection the A and B entities correctly by using the VERIFY function in the last stage of the import specification.  You should see as per the diagram on one of the ends SAME and on the entity you're importing NOT FOUND.  Then you know iBase is using the identifiers properly and linking them to existing entities.


    ------------------------------
    Markus Pankatz
    ------------------------------



  • 4.  RE: entities not able to expand after deleting and re-importing them

    Posted Thu November 12, 2020 09:32 AM
    Hi, 

    soft delete wouldn't help me, as we're deleting all records because it's faster than updating them. 
    Anyways, thanks for your answer. 

    Regards

    ------------------------------
    makcim s.
    ------------------------------