During client installation we faced a issue when AX client gets crashed every time we try to start AX and the client terminates on startup after some investigation we found that is was Intel graphics drivers which were causing issue to fix this you need to Update the graphics driver to the most recent version available
Thursday, April 14, 2016
Sunday, April 3, 2016
Clear your AUC files for All user.
Clear your AUC files for All user.
# Create array containing all user profile folders
$colProfiles = Get-ChildItem "C:\Users\" -Name
$colProfiles = $colProfiles -ne "Public"
# Removes AUC files from each user profile folder
ForEach ( $objProfile in $colProfiles )
{
Get-ChildItem "C:\Users\$objProfile\AppD ata\Local\ *.AUC" -force | remove-item -force
}
if you just want to clear the one user go to the following
c:\users\username\AppData\ Local and clear anything ending with .AUC
# Create array containing all user profile folders
$colProfiles = Get-ChildItem "C:\Users\" -Name
$colProfiles = $colProfiles -ne "Public"
# Removes AUC files from each user profile folder
ForEach ( $objProfile in $colProfiles )
{
Get-ChildItem "C:\Users\$objProfile\AppD
}
if you just want to clear the one user go to the following
c:\users\username\AppData\
AXReportInstanceExtensions COMException error message while trying to install the AX Report instance extensions through PowerShell.
AXReportInstanceExtensions COMException error message while trying to install the AX Report instance extensions through PowerShell.
Install-AXReportInstanceExtensions :
In line:1 char:1
+ Install-AXReportInstanceExtensions -ReportServerInstanceName DAXTest -Credential ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (Microsoft.Dynam...tensionsCommand:InstallReportInstanceExtensionsCommand) [I
nstall-AXReportInstanceExtensions], COMException
+ FullyQualifiedErrorId : Microsoft.Dynamics.AX.Framework.Management.Reports.InstallReportInstanceExtensionsComman
d
To solve this issue you need to start the powershell as administrator and try again.
SQL Script to change logical File name for Dynamics AX Data restore
1. Detach Database First
USE [master]
ALTER DATABASE [OLDAXBaseline]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
EXEC master.dbo.sp_detach_db @dbname = N'OLDAXBaseline'
USE [master]
ALTER DATABASE [OLDAX]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
EXEC master.dbo.sp_detach_db @dbname = N'OLDAX'
USE [master]
ALTER DATABASE [OLDAX_model]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
EXEC master.dbo.sp_detach_db @dbname = N'OLDAX_model'
2. Rename Database MDF and LDF files
manually
3. Create new database and Attached
Manually renamed Files
USE [master]
CREATE DATABASE AXBaseline ON
( FILENAME = N'C:\\DATA\AXBaseline.mdf'),
( FILENAME = N'C:\\DATA\AXBaseline_log.LDF')
FOR ATTACH
USE [master]
CREATE DATABASE AX ON
( FILENAME = N'C:\\DATA\AX.mdf'),
( FILENAME = N'C:\\DATA\AX_log.LDF')
FOR ATTACH
USE [master]
CREATE DATABASE AX_model ON
( FILENAME = N'C:\\DATA\AX_model.mdf'),
( FILENAME = N'C:\\DATA\AX_model_log.LDF')
FOR ATTACH
4. Change logical file name
USE [AXBaseline]
ALTER DATABASE [AXBaseline]
MODIFY FILE (NAME=N'OldAXBaseline', NEWNAME=N'AXBaseline')
ALTER DATABASE [AXBaseline]
MODIFY FILE (NAME=N'OldAXBaseline_log', NEWNAME=N'AXBaseline_log')
USE [AX]
ALTER DATABASE [AX]
MODIFY FILE (NAME=N'OldAX', NEWNAME=N'AX')
ALTER DATABASE [AX]
MODIFY FILE (NAME=N'OldAX_log', NEWNAME=N'AX_log')
USE [AX_model]
ALTER DATABASE [AX_model]
MODIFY FILE (NAME=N'OldAX_model', NEWNAME=N'AX_model')
ALTER DATABASE [AX_model]
MODIFY FILE (NAME=N'OldAX_model_log', NEWNAME=N'AX_model_log')
Tuesday, March 1, 2016
SQL script Get a list of Duties and Privileges based on Security Role
SQL script Get a list of Duties and Privileges based on Security Role
USE [Model_database_name];
SELECT secRole.AOTNAME [Role_Name], secRoleExplode.SECURITYROLE,
secRole2.AOTNAME [Subrole_Name], secRoleExplode.SECURITYSUBROLE,
secTask.AOTNAME [Task_name], secRoleTask.SECURITYTASK,
secTask2.AOTNAME [secTask2_name], secTaskExplode.SECURITYSUBTASK,
CASE
WHEN secTask2.TYPE = 0 THEN 'Privilege'
WHEN secTask2.TYPE = 1 THEN 'Duties'
ELSE 'Other'
END AS OBJECTTYPE
FROM SECURITYROLE secRole
join SECURITYROLEEXPLODEDGRAPH secRoleExplode
ON secRole.RECID = secRoleExplode.SECURITYROLE
JOIN SECURITYROLE secRole2
ON secRoleExplode.SECURITYSUBROLE = secRole2.RECID
JOIN SECURITYROLETASKGRANT secRoleTask
ON secRoleExplode.SECURITYSUBROLE = secRoleTask.SECURITYROLE
JOIN SECURITYTASK secTask
ON secTask.RECID = secRoleTask.SECURITYTASK
JOIN SECURITYTASKEXPLODEDGRAPH secTaskExplode
ON secRoleTask.SECURITYTASK = secTaskExplode.SECURITYTASK
JOIN SECURITYTASK secTask2
ON secTaskExplode.SECURITYSUBTASK = secTask2.RECID
WHERE secRole.AOTNAME = '' // Add role name here
ORDER BY OBJECTTYPE, secRoleExplode.SECURITYSUBROLE
USE [Model_database_name];
SELECT secRole.AOTNAME [Role_Name], secRoleExplode.SECURITYROLE,
secRole2.AOTNAME [Subrole_Name], secRoleExplode.SECURITYSUBROLE,
secTask.AOTNAME [Task_name], secRoleTask.SECURITYTASK,
secTask2.AOTNAME [secTask2_name], secTaskExplode.SECURITYSUBTASK,
CASE
WHEN secTask2.TYPE = 0 THEN 'Privilege'
WHEN secTask2.TYPE = 1 THEN 'Duties'
ELSE 'Other'
END AS OBJECTTYPE
FROM SECURITYROLE secRole
join SECURITYROLEEXPLODEDGRAPH secRoleExplode
ON secRole.RECID = secRoleExplode.SECURITYROLE
JOIN SECURITYROLE secRole2
ON secRoleExplode.SECURITYSUBROLE = secRole2.RECID
JOIN SECURITYROLETASKGRANT secRoleTask
ON secRoleExplode.SECURITYSUBROLE = secRoleTask.SECURITYROLE
JOIN SECURITYTASK secTask
ON secTask.RECID = secRoleTask.SECURITYTASK
JOIN SECURITYTASKEXPLODEDGRAPH secTaskExplode
ON secRoleTask.SECURITYTASK = secTaskExplode.SECURITYTASK
JOIN SECURITYTASK secTask2
ON secTaskExplode.SECURITYSUBTASK = secTask2.RECID
WHERE secRole.AOTNAME = '' // Add role name here
ORDER BY OBJECTTYPE, secRoleExplode.SECURITYSUBROLE
Wednesday, July 8, 2015
Installation Management Reporter 2012 for Dynamics AX 2012 Error
During the recent installation of Management Reporter, I used the wrong Service Port(8101) in my case which was 8201 I have mistakenly put 8101. Consequently, the installation failed. The error message in the log file was:
System.ServiceModel.ProtocolException: You have tried to create a channel to a service that does not support .Net Framing. It is possible that you are encountering an HTTP endpoint. ---> System.IO.InvalidDataException: Expected record type 'PreambleAck', found '72
To Solve this error please check service endpoint port by opening config file in notepad C: \ Program Files \ Microsoft Dynamics AX \ 60 \ Server \ MicrosoftDynamicsAX \ bin \ ax32serv.exe.config
Friday, April 3, 2015
AX2012 R3 Creating product variants using X++
static void DSCreateVarientforAllproducts(Args _args)
{
EcoResProductVariantCreationMgr ecoResProductVariantCreationMgr;
EcoResProductMaster EcoResProductMaster;
EcoResDistinctProductVariant ecoResDistinctProductVariant;
EcoResProductReleaseManagerBase releaseManager;
args args;
int i;
while select EcoResProductMaster
{
i++;
args = new args();
args.record(EcoResProductMaster);
EcoResProductVariantCreationMgr = null;
EcoResProductVariantCreationMgr = ecoResProductVariantCreationMgr::newFromArgs(args);
ecoResProductVariantCreationMgr.parmCalledfromjob(true); // Added in ecoResProductVariantCreationMgr class to select all varients to release
ecoResProductVariantCreationMgr.buildVariantSuggestions();
ecoResProductVariantCreationMgr.run();
EcoResProductMaster::updateVariantDescriptions(EcoResProductMaster.RecId); // To Generate Varient Descritoin of all varients
select ecoResDistinctProductVariant where ecoResDistinctProductVariant.ProductMaster == EcoResProductMaster.RecId;
if (ecoResDistinctProductVariant && !ecoResDistinctProductVariant.isReleased())
{
releaseManager = EcoResProductReleaseManagerBase::newFromProduct(ecoResDistinctProductVariant);
releaseManager.release();
}
print i;
}
}
{
EcoResProductVariantCreationMgr ecoResProductVariantCreationMgr;
EcoResProductMaster EcoResProductMaster;
EcoResDistinctProductVariant ecoResDistinctProductVariant;
EcoResProductReleaseManagerBase releaseManager;
args args;
int i;
while select EcoResProductMaster
{
i++;
args = new args();
args.record(EcoResProductMaster);
EcoResProductVariantCreationMgr = null;
EcoResProductVariantCreationMgr = ecoResProductVariantCreationMgr::newFromArgs(args);
ecoResProductVariantCreationMgr.parmCalledfromjob(true); // Added in ecoResProductVariantCreationMgr class to select all varients to release
ecoResProductVariantCreationMgr.buildVariantSuggestions();
ecoResProductVariantCreationMgr.run();
EcoResProductMaster::updateVariantDescriptions(EcoResProductMaster.RecId); // To Generate Varient Descritoin of all varients
select ecoResDistinctProductVariant where ecoResDistinctProductVariant.ProductMaster == EcoResProductMaster.RecId;
if (ecoResDistinctProductVariant && !ecoResDistinctProductVariant.isReleased())
{
releaseManager = EcoResProductReleaseManagerBase::newFromProduct(ecoResDistinctProductVariant);
releaseManager.release();
}
print i;
}
}
Subscribe to:
Posts (Atom)