Tuesday, December 27, 2011
Friday, December 23, 2011
Thursday, December 22, 2011
Tuesday, December 20, 2011
Microsoft Dynamics AX 2012 - Technical Conference Fall Edition
From January 4th, 2012 at this link https://mbs.microsoft.com/partnersource/training/news/MSDYAX_TechConferenceFall.htm will be available all the session recordings and presentation content about AX 2012.
Enjoy!
Enjoy!
AX 2012 - Models, Layers, and the Model Store
Models and Model Store
Deploying Customizations and Solutions by using Models and the Model Store
Import\Export ModelStore
Model and model store cmdlets
EX:
Export-AXModel -Server SERVERDB -Database DataBaseName –Model "Model Name" -File c:\temp\xxxxx.axmodel
Install-AXModel -Server SERVERDB -Database DatabaseName -File c:\temp\xxxxx.axmodel -DETAILS -Conflict Overwrite
How to add or delete a label file in Dynamics AX 2012
For exporting all models from a single layer, you can use the following Powershell command (in the AX management shell):
You have to update the path and the layer, of couse.
If you want Export models in sequence : AX 2012 – Export models in Sequence
Deploying Customizations and Solutions by using Models and the Model Store
Import\Export ModelStore
Model and model store cmdlets
EX:
Export-AXModel -Server SERVERDB -Database DataBaseName –Model "Model Name" -File c:\temp\xxxxx.axmodel
Install-AXModel -Server SERVERDB -Database DatabaseName -File c:\temp\xxxxx.axmodel -DETAILS -Conflict Overwrite
How to add or delete a label file in Dynamics AX 2012
For exporting all models from a single layer, you can use the following Powershell command (in the AX management shell):
$path = 'c:\Share' Get-AXModel -Layer USR ` | % {Export-AXModel -Model $_.Name -File (Join-Path $path "$($_.Name).axmodel") }
If you want Export models in sequence : AX 2012 – Export models in Sequence
Monday, December 19, 2011
SQL Server 2008 - CPU Usage
Below, a query due to verify the CPU Usage of Sql Server.
Finally, check also this link http://support.microsoft.com/kb/961811 related the orphaned session IDs.
SELECT TOP 500 (a.total_worker_time/a.execution_count) as [Avg_CPU_Time],
Convert(Varchar,Last_Execution_Time) as 'Last_execution_Time',
Total_Physical_Reads,
SUBSTRING(b.text,a.statement_start_offset/2,
(case when a.statement_end_offset = -1 then len(convert(nvarchar(max), b.text)) * 2
else
a.statement_end_offset end - a.statement_start_offset)/2) as Query_Text,
dbname=Upper(db_name(b.dbid)),
b.objectid as 'Object_ID'
FROM sys.dm_exec_query_stats a
cross apply
sys.dm_exec_sql_text(a.sql_handle) as b
ORDER BY
[Avg_CPU_Time] DESC
Denis
Finally, check also this link http://support.microsoft.com/kb/961811 related the orphaned session IDs.
SELECT TOP 500 (a.total_worker_time/a.execution_count) as [Avg_CPU_Time],
Convert(Varchar,Last_Execution_Time) as 'Last_execution_Time',
Total_Physical_Reads,
SUBSTRING(b.text,a.statement_start_offset/2,
(case when a.statement_end_offset = -1 then len(convert(nvarchar(max), b.text)) * 2
else
a.statement_end_offset end - a.statement_start_offset)/2) as Query_Text,
dbname=Upper(db_name(b.dbid)),
b.objectid as 'Object_ID'
FROM sys.dm_exec_query_stats a
cross apply
sys.dm_exec_sql_text(a.sql_handle) as b
ORDER BY
[Avg_CPU_Time] DESC
Denis
AX 2012 - Add a new Financial Dimensions with the values linked to a Table
Hi
If you have to add a new Financial Dimensions with the values linked to a Table ( Setting an entity to be dimensionable ) follow this steps :
To set an entity to be dimensionable, create a view as directed below. The entity will automatically appear as an available backing entity type.
Also, to integrate with the dimensions framework when deleting or renaming the natural key of the backing entity, you must write custom code on the backing table's delete method, and also on either the update or renamePrimaryKey method. See CustTable for an example of the pattern these methods must follow.
1. The view name must be DimAttribute[yourentityname]. For example, DimAttributeCustTable.
2. The view must contain a root data source named BackingEntity that points to your backing table to identify a surrogate key and natural key.
3. The view may optionally contain additional related data sources to handle inheritance or relational associations to provide additional fields, such as a name from the DirPartyTable.
4. The view must contain the following fields named exactly as follows:
• Key - Must point to the backing entity's SK field. For example, an int64 RecId field.
• Value - Must point to the backing entity's NK field. For example, a str30 AccountNum field.
• Name - Must point to the source of an additional description for the entity. For example, a str60 Description field.
Because the list of dimensionable entities are cached on both the client and server, the creation of a new dimensionable entity will not appear in the list of existing entities until a call to clear the caches is performed, or until both the client and the server are restarted. In order to clear the caches and have the new backing entity appear immediately, you must execute the following line of code within a job:
DimensionCache::clearAllScopes();
If a new Organization Model OMOperatingUnitType enumeration is added, the steps to make it dimensionable are similar but can be made shorter as follows: 31 IMPLEMENTING THE ACCOUNT AND FINANCIAL DIMENSIONS FRAMEWORK FOR MICROSOFT DYNAMICS AX 2012 APPLICATIONS
1. Copy one of the existing DimAttributeOM[entityname] views, rename it appropriately and adjust all associated labels and help text.
2. Expand the Datasource\BackingEntity (OMOperatingUnit)\Ranges node on the copied view and change the value property on the range to the new OMOperatingUnitType enumeration value that was just added.
Because the OMOperatingUnitType is backed by the OMOperatingUnit table, generic code already exists to handle the delete, update and renamePrimaryKey methods. Therefore, in this case, you do not need to update these methods.
Finally, due to activate the new Dimension read this blog http://www.intergen.co.nz/blog/tim-schofield/dates/2011/12/how-to-add-a-financial-dimension-in-ax-2012/
Enjoy !
Denis
If you have to add a new Financial Dimensions with the values linked to a Table ( Setting an entity to be dimensionable ) follow this steps :
To set an entity to be dimensionable, create a view as directed below. The entity will automatically appear as an available backing entity type.
Also, to integrate with the dimensions framework when deleting or renaming the natural key of the backing entity, you must write custom code on the backing table's delete method, and also on either the update or renamePrimaryKey method. See CustTable for an example of the pattern these methods must follow.
1. The view name must be DimAttribute[yourentityname]. For example, DimAttributeCustTable.
2. The view must contain a root data source named BackingEntity that points to your backing table to identify a surrogate key and natural key.
3. The view may optionally contain additional related data sources to handle inheritance or relational associations to provide additional fields, such as a name from the DirPartyTable.
4. The view must contain the following fields named exactly as follows:
• Key - Must point to the backing entity's SK field. For example, an int64 RecId field.
• Value - Must point to the backing entity's NK field. For example, a str30 AccountNum field.
• Name - Must point to the source of an additional description for the entity. For example, a str60 Description field.
Because the list of dimensionable entities are cached on both the client and server, the creation of a new dimensionable entity will not appear in the list of existing entities until a call to clear the caches is performed, or until both the client and the server are restarted. In order to clear the caches and have the new backing entity appear immediately, you must execute the following line of code within a job:
DimensionCache::clearAllScopes();
If a new Organization Model OMOperatingUnitType enumeration is added, the steps to make it dimensionable are similar but can be made shorter as follows: 31 IMPLEMENTING THE ACCOUNT AND FINANCIAL DIMENSIONS FRAMEWORK FOR MICROSOFT DYNAMICS AX 2012 APPLICATIONS
1. Copy one of the existing DimAttributeOM[entityname] views, rename it appropriately and adjust all associated labels and help text.
2. Expand the Datasource\BackingEntity (OMOperatingUnit)\Ranges node on the copied view and change the value property on the range to the new OMOperatingUnitType enumeration value that was just added.
Because the OMOperatingUnitType is backed by the OMOperatingUnit table, generic code already exists to handle the delete, update and renamePrimaryKey methods. Therefore, in this case, you do not need to update these methods.
Finally, due to activate the new Dimension read this blog http://www.intergen.co.nz/blog/tim-schofield/dates/2011/12/how-to-add-a-financial-dimension-in-ax-2012/
Enjoy !
Denis
Wednesday, December 14, 2011
Dynamics AX 2012 - Error during deployment SSRS Reports on the Second instance of SQL Reporting
On a server running multiple report server instance i have a error during SSRS Reports deployment.
I have run the command Test-AXReportServerConfiguration that return IsReportServerRunning : False
After a hard investigation ...without success, i have uninstall the second instance of Reporting Services and install again.
I have run the command Test-AXReportServerConfiguration that return IsReportServerRunning : False
After a hard investigation ...without success, i have uninstall the second instance of Reporting Services and install again.
After that i have follow again the steps listed on TechNet page Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX) [AX 2012] (technet.microsoft.com/.../hh389760.aspx) and now all work fine.
Enjoy!
Tuesday, November 29, 2011
AX 2012 - Install multiple instances of Reporting Services on the same computer
Install multiple instances of Reporting Services on the same computer
Report server management cmdlets
If you want test the SSRS Server Configuration the command is :
Test-AXReportServerConfiguration -id "Configuration_ID" -ServicesAOSName XX@AOSServerName -ServicesAOSWSDLPort 810X
Report server management cmdlets
If you want test the SSRS Server Configuration the command is :
Test-AXReportServerConfiguration -id "Configuration_ID" -ServicesAOSName XX@AOSServerName -ServicesAOSWSDLPort 810X
Friday, November 25, 2011
AX 2012 - The Client Configuration don't have a valid WCF configuration
When you open AX 2012 and appear the error in the subject, you have open the Dynamics AX Configuration Utility, go to the tab Connection and Click on the Button "Configure Services" !!
After that the WCF Configuration comes rebuild.
After that the WCF Configuration comes rebuild.
Tuesday, October 25, 2011
AX 2009 and Visual Studio 2010 - Install Enterprise Portal Developer tools without enterprise portal
Out of the box EP Visual studio Add-in (Enterprise portal tools) shipped with AX2009 doesn't work with VS2010. With few simple steps it is possible to make it compatible. AX installer performs validation for VS2008 so all installations steps for Enterprise portal tools have to be done manually:
The same step more & less can be use for install Enterprise Portal Developer tools without install Enterprise Portal !
The same step more & less can be use for install Enterprise Portal Developer tools without install Enterprise Portal !
Copy DVD\MSI\EnterprisePortalTools to C:\Program Files\Microsoft Dynamics AX\50\EnterprisePortalTools
- Rename file Microsoft.Dynamics.Framework.Portal.VisualStudio.2008.AddIn.AddIn to Microsoft.Dynamics.Framework.Portal.VisualStudio.2010.AddIn.AddIn
- Edit the file: replace VS version 9.0 with 10.0
- Open VS2010: Tools->Options->Add-in/Macros security and add C:\Program Files\Microsoft Dynamics AX\50\EnterprisePortalTools
- Open DVD\MSI\Components64\
- Unpack AxWebProject.zip
- File ProjectName.webproj is just one bit big. For VS2010 it should be 0: either delete the file and create new one with same name or edit it and delete it's content
- Pack it back to AxWebProject.zip
- Create folder My Documents\Visual Studio 2010\Templates\ProjectTemplates\Visual Web Developer\CSharp
- Copy AxWebProject.zip to My Documents\Visual Studio 2010\Templates\ProjectTemplates\Visual Web Developer\CSharp
- Create folder My Documents\Visual Studio 2010\Templates\ItemTemplates\Visual Web Developer\CSharp
- Copy AxWebpartPage.zip and AxWebUserControl.zip from to My Documents\Visual Studio 2010\Templates\ItemTemplates\Visual Web Developer\CSharp
- Open VS2010 and make sure that EP project template is available
- To add EP specific Items to Visual Studio's Toolbox, select "Chose items" from the right click menu on VS's toolbox
- Browse for C:\Program Files\Microsoft Dynamics AX\50\Client\Bin\Microsoft.Dynamics.Framework.Portal.dll
Thursday, September 22, 2011
Tuesday, August 9, 2011
Tuesday, August 2, 2011
Sunday, July 31, 2011
Thursday, June 30, 2011
Microsoft Dynamics AX 2012 Product Release Training Web Seminars
Hi
Below some training link :
Microsoft Dynamics AX 2012 Product Release Training Web Seminars :
mbs.microsoft.com/.../MSD_AX2012ProductReleaseTrainingWebinars
Role Tailored Learning Plans for Microsoft Dynamics AX :
mbs.microsoft.com/.../RolebasedLearningPlansAX
Information Source :
informationsource.dynamics.com/.../RfpServicesOnline.aspx
Microsoft Dynamics® AX 2012 Enterprise Academy :
www.microsoft.com/.../AXEnterpriseAcademy
MPN Partner Learning Center :
training.partner.microsoft.com/.../LMS_LearnerHome.aspx
Free Axapta Training :
www.dynamicsaxtraining.com
AX Training School
http://www.axaptatraining.com/
Enjoy!
Below some training link :
Microsoft Dynamics AX 2012 Product Release Training Web Seminars :
mbs.microsoft.com/.../MSD_AX2012ProductReleaseTrainingWebinars
Role Tailored Learning Plans for Microsoft Dynamics AX :
mbs.microsoft.com/.../RolebasedLearningPlansAX
Information Source :
informationsource.dynamics.com/.../RfpServicesOnline.aspx
Microsoft Dynamics® AX 2012 Enterprise Academy :
www.microsoft.com/.../AXEnterpriseAcademy
MPN Partner Learning Center :
training.partner.microsoft.com/.../LMS_LearnerHome.aspx
Free Axapta Training :
www.dynamicsaxtraining.com
AX Training School
http://www.axaptatraining.com/
Enjoy!
Tuesday, June 28, 2011
Monday, June 27, 2011
Configure/Setup AX Client although a AOS Cluster
The Command Line syntax is :
"..................Ax32.exe" -loadbalance=0 -AOS2=ServerAOSxxxx:27xx " "path and file.axc"
The important parameter is LoadBalance set to 0 !
"..................Ax32.exe" -loadbalance=0 -AOS2=ServerAOSxxxx:27xx " "path and file.axc"
The important parameter is LoadBalance set to 0 !
Monday, June 6, 2011
Wednesday, May 25, 2011
Run Client Batches on Dynamics AX 2009
Here the steps to run Batch Job Client Side in Dynamics AX 2009 :
- First of all, modify the class and override the Method RunsImpersonated. Modify this method with Return False. In this way the Class will execute Client Side
- Create a Batch Group (Administration -> Setup -> Batch groups)
- Add this batch group to an AOS acting as batch server. (Administration -> Setup -> Server configuration)
- Start the batch client ( Basic -> Periodic -> Batch -> Processing )
- Select the new batch group and press 'OK'
- In the Server Configuration Form, verify that exists only AOS Instance really present. Delete all AOS Instance that don't exist.
- First of all, modify the class and override the Method RunsImpersonated. Modify this method with Return False. In this way the Class will execute Client Side
- Create a Batch Group (Administration -> Setup -> Batch groups)
- Add this batch group to an AOS acting as batch server. (Administration -> Setup -> Server configuration)
- Start the batch client ( Basic -> Periodic -> Batch -> Processing )
- Select the new batch group and press 'OK'
- In the Server Configuration Form, verify that exists only AOS Instance really present. Delete all AOS Instance that don't exist.
Thursday, May 19, 2011
Dynamics AX 2009 EP - WebForm anyMarked method don't work
Problem :
Could happen that the anyMarked() method of a Webform Datasource don't work.
Solution :
Set the InsertAtEnd properties of the Datasource a NO
Could happen that the anyMarked() method of a Webform Datasource don't work.
Solution :
Set the InsertAtEnd properties of the Datasource a NO
Dynamics AX 2009 Enterprise Portal - WebForm Lookup - Firefox, Google chrome, ect
In Dynamics AX 2009 EP, don't work lookup control on Firefox, Google Chrome, ect.It work only with Internet Explorer.
Cause :
Class WebFormHtml method showLookupButton.
This method in the Syp layer have introduce the keyword URLENCODE.
In the Sys layer instead is use the keyword Escape.
Solution :
Use sys layer code ( Keyword Escape ), so compare Sys with Syp and move the code present in Sys in the current layer ( Var, Usr, ect )
Cause :
Class WebFormHtml method showLookupButton.
This method in the Syp layer have introduce the keyword URLENCODE.
In the Sys layer instead is use the keyword Escape.
Solution :
Use sys layer code ( Keyword Escape ), so compare Sys with Syp and move the code present in Sys in the current layer ( Var, Usr, ect )
Friday, April 8, 2011
Monday, April 4, 2011
Retrieve Label from Enum Value
The follow codes is useful due to retrieve the label of TransType field related table InventTrans :
1. SysDictEnum dictEnum = new SysDictEnum( enumnum(InventTransType) );
2. dictEnum.value2Label(InventTrans.TransType)
1. SysDictEnum dictEnum = new SysDictEnum( enumnum(InventTransType) );
2. dictEnum.value2Label(InventTrans.TransType)
Thursday, March 31, 2011
Unable to Login in Window Server 2008 in Terminal Server
Go in Secpol.msc - user rights assignments - allow logon through terminal services - Adding the Group or User that you want.
Thursday, March 24, 2011
SharePoint 2010 - Unable to do any operation on sharepoint rather than read only
Unable to do any operation on sharepoint rather than read only
This issue might be caused by backup failure
You may read here for details
http://technet.microsoft.com/en-us/library/ee748617.aspx
If the site collection’s Lock status is set to Not locked or Adding content prevented, Microsoft SharePoint Server 2010 temporarily sets the site to Read-Only while the backup operation is occurring. SharePoint Server 2010 does this to reduce the possibilities of users changing the site collection while it is being backed up. After the backup is finished, the setting is changed back its normal status
This issue might be caused by backup failure
You may read here for details
http://technet.microsoft.com/en-us/library/ee748617.aspx
If the site collection’s Lock status is set to Not locked or Adding content prevented, Microsoft SharePoint Server 2010 temporarily sets the site to Read-Only while the backup operation is occurring. SharePoint Server 2010 does this to reduce the possibilities of users changing the site collection while it is being backed up. After the backup is finished, the setting is changed back its normal status
Tuesday, March 22, 2011
Friday, March 11, 2011
Tuesday, March 1, 2011
Thursday, February 24, 2011
Thursday, February 3, 2011
Tuesday, January 18, 2011
Downgrade Forms and Reports from AX 2009 to AX 4.0
Hi
If you export a Form or a Report from AX 2009 you can't import in AX 4.0. If you try compare a errore related Datasource Properties..
To fix the problem you have to open with Notepad the XPO and remove the follows two lines :
PROPERTIES
ENDPROPERTIES
You can found this lines after the keyword OBJECTBANK after the keyword ENDMETHODS.
Enjoy
If you export a Form or a Report from AX 2009 you can't import in AX 4.0. If you try compare a errore related Datasource Properties..
To fix the problem you have to open with Notepad the XPO and remove the follows two lines :
PROPERTIES
ENDPROPERTIES
You can found this lines after the keyword OBJECTBANK after the keyword ENDMETHODS.
Enjoy
Wednesday, January 5, 2011
Code compare utility in MorphX on EP User controls
To enable the code compare utility in MorphX on EP user controls , edit the CodeIsSource method of SysTreeNode class in AOT and add UtilElmentType:WebControl and UtilElementType::WebSourceFile to the switch statement that returns true. After making the change, you shoudl be able to do code compare on user control markup and code behind files.
https://community.dynamics.com/product/ax/axtechnical/b/axsolutionsmonkey/archive/2010/12/20/code-compare-utility-in-morphx-on-ep-user-controls.aspx
https://community.dynamics.com/product/ax/axtechnical/b/axsolutionsmonkey/archive/2010/12/20/code-compare-utility-in-morphx-on-ep-user-controls.aspx
Welcome to the MCT Program
From Today I'm an MCT Trainer in Dynamics AX.
https://www.mcpvirtualbusinesscard.com/VBCServer/DenisMacchinetti/profile
https://www.mcpvirtualbusinesscard.com/VBCServer/DenisMacchinetti/profile
Monday, January 3, 2011
SSRS Reports Server tips and Settings with EP and Ax
Dynamics AX 2009 SSRS and SSAS Integration Tips :
SSRS and SSAS Integration for Microsoft Dynamics AX 2009
SSRS and SSAS Integration for Microsoft Dynamics AX 2009
User cannot view Customers Site at EP on SharePoint 2010
After install EP on Sharepoint 2010 Web Server you have to setup the User Right for a TMP Folder !!
http://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/22/user-cannot-view-customers-site-at-ep-on-sharepoint-2010.aspx
http://blogs.technet.com/b/dynamicsaxse/archive/2010/12/28/unable-to-browse-list-pages-in-ep-when-running-sharepoint-2010-with-windows-server-2008-r2-64-bit.aspx
http://blogs.msdn.com/b/emeadaxsupport/archive/2010/12/22/user-cannot-view-customers-site-at-ep-on-sharepoint-2010.aspx
http://blogs.technet.com/b/dynamicsaxse/archive/2010/12/28/unable-to-browse-list-pages-in-ep-when-running-sharepoint-2010-with-windows-server-2008-r2-64-bit.aspx
Sunday, January 2, 2011
Microsoft SharePoint 2010 is supported with Microsoft Dynamics AX 2009 Service Pack 1
If you plan to use SharePoint 2010, you must download and install the hotfix package available with Microsoft Knowledge Base article number 2278963.
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;2278963
http://blogs.technet.com/b/dynamicsaxse/archive/2010/08/12/new-compatibility-testing-result-august-2010.aspx
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;2278963
http://blogs.technet.com/b/dynamicsaxse/archive/2010/08/12/new-compatibility-testing-result-august-2010.aspx
Subscribe to:
Posts (Atom)