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 DB6 , KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , BC-INS-SWPM , Installation with Software Provisioning Manager , 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.