QuickFix -11: Extensible Data security in D365FO

Here is some really good read on XDS and how to use it. While another link detailed about how to bypass XDS as some exceptional requirement.

Extensible Data Security (XDS) Framework in D365FO

Bypass or disable extensible data security (xds) policy on runtime AX2012 and Dynamics 365 For Finance and Operations

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

Solution: Working time has not been specified for xx/xx/xxxx

Hi Folks,

While trying to release a Production order, I encountered an error,

Error: Working time has not been specified for xx/xx/xxxx when releasing production order

Solution: You need to define the working time for working time calendar. Follow below steps.

Step I: Go to Organisation administration > Setup> Calendar > Calendars

Step II: Select a calendar and click on Working time on action pan.

Step III: Click on compose working time, and select appropriate values

Step IV: Once done, click on OK button, you will get default working time created for the calendar.

Enjoy…!!!

Harry

How to setup Item coverage in Dynamics 365 FO

While performing some inventory transaction or MRP you may get this error “Item coverage is not fully updated.". We encounter this error because of default item coverage is not available for selected item and inventory dimension. Here is step by step guide to setup the item coverage for various inventory dimension.

Go to Master planning > Setup > Item coverage and Follow below steps to setup Item coverage.

Please note: few steps may differ on the basis of your selection during the wizard.

Enjoy…!!!

Harry

Dynamics AX 2012 R3 Demo Data Installation

Dynamics AX 2012 R3 Demo Data Installation

Hi Friends,

Data importing is slightly different in AX 2012 R3, in earlier version can import data through SQL but now here is something new for us. 

Before performing below operation you should have following tools/Setups with you

1. Dynamics AX 2012R3 (of course it will be there :P )

2. Demo data file (downloadable from Partner source)

DynamicsAX2012R3DemoData.exe

3. Data transfer tool (downloadable from Partner source

AX2012TestDataTransferTool.msi

Ohk, now we have all the require setups with us, so let’s start now.

Step 1. Extract demo data file, run “DynamicsAX2012R3DemoData.exe”

In this case I extract it on C drive.

Step 2. Run “AX2012TestDataTransferTool.msi” file.

It will create a new folder in under following path

C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)

Step 3. Import “MetaDataXMLGenerator.xpo” , it will import a new job named “MetaDataXMLGenerator” in AOT, Run this job.

This operation will create a XML file names “MetaData.xml” under below path

(You can directly go this folder by using “%temp%” from run)

7/29/2014 5:00 PM - Screen Clipping

Step 4. Copy this file and paste is in “[List]” folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file. In this example path will be following

“C:\AX 2012 Test Data Transfer\[Lists]”

Step : 5 Close all AX instances and stop the AOS services.

Now you have all data and required files with you.

Step 6. Now run command prompt as administrator

Navigate to the directory where your “AX2012TestDataTransferTool” folder exist. In this case I have “C:\AX 2012 Test Data Transfer” (just copied from program files J )

Now the final stunt, Run following command

DP.exe IMPORT “C:\AXR3DemoData” AX2012R3DB

Pease note: Make sure all AX instance and AOS service are stopped.

Here

Ø “DP.exe” is executable file in “AX2012TestDataTransferTool” folder

Ø “C:\AX2012R3DemoData” is your demo data folder path

Ø “AX2012R3DB” is your AX database name

System will ask to your acceptance to import data, simply press “y/Y”

Note: Some time system will show below error

“Unhandled Exception: System.UnauthorizedAccessException: Access to the path ‘C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\DP Log.xml’ is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, I
nt32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions o
ptions, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolea
n useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Xml.XmlWriterSettings.CreateWriter(String outputFileName)
at System.Xml.Linq.XDocument.Save(String fileName, SaveOptions options)
at DP.Program.Execute(String currentDirectory, DataportDirection direction, S
tring directory, String database, String server, DataportAction action) in e:\bt
\110700\Source\DataPort\DP\Program.cs:line 182
at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82

If you are facing the same error than try to run following command (Its same command as above without “ ”)

DP.exe IMPORT C:\AXR3DemoData AX2012R3DB

Now it will work J

As next, Below window will open

Here you done your part, now wait to complete this operation and open your AX client.

-Harry

Axapta Application file extensions

Dynamics Ax Application file extensions

In Axapta we found a lot of file extensions are used. Each and every extension have a logical name, so you can easily identify their purpose. The extensions have 3 characters.

Most of these files are located in the application folder (AX 2009):
C:\Program Files\Microsoft Dynamics AX\50\Application\Appl\[your_application]



The first character indicates the owner of the file:

a: application
k: kernel
The second character indicates the content of the file:
l: label
o: object
t: text
d: developer documentation
h: help
And the third character indicates the type of file:
d: data
i: index
c: cache
t: temporary

Using this logic, we can easily name all file extensions, and understand their purpose.

In the application folder:
ALD : Application Label Data files
These files contain the labels and label comments for a specific language of a label file.

ALC : Application Label Cache files
These files contain the application label cache. These files can be deleted when the AOS is stopped.

ALI : Application Label Index files
The .ali files contain an index to the .ald files. These files can be deleted when the AOS is stopped.

ALT : Application Label Temporary files
These files contain new labels before they are committed to the .ald file.

AOI : Application Object Index file
The AOI file contains an index to the AOD files. You can delete this file when the AOS is stopped. Be sure to delete this when you have copied layers from one AX installation to an other.

ADD : Application Developer Documentation Data files
These files contain the documentation that is found under the Application Developer Documentation node. These files are localized, just like label files.

ADI : Application Developer Documentation Index files
This is the index to the ADD file.

AHD : Application Help Data files
The AHD file contains the documentation aimed at the end user. In the AOT, this is found in the “Application Documentation” node.

AHI : Application Help Index files
This is the index to the AHD file.

AOD : Application Object Data file
This is the ‘AX layer file’, each of these files represents one layer.

KHD : Kernel Help Documentation files
These files contain the kernel help documentation you can find in the AOT in the tree node System Documentation.

KHI : Kernel Help Index files
The KHI file is the index to the Kernel Help file.

Located in Server/bin:

KTD extension: Kernel Text Data file
This file contains system text strings. These are used in the interface of AX and for system messages.

KTI extension: Kernel Text Index file
This is the index to the KTD file.

-Harry

How to install microsoft dynamics ax 2009 on windows 7

How to install microsoft dynamics ax 2009 on windows 7

Here is steps to install AX on Win-7 (non-server OS),

Dynamics AX Basic Installation:

1. Make sure you are logged in through your domain account (domain\user) on your laptop, not local system account.
2. You should have local admin rights on your laptop.
3. Install SQL Server 2008 with SP1. Service account for this should be local system.
4. Install AX 2009. You need to be connected to your domain while installing AX. Ignore warning that says this operating system is not supported. 
5. AOS again should run under local system, instead of your domain account. Because this way you can use AX when you are out of your domain network.
   Hint: At the time of installation select Network service and after successful installation convert AOS service account to Local System.
   
6. On the next screen, uncheck checkbox which says start AOS after installation.
   
7. Click Install and you are done with the basic AX 2009 installation.
8. To get it running with SQL Server 2008 SP1, you need AX 2009 SP1.
9. Install AX 2009 SP1.
10. Start AOS. (Optional: you may need to change the AOS service account to Local System).
11. In AX, AdministratorSetupSecuritySystem service account, Set BC Proxy Account to your domain account (user , domain.com).
12. Import Demo Data.

Dynamics AX Role Center & Enterprise Portal Installation:

1. EP needs Sharepoint portal to be installed on your laptop. To install WSS / MOSS on your Windows 7 OS follow this link. http://theaxapta.blogspot.in/2013/03/installing-microsoft-sharepoint.html
2. Once you have installed & configured Sharepoint, install Role center & Enterprise portal from the AX installation CD. It will run fine; I have checked it on my laptop.
3. If you have Visual Studio 2008 installed, then you can also install enterprise portal development tools.

-Harry

Installing Microsoft SharePoint Foundation

Installing Microsoft SharePoint Foundation

Note: Microsoft SharePoint Foundation (MSF) can be only installed on a 64-bit hardware

Recently i installed MSF on my local system , I just sharing my exp about how to install MSF. Installation and configuration of Microsoft SharePoint Server 2010. We will complete this tutorial in four main steps as:
      1.     Hardware and Software requirements
      2.     Pre-requisites
      3.     Installation
      4.     Post Setup Configuration



1.     Hardware and Software requirements

Microsoft SharePoint Foundation (MSF) can be only installed on a 64-bit hardware and Microsoft provides the detailed hardware and software requirements in the following TechNet article.This is the new name for Windows SharePoint Services V4.
http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx#section2

2.     Pre-requisites

In this release Microsoft has included a Prerequisite Installer (Preparation Tool) which will take care of all the pre-requisites which are required to setup a SharePoint Server.The tool would connect to Internet to download and install any prerequisites as well as enabling and configuring any Windows features and roles required by setup. Also the administrator can override this if the necessary software is already present in the hard disk or in a network location.
The Preparation Tool executable, Prerequisiteinstaller.exe, is located at the root of the setup folder. It can also be launched from the setup splash screen.When you run the Prerequisiteinstaller.exe /? , the following screen is shown which will list the command-line parameters that can be used with this executable.



You can also install the pre-requisite from a folder if it is already downloaded from the internet and the SharePoint server doesn’t have internet access.

C:\setup\prerequinstaller.exe /IDFX:c:\GenevaFramework.amd64.msi

It is possible to include multiple file location parameters for the different components. In the following example, we've also added local file location parameter for both the IDFX and Sync framework:

C:\setup\prerequinstaller.exe /IDFX:c:\GenevaFramework.amd64.msi /SYNC c:\sync.msi

To install the Pre-requisites, run the prerequisiteinstaller.exe in the installation media of SharePoint or run the Splash which will provide you the following screen.



Click on the “Install Software prerequisites” option which will start the installation of the necessary pre-requisites.



You can get the download link for each of the required product when you click Learn more about these prerequisites in the above screen.

Click Next will start the download and installation of pre-requisites from the internet.



Accept the EULA and click Next and this will start the installation of the required product.



Some of them may require a Restart and the pre-requisite installer will continue once the system is restarted.



There is a link called “Review the log file” in the above screen which will help to find out any issue with the installation of the Pre-requisites.Once the installation is complete, you will see the following screen and it means that all the required Pre-requisites are installed and configured on the server and you can start the installation of SharePoint.

Installation of SharePoint Server 2010

When installing SharePoint Foundation, there are primarily three setup options.Following is a short description of each type of installation:

Standalone Installation:

  SQL Server 2008 Express Edition is the database type automatically installed (instead of Windows Internal Database/SQL Server 2005 Embedded Edition used in Windows SharePoint Services 3.0).   This is almost a “one-click” installation, no questions are asked during setup or during Post Setup Configuration Wizard (PSConfig)
A Web application and team site collection are automatically created in the newly created farm. The search service is started automatically.
Cannot add servers to join a farm.
When the installation is complete, the browser opens taking you to a newly created site collection. Installer is not prompted for farm passphrase, it is automatically generated.
Standalone Same as Basic installation, except it allows changing installation directory location. Complete SQL Server 2005 SP2/SQL Server 2008 is the database type, not installed by setup.
Administrator can pick whether or not to create a site and the site template to use.
Prompted for farm passphrase during PSConfig phase of installation. The farm passphrase will be discussed later in this document.
To run setup you must at minimum be a local administrator on the computer where SharePoint Server 2010 is installed.



Run the Splash from the setup media which will show the above screen and click on “Install SharePoint Foundation” which will start the installation process.



-Harry

Installing Oracle Database 11g Release 2

Step-by-step instructions for installing Oracle Database 11g Release 2

Here are step-by-step instructions for installing Oracle Database 11g Release 2 on Windows 7. It’s provided in response to questions posted on my step-by-step instructions for installing Oracle 11gR1 on Windows 7. For reference, I posted the former because it didn't work without intervention. I hadn't updated step-by-step instructions because Oracle Database 11g Release 2 has always worked for me when installing on Windows 7.
A number of students and blog readers have mentioned that it didn't work for them. My guess is that they had configuration issues within the Windows 7 environment. There are some Windows 7 configuration caveats before you perform this installation, and they are:
Windows 7 Configuration Steps

1. Make sure you have at least 3 GB of memory on your Windows PC, or that you can allocate 4 GB of memory to your virtual machine (the latter typically requires 8 GB of real memory to avoid extensive disk caching of memory).
2. Install Oracle’s SJDK and run time for Java 6 or 7 on Windows 7 (I installed Java 7). Although either work with the database, you need the Java 6 SDK 32-bit version (at least SJDK 1.6.0_4) for Oracle SQL Developer. This means you need to download the 32-bit version even when you’re installing the 64-bit Oracle Database 11g version.
3. Disable Microsoft’s User Access Controls (UAC). I blogged about a set of Windows 7 gripes, and the second point shows you the screen shots that let you disable UAC on Windows 7.
4. Configure your C:\Windows\System32\drivers\etc\hosts file. Use lines 1 through 3 when you’re using a DHCP IP address, and lines 1 through 4 when you’re using a static IP address.  Please note that the hostnameneeds to be lowercase.

1 127.0.0.1 localhost 
2 ::1 localhost
3 127.0.0.1 agarwalax theaxapta.blogspot.com
4 172.26.126.131 agarwalax theaxapta.blogspot.com 

5. Create a user account name that doesn’t have a white space, like McLaughlinM in the screen shots, and assign it Administrator privileges.
6. The Oracle Enterprise Manager (OEM) uses port ranges above 5,000, which according to Microsoft requires that you set MaxUserPort key in the Windows Registry. You can find more details at this Microsoft Support page. Personally, I haven’t found this necessary and after adding it to please somebody without setting it everything ran fine in Windows 7.

Registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Value Name
MaxUserPort
Value Type
DWORD
Value Data
65534
Value Range
5000-65534 (decimal)
Value Default
0×1388 (5000 decimal)
Description
This parameter controls the maximum port number that is used when a program requests any available user port from the system. Typically, ephemeral (short-lived) ports are allocated between the values of 1024 and 5000 inclusive. After the release of security bulletin MS08-037, the behavior of Windows Server 2003 was changed to more closely match that of Windows Server 2008 and Windows Vista. For more information about Microsoft security bulletin MS08-037
Oracle 11g Release 2 Installation Steps

1. The Oracle Database 11g Release 2 files are broken down into two zip files on the Oracle site. That means you need to download both files, and then expand them into an installation directory. I called my installation directory C:\OracleInstall, but you can call it whatever works for you. Here’s a screen shot of the directory after expanding both compressed files (done with WinZip 15).

You should notice that the two expanded compressed files put everything into a database directory (or folder). Within the installation folder (C:\OracleInstall\database), you double click on the oui icon to launch (start) the Oracle Universal Installer. It’ll open a command prompt that may dwell on the screen for a few seconds up to maybe fifteen seconds.

2. It’s a good idea to provide an email address for security updates no matter what. You can unchecked the box if you don’t want updates via Oracle Support Services. Click the Next button to continue.

3. Most developers want to Create and configure a database. If that’s your desire, leave the default radio button checked. Click the Next button to continue.

4. Most developers install their test instance on a desktop or laptop. If that’s your desire, leave the defaultDesktop Class radio button checked. Click the Next button to continue.

5. These are default settings and generally the easiest to use. I’d suggest you change the Character Set drop down to Unicode. Then, enter a password twice. Oracle requires that you use at least one capital letter and one number in a 6 character or more long password. Click the Next button to continue.

6. The next screen is a progress bar that checks for prerequisites. You shouldn't have to do anything here because it automatically advances you to the next dialog screen. This generally takes less than a minute to run but can take two or so. If you’re much beyond 3 minutes there may be a resource problem with your Windows PC or virtual machine.

7. This shows you all the selected values for the installation. Unless you want to abort the installation, click the Finish button to proceed.

8. This screen is the main progress bar, and you’ll be here somewhere between 5 and 10 minutes. The downside is that there are some dialog that will popup during this phase and you need to authorize them, so it’s a bad time to take a break.

9. The first popup screen requires you to authorize the Java run time to call home. You should click the Allow Access button to proceed.

10. When the progress bar starts configuring the instance, failures can occur. The first may occur during the network configuration, which typically happens if you didn't preconfigure the hosts file. You don’t need to do anything but watch here unless the installer triggers an error.

11. The following progress bar is launched by the Oracle Database Configuration Assistant. It typically runs without a problem. You don’t need to do anything but watch here unless the installer triggers an error. This takes a few minutes, and unfortunately requires you to stick aroung to again authorize Java.

12. The second popup screen requires you to authorize the Java runtime to call home. You should click theAllow Access button to proceed.

13. The third and last popup screen asks you to whether you want to open other scheme. Generally, you should click the OK button to proceed.

14. The next dialog shows you that the network and database instances are configured. It’s also running the OEM (Oracle Enterprise Manager) installation. You can wait here but it won’t be a long wait.

15. This is the last dialog and says you’ve installed Oracle Database 11g Release 2 successfully. You can theClose button to complete the installation.

-Harry

AX 2012 R2 Step By Step Installation Guide

AX 2012 R2 Step By Step Installation 

As you know the much awaited AX 2012 R2 is launched. I just installed AX on my local computer, So i am just sharing some screen shots for your reference to install AX 2012.

1) Start the Setup Program.



2) Click "Microsoft Dynamics AX Components" under Install.



3) Click Next.



4) Select "I accept the license terms" *.



5) Choose Appropriate Option.



6) Processing will start.







7) Choose "Add or modify components".



8) Select Options to install/upgrade.



9) Review the Errors/warnings and click on "Configure" check box for the 
applicable errors. and click "Configure".



10) Click "Start" to start configuring components as per AX needs.



11) Select "Configure existing database (for upgrade scenarios)".



12) Specify your existing databases.



13) Choose models to upgrade.



14) Specify the "Temp" location for setup files.



15) Specify the SSAS details.



16) Specify credentials (we just have used the dummy account) for learning 
purpose only. Use your AD authenticated account details.



17) Specify .net BC account (if its not already there in AX)



18) Choose your Languages (en-US) in this demo.



19) Specify Data Crawler Account details.





20) SSRS Database details.



21) User Account for SSRS Access.





22) Click Install.
23) Verify the installation.


-Harry