Item List Copy error
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..
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
0
Comments
-
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 once0 -
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 PATEL0 -
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 etc0 -
Thanks for the reply,JAYESH PATEL0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions