My Oracle Support Banner

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

Last updated on OCTOBER 27, 2022

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.

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?


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 Message 1

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.