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 = TRUEwhith 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.
COMMIT EACH TABLE = TRUE
ROLLBACK ON ERROR = FALSE
To avoid this, just change your parameters to
COMMIT EACH PASS = FALSEThis ensures that EIM will either complete sucessfully or rollback the batch.
COMMIT EACH TABLE = FALSE
ROLLBACK ON ERROR = TRUE
Just one note, be sure that your database resources are large enough to handle this transaction.
4 comments:
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.
I think it will be interesting to also have a look at this white paper :
Debugging EIM taskscheers
I think it will be interesting to also have a look at this white paper :
Debugging EIM taskscheers
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
Post a Comment