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 , sql0204n , tablespace pool , cx_sy_open_sql_db , sql0104n an unexpected token "{20}" , swpm, create, table, dbif_rsql_sql_error , 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.