Monday, 20 October 2014

while Importting Ax 2012 r3 contoso data Error

while Importting Ax 2012 r3 contoso data  Error

Unhandled Exception: System.NotSupportedException: The given path's format is no
t supported.
   at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boo
lean needFullPath)
   at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[
] str, Boolean needFullPath)
   at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionA
ccess access, AccessControlActions control, String[] pathListOrig, Boolean check
ForDuplicates, Boolean needFullPath, Boolean copyPathList)
   at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionA
ccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFul
lPath, Boolean copyPathList)
   at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess
access, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath)
   at System.IO.FileSystemEnumerableIterator`1..ctor(String path, String origina
lUserPath, String searchPattern, SearchOption searchOption, SearchResultHandler`
1 resultHandler, Boolean checkHost)
   at System.IO.Directory.InternalGetFileDirectoryNames(String path, String user
PathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, S
earchOption searchOption, Boolean checkHost)
   at System.IO.Directory.InternalGetFiles(String path, String searchPattern, Se
archOption searchOption)
   at Microsoft.Dynamics.AX.Dataport.SqlHelper.GetDifferentialTableNames(Datapor
tDatabase db, String directory) in e:\bt\110700\Source\DataPort\Dataport\Library
\SqlHelper.cs:line 721
   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 183
   at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82


solution : Give the read ,write and DB-owner access of database.

Tuesday, 14 October 2014

Dynamics Ax or D365 F & O SSRS Reports Error

Publish-AXReport : An error occurred : The network path was not found.
If User Account Control (UAC) is enabled on the machine, close the
application, right-click the application, and then click Run  as administrator.
At line:1 char:1
+ Publish-AXReport -ReportName *
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (Microsoft.Dynam...erConfigura
   tion:VerifyReportServerConfiguration) [Publish-AXReport], InvalidOperation
  Exception
    + FullyQualifiedErrorId : An error occurred : The network path was not fou
   nd.
    If User Account Control (UAC) is enabled on the machine, close the applica
   tion, right-click the application, and then click Run as administrator.,Mi
  crosoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

Publish-AXReport : The deployment was aborted. You do not have privileges to
deploy to server: ignblr-pothuraj. For deployment, you must have
administrative rights to the SQL Server Reporting Services (SSRS) server.
Contact your administrator to deploy.
At line:1 char:1
+ Publish-AXReport -ReportName *
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : SecurityError: (Microsoft.Dynam...ReportsDeploye
   r:ReportsDeployer) [Publish-AXReport], SecurityException
    + FullyQualifiedErrorId : The deployment was aborted. You do not have priv
   ileges to deploy to server: ignblr-pothuraj. For deployment, you must have
   administrative rights to the SQL Server Reporting Services (SSRS) server.
  Contact your administrator to deploy.,Microsoft.Dynamics.AX.Framework.Man
agement.Reports.PublishReportCommand



Solution :
Remote Registry”-service is not enabled by default. After enabling and starting the service via Start -> Administrative Tools -> Services deployment of
 AX 2012 default SRS reports was successful. I suggest changing Start type from Manually to Automatic.




Friday, 10 October 2014

commands for Compilation of Ax2012 R3

 the Bellow commands for Compilation of Ax2012 R3

Open the command prompt  Run as Administrator

C:\Program Files\Microsoft Dynamics AX\60\Server\DynamicsAXR3\bin\
  axbuild.exe  xppcompileall  /s=01
     /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\6.0\Client\Bin"


CD  C:\Program Files\Microsoft Dynamics AX\60\Server\DynamicsAXR3\bin

above the installation of file path.

Cd   axbuild.exe  xppcompileall  /s=01
     /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\6.0\Client\Bin"


Thursday, 9 October 2014

Date Range query(From date ...Todate ) on MS Dynamics Ax using x++ code

 
    Query                   q;
    QueryBuildDataSource    qbd;
    QueryBuildRange         qbr,qbr1;

   // ret = super();

    q = new Query();
    qbd = q.addDataSource(TableNum( RateLine));
    qbr = qbd.addRange(FieldNum( RateLine, StartDate));
    qbr1 = qbd.addRange(FieldNum( RateLine, InflationTypeID));
    qbr1.value(InflationRate_Type.valueStr());
    qbr.value(strfmt('"%1".."%2"',FromDate.dateValue(), editEndDateRange.dateValue()));
    RateLine_ds.query(q);
    RateLine_ds.executeQuery();