Need Help With a Load

[datapro01]

We are attemtping a load using a dump file. The load is being run from
an app server box (No 15) into a database server(box 13).

The load works ok but we are getting some errors ...some rows have bad
data.

We are attempting to capture the specific rows that are not being
loaded due to errors and are using a dump file.

Even though the permissions are ok we are getting error messages on
accessing the dump file. We understand that the dump file should be on
the database server and have tried placing it on either with the same
error.

Is a mount point for the dumpfile required in this situation?
Can you see what we are doing wrong?

Card and error message is below.

Thanks in advance.
Gerry
da*******@yahoo.com
The following is the script along with the error message. At the very
bottom is the path from which it is being run:

LOAD CLIENT FROM "/siebel/Sieb_ftt/IN/SCETCOV2" OF ASC MODIFIED BY
ANYORDER IDEN
TITYMISSING DUMPFILE = /home/siebel/logs/dumpit.log NULLINDCHAR=Y
METHOD L (208
241, 314 319, 308 313, 320 329, 173 202, 1 4, 5 6, 8 10, 11 13, 7 7, 91
109, 110
128, 74 78, 79 81, 14 43, 45 73, 82 84, 85 87, 88 90, 129 142, 143
172, 1 13, 2
08 237, 240 241, 238 239, 206 207, 203 205, 275 275, 242 260, 261 267,
268 274,
276 307) NULL INDICATORS (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) MESSAGES
"/siebel/Sieb_ftt/log/loadmsg
s.err" REPLACE INTO SIEBEL.EIM_FN_DEFADM (VAL_VALUE, ROW_ID,
IF_ROW_BATCH_NUM, I
F_ROW_STAT, DEF_ATTRIB_01, DEF_ATTRIB_03, DEF_ATTRIB_04, DEF_ATTRIB_06,
DEF_ATTR
IB_07, DEF_ATTRIB_08, DEF_ATTRIB_12, DEF_ATTRIB_26, DEF_ATTRIB_34,
DEF_ATTRIB_35
, DEF_ATTRIB_36, DEF_ATTRIB_37, DEF_ATTRIB_38, DEF_ATTRIB_39,
DEF_ATTRIB_40, DEF
_ATTRIB_41, DEF_ATTRIB_42, DEF_DEF_ADMIN_NUM, X_VAL_ATTRIB_03,
X_VAL_ATTRIB_04,
X_VAL_ATTRIB_05, X_VAL_ATTRIB_06, X_VAL_ATTRIB_07, X_VAL_ATTRIB_08,
X_VAL_ATTRIB
_12, X_VAL_ATTRIB_14, X_VAL_ATTRIB_15, X_VAL_ATTRIB_16)FOR EXCEPTION
SIEBEL.EIM_
ERR_TAB NONRECOVERABLE INDEXING MODE AUTOSELECT
SQL3508N Error in accessing a file or path of type "DUMPFILE" during
load or
load query. Reason code: "1". Path: "/home/siebel/logs/dumpit.log".

[datapro01]

Got it!!

The load was being run by a non-instance owner id. We had been trying
to make sure that that ID had permissions on the dumpfile....it has to
be the instance owner.