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.
SAP Knowledge Base Article - Preview