SAP Knowledge Base Article - Preview

2270617 - Installation fails at 99% processing SP_A_DROP_INDEXES.mssql

Symptom

Installation fails at 99% while processing SP_A_DROP_INDEXES.mssql

The following error is displayed:

---------------------------
setup
---------------------------
Error processing SQL statements:
SQLStatement: CREATE PROC [SP_A_DROP_INDEXES] @TableName VARCHAR(255)
 AS
 BEGIN
  SET NOCOUNT ON
  IF ( SELECT OBJECT_ID(@TableName) ) IS NULL
   BEGIN
    PRINT 'Table does not exist'
    RETURN
   END
  DECLARE @SQL VARCHAR(8000),
          @Columnlist VARCHAR(8000),
          @Message VARCHAR(8000),
     ...

ADO Error:
Code = 0x80040e14
(Not a native OS error)
ADO Code meaning = IDispatch error #3092
Source = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@sql".

ADO Error 1 of 2
  Number      = 0x80040e14
  Source      = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@sql".
SQLState    = 37000
  NativeError = 137

ADO Error 2 of 2
  Number      = 0x80040e14
  Source      = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@sql".
SQLState    = 37000
  NativeError = 137

---------------------------
OK  
---------------------------


Read more...

Environment

  • Afaria 7.0
  • SQL Server database
  • Case sensitive server collation

Product

SAP Afaria 7.0

Keywords

install, fail, crash, error , KBA , MOB-AFA , Afaria , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.