Item List Copy error

JAYESH
JAYESH Member Posts: 290
HI,

I have 2 database with the same records.

I run Item table and select all item in the table and try to copy all item list.

In 1 database it is working, it allow me to copy the Item list from Item table.

On the same PC, in 2 nd database it's showing me error.


ERROR-

There is not enough memory to execute this function. IF you work in a single user installation you can try reducing the value of the "cache" program property,
you can find information about how to optimize operating system in the documentation for your operating system

============

I dont know i work on same PC why it's showing me this error ??

Can any one help me solve this.

Thank you..
JAYESH PATEL

Comments

  • Savatage
    Savatage Member Posts: 7,142
    edited 2007-05-31
    your pc does not have enuf mem to copy all that item data from one table to another (note table to table) not item list form to table or anything like that.

    When you select all that item data it's stored in your pc's mem. this is not a navision error.

    Another way is to use a dataport - export the item data from one database into a file and create a dataport on the 2nd database & import the file.

    note there are alot of tools in the download section that can be used to export table data

    another option is try to copy the item data in smaller chunks instead of all at once
  • JAYESH
    JAYESH Member Posts: 290
    Thanks for the reply

    But i have another same database with the same record and it's work in the same PC ...

    If it's PC doen't have enough memory then in both database i got error but it's not like that. i got error in only one database.

    Thank you..
    JAYESH PATEL
  • Savatage
    Savatage Member Posts: 7,142
    export the data you want into a file & import it using a dataport.

    1-2-3 done.

    It's the really the only answer I can have since we don't know your PC and/or server specs, how you have your database setup, all the settings you chose, etc etc
  • JAYESH
    JAYESH Member Posts: 290
    Thanks for the reply,
    JAYESH PATEL