By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,262 Members | 1,125 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,262 IT Pros & Developers. It's quick & easy.

Need Help With a Load

P: n/a
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".

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.