EIM Load Of attachments from another machine (Doc ID 530343.1)

Last updated on JULY 13, 2015

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.2.100 [15252] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.2.100 [15252]
Database: Oracle 8.1.7.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: HP-UX 10.0

This document was previously published as Siebel SR 38-921883951.
***Checked for relevance on 06-NOV-2013***


Symptoms

We are currently trying to load Activity Attachments into our Production database using EIM.
The problem is that the IF_ROW_STAT in the the EIM_ACT_DETAIL table is reporting 'IMPORTED' for all rows however when we check the table S_ACTIVITY_ATT no rows are imported!!
This is urgent as it affects the Production Go-Live

We have used the following in out IFB file:

[Siebel Interface Manager]
      USER NAME = "SADMIN"
      PASSWORD = "SADMIN"
      PROCESS = "Import Activity Attachments"

[Import Activity Attachments]
    
      ATTACHMENT DIRECTORY = Y:\EIM_ATTACHMENTS\INPUT2
      TYPE = IMPORT
      TABLE = EIM_ACT_DTL
      BATCH = 1-16
      ONLY BASE TABLES = S_EVT_ACT, S_ACTIVITY_ACT
      INSERT ROWS S_EVT_ACT, FALSE


As you can see, we have mapped a drive (Y:) from the macj=hine where the Attachments reside. We have also tried using the UNC path name of the location of the Attachment Directory.

Is is possible for the Attachment directory to be located on another machine?

Thanks

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms