How do I publish AX 2012 SSRS Reports to default directory with this error?

(0) Share

Report

Posted on by Mark Simmerman

1,325

Thanks in Advance.

We are doing a test install of AX 2012 which works generally, but will not render reports. We discovered that the localhost/reports directory was empty. We follow the TechNet article "Deploy the default reports [AX 2012]" and received the following result:

PS C:\Windows\system32> Publish-AXReport -ReportName *
Deploying reports and related artifacts.
AOSName                   : 01@Server1
ConfigurationId           : Server1MSSQLSERVER
Description               :
Default                   : True
ReportServerFolder        : DynamicsAX
ReportServerName          : Server1
ReportServerInstanceName : MSSQLSERVER
ReportServerManagerUrl    : http://Server1/Reports
ReportServerWebServiceUrl : http://Server1/ReportServer

Publish-AXReport : Could not find file 'C:\Users\username\AppData\Local\Temp\2\dsxqyn8l.dll'. At line:1 char:17 + Publish-AXReport <<<< -ReportName * + CategoryInfo :

OpenError: (Microsoft.Dynam...shReportCommand:PublishReportCommand) [Publish-AXReport], FileNotFoundException + FullyQualifiedErrorId : Could not find file 'C:\Users\username\AppData\Local\Temp\2\dsxqyn8l.dll'.,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

Publish-AXReport : Could not find file 'C:\Users\username\AppData\Local\Temp\2\lu9end4i.dll'. At line:1 char:17 + Publish-AXReport <<<< -ReportName * + CategoryInfo :

NotSpecified: (:) [Publish-AXReport], FileNotFoundException + FullyQualifiedErrorId :

System.IO.FileNotFoundException,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

********************

An empty folder "Dynamics AX" was created in localhost/reports. I looked for both dlls on the server and could not find them (I would have inserted them in the above temp file).

We can see a list of reports when we run the management shell that are available to publish, and we ran the shell as administrator with an account with the highest privileges.

Any ideas?

Our test environment:

Single MS2008 R2 server with SQL Server 2008 installed with SSAS and SSRS. We have one AOS. All accounts to run services are domain user accounts which are over-privileged (login as Service, local server Admin group, SysAdmin on SQL). The server is a member of the domain. All users in AX 2012 are imported domain accounts that run fine.

Kind Regards,

Mark Simmerman

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

640579632b5c4e6780a... 4,730 on at

Like (0)

Report

Have you tried deploying report from AOT.

Also , can you validate you setting by going to DAT/System administration/Area page/Setup/business intelligence/Reporting services

Was this reply helpful? Yes No
Mark Simmerman 1,325 on at

Like (0)

Report

Thanks, Huzaifa. I should have mentioned that we already validated successfully.

We can publish a single report to the directory through AOT. We have not yet tested fully functionality. Our concern is that we want to publish all reports as part of the setup process.

We would very much like to avoid using the AOT to publish all of our reports if we can.

Was this reply helpful? Yes No
M.H.M.M. van den He... 750 on at

Like (0)

Report

I have posted the same issue on

community.dynamics.com/.../122885.aspx

Do you have an answer yet.

Was this reply helpful? Yes No
Mark Simmerman 1,325 on at

Like (0)

Report

I wish that I had a good answer for you. We reinstalled and this cleared up. Nothing that we changed one-at-a-time revealed anything useful before the reinstall and we had a schedule to keep. The three leading contenders are a corrupt file, a permissions issue, or we made a configuration choice that was incorrect. We were able to rule out solar flares and unfavorable biorhythms however. ;)

Kind Regards,

Mark Simmerman

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

For the life of me, I am also stuck with the same issue, and even after re-installing the 2nd report server twice, I wasn't able to get pass the error.

Any help to this matter would be appreciated. thanks.

Was this reply helpful? Yes No
Mark Simmerman 1,325 on at

Like (0)

Report

Jason, I will do my best, but since we did not do a controlled study of the problem to fully troubleshoot, so I cannot say that I know the root cause.

We are pretty sure this was a permissions issue with a path dependency element (changing paths mid process). One person started set up using a non-standard, non-microsoft supported approach, and then I came in later to try to clean up. In subsequent installs I have found certain approaches work better.

1. Set up RS on the same database server (2008 R2) with the non-IIS web method to deliver reports so you don't mixed roles on the SQL server.

2. Use dedicated domain user accounts with AD to create service accounts. You can right size privileges later, but giving them either sysadmin (server level) or dbo (database level) to start with shows that you can do the basic processes to begin with. Do not leave them so highly privileged; follow Microsoft guidence on access (AX 2012 Install Guide and TechNet are good starts) and experiment with giving each account the least operable privelege.

3. Two key service accounts will be the dbservice account running SQL and the BCP (business connector proxy) account running SSRS. The BCP account should have a SQL login and appropriate access to key databases (e.g. AX, Report Server, etc.). If the BCP account is correctly privileged to perform it's other functions, it will run and deploy reports correctly.

4. Before a new install or re-install, insure that you walk through the Reporting Services Configuration Manager (attention on Service Account, Web Service URL, Report Manager URL, and Execution Account primarily; the other sections can be important for other goals) and insure the key areas have the correct accounts and respond properly.

5. Attempt to deploy reports using the standard AX install (not PowerShell unless you are very technical and have experience with it). If you get an error, immediately check the Windows logs (see below; Application is most helpful, try System and AX specific logs too) to see what the problem is. An account (either service or the account you are logged on with to install) without sufficient write privileges to a directory can frequently be the culprit.

6. Follow the AX Install Guide's directions on providing an AD user group AX browers priveleges to the directory of reports once deployed.

I apologize for the general nature of this post. Troubleshooting is like pottery, you have to get your hands on it and shape the clay until you get a satisfactory result. If you have more detailed questions I will monitor this thread.

I hope this helps.

Mark Simmerman

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mark,

Thanks a lot for taking time to reply with such an elaborate answer. Really helps me to do a check on my own steps as well.

Point 1 to 4, I have already done so and is doing it exactly as per what your recommendation is.

for point 5, initially i tried deploying reports from AX but it failed (directly after I have finished the steps that is stated on MSDN site regarding the setup for 2nd report server). on my 2nd attempt, it also failed, however after an AOS service restart, deployment from AX works perfectly! so at least for the time being I am relying on this method to deploy reports.

For point 6, this seems pretty interesting as I am leaning towards that direction pertaining to folder security rights issue etc. Will take a closer look on this and revert.

One thing that is also quick 'funny' is that since I wasn't able able to find the DynamicsAXBrowser security role under the newly created "Dynamics AX" folder on the RS report manager. not sure if this is also caused by the same issue.

Again, thanks a lot Mark for your sharing.

Regards,

Jason Lee

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i can't find DynamicsAXBrowser role , any idea why ?

thanks

Was this reply helpful? Yes No
Tommy Skaue Moderator on at

Like (0)

Report

The DynamicsAXBrowser role only appear as soon as there are any AX reports published, as far as I remember.

Was this reply helpful? Yes No
Bart VDS 227 on at

Like (0)

Report

I had the same problem (missing DynamicsAXBrowser role) after installing a second SSRS Instance on the same machine. I did have reports published, and still no DynamicsAXBrowser role. I read somewhere that you can substitute the DynamicsAXBrowser role for the combination Browser and Content Manager. I tried this and it seems to work so far...

Was this reply helpful? Yes No