Forums

Hello Scott,

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?

Thanks,

April

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.DataProvider.Server.DirectLinkService.<>c__DisplayClass6.<Connect>b__5()

  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.

  at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ReportDataSet.FRxReportRow.get_CompanyID()

  --- End of inner exception stack trace ---

  at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ReportDataSet.FRxReportRow.get_CompanyID()

  at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportTask.LoadReportDefinition(ReportScheduleTaskGetTaskInfoRow taskInfo, FileData reportFile, ReportDataSet reportDataset)

  at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportTask.Run()

********

Hello Scott,

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.

Thanks,

April

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?  

community.dynamics.com/.../151741.aspx

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

Hello Scott,

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.

Thanks,

April

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):  

*****

System.Data.StrongTypingException: The value for column 'CompanyID' in table 'FRxReport' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.

  at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ReportDataSet.FRxReportRow.get_CompanyID()

  --- End of inner exception stack trace ---

  at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ReportDataSet.FRxReportRow.get_CompanyID()

  at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportTask.LoadReportDefinition(ReportScheduleTaskGetTaskInfoRow taskInfo, FileData reportFile, ReportDataSet reportDataset)

  at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportTask.Run()

****

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".

Hello Scott,

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.

Thank you,

April