Hi Danny,
Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote:
>
> While executing a DATALOAD, repmcli 'got stuck' .
> So I had to kill the prozess.
>
Any idea why it 'got stuck'? DB full?
> That is the loader.prt-Content, you see the drop-out in the end.
>
> // M Starting protocol at 2003022100114506
> // *
> // *
> // *
> // M START 20030221 00114506
> // *
> set logowner sapdb
> // *
> // M START 20030221 00114506
> // *
> set
> // *
> // M START 20030221 00114506
> // *
> USE USER "DBADMIN" * SERVERDB "WORKDB"
> // *
> // M USER: 'DBADMIN' on DB: 'WORKDB'
> // *
> // M START 20030221 00114506
> // *
> DATALOAD table toti011
> user_id 1
> function_id 2
> mod_stamp 3
> mod_flag 4
> mod_user 5
> INFILE '/home/sapdb/db_script/sapdb_toti011.bcp'
> SEPARATOR '|'
> DELIMITER ''
> // *
>
> Now I want to execute the same DATALOAD again, but now the
> error comes :
>
> -->-25010
> SQL error 250 = Duplicate secondary key:XPKTOTI011 (error position: 1)
>
Please have a look at the loader.prt. There is logged at which line/row
the error occurred. I'm pretty sure it's the second row.
The problem is that the Loader was able to load some rows before it was
killed. Restarting with the very first row does not work.
So, you need to check at the db how many rows are in the table, and
supposing it was empty before starting the DATALOAD you could
set up the DATALOAD to continue loading at the row following the last
successfully inserted row with the following syntax:
DATALOAD table toti011
user_id 1
function_id 2
mod_stamp 3
mod_flag 4
mod_user 5
INFILE '/home/sapdb/db_script/sapdb_toti011.bcp'
SEPARATOR '|'
DELIMITER ''
START <row number following the last that were successfully loaded>
Ok, here is a more handy example:
DATALOAD TABLE <tabname>
COL1 1
INFILE '<file name>'
is killed when 1000 rows were successfully inserted. To continue the
load the following command would be issued:
DATALOAD TABLE <tabname>
COL1 1
INFILE '<file name>'
START 1001
Regards,
Steffen
--
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
