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

ISSUE:

When you deploy the report in Dynamics AX 2012 or D365F&O and you try to view the report and get the error "no report data table with name exists in report schema for data provider".

SOLUTION:

Just restart your report server service from the services console and the error will be resolved.

Thank you,

Error: The report server isn’t configured properly, SSRS report deployment error.

Error:

The service is not available.

The report server isn’t configured properly. Contact your system administrator to resolve the issue. 

System administrators: The report server can’t connect to its database because it doesn’t have permission to do so. 

Solution:

Use Reporting Services Configuration Manager to update the report server database credentials.

This issue "The report server can’t connect to its database because it doesn’t have permission" might occur if the account that the report server uses to connect to the report server database is:

• Disabled or Locked.
• Its password has changed recently.
• It doesn't have owner permission on the Report Server databases (its permission has revoked).
• This Report Server account can be one of the below types:
• Windows domain user account.
• SQL Server account.
• The same service account that used to run the Power BI Report Server service.

And, you can find the current report server account login type at

Report Server Configuration Manager > Database > current report server database credential:

Update your current credential or add admin credential.

Error Access Denied while generating Full/Incremental CIL Ax 2012

Hi,

Today i faced an issue where i needed to generate Full/Incremental CIL, but i was not able to generate.

Error:
Access to the path 'C:\Program Files\Microsoft Dynamics AX\60\Server\AOSName\Bin\XppIL\xml\AppObjects1.xml' is denied.

Solution:

1. Goto the Aos services i.e.., Win+R then type services.msc and press OK and search your AOS.

2. check the "Log on as" column of your particular aos, "Log on as" will have user name which runs AOS.

3. Then press Win+R and type compmgmt.msc and press OK.

4. Then navigate to System Tools -> Local Users and Groups -> Groups -> then right click on 
"Administrators" in right pane -> properties -> check if the user name in step 2 is there, if not then add the user.

5. Stop AOS.

6. Backup XppIL folder and delete it from Bin folder.

7. Start the AOS.

8. Perform Full CIL.