The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا
Wednesday, August 17, 2016
Sunday, May 22, 2016
SQL Server 2014 build versions
SQL Server 2014
build versions
This article lists
the Microsoft SQL Server 2014 builds that were released after SQL Server 2014
was released.
SQL Server 2014 Service Pack 1 (SP1) and cumulative update (CU) builds
Cumulative update name
|
Build version
|
Knowledge Base number
|
SQL Server 2014 SP1 CU6
|
12.0.4449.0
(latest build)
|
|
SQL Server 2014 SP1 CU5
|
12.0.4439.1
|
|
SQL Server 2014 SP1 CU4
|
12.0.4436.0
|
|
SQL Server 2014 SP1 CU3
|
12.0.4427.24
|
|
SQL Server 2014 SP1 CU2
|
12.0.4422.0
|
|
SQL Server 2014 SP1 CU1
|
12.0.4416.1
|
|
SQL Server 2014 SP1
|
12.0.4100.1
|
SQL Server 2014 cumulative update (CU) builds
Cumulative update name
|
Build version
|
Knowledge Base number
|
CU13
|
12.0.2568.0
(latest build)
|
|
CU12
|
12.0.2564.0
|
|
CU11
|
12.0.2560.0
|
|
CU10
|
12.0.2556.4
|
|
CU9
|
12.0.2553.0
|
|
CU8
|
12.0.2546.0
|
|
CU7
|
12.0.2495.0
|
|
CU6
|
12.0.2480.0
|
|
CU5
|
12.0.2456.0
|
|
CU4
|
12.0.2430.0
|
|
CU3
|
12.0.2402.0
|
|
CU2
|
12.0.2370.0
|
|
CU1
|
12.0.2342.0
|
Ref : https://support.microsoft.com/en-us/kb/2936603
Tuesday, May 17, 2016
Ax error " A user session on the server could not be created. Try to start the client again. If the problem continues contact Ax Administrator
Cause:
AOS has no access to createusersessions stored procedure in the database.
Even there will not be any log in Event Viewer for this issue.
Whenever C:drive of AOS server gets full then this will occur.
Resolution:
Clear the C: drive at-least to 2 GB to run the application.
Best way is to shirk the SQL databases.
Regards,
Tuesday, May 10, 2016
The user or group name 'DmainName\UserId' is not recognized in AX 2012 R3
Hi,
When you restore the AOS database from 1 environment to another where there is no relation of domain or user then you will encounter above mentioned error nduring report server validation / creation of folder / making default.
Reason: Existence of records of parent server in the table SysServerSessions. though you added the new server details as record in SQL level, you needs to delete those records too.
Hope this will solve your error.
Thanks,
When you restore the AOS database from 1 environment to another where there is no relation of domain or user then you will encounter above mentioned error nduring report server validation / creation of folder / making default.
Reason: Existence of records of parent server in the table SysServerSessions. though you added the new server details as record in SQL level, you needs to delete those records too.
Hope this will solve your error.
Thanks,
Sunday, May 1, 2016
The internal time zone version number stored in the database is higher than the version supported by the kernel (8/7). Use a newer Microsoft Dynamics AX kernel
Hi,
This is the error which arrives when you start the service after restoring the database from DB to this concern DB.
This is due to mismatch of the time zone in the AX system.
This error can be noticed only in the event log.
Resolution:
Open SQL 'SQLSystemVariables' table and edit the record in 'SYSTIMEZONEVERSION' column from 8 to 7.
Regards,
This is the error which arrives when you start the service after restoring the database from DB to this concern DB.
This is due to mismatch of the time zone in the AX system.
This error can be noticed only in the event log.
Resolution:
Open SQL 'SQLSystemVariables' table and edit the record in 'SYSTIMEZONEVERSION' column from 8 to 7.
Regards,
Sunday, April 17, 2016
SQL Server 2014 installation Reporting Services Catalog error
Hi,
ERROR: Reporting Services Catalog Database File Existence or Reporting Services Catalog Temporary Database File Existence.
Cause : Earlier installed SQL instance leaves the reporting service files which are all in *.mdf file format stops to recreate.
Solution : Needs to delete those files which are all present in the below mentioned location.
'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA'
that needs to be repeated for all the 3 folders which I highlighted in trail images.
Regards,
Subscribe to:
Posts (Atom)
Get a table ID in SQL / table browser - D365
Hi select ID from SysTableIdView where SysTableIdView .Name = 'CustTable' <URL>/?cmp=<CompanyID>&mi=sysTableBrowser...
-
Hi, AccountingDistribution ( accounting distribution 7452 ) AccountingDistributionEventTmp ( accounting distribution 100001 ) Accountin...
-
//< What is GUID> // GUID 16 bit large range of alphanumeric similar to RecID to treat as primary key of a table. static void CreateG...




