2006 Dec 07 9:37 PM
Hello Experts,
I have a file which contains data which needs to be uploaded to a table.The file extension is .csv and file size is 99Mb.
The problem I am facing is that when I try to upload the file in foreground it gives me a 'malloc' error and when I try putting it on the application server using SXDA,this too results in a dump.
Is there any special techniques we need to use to upload heavy files.Please give me pointers in this direction.
Thank you.
Gaurav.
Hello Experts,
I have a file which contains data which needs to be uploaded to a table.The file extension is .csv and file size is 99Mb.
The problem I am facing is that when I try to upload the file in foreground it gives me a 'malloc' error and when I try putting it on the application server using SXDA,this too results in a dump.
Is there any special techniques we need to use to upload heavy files.Please give me pointers in this direction.
Thank you.
Gaurav.
2006 Dec 07 9:46 PM
try to do a parital load. In the sense try to upload the first half of the file and once it is done then load the second half of the file. In SXDA you have the option to give the from and to row numbers to load.
- Guru
2006 Dec 07 9:51 PM
Hello Guru,
Thank you for the reply.
The problem is that this is a scenario which has headers in a file and items in another,so I cannot go for the partial load option.
Regards,
Gaurav.
2006 Dec 07 10:01 PM
Then you may have to contact your Basis guys and ask them to allocate more memory space temporarly so that it will allow you to upload this file. Once you are done with the data load they can pull back the additional memory they have provided.
- Guru
2006 Dec 07 10:08 PM
Hi Guru,
Thanks I think that this wud be the only solution.
Regards,
Gaurav.
2006 Dec 07 10:08 PM
Have your basis people FTP it to the application server.
Rob