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 ONE Support launchpad (Login required).

Search for additional results

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