SAP Knowledge Base Article - Preview

2702193 - The step drop_saptools with step key: Error SQL0104N

Symptom

During system copy with SWPM where the target IBM DB2 database is v9.1 or lower the following error is encountered:

  • Sapinst_dev.log:
    Found Error, error_codes[0] = <SELECT 'DROP SPECIFIC PROCEDURE SAPTOOLS.' || RTRIM(SPECIFICNAME) || ';' FROM ( SELECT SPECIFICNAME, COUNT(*) AS PARAM_CNT FROM SYSCAT.ROUTINES WHERE ROUTINESCHEMA = 'SAPTOOLS' AND ROUTINETYPE = 'P' AND LANGUAGE = 'SQL' GROUP BY SPECIFICNAME ) ORDER BY SPECIFICNAME ASC, PARAM_CNT DESC

    SQL0104N An unexpected token "" was found following ")". Expected tokens may
    include: "AS". SQLSTATE=42601>

  • ERROR 2018-00-00 00:00:00.000 (SIDADM) startInstallation) [CSiStepExecute.cpp:1102] id=controller.stepExecuted errno=FCO-00011 CSiStepExecute::execute()
    The step drop_saptools with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_DB6|ind|ind|ind|ind|db6|0|drop_saptools was executed with status ERROR (Last error reported by the step: Error occured, first error is: <SQL0104N An unexpected token "" was found following ")". Expected tokens may >).


Read more...

Environment

IBM Db2 LUW 9.1

Keywords

SWPM, control , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

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

Search for additional results

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