January 30, 2011 in Blog by Amer

Riyadh Online Community Summit February 2011

As part of Microsoft technical community contributions in Saudi Arabia, we are conducting a two days online event in February 10th and 11th.

Dynamics AX Brains will conduct a Dynamics AX session by the end of that event called: “The What, Why and How Answers of Dynamics AX” which will give an overview about the Dynamics AX 2009 from functional and technical perspectives.

There are going to be other topics to be covered like Windows Azure, Silverlight, SharePoint 2010, XNA, Windows Phone 7, Dynamics CRM 2011, and SSIS.

Wish you can attend! Remember that the Dynamics AX session will be on the 11th at 03:00 PM Riyadh time.

January 7, 2011 in Blog by Amer

Upcoming Microsoft Dynamics AX Webcasts from Microsoft

The great Microsoft Dynamics team is conducting some sessions in the coming period. Those online sessions will cover topics in all Dynamics products including Microsoft Dynamics AX.

The first coming event will be “Management Reporter and Performance Management with Microsoft Dynamics AX“ that will be held in the 12th of Jan. The next session will be “See the New Payroll for Microsoft Dynamics AX“, and I’m really excited to attend this session to see the new Payroll. The Payroll session will be in the 1st of Feb.

To see full list of those webcasts and to register, click here.

January 1, 2011 in Blog by Amer

BI project generate options form error: Cannot execute the required database operation. The SQL database has issued an error.

Happy new year

I got a SQL error today when I tried to open the “BI project generation options” form in Dynamics AX. The error was like the following:

When walked through the code, I discovered that it tries to delete some entries from a table called: “UDM Roles (BIUdmRoles) throw a SQL statement but unfortunately that SQL statement is mistyped!

To correct the issue, go to AOT –> Classes –> SRSStatement –> deleteInvalidBIUdmRoles method and write the code between my comments as below:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

//Amer Atiyah, http://blog.amerax.net/
public static void deleteInvalidBIUdmRoles()
{
    BIUdmRoles udmRoles;
    UserGroupInfo userGroupInfo;
    str list = #emptyString;
 
    Connection connection;
    Statement statement;
    SqlStatementExecutePermission permission;
 
    str sqlStatement = @"DELETE FROM %1BIUDMROLES WHERE USERGROUPID IN (%2)";
    ;
 
    while select udmRoles
    {
        select userGroupInfo where userGroupInfo.Id == udmRoles.UserGroupId;
        if (!userGroupInfo)
        {
            if (strlen(list) > 0)
            {
                list += #comma;
            }
            /*Comments Begin*/
            //list += udmRoles.UserGroupId;
            list += "'" + udmRoles.UserGroupId + "'";
            /*Comments End*/
        }
    }