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

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 required in this situation?
Can you see what we are doing wrong?

Card and error message is below.

Thanks in advance.
Gerry

snowcrash7@sbcglobal.net

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".

I should clarify that with the error message we are receiving, I am asking if a mount point between aix boxes is needed for the dumpfile.

The load does run..we are just rying to identify some bad data in a few rows not being loaded.

Did you give the instance owner read/write permissions to "/home/siebel/logs"?

That was it.
See the load was being run by a developer using another id not the instance owner. We were trying to make sure that THAT ID had write permissions on the dumpfile.

You nailed it....has to be the instance owner's permission on the dump file.

Many thanks

Gerry