Hi Martin, [Martin Pawlack wrote] > Subject: Re: Replication Manager (repmcli) and DATE (datetimeformat) > > Hi, > > i am using Version: 7.3.0 of repmcli, it has problems with > empty Strings > (for example ""), so i changed every "" in " " in the data file and > appended NULL ' ' to the command file. But now repmcli > reports: Invalid > input for date or time column: > At this point the 4th number in the version makes the difference. This problem is corrected with 7.3.0.18 and in any case with the patch made available last Friday (January the 25th).
> I have attached the command file and the data file. > > --------------------------------------------------------------- > repmcli -u xxx,xxx -d xxx -b command1.dat > Opened connection to REPLICATION SERVER at node local host. > REPLICATION SERVER Log File: > '/var/opt/sapdb/indep_data/wrk/repserver.log' > > User vpressedb connected to database TNG1 on local host. > DATALOAD TABLE presse1 > id 1 > anrede 2 > datum_der_eingabe 6 [snipped column names] > INFILE '/var/tng/tmp-transfer/pressedatenbank/test.data' compressed > NULL ' ' > DATE EUR > Error during execution > -->-25301 > Invalid input for date or time column: > > Defined maximum number of errors (1) reached > The problem is your data itself. You try to load a double quote as date (the 6th position). It won't work. Here is an except of your data file: 1,"Herr","Herr Schmidt","^K","Sehr geehrter Herr Schmidt,"," ",... If you consult the log file repserver.log found in $INSTROOT\wrk you'll probably see the erroneous value. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
