The thing about the .NET Business Connector and the number of online users - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs

The thing about the .NET Business Connector and the number of online users - Microsoft Dynamics AX Technical Support Blog - Site Home - MSDN Blogs:

'via Blog this'

Dynamics AX 2009 + SSRS Lessons Learned

Following are the lessons i have learned when configuring SSRS for AX 2009,

1- Always use IP address for connecting to SSRS
2- Add both the business connector user and the client connecting user as AX users, for instance if your bc user is proxy and the client connecting is newclient both the ID's should be in AX.
3- Make sure the business connector is configured properly.
4 -Make sure that SSRS URL is under trusted sites.

app.config editor

Question:


Is there any application around which I can use to update app.config files associated with .Net applications.


Answer:


The best application I have found is hosted on code project, http://www.codeproject.com/KB/files/AppConigEditor.aspx

Dynamics AX 2009 Known Issues

Question  :


Is there a place to review all the knows Dynamics AX 2009 Issues ?


Answer:


Yes, kindly review the following link.
http://dynamicspost.blogspot.com/2011/04/ax-2009-known-issues-solutions.html

RPC 5 Exception

Question :
I am running SSRS 2008 R2 with Dynamics ax under network services user. Issue is sometimes the reports show up and sometimes they do not. I notice that i have few error with RPC 5 exception in my event log.

Answer :
This is a know issue. To fix this for SSRS 2008 remove the execution account from SSRS configuration manager and run the SSRS service under BC Proxy account. 

Dynamics AX SSRS The request failed with HTTP status 401

Question : 
I am receiving a 401 error when connecting to AX Reports hosted on SSRS 2008 R2.


Answer :

The solution that worked for me was to open rsreportserver.config file placed in the reporting services instalaltion directory, finding authentication group and commenting WindowsNegotiate tag as shown below.

 

   

   

 

  true

Dynamics AX Log On Failed on Reporting Services

Query:

I am getting a logon failure when running reporting services for dynamics.

Answer:

Make sure the business connector credentials are correct.

Seconds to actual time in C#

I always used to have issues when debugging time related issues in AX. Time is saved in seconds so many time when you want to know the actual time associated with it in hh : mm :  ss, you will either have to do it in mind or use a calculator. In order to simplify debugging I have created a small C# based console application that takes seconds as input and returns the time in actual format.

The code is below and you can compile it in visual studio to make it work.

Enjoy!

Download the application from here.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;


namespace Decimal2Hours
{
    class Program
    {
        static void Main(string[] args)
        {
            while (true)
            {
                Console.WriteLine(Program.ConvertSecondsToHoursMinutes(Console.ReadLine()));
            }
        }


        public static string ConvertDecimalToHours(string paramHours)
        {
            int realPart;
            int decimalPart;
            decimal hours;
            string hoursStr;
            string minStr;
            int decimalLocation;
            string finalMinutes;
            decimal _hours = decimal.Parse(paramHours);
            ;
            try
            {
                hours = _hours;
                hoursStr = hours.ToString();
                decimalLocation = hoursStr.IndexOf(".");
                hoursStr = hoursStr.Substring(0, decimalLocation);
                hoursStr = hoursStr.Trim(new char[] { '.' });
                minStr = hours.ToString();
                minStr = minStr.Substring(decimalLocation);
                minStr = minStr.Trim(new char[] { '.' });
                realPart = Convert.ToInt32(hoursStr);
                decimalPart = Convert.ToInt32(Math.Floor((decimal)Convert.ToDecimal("0." + minStr) * 60));
                finalMinutes = (realPart.ToString().Length == 1 ? "0" + realPart.ToString() : realPart.ToString())
                                + ":" +
                                (decimalPart.ToString().Length == 1 ? "0" + decimalPart.ToString() : decimalPart.ToString());
                return finalMinutes;
            }
            catch
            {
                return paramHours;
            }
        }


        public static string ConvertSecondsToHoursMinutes(string paramSeconds)
        {
            string finalTime;
            int seconds = Convert.ToInt32(paramSeconds);
            int result;
            int hours = Math.DivRem(seconds, 60 * 60, out result);
            seconds = result;
            int minutes = Math.DivRem(seconds, 60, out result);
            seconds = result;


            finalTime = hours.ToString() + " : " + minutes.ToString() + " : " + seconds.ToString();


            return finalTime;
        }
    }
}

How can I add sql server account from command prompt?

Query :
How can I add sql server account from command prompt?

Answer :

http://blogs.ameriteach.com/chris-randall/2009/12/11/sql-server-2008-forgot-to-add-an-administrator-account.html

Dynamics AX Excel Sheet Import, In Correct Time Values

Query
Whenever I import an excel sheet containing a timing point, it is converted to 1 second less than the actual value. 


Answer
This is a known issue and you can look at http://support.microsoft.com/kb/969186 for the resolution and workaround.