During system copy with SWPM where the target IBM DB2 database is v9.1 or lower the following error is encountered:
Found Error, error_codes = <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 >).
IBM Db2 LUW 9.1
SWPM, control , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this pageThis 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.