Tag: Running

BC14, Business Central, Error, Event Log, Failed to reach status, How To, Information, On this Server, Running, Symbol Reference

Update Symbol Reference & Error: Failed to reach status ‘Running’ on this server – Additional information may be in the event log of the server

Ashwini Tripathi

Some time while working we notice below error; Server Instance fails to start.

One of my reader requested solution from me.

So, to generate error I have intentionally created the error to explain the process.

You should pay attention to the message, as it says Additional information may be in the event log of the server.

All errors represented in Error log, sometimes is too technical and don’t give right clue.

There could be other reason, I am representing one general error.

When this happens, series of error messages are generated. All of them may not be helpful to find exact error.

But if you seriously scan each error, something always you can find which can help you in identifying the error or cause of same.

Just like below message, here we can identify that error is in Page 41, due to which Metadata is not updated correctly, leading to failure to starting the Server Instance.

Once you fix the error, you may get error for another object and similarly you can fix that too.

Alternatively, you can compile all objects and find errors in objects modified by you and get done in one shot.

Once all error is resolved, you will be able to start the Server Instance.

If you don’t get modifications to objects available in your AL you can run below command, make sure you Run as Administrator.

Switch to Installation folder by default: –

C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\140\RoleTailored Client

And execute below command:

Finsql.exec Command=generatesymbolrefrence, Database=<Your BC Database>, ServerName=<Your SQL Server Name>

After this you should be ok to start your Server Instance and see modification in AL Project.

Advertisement
Report

The New Report Scheduling feature for end users running reports in Microsoft Dynamics Navision 2015

Ashwini Tripathi

The new Report Scheduling feature for end users running reports:

  • End user can schedule reports for later execution.
  • User can get to his next task quicker.
  • User has an inbox part for viewing the scheduled reports.

 A. Setting up the job queue to run a report

My Customer needs to run a number of long running reports and does not want to wait for them to complete.

The scenario is simplified because a typical customer setup would involve setting up a NAS instance to process the reports.

* Open the Job Queues page.

ReportSchedule-1

* On the Home tab, in the New group, choose New to set up a new job queue

ReportSchedule-2

* In the Code field, type Reports.

* Fill in the Description field My Report Schedule.

* Leave the Job Queue Category Filter field blank.

* On the Home tab, in the Process group, choose Start Job Queue.

* Close the Job Queue Card

ReportSchedule-3

A job queue with no filter runs the reports.

In many customer installations, the reports will be picked up by the DEFAULT job queue

B. Adding the Report Inbox to the Role Center

My Customer wants easy access to the reports that he has scheduled, so he adds the Report Inbox part to the Role Center page.

* To open the Role Center page that you want to customize, in the navigation pane, choose the Home button, then choose the Role Center menu item.

* On the Application menu , choose Customize, and then Customize This Page.

* In the Available Parts pane, select Report Inbox, and then choose the Add button.

* To move the Report Inbox part to top of the second column in the Role Center layout pane, select it and then use the Move buttons.

* (Optional) To add the My Job Queue to the Role Center, in the Available Parts pane, select My Job Queue, and then choose the Add button.

* (Optional) To move the My Job Queue part below the Report Inbox in the Role Center layout pane, select it and then use the Move buttons.

ReportSchedule-4

ReportSchedule-5

* Verify that the Report Inbox appears in the Role Center.

ReportSchedule-6

C.Scheduling a report and viewing the result

* On the Role Center, on the Report tab, choose Customer Order – Summary.

* On the report request window, choose the Print button, and then choose Schedule

ReportSchedule-7

* In the Schedule a Report window that appears, in the Description field type a different text.

* In the Report Output Type field, select the down arrow, and choose PDF.

* Choose the OK button.

ReportSchedule-8

* Go to the Report Inbox on the Role Center and show that the report appears when it is finished running.

* To view the report, select it in the Report Inbox, and then choose Show.

ReportSchedule-9

D. When a scheduled report fails

* Open the Role Center.

* On the Application menu , choose Customize, and then Customize This Page.

* In the Available Parts pane, select My Job Queue, and then choose the Add button.

* To move the My Job Queue part below the Report Inbox in the Role Center layout pane, select it and then use the Move buttons

* In the Role Center, go to the My Job Queue part.

We have already done above step in above steps. Let’s continue with next step. If not already done follow the steps as defined above.

* On the Role Center, on the Reports tab, choose Price List.

* In the Sales Type field select Customer.

* To schedule the report to run later, choose the Print button, then select Schedule.

* In the Schedule a Report window, leave the default values in fields and choose the OK button.

ReportSchedule-10

* When the error shows up in the My Job Queue part, select the error, and then choose Show Error.

* Read the error message, and then choose the OK button to close it.

ReportSchedule-11

* Open the Job Queue Log Entries page.

* Filter the list to display entries whose Status is Error.

* To view the error message, point to the Error message field for the entry, or, select the entry, and then on the Home tab, choose Show Error Message.

* Return to the Role Center, and then run the Price List report again.

* On the report request window, set the Sales Type field to All Customers, choose Print, and then choose Schedule.

* In the Schedule a Report window, leave the default values in fields and choose the OK button.

* In the Report Inbox on the Role Center, view the completed report.

ReportSchedule-12