SAP Knowledge Base Article - Preview

2487625 - SQL0104N An unexpected token Files/sapinst_instdir SQLSTATE=42601 RESTORE DB database_restore_script.sql DB6 DB2 LUW Windows

Symptom

  • Refreshing DB2 LUW database using SWPM (SAP Software Provisioning Manger) on Microsoft Windows
  • The step GenerateDatabaseRestoreScript reports error in sapinst_dev.log:

    GenerateDatabaseRestoreScript was executed with status ERROR ( Last error reported by the step: Error occured, first error is: <SQL0104N  An unexpected token "Files/sapinst_instdir/NW###/DB6/COPY/SY" was >).

  • Full error returned by DB2 LUW:

    SQL0104N  An unexpected token "Files/sapinst_instdir/NW###/DB6/COPY/SY" was found following "<identifier>".  Expected tokens may include:  "END-OF-STATEMENT".  SQLSTATE=42601

Read more...

Environment

  • SWPM sapinst
  • DB2 LUW on Microsoft Windows

Keywords

TRACE Administrator startInstallation Found Error error_codes RESTORE DB  FROM BACKUP TO INTO REPLACE EXISTING REDIRECT GENERATE SCRIPT C:\Program Files sapinst_instdir NW DB6 COPY SYSTEM STD AS-ABAP REF database_restore_script.sql SQL0104N An unexpected token Files/sapinst_instdir/NW###/DB6/COPY/SY was found following "<identifier>"  Expected tokens may include  "END-OF-STATEMENT"  SQLSTATE=42601 ERROR bas REL bc_ src ins SAPINST impl src sapinst CSiStepExecute.cpp id controller stepExecuted errno FCO-00011 The step GenerateDatabaseRestoreScript with step key NW_ABAP_DB_DBRefresh ind NW_ABAP_DB NW_CreateDBandLoad createdbandload NW_CreateDB createdb NW_DB6_DB db6 NW_DB6_Database_Refresh executed with status ERROR Last error reported by the step Error occured first is syslib filesystem syxxcfile.cpp CSyFileImpl decideIfMoveCopyNode const CopyMoveDestinationInfo m_nodeTypeForCombiCheck m_path INSTANA.2.XML m_realNodeType ISyNode CopyMoveMode_t PSyNode Target node does not exist and mode ISyNode MISSING I will copy move WARNING modlib iaxxbjsmod.cpp id modlib.jslib.childAppReturn Execution of the command db2 db2_software BIN db2cmd.exe /C /w /i db2 -td; -vf database_create_restore_script.sql -r database_create_restore_script.res -z database_create_restore_script.out  finished with return code 4 Output SWPM Software Provisioning Manager DB2 LUW on Microsoft Windows refreshing database using SAP step reports error in sapinst_dev.log was  , 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.