-
To change the size of Object Cache in Nav SP1
When I go to Tools->options->object cache and change the size of the object cache it does not get reflected after getting refreshed. Can somebody help me in this. :? (I have recently joined MBS Nav) Gaurav
-
Import from an sql database
Hi folks, Does anyone knows how to import data from an sql database to navision? Kind regards
-
Log Shiping Problems
Hi, I am trying to set up a stable log shipped standby database - but with no luck My database is big (approx 300GB) so it;s not a qick and easy for me to try stuff. I've the standby server set up fine and log shipping works for a while - but then after a few days I always get a log that the standby database will not…
-
Know database and server
Hi, when I run Navision against SqlServer, can I Know what's the server name, database name, etc in C/AL code?? Thanks Asier
-
Using consoles apps from SQL to NAV
I have a slight problem that is totally doing my head in and makes no sense to me, and hopefully one of you might know at least why it is doing this. I have written a small application in C# that is invoked from SQL Server 2000 using EXEC master..xp_cmdshell in a trigger. The console application should send an MSMQ to a…
-
SOLUTION: Corrupted SIFT tables with 4.0 SP3
Dear all, as we all know there was an issue where renaming a record would corrupt the SIFT tables which was solved with SP3. But still with 4.0 SP3 it is possible to get corrupted SIFT tables and this is due to the use of scripts which delete the 0 amount SIFT records or actually by just using Navisions own optimise…
-
SQL Permission problem.
Hi all, I need an advice about creating a login for Navision use on SQL 2005. I think Navision requires the login to be a member of securityadmin server role (otherwise it's impossible for a user mapped to the login to change its password within Navision). But securityadmin is a over-privileged role for only a Navision…
-
BCD Conversion
Hi there I'm trying to do some integration between 3.70 Native DB and some .Net application running on SQL Server. I've built a DTS package that works fine to pick data back and forth. 8) But I have some problems with BCD data, for example Currency Factor in Currency table. Is there an easy way to convert that BCD value…
-
Write to view
Hi folks, i've a nav 4.0 db on sql server 2005 with standard security model. I've on the same server a second database. In the Nav db i've created a view that selects data from one table in the second db. I want to write to that view from Nav. I'm only able to do this by granting the user sysadmin rights. No other rights…
-
Partial Index for sql 2008 and Navision
Hello I was reading about Partial Index on wiki and there is also an attached pdf that talks about it in detail. http://en.wikipedia.org/wiki/Partial_index PostgreSQL supports this feature. A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate of…
-
Transaction log shipping not working, insufficient rights?
Hi all! I'm trying all day to get transaction log shipping (SQL Server 2005) to work, but without success so far. I hope you can help me! Here's the situation: I have an SQL Server 2005 in Domain A. I want to ship the transaction logs of a Nav 4.03 database to a SQL Server in Domain B. There is no trust between the…
-
Help! NAV 3.7 login issue with SQL 2005
We still use nav3.7 and several days ago, we migrated the db from SQL 2000 to SQL 2005 and keep the compatibility to 80. We can logon with admin accounts, however, when a end user tried to logon, it prompted "the user doesn't have permission to perform the action". Does anyone here know how to fix this? Thanks a lot.
-
Sorting Issues after conversion to SQL2005 NAV4.03
The crimescene: Our customer have a NAV 4.00 on a native database with integrated Celena Payment Management, Customers Own developed webshop etc. The job was to migrate the NAV 4.00 / native into a NAV 4.03 on a MS SQL 2005 databaseserver. The 95% solution: It was a easy job: with migrate.fob we cleaned up the native…
-
Recover C/AL code
Hi, I see that in my SqlServer Database, I've got "Object" table. Some questions: - Does it contain my C/AL code? - Can i see/recover it in SqlServer directly? Thanks Asier
-
server access
Hi I have installed sql server 2005 and created database through Navision 4.03 and restored backup.The database can be accessed locally but when we try to access it from other computers in network an error msg pops out "cannot find the server" can anyone tell me what is the problem ? thanks in advance
-
Nav 5 - SQL Server Express - Database login fails
I am trying to set up a Nav 5 demo on a laptop with Win XP Prof 2002 SP2 using SQL Server Express [I need to ultimately start doing some SQL Reporting Services stuff as well] It opens Nav 5 fine assuming my laptop ID but I cannot set up a Windows login since there is no Active Dir. When I set up a database login user with…
-
Navision - Native to SQL restore objects missing
Hi. I've just done a restore from native to SQl 2005. It completed successfully, however there are only tables. There are no forms, codeuints, reports etc... Anyone got any ideas???
-
Upgrade from 3.60(SQL option) to 4.0SP2 (SQL option)
Hi all I am planning on an upgrade from 3.60(SQL Server option) to 4.0SP2(SQL Server Option). Can we do the upgrade by converting the 3.60 database to ".fdb" ,start the upgrade onto 4.0SP2 and then restore the same into SQL Server option database(.mdf) ? What might be the difference if there are any? Thx in advance.
-
Opening a 3.60 Database with SQL Server option
I've been trying to open an 3.60 SQL Server Database with windows login.An error message pops up saying "The combination of user id and password is invalid.Try again". I've been through the previous topics and checked my SQL Server too regarding the xp_ndo.dll,xp_ndo_enumusersids,xp_ndo_enumusergroups. what might be the…
-
Database Conversion from 3.60 to 4.0SP2 SQL Server option
Can anybody give me an estimate how much time does it take to "convert" a database from 3.60 to 4.0 SP2 using SQL Server Option. Database consists of 50GB. The Process is running on a 2 GB Ram machine. Thx in advance.
-
Table import and creation problem on MSSQL2005
Hello, Recently, we have migrated Navision SQL Server database to a new server. Server has MSSQL Server 2005 installed, while on "old" server MSSQL Server 2003 was used. Since that moment, we have problem with importing and creating TABLE objects in that database. The following error occurs: 4628, "01000", [Microsoft][ODBC…
-
Restore error on sql server
Hi While restoring a fbk (backed up from a Navision 3.7) on sql server 2005 I get the ffw error: "The Gen. Journal Line table contains a value in a Code field that cannot be used with Microsoft Business Solutions-Navision: Field External Document No., Value I-104.427.250ã." Please note: This behavior is reproducable and…
-
SQL Server CE edition integration with Navision
hi, 1.There is data in a table 'stock' on SQL Server CE Edition installed on a hand-held device connected to the PC through Active Sync,Can Navision integrate it with SQL Server 2000 installed on the PC? 2.What customization in Navision is required for RFID to be avilable at the Point of Sales Thanks gd
-
SQL 2005 and Auto Increment
I have just come across a very ineresting "feature". When using the Auto Increment property on a Interger field in a table, and running on a SQL 2005 installation, a user without sys-admin rights gets a very vicious SQL error stating that the user doesn't have permission (even if it was setup and synched with SQL) or the…
-
How does Navision's restore work internally on SQL?
We all know how Navision’s restore works from its dialog window. That means restoring TableData of each selected company, common data and objects (last 2 if selected and if DB is new) and at the end secondary keys (and sum-index tables). But I want to know more in detail? Especially I am interested in estimating the…
-
SQL Stored Procedures
Hi I am executing the stored procedures from Navision through ADO. If the stored procedure returns some boolean value or some other value then How to get the return value of the stored procedure from Navision. Regards Ajay
-
Arithmetic overflow error
I'm recieveing a 8115,"22003"[Microsoft][ODBC Sql Server Driver][SQL Server]Arithmetic overflow error converting expression to data type numeric when I are trying to Calculate a calcfields that are based on following: Sum("Sales Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Order),Posting…
-
Crystal Report
How to call crystal report in navision 4.0?
-
Restoring Database
How to restore native database in sql server?
-
Restroing SQL BAckup through Enterprise Manager
Hi I have to restore the SQL backup (taken using SQL enterprise manager). Am restoring using the SQL enterprise Manager Utility Only. My SQL backup consistes of 2 backup files 1) the backup of the data files 2) backup of the Log file(in 2 seperate folders). So while I restore is it necessary to restore both files or only…