Hi Max, Max Nitribitt wrote: > > I'm having some trouble uploading data with repmcli > and FASTLOAD. I'm trying to upload 75 GB of data into > one table. As the upload-command was executed > successfully on smaller datasets, I assume it has to > do with the size of the input. > It shouldn't. But it probably has. Do you know the count of rows to be loaded?. Is the data extracted from another SAP DB?
> I use Version 7.3.0.20 on Linux. > Replication server version: 7.3.1 > client Version: 7.3.0 > The instance has 3 DATADEVSPACES (50 GB each) > > / * > / E -25011: Error executing internal SQL statement > 'ENDLOAD "SCHERF"."GX_CONTIG"': 'SQL error -3019 = > Invalid exponent (error position: 1) > '. > / M Sum of inserted lines 0, sum of rejected lines > -1472247794 > > > When I understood the message-documentation correctly > this is something like a number format problem. I had > a look at the data and it seems ok. There are no > single values exceeding the limits of the column > definition. > I assume that your data is ok. The message above points to another problem. When issuing the sql-stmt 'ENDLOAD <tab name>' (which is an internal statement, as you can see at the error message) all data has already been loaded. This statement signals the kernel that RepMan has done the job and likes to end the transaction. Together with the ENDLOAD statement the RepMan delivers the count of rows. And thats surely the point: there seems to be an int overflow. > So did an internal calculation produce an invalid > number? How can i find out or prevent this from > happening? > You can't. We should have ;-)) > in the knldiag I get these warnings, shortly before > the upload aborted: > 2003-01-22 17:35:34 7478 WNG 53025 DATA PERM > USED 80%(3932033 PAGES LEFT) > 2003-01-22 17:35:35 7478 WNG 53025 DATA PAGES > USED 80%(3932160 PAGES LEFT) > Shouldn't have any relation to the problem. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
