SQL Server Errors or Failures from Error: 8114 to Error: 8135

SQLServerF1

 

Error: 8114, Severity: 16, Error converting data type %ls to %ls.
Error: 8115, Severity: 16, Arithmetic overflow error converting %ls to data type %ls.
Error: 8116, Severity: 16, Argument data type %ls is invalid for argument %d of %ls function.
Error: 8117, Severity: 16, Operand data type %ls is invalid for %ls operator.
Error: 8118, Severity: 16, Column ‘%.*ls.%.*ls’ is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
Error: 8119, Severity: 16, Column ‘%.*ls.%.*ls’ is invalid in the HAVING clause because it is not contained in an aggregate function and there is no GROUP BY clause.

Error: 8120, Severity: 16, Column ‘%.*ls.%.*ls’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Error: 8121, Severity: 16, Column ‘%.*ls.%.*ls’ is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.
Error: 8123, Severity: 16, A correlated expression is invalid because it is not in a GROUP BY clause.
Error: 8124, Severity: 16, Multiple columns are specified in an aggregated expression containing an outer reference. If an expression being aggregated contains an outer reference, then that outer reference must be the only column referenced in the expression.
Error: 8125, Severity: 16, An aggregated expression containing an outer reference must be contained in either the select list, or a HAVING clause subquery in the query whose FROM clause contains the table with the column being aggregated.
Error: 8126, Severity: 16, Column “%.*ls.%.*ls” is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause.

Error: 8127, Severity: 16, Column “%.*ls.%.*ls” is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
Error: 8128, Severity: 10, Using ‘%s’ version ‘%s’ to execute extended stored procedure ‘%s’. This is an informational message only; no user action is required.
Error: 8129, Severity: 16, The new disk size must be greater than %d. Consider using DBCC SHRINKDB.
Error: 8131, Severity: 10, Extended stored procedure DLL ‘%s’ does not export __GetXpVersion(). Refer to the topic “Backward Compatibility Details (Level 1) – Open Data Services” in the documentation for more information.
Error: 8132, Severity: 10, Extended stored procedure DLL ‘%s’ reports its version is %d.%d. The expected version is %d.%d.
Error: 8133, Severity: 16, At least one of the result expressions in a CASE specification must be an expression other than the NULL constant.
Error: 8134, Severity: 16, Divide by zero error encountered.
Error: 8135, Severity: 16, Table level constraint does not specify column list, table ‘%.*ls’.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *