-
SQL Variant
Hi, I thinking of using this to solve the sorting problem inherent in SQL (10 sorts before 2). Are there any drawbacks to doing this? I haven't been able to find any in depth pluses or minuses on this subject in the forum. I'm planning on changing the "Sales Header"."Document No." and Job."No." fields to SQL Type =…
-
Database open: Server Name
My question is: In the Database open Dialog, what exactly is the "Server Name" and could I use an alias instead of the real server name? Let me explain the question: (NAV 2009 SP1 Classic (30212), SQL Server 2005 Enterprise x64, no named instances, only 1 Sql server installed on the box) A client of mine would like to take…
-
Integration to AD login broke when we recovered the AD
We have had a server crash with our domain controller, so we had to restore the server and recover the AD from tape backup. Now we even have a backup domain controller ;-) Everything seems to work ok, except for our SQL servers. They somehow seem to have “lost” the trusted connection to the AD. We can still login to our…
-
Windows Authentication Login Issue
Hi, One of my Customer Upgraded their database from 3.7 to 5 SP1. The database is in SQL. After their upgrade when they create new users, the user is getting "The Combination of user ID and password entered is invalid" error when he tried to login to navision using Windows authentication. They are using Windows Group. I…
-
Synchronize Logins Delete's Users from Database
Dynamics NAV 2009 I have created a new database on a new server. I restored a ful FBK from the original server. I deleted all the users from the database. I re-configure users logins to the new database. I can only login as sa and when I synchronize all logins my users are dropped from the database. Any ideas.
-
Export file to External SQL Database (BLOB)
Hello, I need to store scanned purchase invoices into an external SQL database. How can I do this. Once stored in this external database I also need to read this Blob file from Navision. Thanks in advance. Klaas
-
Upgrade to SQL 2008 The user id and password are Invalid
Hi all I've installed Nav 2009 and SQL Server 2008 as an upgrade from Nav 5sp1 and SQL 2000. Backed up the current SQL 2000 database and restored to the new SQL 2008. Tried to open the new database in Nav 2009 to convert it but I get the following message <b>The user id and password are Invalid </b> I've tried the these…
-
Invalid Cursor State
Has anyone seen this error before : The following ODBC error occrued: Error: [Microsoft][ODBC SQL Server Driver]Invalid Cursor State State ID:24000 This error occured when trying to import objects on NAV 4.03 Update 6 running on SQL2K5 Thank you
-
3 NAV SQL report advices
Dear collegs, I face with 3 NAV SQL report issues for which am not sura that know good solution. Hope that somebody can help me with that. My Questions are : 1. Open (outstanding) amount report for ceartin date (report which will show Open Entries which was at ceartin date). Namely, is neccesery to make one report which…
-
SQL2008 Case sensitive password in a Case Insensitive DB
Hi! past week I completed the upgrade to Navision 2009 with SQL 2008. Since that, wa are having trubbles with passwords: Users never take attention on uppercase lock and now they have to write passwords with case sensitive. Now we are using a CI-AI database (Master and NAV). So I do not undestand why is it happend. I need…
-
Data Cleaning & Matchin
Hi experts; I need an advice for a specific issue. I have a table with 65000 records. There are duplicate records in this table. These duplicate records depends on various fields. For example; If name, surname and email info of a customer is the same; If name, surname and mobile info of a customer is the same; If name,…
-
SQL Error 15401
Good morning, We installed NAV 2009 SP1 (Classic Client and RTC) on a SQL 2008 Server. I was able to create a partner database login via SQL and 2 Windows Logins (1 Partner (Admin) and 1 User). Both Windows logins were able to access the NAV database via the Classic Client and RTC. The problem arose when we tried to create…
-
How to enable Import/Export Fob and Txt
Dear all, If I restore a BAK on my local SQL Server, I still have the same limited rights for this database. Even though I am DBOwner (on SQL) and Super user (in NAV) I still do not have the right to Import or Export objects in either FOB or TXT format. How can I change the rights that I have on the local database?…
-
SQL Server 2008 R2 with NAV 2009 SP1
Anyone tried the combination yet? Any known problems?
-
SQL restore problem
We are trying to to migrate from native 5.0 SP1 to SQL Server 2008. We took a backup of the live database and did the following 1) Restored the FBK as FDB on a test environment 2) Ran a full database test 3) Used migrate.fob from Upgrade toolkit and made all necessary corrections to make the DB SQL Ready 4) Took a fresh…
-
Nav 2009 Sql 2005 Performance is very Low for huge Data
Hi to all, We upgrade the Nav4.0 Sp1to 2009 sp1 the problem the SQL db size is 40gb if i open Navision any item form or any table which having data its taking much time. For ex in ledger Entry Dimension we having 61lakhs records it is very Very slow.At the same time before upgradation 4.0 is fine. Can u help me how to…
-
Cliconfig SQL Alias
Hi all, I'm getting trouble with the use of SQL Server Alias set up through cliconfig. The problem is particular to the use of jetreport drilldown capabilities. When used, the Navision client says it cannot connect to server because the server address is not corrresponding. Does anyone got this problem in the past and was…
-
NAV Report Sql Query Question
Dear Collegs, I am currently bussy with Navision reports making with one BI tool. In that process I faced with one issue for which do not know exact solution. Namely, my problem is that customer want report in which will be presented Outstanding Amounts of their customers ordered by Due Date. Theoreticly it means that they…
-
SQL ligin aproach.
](*,) ](*,) ](*,) ](*,) ](*,) ](*,) Hello, I have a problem with SQL/NAV integration. I do not know how to configure SQL Server to the rights granted through NAV only. Currently I have configured the SQL database users with DBO ownership over the database. Such a scenario I do not like, as the user navigates through the…
-
Navision sql table structure and Future Dynamics Product
Hello From what I understand is that in Native db the company is part of the table and all the companies are in the same table. On sql every company has a separate table. So My question is why did Navision chose this solution, instead of keeping Company Name part of PK of the table? Also how does other erp system handle…
-
Price List Query
I have a problem creating a report of a dynamic price list true SSRS. I need the "Item" and "Sales price" tables. From the "item" table I want to get the "unit price" for each record. From the "sales price" table I need all the available prices for each item. This should be my result set:ITEM UPrice Sales Code PriceAAA 1…
-
Can not use KILL to kill your own process
Hello, My customer had requested a customization which will auto log off a Navision Idle session if number of user sessions is exceeded from the license allowed. This customization is done on NAV2009 sql server option. I had tried on using a SQL automation ('Microsoft SQLDMO Object Library'.SQLServer) to kill the process…
-
NAV on SQL - why 2 database files?
Hi all When creating a NAV database on SQL the deafult is 2 database files and 1 log file. But what is the explanation for 2 database files and not 1? Can you have a normal setup with only 1 file or? AJ
-
Weird behaviour during security synchronization
Hi all! A client of ours has a very weird problem with one (!) SQL login during security synchronization. They use Dynamics NAV 6.0 SP1 (Classic only) on SQL Server 2008 with a mirrored database. The synchronization process only fails with "Error 15023: User already exists in current database." if a special username is…
-
Connecting to master db??
We are running Navision 3.7 on SQL Server 2000. Today we experienced major blocking problems stemming from two users that somehow got logged onto the master database instead of the normal company production database. Ordinarily the only users who get logged on to master are myself (Navision admin) and the SQL Admin…
-
Dynamic SQL
Hi All, I wrote a store procedure with some parameters, based on that it fetch some data from database tables then generate a SQL Statment, and i am executing this statment through EXECUTE IMMEDIATE. The problem is that in database table I have one parameter with the name P_DIV. i want to fetch the value of p_div in my…
-
Problem with user security/access
Hi On a DK 4.00 SP3 (runtime 5.0 SP1) database running on SQL2005, we have a very strange problem. It seems that we are not able to control the behaviour of some users (how many is yet to be determined), meaning that even if we delete them as users in Navision (Windows-logon) they can still open the database and company.…
-
Navision Sales Order amount in Local currency in SQL
Dear Collegs, I have one question and hope that somebody maybe can help me. Namely, I have problem to find tabel and column in which can see Amount of Sales Order in Local currency (Sales Lcy). Does somebody maybe know where this data can be in Navision database. Thanks in advance. Regards, Marko
-
SQL users loose permission in navision when synchronise is d
Hi there, I have a small question to ask about a behaviour we recently encountered with a customer. At our customer there is a navision Db with all its users. They do have one user which isn't set in navision, but does have to be able to run reports for this database. Everytime a full synchronise is done, it seems SQL…
-
NAV2009sp1 database collation problem
Hi, I have a problem. I want the NAV2009 client to create a blank NAV database with a collation of Latin1_General_CI_AS. This is because we have many interfaces with external databases and all other databases have this collation. The NAV2009 SP1 client creates a blank database with collation of Latin1_General_100_CI_AS…