Resolving Errors in the EIM Process

Perform the following steps to resolve errors that can occur during your EIM process:

  • If EIM aborts with the following generic error, then the user account running EIM does not have EXECUTE privileges on the DSNUTILS stored procedure:

    DSNU060I database_alias DSNUGMAP - USER username NOT AUTHORIZED FOR RUNSTATS UTILITY ON

    For information about the required permissions, see RUNSTATS Utility. Alternatively, you can run EIM with the UPDATE STATISTICS parameter set to FALSE.

  • If your EIM process fails with the following error message, then the DSNZPARM parameter RETVLCFK might be set incorrectly.

    EIM-00205 Failed To Load the Application Dictionary

    Siebel CRM requires that the parameter RETVLCFK is set to NO. For information on DSNZPARM settings see DSNZPARM Parameter Settings for Siebel CRM.

  • If EIM terminates during a DELETE EXACT process involving deletion of child records, the following error indicates that the maximum allowable locks have been exceeded:

    EIM Fails - Max Locks Exceeded on DELETE EXACT

    This termination causes the child records to be orphaned, because the delete to the parent table has already been committed.

    You can avoid this error by specifying the following in your .ifb file:

    COMMIT EACH PASS = FALSE
    COMMIT EACH TABLE = FALSE
    ROLLBACK ON ERROR = TRUE