Hi S�bastien, [Koller S�bastien wrote]
> Subject: -25009 Failure in db communication (request): 1 = wrong > connectio n state > > I try to insert about 4 millions rows in a table using > dataload, but I get the following error: > > Error during execution > -->-25009 > Failure in db communication (request): 1 = wrong connection state > . > > Defined maximum number of errors (1) reached > [...] > / M START 20021202 00104126 > / * > DATALOAD TABLE proxy_0201 > NUMERO 1 > HEURE_NUM 2 > SITE_NUM 3 > CALENDRIER_NUM 4 > ADRESSE_IP_NUM 5 > DATE_LU 6 > BYTE_SEND 7 > BYTE_RECVD 8 > INFILE '/var/opt/sapdb/proxy_0201.dat' COMPRESSED > > / * > / E -25009: Failure in db communication (receive): 1 = > connection broken > . > / E -25009: Failure in db communication (request): 1 = > wrong connection state. > / E -25010: -25009 [snipped some error messages] > -------- > How can resolve this problem? > this error points to a problem with the database kernel. Pls have a look into the knldiag.err. Is there an error logged for the time you tried to insert? RepMan server is in the state receive when the kernel dies - this simply means RepMan server expects an answer packet for a mass insert packet sent to the db kernel. But rather than getting a packet back the kernel is unavailable. What log mode does your database have? You should keep in mind that during DATALOAD the database log is continued and might get rather full. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
