SAP Knowledge Base Article - Preview

2482610 - Attempt to convert virtual Table SVERS failed with dbcode -104

Symptom

  • During new installation, facing below error.

    Sapinst.log:
    Import Monitor jobs: running import of package: SAPNTAB
    Loading of 'SAPNTAB' import package: ERROR

  • SAPNTAB.log:
    =====================
    DbSl Trace: Failed to create table SVERS.
    (DB6) ERROR: Attempt to convert virtual Table SVERS failed with dbcode -104 .
    (DB6) ERROR: message text: SQL0104N  An unexpected token "{20}" was found following "NULL  ) IN <SID>#DATA".  Expected tokens may include:  "<space>".  SQLSTATE=42601
    (DB6) [IBM][CLI Driver][DB2/LINUXX8664] SQL0150N  The target fullselect, view, typed table, materialized query table, range-clustered table, or staging table in the INSERT, DELETE, UPDATE, MERGE, or TRUNCATE statement is a target for which the requested operation is not permitted.  SQLSTATE=42807

           (IMP) ERROR: InitFastload: rc = 2
           (DB) INFO: disconnected from DB

  •  SQL-error "-204-SQL0204N "<SAPSID>#DATA{number}" is an undefined name.     

Read more...

Environment

  • Db2 for Linux Unix and Windows database release: 10.5
  • SAP Kernel 7.45

Product

SAP Solution Manager 7.1

Keywords

IMPORT,EXPORT, DBSL, KERNEL, SL TOOLSET , KBA , cx_sy_open_sql_db , sql0104n an unexpected token "{20}" , swpm, create, table, dbif_rsql_sql_error , sql0204n , tablespace pool , 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.