From: Date: February 21 2003 11:58am
Subject: new DATALOAD after killing Prozess repmcli
List-Archive: http://lists.mysql.com/maxdb/12611
Message-Id: <27784.1045825090@www32.gmx.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Hi all

While executing a DATALOAD, repmcli 'got stuck' .
So I had to kill the prozess.
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)

Defined maximum number of errors (1) reached

And now there is no new entry in loader.prt !

So, what I have to do now, to being able to make that DATALOAD ?

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!