Archive for the ‘Dynamics NAV’ Category.
January 6, 2010, 10:27
Did decide to write this blog since this simple problem did take a lot of time for me to find the solution for, in the hope that it will save you from the same time eater.
The problem I did run into was that when starting the RTC client it could not connect to the service, since I had moved the service. Since the service had moved I did say “no” to the questions if RTC should try to connect again. In the address field in the “server selection window” I did type the new address into address field. The “OK” button was now greyed out, so I could not connect to the server.
After spending some time to try to figure it out how to un grey the “OK” button I found by simple press TAB in the address field make RTC to connect to the service and retrieve the companies on the service. Now the “OK” button was not greyed out anymore.
December 3, 2009, 13:56
Problem:
When previewing a report you only getting a small window in upper left corner with only a text string with the name for the report and the rest blank. When I trying to close this window, you get an error message: “Errors exist. Do you want to discard changes?” (Y/N). Pressing Yes, hangs and close the RTC client.
Probably cause:
You have installed the RTC client outside the setup chainer or you have uninstalled Report Viewer 2008. It may also be that Report Viewer 2008 installation is broken.
Solution:
Run DVD\Prerequisite Components\Microsoft Report Viewer 2008\ ReportViewer2008.exe and select install or repair depending on if Report Viewer 2008 was already installed.
October 27, 2009, 13:40
Today I did run into a problem installing the “Cronus Sample Database”. In the error report view I found this error message
SQL Server option
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Continue reading ‘CREATE DATABASE failed when installing Cronus Sample Database’ »
October 14, 2009, 9:45
You do not have permission to run the ‘Microsoft Dynamics NAV Server’ system. Contact your system administrator to have your permissions changed
If you get this error when trying to start the RTC, it normally means it’s something wrong with the licenses.
Ensure that the license you are using have permission to run RTC and service tier (correct granule). Granule needed for RTC.
• 9,000 Role Centers
• 9,100 Dynamics NAV Server
Ensure also that the license is uploaded.
1. Start classic client
2. Open the database used by RTC
3. Click Tools->License information
4. Click upload and pick the license file to be uploaded to SQL server
Ensure also that the license is saved in the database.
1. Start classic client
2. Open the database used by RTC
3. Click File->Database->Alter
4. Click on integration tab
5. Put a check mark on “Save license in database”
October 8, 2009, 10:42
If you get “User ID and password are invalid.try again?” when starting RTC you need to first check that you can login to database in the classic client. Note that the database should be the same as the service tier (the service you are trying to connect with RTC) is connected to.
1. Start “classic client with SQL”
2. Click File->Database->Open
3. Pick the server the database exist one
4. Select authentication “Windows Authentication”
5. Pick the database
6. Press OK
If it works in the classic client make database login synchronization.
1. Start “classic client with SQL” and connect to the database as above
2. Click Tools->Security->Synchronize all logins
3. Answer yes to the question if you would like to synchronize
If it doesn’t to connect to the database start SQL server manager and verify that the windows user have permission to login and use the NAV database
September 23, 2009, 10:03
Today I found a really good and interesting blog about general troubleshooting of multi-machine scenarios in NAV 2009. Most of the blog is checking SPN settings, delegations settings and different problems with those.
Intro
The NAV 2009 documentation walkthroughs provide step-by-step instructions for installing NAV 2009 on 2 or 3 machines. However, we have found that some of the same configuration issues come up time after time after installation.
When on calls with partners and customers, it seemed to me that this information was spread out all over the place, so I wanted to organize it in a different way for troubleshooting purposes so that I would have most everything in one place. Hopefully this will be helpful to others as well.
The intention of this post is to provide a checklist of sorts for troubleshooting some of the areas where we frequently find errors or omissions in configuration after NAV 2009 has been installed.
Find the whale blog here: http://blogs.msdn.com/nav_developer/archive/2009/08/17/troubleshooting-multi-machine-installations-of-nav-2009.aspx
September 18, 2009, 8:58
Did find an interesting tool developed by Kine yesterday about managing multiple service in NAV 2009. So what can this tool do?
1. Start/Stop the NAV services
2. Create new instances of the services
3. Configure the services (change DB server, DB name, and enable/disable debugging on them)
4. Remove the services (excluding the default one)
5. Do it all on remote machine (remote registry access required)
Kine’s post about the tool: Here
Zip: NAV2009_NST_Management_1_0_0_debug.zip
Source code: http://github.com/kine/NAV_NST_Management
September 7, 2009, 11:14
Did install Dynamics NAV 2009 on windows 2008 64 bit. When trying to connect to the database in classic client I got this error.
The following SQL server error or errors occurred:
17750,“42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL C:\Program Files (x86)\Microsoft Dynamics NAV\60\Database\xp_ndo.dll, or one of the DLLs it references. Reason: 193(failed to retrieve text for this error. Reason: 15100).
SQL:
INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}
The reason for this error is that the installed xp_ndo.dll is 32 bit and not 64 bit. My solution was simple to replace xp_ndo.dll with the 64 bit version.
1. Stop SQL server
2. Copy \\vedfssrv01\DynamicsNAV2009\W1\DVD\Sql_esp\x64\ xp_ndo_x64.dll to C:\Program Files (x86)\Microsoft Dynamics NAV\60\Database
3. Rename existing xp_ndo.dll to xp_ndo_x32.dll
4. Rename xp_ndo_x64.dll to xp_ndo.dll
5. Start SQL server
August 31, 2009, 12:37
The reason that setup.exe doesn’t start can be many. But I will try to give you ha checklist that you can work through if you end up in this situation.
1. Ensure that the user account running setup.exe have administrator rights.
2. Try the DVD/download one another computer. If this work you have eliminated that it’s any wrong on the installation media.
3. Start the task manager and check if any setup.exe is running. Sometimes under very special circumstances the setup.exe crash and will prevent any other attempt to start it again by staying running. If you find any setup.exe process kill them. And try to run the setup.exe again.
4. Start the task manager and check if any msiexec.exe is running. This may happen when a windows update is running or that another installation process is running or have crashed. The best solution in this case is to restart the machine and check again and try to run the setup.exe again. In most cases the msiexec.exe process will be gone.
5. If msiexe.exe are still there it probably mean that windows installer are running something. You can on your own risk try to kill all of those processes. The risk you take here is that you may end up with something half installed from windows update or other source. So it’s recommended to run windows update after this to ensure its ok.