Microsoft Dynamics 365 Blog

SQL Server 2017 and Dynamics NAV 

<1 min read

SQL Server 2017 was released in October last year with many new and interesting capabilities. For further information, please take a look at the product information at this location: https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017. Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud…Read more

0 Comments

Troubleshooting SQL Queries Generated by Dynamics NAV 

<1 min read

The documentation on Optimizing SQL Server Performance with Microsoft Dynamics NAV has been updated with information about: Troubleshooting long running SQL queries involving FlowFields by disabling SmartSQL. Using SQL Server 2016 Query Store to monitor query performance in Dynamics NAV.   Read more at https://msdn.microsoft.com/en-us/dynamics-nav/optimizing-sql-server-performance-with-microsoft-dynamics-nav   Please get back to us if you miss documentation around…Read more

0 Comments

Creating and managing custom indexes in Dynamics AX 

2 min read

Hello, An index is a database structure that is used to speed the retrieval of information from a table, or in some cases to ensure the uniqueness of records in a table. In Dynamics AX, each table comes out-of-the-box with a variety of indexes designed to provide the best results in most cases. As every Dynamics AX…Read more

0 Comments

How to delete orphaned data remained from deleted company? 

1 min read

In AX 2009 it may happen that you delete a company but data related to this company remain in the database. You can use a SQL script similar to the following to delete this data NOTE: Use with caution! We recommend you take appropriate actions to backup the database first before attempting to delete any data: /*This…Read more

0 Comments

Performance Improvement on “Multisite activation – Dimension inconsistency clean-up” Job 

3 min read

After enabling Multisite activation (Administration > Setup > System > Multisite Activation), you would typically run the “Multisite activation – dimension inconsistency clean up” job (Administration > Periodic > System > Multisite activation – dimension inconsistency clean up). However, I have found in some cases there can be a performance issue with this process. Here…Read more

0 Comments

We get lots of Event 110 Cannot edit a record in LastValue (SysLastValue) and Event 117 messages in the Event Viewer 

1 min read

You may sometimes get the following event log entries on the AOS server in pairs:   110 Object Server 01: Dialog issued for client-less session 1: Cannot edit a record in LastValue (SysLastValue). User ID: , AdminUserSetup. The SQL database has issued an error.   117 Object Server 01: The database reported (session 1 (-AOS-)):…Read more

0 Comments

Checking Database entries after restoring a Microsoft Dynamics 2009 SQL Database to another Domain or Environment 

6 min read

This BLOG post describes some common steps after restoring a Dynamics AX 2009 SQL Database to another environment under several different scenarios. SUMMARY Consider the following scenarios where you may need to restore a Dynamics AX database to a different environment When testing a Dynamics AX upgrade When bringing Dynamics AX 2009 data in house…Read more

0 Comments

Proxy settings can interfere Dynamics AX 2009 report deployment 

1 min read

I was recently involved in a situation were the Reporting Library deployment from Dynamics AX 2009 to SQL Server 2008 Reporting Services was not working correctly. More concrete, after the Reporting Libraries were extracted, compiled and the deployment to the SSRS started, soon the following error was displayed: Unable to connect to http://server/ReportServer/ReportService2005.asmx as specified…Read more

0 Comments

How to fix SQL error: “Too many parameters were provided in this RPC request” 

1 min read

Recently we were confronted with a case where we received the following SQL error: [Microsoft][SQL Native Client][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100. This error occurs if we are running into a SQL limitation…Read more

0 Comments

Kerberos authentication issues in a multi server environment affecting only the KPI web part 

3 min read

When you are setting up Dynamics AX 2009 Role Center and Enterprise Portal in a multi server environment where each component is running on Windows Server 2008 you may get confronted with an authentication issue. The base requirement for a multi server scenario to work is to use Kerberos authentication and configuring Service Principle Names…Read more

0 Comments