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.
SAP Knowledge Base Article - Preview