Wednesday, June 25, 2008

EIM : Handling EIM process failures

Imagine this scenario, you are deleting a large number of contacts and you process aborts somewhere during the process. If you are using default parameters in process IFB, you can be in a lot of trouble. Why? EIM have this 3 parameters 
COMMIT EACH PASS = TRUE
COMMIT EACH TABLE = TRUE
ROLLBACK ON ERROR = FALSE
whith this defaults, this means that after deleting a table a commit is performed. And no rollback is performed. this can leave you with "orphan" records.
To avoid this, just change your parameters to 
COMMIT EACH PASS = FALSE
COMMIT EACH TABLE = FALSE
ROLLBACK ON ERROR = TRUE
This ensures that EIM will either complete sucessfully or rollback the batch.

Just one note, be sure that your database resources are large enough to handle this transaction.
em

4 comments:

  1. gmlNovember 9, 2008 at 10:59 PM

    Hi,
    The loading of data from eim_account to s_org_ext is done.the status shows 'IMPORTED'.I have given insert true for S_ORG_EXT,S_PARTY,S_ADD_ORG,S_ORG_BU in the ifb file.the data got imported successfully but it does not showup in the application.i tried updating the flag fields corresponding to the already existing rows which are displaying.But still not able to make the imported data display.Can you please help me on this with your suggestion?I am using siebel 8.0 version.

    ReplyDelete
  2. ixanosApril 27, 2009 at 11:26 AM

    I think it will be interesting to also have a look at this white paper :

    Debugging EIM taskscheers

    ReplyDelete
  3. ixanosApril 27, 2009 at 11:27 AM

    I think it will be interesting to also have a look at this white paper :

    Debugging EIM taskscheers

    ReplyDelete
  4. Priyankar PakhiraFebruary 6, 2010 at 7:12 AM

    can u check populate the MASTER_OU_ID column in S_ORG_EXT, if not update this column with row_id of S_ORG_EXT

    ReplyDelete