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 , tablespace pool , sql0204n , 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.