Followers

30 November 2016

While generating the report BI Services problem.


   While running the SSRS report  got following error

    " BI Services problem"


Solution:


1)  Full CIL Compilation( if not started BI service) then process 2nd step
2) Stop AOS services
3) Delete the XPPIL folder
4) Start the AOS services


Check the BI services as below path

System Administrator> Setup>Application Integration Framework Services>Inbound>BI Servciesl

No report data table with name exists in report schema for data provider


   I was getting the  error message  when  running the report

   "No report data table with name exists in report schema for data provider"

Solution:

     1)  Restart the reporting services
     2)  Clear cache and the usage data
     3)  Restart the AOS
  


Parameter is missing a value" error running a customized report in Microsoft Dynamics AX 2012


whenever I added new parameter to the contract may fail with the following error:

The ‘Parameter Name’ parameter is missing a value

 Solution:


Recreate the parameter in Visual Studio and set the properties as required before deploying the report

1) In AOT, expand the SSRS Reports node, expand the Reports node and locate the report.

2) Right click on the report and select Delete. This will remove all customizations to the report from the current model/layer so make sure you create a backup if you think you might want to return to them.

3) Right click on the report and select Deploy element. You should now be at the point where you did not receive this error.

4) Open the report for editing in Visual Studio and refresh the dataset. The parameter will be created under the Parameters node. 

 5) Set Allow Blank and Nullable to True.

6.)Deploy the report.



 

Error while setting server report parameters. error message: the permissions granted to user 'Domain\User name' are insufficient for performing this operation.


For some user when you open the existing or default reports it may show some error which I mentioned below,

Error:

Error while setting server report parameters. error message: the permissions granted to user 'Domain\User name' are insufficient for performing this operation. (rsaccessdenied)


Solution:


Go to the web Reporting Services, navigate to the path http://ssrsreportservername/Reports/Pages/Folder.aspx, Go to Folder setting, then click New Role Assignment. The add the user or else group. Finally give the permission rights like, DynamicsAXBrowser, Reports., etc to the specific user and click OK button.
(or)

Else if the User is already created then delete that user and create the user again and assign the as it is.

A call to the Microsoft dynamics AX SSRS framework services failed


  while deploying the SSRS report  got following error

"A call to the Microsoft dynamics AX  SSRS framework services failed.An existing connections was forcibly closed by remote host".


Solution: 

> Stop Reporting Services
> Stop AOS Services
C:\Users\\App Data\Local\
> Take the backup of all AUC files.
> Remove the AUC files from Step3 path
> Start Reporting Services
> Start the AOS Services
> Run report through Power Shell

        publish-AXReport -ReportName *

    Reports are successfully deploy on my machine