not enough storage is avaliable to complete this operation

  • Thread starter Thread starter BJ
  • Start date Start date
B

BJ

I get this error when transfering data from oracle database over web
service.
there is about 390 rows which is returned from web service like dataset and
it
works ok for about 200 rows. then I get this error.

Can anyone help??

thans!
 
Since we have no idea what kind of data you're transferring, and therefore
no idea on a row size, all we can do is guess. So I'm guessing that you
have enough memory available for 200 rows, but not for 390. The fix would
be to transfer less rows.
 
hm, but my transfer is ok....that means that i have all the records in one
dataset when starting to insert
that records in database on pocket pc.

so, i think that problem is not in transfer from oracle to dataset in pocket
pc....but in inserting these
records into sql server mobile database on pocket pc.
 
Ok, so you have enough to transfer it, but when you do the insert, it
creates a new row in the database and all indexes. These also take up
space, and at some point there's no more space for a requested insert so
it's failing.

Again, you didn't give much info (like where is the database file stored,
how big is a row item, what have you done to debug, etc.), so this is all
just a guess.
 
yes, that is what's happening when inserting into database on my pocket pc.
the question is: what i have to do to insert these records without failing?

i don't believe that it is not possible to insert 300 rows at once.

thanks!
 
The whole point is you get the error because you don't have enough room to
store the data you are trying to. I can't see how you don't believe it -
you're seeing the error, so it's obviously happening. Either you're out of
space on the media or our of storage space in RAM or something but you are
not giving us enough information to help you. We need to know how big a row
is, including index information. We need to know where the database is
stored (storage card, ram, etc). We need to know the type of device (WM 5.0
uses storage differently thatn PPS 03). We need to know what you've already
done to debug this.

Give us answers to all of those and then we can help you.
 
Back
Top