Hi Steffen,

--- "Schildberg, Steffen" <[EMAIL PROTECTED]>
wrote:
> 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?


thank you for your help!
The number of rows is something slightly above 3 000
000 000 rows. The data was not extracted from another
database. 



> > 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.

Do you have an idea what I can do to get the data
uploaded?

regards 

Max


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to