Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
SSRS and SSAS Integration
Scheduling all other reports works fine. I've tried as report designer with access to all companies (about 10) and as an administrator. At first I thought it was because the report had not been generated yet? But I manually generated first, then let schedule run and still no affect. I thought it could it have something to do with not having a default company, but I changed from "@any" to a company and saved the report and still no luck. Security related?! Help?
AX 2009 SP1 RU8 (5.0.1500.6491), MR 2012 Ru1(2.1.1028.0)
You mention you are having trouble, but didn't mention if the reports never generate or if you get an error?
1. How long have you let the reports sit in the Report Queue?
2. Do you receive an error in the report queue?
3. If you check the event viewer on the server, does it provide any detail to the message?
April, thank you so much for your responsiveness!
The report with the report tree never generates via schedule. Other reports generate just fine (but not until the next day...here's another post I made on that topic: community.dynamics.com/.../151741.aspx )
Event Viewer Errors below in order in which they appear. I can send other Event Viewer Errors if necessary.
Microsoft.Dynamics.Performance.Reporting.DataProvider.Service.DirectLinkException: The operation could not be completed because the specified credentials are not valid.
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.ConnectInternal(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)
at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)
at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)
System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault]: The operation could not be completed because the specified credentials are not valid. (Fault Detail is equal to Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault).
System.Data.StrongTypingException: The value for column 'CompanyID' in table 'FRxReport' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.
--- End of inner exception stack trace ---
at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportTask.LoadReportDefinition(ReportScheduleTaskGetTaskInfoRow taskInfo, FileData reportFile, ReportDataSet reportDataset)
Thanks for sending the messages, they definitely help.
Click on the Report Scheduling tab and then double-click the schedule to open it.
Click on the Permission button. Update your credentials in there so the schedule can generate.
This should resolve it.
April, I tried updating the credentials and it still seems not to work...I guess I expect a new "version" to be created. It may be related to my other post where I set a scheduled time later in the day and it doesn't run until that time 24 hours later rather than running later the same day?
I've scheduled for tomorrow morning and will take a look then...
The report did not run even after waiting until the next day.
I did notice that it seems the .NET Business Connector from MR is connecting to AX at the scheduled time. This brings up a different question which is why these sessions don't close themselves out...I created a new post for that: https://community.dynamics.com/product/ax/f/33/p/81770/152324.aspx#152324
If you make a change to the schedule and change it you will not see a new versions. As long as you make the changes to the schedule before the start date and start time it should work. I have a few things for you to try, some will just provide more information.
1. Can you try deleting and re-creating the schedule?
2. Verify the start date is today and the start time is a few minutes after.
3. Does it ever hit the Report Queue?
4. If it doesn't hit the Report Queue, are you still getting the crednetial message every time in the Event Viewer? I want to narrow it down if its the same error each time.
5. Are the credentials/permissions you are entering those of a designer with access to all companies or an administrator?
If this doesn't provide any new info or changes, we may want to have you work with support so we can do a screen share and see the issue.
I deleted the Schedule, created a new one with time about 5 minutes ahead from present time.
I watched the report queue hitting "refresh" frequently... and it shows as "queued" then as "complete"
No new authentication related messages in Event Viewer but I do get this error reminding me support had to help me install since there is a bug with numeric companies/dataareaid (which ours are):
I've tried authenticating mostly as an "Administrator" trying to get it to work first, then I was going to try as a Designer before I install in production and set end-users loose on the new product.
Would LOVE to do a screen share....
Sorry, meant to to say report does NOT complete...hangs as "queued".
We have only seen this happen one other time and were not able to ever reproduce it. I think we will need you to work with Support on this so we can more accurately troubleshoot it by doing a screen share. I apologize for not having a quick resolution, but we will defintely get to the bottom of it. Please let me know if you need any assistance opening a support case.
We did get a report tree with multiple companies scheduled by doing 3 things.
1. We went to each company 01, 02 and 70 as an example from the Company menu and temporarily set each company as the “default” company…to make sure authentication is ok.
2. Per screen shot below we
a. Set Company Name to 02 in the report definition rather than @any
b. Set Company to 02 rather than @any in the report tree definition located at the Intersection of A 1…the company ID/tree
Microsoft acknowledges that A) this is by design …we just can't leave it set to @any if we want to schedule it. They may propose a better error message in the event log.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13