error while trying to expand the sql database in navision

sagarppadamati
sagarppadamati Member Posts: 13
edited 2010-04-19 in NAV/Navision Classic Client
Dear,

Can anybody tell me the reason for the error i am getting while trying to expand my sql database from navision.
Each time i click the Alter button it was showing the following error.
YOU CANNOT ENTER "2147483648 KB" IN INTEGER. THE CURSOR IS INFRONT OF THE INVALID CHARACTER.

I do thank in advance if anyone let me know the solution.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    When you click on alter NAV runs the following sql statement.
    select 	name,  fileid, filename,
	filegroup = filegroup_name(groupid),
	'size' = convert(nvarchar(15), convert (bigint, size) * 8) + N' KB',
	'maxsize' = (case maxsize when -1 then N'Unlimited'
			else
			convert(nvarchar(15), convert (bigint, maxsize) * 8) + N' KB' end),
	'growth' = (case status & 0x100000 when 0x100000 then
		convert(nvarchar(15), growth) + N'%'
		else
		convert(nvarchar(15), convert (bigint, growth) * 8) + N' KB' end),
	'usage' = (case status & 0x40 when 0x40 then 'log only' else 'data only' end)
	from sysfiles
	order by fileid

    run this query in SQL Server Management Studio (SMS) for your database and see which value is greater 2147483648 and fix that from SMS.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • shjel
    shjel Member Posts: 7
    Why do you have to expand the size of your SQL database?

    Normally this is done automatically.
  • FDickschat
    FDickschat Member Posts: 380
    For performance reasons you should not set the DB to autogrow. Just imagine that in a db of several 100GB the autogrow kicks in and wants to increase size by e.g. some GB. During that time no user can do anything.
    Frank Dickschat
    FD Consulting
  • kriki
    kriki Member, Moderator Posts: 9,121
    And also to avoid fragmentation of the DB-file. A heavily fragmented DB-file (and also log-file) can hinder performance a lot!
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • David_Singleton
    David_Singleton Member Posts: 5,479
    shjel wrote:
    Why do you have to expand the size of your SQL database?

    Normally this is done automatically.

    [-X [-X [-X [-X [-X [-X [-X [-X [-X [-X [-X [-X [-X

    Noooooooooooooooooo! Never do this Please. And especially never advise others to do this.
    David Singleton
  • kine
    kine Member Posts: 12,562
    sagarppadamati wrote:
    Dear,

    Can anybody tell me the reason for the error i am getting while trying to expand my sql database from navision.
    Each time i click the Alter button it was showing the following error.
    YOU CANNOT ENTER "2147483648 KB" IN INTEGER. THE CURSOR IS INFRONT OF THE INVALID CHARACTER.

    I do thank in advance if anyone let me know the solution.

    For me it looks like you are using NAV 4.00SP2 with SQL 2005/2008, am I right?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • jpelaho
    jpelaho Member Posts: 14
    kine wrote:
    sagarppadamati wrote:
    Dear,

    Can anybody tell me the reason for the error i am getting while trying to expand my sql database from navision.
    Each time i click the Alter button it was showing the following error.
    YOU CANNOT ENTER "2147483648 KB" IN INTEGER. THE CURSOR IS INFRONT OF THE INVALID CHARACTER.

    I do thank in advance if anyone let me know the solution.

    For me it looks like you are using NAV 4.00SP2 with SQL 2005/2008, am I right?

    Hello,

    I have the same problem when I want to set the lock timeout.

    Can I simply update the locktimeoutperiod column of the "$ndo$dbproperty" table in the database ?

    Thanks to all.
    Jp.

Categories