Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
filegroup name is full
wiro
Member Posts: 92
Hi again all
I have a problem when i want to post a journal with a lot of records (1000), the message is :
could not allocate space for object company name in database name
because the filegroup name if full.
I don't understand because i can post a journal before.
What is the meaning of filegroup name?
Thanks in advanced.
I have a problem when i want to post a journal with a lot of records (1000), the message is :
could not allocate space for object company name in database name
because the filegroup name if full.
I don't understand because i can post a journal before.
What is the meaning of filegroup name?
Thanks in advanced.
0
Answers
If no increase the size of the db.
Also are you running by any chance the express version? It has a limit on sql 2000 to 2 gig and on 2005 4 gig.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Yes, i'm on sql and i have set the file for unrestricted.
I use sql 2000 and we have 12 company.
If i use 1 company, the posting is success.
Yes when you post 1 entry you are not filling the db. post 1 journal 1000 times and you'll get the error.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
My free space on harddrive is 4 Gb,
database file ndf is 1,7 Gb
log file is 1,2 Mb
mdf is : 273 Mb
When i use 1 company there is no problem, is it problem with so many companies?
A filegroup is full when
1. the disk on which its files live become full OR
2. The MAXSIZE of the files have been reached.
Go to Sql Enterprise Manager -> Databases -> properties and check/change the
maxsize of your data files.
Also in navision. click on files->database->info. what percentage is filled up?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
It works.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n