SSRS compile error in visual studio

Finance and Operations/AX Developer Forum
1

Hello everyone,

We have several reports that were done by an external team, and right now, multiple reports have similar pattern of error when using Visual studio, as follows. I am pretty sure that the visual studio is using the correct configuration, as I modified the visual studio 2010 shortcut using /AXConfig parameter, like these pages say https://msdn.microsoft.com/en-us/library/gg889291.aspx

https://community.dynamics.com/ax/b/faisalfareedaxlibrary/archive/2015/02/09/configure-visual-studio-to-connect-open-with-correct-aos

Any advice greatly appreciated.

Error 1 Unable to connect to the AOS specified in the AX Client Configuration. The configuration could be missing, invalid, or the AOS is not running. To connect to the AOS, check the network connection between the client and the AOS, verify that a valid configuration exists, and that the AOS service is running on the server. C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets 103 6 ReportModel5

Error 2 The “GenerateRdlTask” task failed unexpectedly.

Microsoft.Dynamics.Framework.BusinessConnector.Session.Exceptions.NoKernelSessionException: Unable to connect to the AOS specified in the AX Client Configuration. The configuration could be missing, invalid, or the AOS is not running. To connect to the AOS, check the network connection between the client and the AOS, verify that a valid configuration exists, and that the AOS service is running on the server. —> Microsoft.VisualStudio.Modeling.ModelingException: Unable to connect to the AOS specified in the AX Client Configuration. The configuration could be missing, invalid, or the AOS is not running. To connect to the AOS, check the network connection between the client and the AOS, verify that a valid configuration exists, and that the AOS service is running on the server. —> Microsoft.Dynamics.Framework.BusinessConnector.Session.Exceptions.NoKernelSessionException: No .NET Business Connector session could be found.

at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsAdapter.GetObject(String objectName)

at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsAdapter.Microsoft.Dynamics.Framework.BusinessConnector.Adapter.IAxaptaAdapter.GetObject(String objectName)

at Microsoft.Dynamics.Framework.BusinessConnector.Proxy.ProxyObjectBase…ctor(IAxaptaAdapter axaptaAdapter, ProxyClassName className)

at Microsoft.Dynamics.Framework.BusinessConnector.OperationExecuter.HandleError(IAxaptaAdapter adapter, Exception businessConnectorException, Collection`1 messages)

at Microsoft.Dynamics.Framework.BusinessConnector.OperationExecuter.Execute[T](Collection1 messages, Func1 nodeAction)

at Microsoft.Dynamics.Framework.Design.Modeling.Interop.TreeNodeOperationExecuter.Execute[T](ITaskLogger logger, Func`1 nodeAction)

— End of inner exception stack trace —

— End of inner exception stack trace —

at Microsoft.Dynamics.Framework.Design.Modeling.Interop.TreeNodeOperationExecuter.Execute[T](ITaskLogger logger, Func`1 nodeAction)

at Microsoft.Dynamics.Framework.Design.Modeling.Interop.TreeNodeOperationExecuter.Execute(ITaskLogger logger, Action nodeAction)

at Microsoft.Dynamics.Framework.Deployment.Reports.GenerateRdlTask.SaveReport(ReportDefinition report, TreeNode reportNode, ReportAdapter reportAdapter, Dictionary`2 designRdlMap)

at Microsoft.Dynamics.Framework.Deployment.Reports.GenerateRdlTask.Execute()

at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()

at Microsoft.Build.BackEnd.TaskBuilder.d__20.MoveNext() C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets 103 6 ReportModel5

Thank you,
Kwen

2

3823.Error_compile.jpg
3823.Error_compile.jpg963×351 100 KB

3

The Error is self explanatory.

Check following scenarios.

  1. Check the Target property of the Visual studio shortcut and under that after /AxConfig there will be a path for AX config file. Note that path and check whether AX config file exists and it is connecting to which of your AOS server.

  2. Also check whether your AOS service is running or not.

4

Thank you for your reply, Lalit. Actually I found out the reason, but forgot to update this thread.

The root cause is the SSRS report file size is exceeding the limit, as there are multiple layouts for the report file, and each layout has several pictures embedded. So, the size was over 10M, we tried multiple times, the report can work correctly when the size is relatively small, but once over about 10M, the business connector cannot hold the report effectively and the connect is lost.

Solution is to create another SSRS file to have other layouts.

Marking this as resolved.