Tuesday 23 July 2013

Unable to log on to Microsoft Dynamics AX

Error: Unable to log on to Microsoft Dynamics AX.
It can happen that even though AOS and SQL Server seem to be running fine and with no errors in the EventLogs, you get an "Unable to log on to Microsoft Dynamics AX" error message when opening the AX client. This is a problem with stored passwords in the client machine.

Solution

Please navigate to "Control Panel-->User Accounts-->Manage Password" ,select the particular user and change to 'Advanced' tab and click 'Manage Passwords' and change the existing password (or) Remove the Password.

Tuesday 16 July 2013

Job for SSRS Report

Job for SSRS Report:

static void debugreport(Args _args)
    {
   
         AlkhaldiPOTransRptDP empl;
        AlkhaldiPOTransRptContract con;
        Query q;
        AlkhaldiPOTransTmp      AlkhaldiPOTransTmp;
        ;
         empl = new AlkhaldiPOTransRptDP();
        con = new AlkhaldiPOTransRptContract();
        q = new Query(querystr(AlkhaldiPOTransQry));
        empl.parmQuery(q);
        empl.parmDataContract(con);
         empl.processReport();
        AlkhaldiPOTransTmp = empl.getLedgerJournalTmp();

    }


Job for SSRS Report:

 static void DpDebug(Args _args)
{
    SaleInvTmp      SaleInvTmp;
    SalesInvDp    SalesInvDp;
    SaleInvContract SaleInvContract;
    SalesInvDp   dataprovider = new SalesInvDp();
   // SaleInvContract = new SaleInvContract();
    dataprovider.processReport();
    SaleInvTmp = dataprovider.getSaleInvTmp();
}



Job for SSRS Report:

static void Debugging(Args _args)
{
 
    SalesConfirmDp  dataprovider = new SalesConfirmDp();
    recId ret;
 
    SalesConfirmContract    contract    = new SalesConfirmContract();
    SalesConfirmDetailsTmp  SalesConfirmDetailsTmp;
    salesConfirmHeaderTmp  salesConfirmHeaderTmp;
    ;

    ret = 5637145081;
    contract.parmDocumentTitle(“confirmation copy”);
    contract.parmFormLetterRecordId(0);
 
    dataprovider.parmDataContract(contract);
    dataprovider.processReport();
    SalesConfirmDetailsTmp = dataprovider.getSalesConfirmDetailsTmp();
    SalesConfirmHeaderTmp = dataprovider.getSalesConfirmHeaderTmp();
}

Monday 15 July 2013

Step by Step Guide How to Install Dynamics AX2012 Enterprise Portal

Step by Step Guide How to Install Dynamics AX2012 Enterprise Portal

How to Install Dynamics AX2012 Enterprise Portal

This is the second post in the series of installing Dynamics AX2012 Components. You can refer to the first post here - (Installing the base Dynamics AX Components - Databases, AOS, Client, Debugger, Office Addins)

http://daxdilip.blogspot.com/2011/08/step-by-step-guide-how-to-install.html

This post will talk about installing Dynamics AX2012 Enterprise Portal.
The basic pre-requisite for Installing Enterprise Portal is Sharepoint 2010 Foundation/Sharepoint 2010 Server

Since this is sandpit/training box, I would be just installing Sharepoint Foundation 2010.

i. Install the Sharepoint 2010 Pre-Requisites shown below













ii. Pre-Requisites Installed Successfully

iii. Now, start with the Foundation Installation

iv. Run the Sharepoint Configuration Wizard
v. After all the tasks are completed successfully, you are welcomed to the Sharepoint Team site


Tip - If you are planning to Install Sharepoint 2010 on Windows 7, please see the steps here which I posted a while ago - http://daxdilip.blogspot.com/2009/11/how-to-install-and-configure-sharepoint.html

Installing Dynamics AX2012 Enterprise Portal

i. Now, let's go ahead and install Enterprise Portal Component. Run the setup and click Next


ii. Check the Pre-Requisite Validation runs fine and then move next


iii. Enter the .Net BC Connector Information
iv. Configure the website, I just left the defaults as it is and moved next
v. Move next with the installation



vi. Encountered an error at this step


Looked at the error log file which came up, and found the below logs:

Error: Windows cannot find the local profile and is logging you on with a temporary profile. Changes you make to this profile will be lost when you log off.
Installation completed successfully, but Setup could not create the Enterprise Portal website. You can create the website by running Setup and installing Enterprise Portal again. You can also manually create a website using SharePoint Central Administration.



An error occurred during setup of Enterprise Portal (EP).
Registering tracing manifest file "C:\Program Files\Microsoft Dynamics AX\60\Server\Common\TraceProviderCrimson.man"
WEvtUtil.exe install-manifest "C:\Users\itadmin.PASPALEY\AppData\Local\Temp\tmpA5A1.tmp
**** Warning: Publisher {8e410b1f-eb34-4417-be16-478a22c98916} is installed on

Troubleshooting:
Didn't spent much time on troubleshooting this one as I have seen this error of logging with temporary profile before, but not with EP. The simplest solution which worked for me was to restart the box , login back and run the Enterprise Portal Setup again and that fixed the issue.


Finally, the Role center page arrives :-)... I can recall my pervious experience with  Dynamics AX 4.0 and 2009 version, never I was able to install MOSS and Enterprise Portal at the first go successfully without too many hiccups.




Additional Tip/Note -
Installation of Sharepoint Foundation 2010 Creates a new SQL Server named instance for e.g. In this case TEST-DEMOAX2012/Sharepoint where all sharepoint related databases can be found


Step by Step Guide How to Install Dynamics AX 2012 SSRS and Analysis Extensions

Step by Step Guide How to Install Dynamics AX 2012 SSRS and Analysis Extensions

This is the 3rd part in the series - Step by Step Installation of Dynamics AX 2012 Components:

Part 1 - Basic Dynamics AX 2012 Installation http://daxdilip.blogspot.com/2011/08/step-by-step-guide-how-to-install.html

Part 2 - Dynamics AX 2012 Enterprise Portal Installation http://daxdilip.blogspot.com/2011/08/how-to-install-dynamics-ax2012.html


INSTALL REPORTING EXTENSIONS
Run Pre-Requisite Validation

Go to the Link below and Download Cumulative Update 3 for SQL Server 2008 R2
http://support.microsoft.com/?kbid=2261464










Troubleshooting Tip (SSRS Errors)


Error during Install of AX 2012 SSRS Extensions

Microsoft.ReportingServices.WmiProvider.WMIProviderException: The profile for the user is a temporary profile. (Exception from HRESULT: 0x80090024)   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ReencryptSecureInformation()
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ReencryptSecureInformation()

An error occurred during setup of Reporting Services extensions.

Reason: Unable to restore the SQL Server Reporting Services encryption key. The operation failed with error code 2148073508


Solution


a. Restart the box

b. In SQL Server 2008, SSRS Reporting Configuration Manager, Under Encryption Keys, Restore the key

c. Generate Backup encryption key for the service account

d. Check you are able to browse Report Server and Report Manager URL

e. Now, Install SSRS Extensions again, it should work



Deploy Reports (Powershell)



Wait for a few mins to populate the variable, it will return back to the PS Prompt
TIP - You can also output to a file by appending out-file as shown


803 SSRS reports out of the box
Publishing reports
Note – takes around 45 mins to deploy (with some warnings which can be ignored I guess)

INSTALL/CONFIGURE ANALYSIS SERVICES
  1. Install SQL Server Analysis
  2. Restart Server