question

Tilicho-7232 avatar image
0 Votes"
Tilicho-7232 asked ErlandSommarskog commented

Error: 7884, Severity: 20, State: 1. (Params:). The error is printed in terse mode because there was error during formatting.

Error seen:
Error: 7884, Severity: 20, State: 1. (Params:). The error is printed in terse mode because there was error during formatting.

This is for 2014 SQL server with alwaysOn group that hosts databases for Sharepoint. All are virtual machines on esxi. Over a week back this noticed popped up (the server has been in production for about two years and first time witnessing the error). Ran consistency check on the databases and no errors.

The error popped up again after a week yesterday. Ran checksum and no errors. And again this afternoon.

I have gone through numerous links in the web and none seem to be helpful. There are no errors in sql log prior to or after that one particular error shows. No error in event viewer either during that time.

Looking at sessions, one time the session id seem to point the web front end of sharepoint as source with secure store database as backend. Second time the session id showed the application server as source that was using the search database.


https://social.msdn.microsoft.com/Forums/en-US/5d9a6149-043b-4fed-9909-078b7b870239/the-error-is-printed-in-terse-mode-because-there-was-error-during-formatting?forum=sqldatabaseengine

wasn't helpful in that it talks about sql profiler (since the error is sporadic running profiler forever doesn't help) and also the microsoft connect sites some of these articles references are no longer in use. I have "googled" and not found anything substantial.

Any tips or recommendations would be appreciated.

sql-server-generalsql-server-transact-sqloffice-sharepoint-server-administration
· 3
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.

Where do you see this error? Have you looked in the SQL Server errorlog?

What is the output of "SELECT @@version"?

0 Votes 0 ·

The error is from the SQL Server Logs. Nothing in the SQL Server Agent error logs. And nothing in windows applications, security, or system logs around the time that the error in sql server logs showed.

Version is sql 2014 with SP3.

0 Votes 0 ·

@ErlandSommarskog @TomPhillips-1744 @AmeliaGu-msft

Lowered the max memory in primary replica (alwayon group has two replicas. The secondary had a limit set and primary didn't. So had primary match up with secondary). Some time after the change got the same error which I ignored since the server hadn't been rebooted.

Servers were rebooted over weekend. Encountered two episodes of the errors again today. The extended events points to the sharepoint portal content database with client being the sharepoint webserver1. The other time it was for the same database but from sharepoint webserver2. Both cases ties the username to the application pool service account. It has a lengthy sql text and look similar in both incidents.

There are no errors right before this happens. Right after though is followed by message of transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. The victim is the process id that generates the 7884 error.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered Tilicho-7232 commented

Rather than using Profiler, you can use an Extended Events session. This is useful so far, that you can capture only the even error_reported, but with this event also get the statement which produced this error. This is difficult to achieve with Trace/Profiler.

I have an article on my web site on how to set up such an event session and how to query it: https://www.sommarskog.se/Short%20Stories/trace-exceptions.html.

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

Thank you! The blog was helpful in setting up the extended event. I have "error_reported" selected with "client_app_name, client_hostname, database_name, server_principal_name, session_id, session_nt_username, sql_text, tsql_frame, tsql_stack, username" selected for global fields. The data storage is set to save to file with max size 1 GB with rollover.

Hopefully, it helps to catch the culprit. I will update after the error pops up again.

0 Votes 0 ·

Hi Tilicho-7232,

How are things going?
Have you captured any exceptions?
Please feel free to let us know if you have any other question. If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
Tilicho-7232 avatar image Tilicho-7232 AmeliaGu-msft ·

@ErlandSommarskog @TomPhillips-1744 @AmeliaGu-msft

Lowered the max memory in primary replica (alwayon group has two replicas. The secondary had a limit set and primary didn't. So had primary match up with secondary). Some time after the change got the same error which I ignored since the server hadn't been rebooted.

Servers were rebooted over weekend. Encountered two episodes of the errors again today. The extended events points to the sharepoint portal content database with client being the sharepoint webserver1. The other time it was for the same database but from sharepoint webserver2. Both cases ties the username to the application pool service account. It has a lengthy sql text and look similar in both incidents.

There are no errors right before this happens. Right after though is followed by message of trasaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. The victim is the process id that generates the 7884 error.

0 Votes 0 ·
Show more comments
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

This kind of error is almost always related to a memory allocation error. I would try reducing your max server memory setting a little and see if you get a real error message.

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.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog commented

I don't think we come any further with this. If you want to know more, I think you need to open a support case. Which means that you must have purchased extended support, since you are on SQL 2014. To me, this seems like something internal in SQL Server.

Then again, beside the mystery, have you any real problems with things not working properly?

· 2
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.

No support was purchased. I think the norm is to open a ticket with MS and pay on ticket basis. I doubt that will be approved.

Besides the mystery, no issues that I am aware of. I am not a sharepoint person and tagged others here from Sharepoint community hoping they would be able to help. I have checked the databases for consistency and returned 0 errors.

Received two more errors this morning. It is starting to get more frequent now than it was before in that I received the second occurrence of the error after a week of the first one. Now it is like every few days or two days in a row (yesterday and today).

0 Votes 0 ·

I will have to admit that it gives an uneasy feeling. Nothing is real problem yet, but nay be the house is about to crumble totally?

0 Votes 0 ·