Self-Solve Knowledge Search

Minimize Maximize
I am getting a Microsoft 2012 SQL Error 42000-11502
This document has not been formally reviewed for accuracy and is provided as is
Title :
I am getting a Microsoft 2012 SQL Error 42000-11502
Document ID :
KM00837982
Product - Version:
service manager 9.33 ;
OS :
Updated :
Thu Apr 10 12:37:39 GMT 2014
Summary :
I am getting a Microsoft 2012 SQL Error 42000-11502 when I do a true search for CI's The System Version doesn't matter. I get the same error in my Out Of Box System as well as my Production System.
Problem

I am getting a Microsoft 2012 SQL Error 42000-11502 for all CI's in Service Manager.

The System Version doesn't matter. I get the same error in my Out Of Box System as well as my Production System.

4440(  2060) 04/02/2014 11:18:16  RTE A Mapping-3-cm3r,middle,assets, SQL Query incomplete because field (middle,assets) in file (cm3r) can not be used in an SQL query ; application(display), panel(process.option)
4440(  2060) 04/02/2014 11:18:16  RTE D sql diff 0.000  total 4.533  call#:13542 --> _prepare:SELECT m1."NUMBER" FROM CM3RM1 m1 JOIN CM3RM2 m2 ON (m1."NUMBER" = m2."NUMBER") WHERE ((m1."OPEN"=? and (m1."LOGICAL_NAME"=? or m2."AFFECTED_ITEM"=? or 1=1) and m1."DOWN_END">=? and m1."DOWN_START"<=?)) ORDER BY m1."NUMBER" ASC
4440(  2060) 04/02/2014 11:18:16  RTE D sql diff 0.000  total 4.533  call#:13543 --> _describe:SELECT m1."NUMBER" FROM CM3RM1 m1 JOIN CM3RM2 m2 ON (m1."NUMBER" = m2."NUMBER") WHERE ((m1."OPEN"=? and (m1."LOGICAL_NAME"=? or m2."AFFECTED_ITEM"=? or 1=1) and m1."DOWN_END">=? and m1."DOWN_START"<=?)) ORDER BY m1."NUMBER" ASC
4440(  2060) 04/02/2014 11:18:16  RTE E Error: SQL State: 42000-11502 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The type for parameter '@P2' cannot be deduced in this context.
4440(  2060) 04/02/2014 11:18:16  RTE I     Row Number = 1, Column number = -1
4440(  2060) 04/02/2014 11:18:16  RTE E API=SQLDescribeParam [in _describeBindVar], Statement=SELECT m1."NUMBER" FROM CM3RM1 m1 JOIN CM3RM2 m2 ON (m1."NUMBER" = m2."NUMBER") WHERE ((m1."OPEN"=? and (m1."LOGICAL_NAME"=? or m2."AFFECTED_ITEM"=? or 1=1) and m1."DOWN_END">=? and m1."DOWN_START"<=?)) ORDER BY m1."NUMBER" ASC
4440(  2060) 04/02/2014 11:18:16  RTE D sql diff 0.000  total 4.533  call#:13544 --> _errorStatement:ROLLBACK
4440(  2060) 04/02/2014 11:18:16  RTE E error:SQLBindParameter in _setBindVariables
4440(  2060) 04/02/2014 11:18:16  RTE W The following query can not be fully processed by the RDBMS and may be affecting performance.

Cause

The ODBC data source driver is causing this issue:

RTE E Error: SQL State: 42000-11502 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]

The customer is using a SQL Server Native Client ODBC data source driver instead use a SQL Server ODBC driver.

Fix
Create a new ODBC data source driver as SQL Server instead of SQL Server Native Client 11.0