Learn AX

Hi AX Technical, Today, in this post we will talk about an SSRS Report Error and its solution. Please have a look at the below error: If you are getting this below error that means you need to enable remote errors first. Please click on this link to check the solution. Once you enable the remote errors you can check for below error solution: Error : User 'UserID' is not authorized to select a record in table 'CustDefaultLocation'. Request denied. Cannot select a record in Customer default locations (CustDefaultLocation). Access Denied: You do not have sufficient authorization to modify data in database. (S)\Classes\xInfo\add (S)\Classes\Info\add - line 94 (S)\Data Dictionary\Tables\CustDefaultLocation\Methods\exists - line 6 (S)\Classes\LogisticsLocationDefault\defaultExists - line 18 (S)\Classes\LogisticsLocationDefault\findSimpleDefault - line 19 (S)\Data Dictionary\Tables\SalesTable\Methods\initFromCustTableMandatoryFields - l...

Hi AX Technical, Today, in this post we will share a very helpful trick to fight with below kind of error. Error : For more information about this error navigate to the report server on the local server machine, or enable remote errors. Here, we see there is no such description of the error. So first we need to enable remote errors in AX 2012. Solution : Please follow the steps below. Method 1: Open SQL Server Management Studio (SSMS) and create a query. Copy, paste the below query to check and update the value. -- SQL Query written by Chirag Gupta -- To Check the value USE ReportServer select * from ConfigurationInfo where name = 'EnableRemoteErrors' -- To Update the value if the value is false USE ReportServer GO UPDATE ConfigurationInfo SET Value = 'True' WHERE Name = 'EnableRemoteErrors' Method 2: Follow below procedure to enable remote error in SSMS for SSRS 1) Open SQL Server Management Studio and log in with ...

Hi Technical, Today, in this article we are going to share a solution for below error while printing SSRS Report in AX 2012. Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors. Solution: Step 1:  a) Navigate to System administration/Area page/Setup/Services and Application Integration Framework/Inbound ports. b) Click on BI Services and Deactivate this. c) Now, Activate the BI Services and for testing check any invoice report. It is works then okay otherwise check step 2 below. Note : No need to take a downtime for this step. Step 2: Restart SSRS Services and for testing check any invoice report. It is works then okay otherwise check step 3 below. Step 3:  a) Take a downtime for production if you are facing this issue in Live server. b) Delete all client session. c) Restart AOS. d) Restart SSRS Services. e) Now, check any SSRS Report, it should work. We hope thi...

Hi Folks, Today, in this post we are going to share a solution for below error. We got this error while running a SSRS Report from AX client. Error: The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was 'Element 'http://tempuri.org/:queryBuilderArgs' contains data from a type that maps to the name 'http://schemas.datacontract.org/2004/07/XppClasses:SrsReportProviderQueryBuilderArgs'. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver if you are using DataContractSerializer or add the type corresponding to 'SrsReportProviderQueryBuilderArgs' to the list of known types - for example, by using the KnownTypeAttribute attribute or by adding it to the list of known types passed to the serializer.'. Please see InnerException for more details. Soluti...

Hi Readers, Today, all users from my working location faced below issue when they were running SSRS Report on AX 2012 R2/R3 version. Error : No connection could be made because the target machine actively refused it 192.168.10.249:8201 Solution : Step 1: End all users session from AX by logging out online users from System Administrator. Step 2: Close your AX and restart AX services . Step 3: Restart SQL Server Reporting Services ( SSRS ). Now, you can run the reports successfully. Author : Chirag Gupta Microsoft Dynamics 365 AX Technical Consultant at IBM Bangalore Date : 9-Sep-2019 Happy Learning !!

Hi Readers, Today, in this post we will share a solution for SSRS report issue. You might have seen when you run the SSRS report, it runs successfully but data will not display on the report. We have a solution for this... Issue:  Data is not showing on SSRS Report in AX 2012 Resolution: First, we need to understand how SSRS Report works. 1) SSRS Report fetches the data from AX. 2) For testing purpose, put a “test” in report layout and deploy it. 3) If it’s deploy successfully run the report and check “test” is showing in the report or not. 4) If “test” is showing on the report then the issue for not printing the data on report is; SSRS Report is not configured correctly with AX. How to do it? 1) Click on start button and open Microsoft Dynamics AX Configuration Utility. 2) A dialog box will open like below: 3) In the configuration dropdown choose the right AX configuration file. 4) Restart the AOS services. 5) Restart the SSRS report service...

Hi Readers, Today, in this post we will share a very important solution for the below error. You may get this error at the time of report deployment in ax 2012 or may be when you are running a SSRS report. Error:  There was no endpoint listening at net.tcp:/your_server_name:8201/Dynamics AX/Services… "A call to the Microsoft Dynamics AX SRSFrameworkService service failed. There was no endpoint listening at net.tcp://############/DynamicsAx/Services/BIServices that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details." Solution: Method 1: 1) Go to System administration > Setup > Services & Application Integration Framework > Inbound ports. 2) Select BIServices port, activate same.  Note:  When you activate the same, you might get some more errors, please see the screen shot below: 3) Go to AOT >> Service Groups >...