If you get lots of phone calls that the users can’t do anything because one single user is locking the table you quickly end up in a stressful situation. This entry will be about to how to solve the locking and hopefully find the user that created the lock.
Read the rest of this entry »Tag Archives: OnPrem
How to Find a User From the User Telemetry ID
In my previous log entry I described how to find activity for a specific user in telemetry from Microsoft Business Central. This entry will be about doing the opposite, having a User Telemetry ID and then try to find which user it belongs to. The solution to this varies depending on which Business Central version you are running and which platform.
Read the rest of this entry »How To Show Business Central Server Information In Telemetry
In Business Central it is standard to not show server specific information in telemetry. The reason for this is that many run the SaaS version which makes server information irrelevant since the end users don’t need to care about server information. However, some us still have customers that run OnPrem which this information can be quite useful. One of our customers has multiple servers with job queues activated on all of them. One way of troubleshooting job queues is to look at if a certain server is the source of problem and to do that we need server information in the telemetry.
In this blog entry I will explain how you can create your own telemetry message that send the job queue entry status and server information to application insights.
Tag: 0000G92 – Sales Header must not be temporary
Are you running OnPrem and you get a lot of warnings “Tag: 0000G92 – Sales Header must not be temporary” or “Tag: 0000G95 – Sales Header must not be temporary” in the event viewer like this?
Read the rest of this entry »Business Central: Cannot determine the frame size or a corrupted frame was received.
We were setting up a new customer with Microsoft Business Central OnPrem and I tried to download the symbols from the customer remotely.
I knew the NST and firewall was configured but I still got the following error message when I ran AL:Download Symbols:
[2023-02-02 10:37:32.45] Using reference symbols cache path: c:\GIT\algo\BC21.alpackages
[2023-02-02 10:37:32.46] Sending request to https://<CompanyURL>.com:7389/<BC INSTANCE NAME>/dev/metadata?tenant=default
[2023-02-02 10:37:32.54] Error: The SSL connection could not be established, see inner exception.
Cannot determine the frame size or a corrupted frame was received.
[2023-02-02 10:37:32.54] Error: An error occured while processing the request.
Request ID: a8739f78-4316-4c39-ad9b-1353bddbee16
Session ID: 00721ee7-41e7-4f25-b1fc-354139dba1a6
If you are targeting a cloud instance, supply these IDs if contacting Microsoft support.
[2023-02-02 10:37:32.54] Sending request to https://<CompanyURL>.com:7389/<BC INSTANCE NAME>/dev/metadata?tenant=default
[2023-02-02 10:37:32.64] Error: The SSL connection could not be established, see inner exception.
Cannot determine the frame size or a corrupted frame was received.
[2023-02-02 10:37:32.64] Error: An error occured while processing the request.
Request ID: 6294518c-9186-4d82-bc5b-3dcf89a8c8be
Session ID: 00721ee7-41e7-4f25-b1fc-354139dba1a6
If you are targeting a cloud instance, supply these IDs if contacting Microsoft support
It turns out our technician had forgotten to enable the setting DeveloperServicesSSLEnabled to true.
Once activated it worked with downloading the symbols
.
.
Business Central: Can’t find/get invoices with API
We had a scenario were we did an OnPrem installation for a customer (BC 19.x). We had set up three NST, one for web clients, one for job queue and one for API. We had a Cronus database as a base were we created a new empty company besides the cronus company.
When we wanted to get posted invoices via API we couldn’t find any even though we had posted several invoices(!). First we thought something was wrong with the API NST but we could reach other companies and it became even weirder when we tried to access invoices in the cronus company, then it worked!
So why the hell did it work against the Cronus company in the same database with the same NST BUT NOT for our newly created company!? 🤔
Read the rest of this entry »Business Central, CSIDE objects not included in symbols
Do you want to go hybrid where you mix your Business Central extensions with CSIDE objects and have problems with getting these objects included in symbols? Then you will find a checklist here that hopefully helps you to solve that issue.
Read the rest of this entry »