question

DanielM-6075 avatar image
0 Votes"
DanielM-6075 asked DanielM-6075 commented

Unknown SQL Exception 201 occurred. Additional error information from SQL Server is included below. Procedure or function proc_StartTimerRunningJob expects parameter @ServiceId, which was not supplied

Hi,

We have just set up a test farm for Sharepoint 2019 and I am getting this error message spammed in the ULS logs.
Unknown SQL Exception 201 occurred. Additional error information from SQL Server is included below. Procedure or function proc_StartTimerRunningJob expects parameter @ServiceId, which was not supplied

Does anyone know how to fix this?

Here is the context from the correlation ID
The error message is in swedish which, in the title, I have translated as best as I can. Ask if you need to translate more.

90348-sqlerror201.png


office-sharepoint-server-itpro
sqlerror201.png (87.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered DanielM-6075 commented

Hi @DanielM-6075 ,

Are there any error messages on Modern UI? Was there an issue when setting up the farm? Has the farm been established successfully now? Is there an issue with the database connection?

Please also make sure that the farm meets the requirements.
Hardware and software requirements for SharePoint Server 2019


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DanielM-6075 , how are things going? Is there any update?

0 Votes 0 ·

Hi Elsie,

Everything works in the farm, except these error messages I find in the ULS logs. We have web applications and we have content databases and managed metadata service that works.
We can see pages from sharepoint in the web browser, no problem at all.

Maybe I wasn't clear about that. We are not in the installation phase. We have had the farm up for quite a while.

0 Votes 0 ·

Hi @DanielM-6075 ,

This is a general error message. Sometimes various error messages do appear during configuration, and some are even misleading. If there is no issue with the farm, don't worry.

If you have any other questions in the future, you could post in Q&A, we will do our best to help you.

Thank you for your understanding and support. :)

Have a nice day!

Thanks,
Elsie Lu


0 Votes 0 ·

I'd rather not just ignore this.
Each ULS log file being created every 15 minutes is ~175MB instead of the usual 12MB.
Isn't there any fix or reason why this error occurs?

0 Votes 0 ·
sadomovalex avatar image
0 Votes"
sadomovalex answered

based on the stored proc name (proc_StartTimerRunningJob) it may be related with Timer Jobs infrastructure. Is Sharepoint Timer Service working? Does it use farm admin account? Did you try to restart all servers at farm?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.