Symptom
-
instdir_SAPDFACT.log
. . .
A1 ETSK 005 Starting create for object "<table_nm>~040" of type "index" #YYYYMMDDHHMMSS
A1 ESQL 004 index <table_nm>~040: SQL overridden by '/export/ABAP/DB/DB6/DFACT.SQL', line 21-24
A1EEIMP 010 Task failed with error: (DB6) DDL statement failed with SQL error!
A1EEIMP 010 (CREATE TYPE 2 INDEX "<table_nm>~040" ON "<table_nm>" ("<key_nm>" ) PIECESIZE ####### K)
A1EEIMP 010 (SQL error -156)
A1EEIMP 010 Error message returned by DbSl:
A1EEIMP 010 SQL0156N The name used for this operation is not a table. SQLSTATE=42809 -
DFACT.SQL
. . .
#
# DB2 : NATIVE SQL EXPORT GENERATED AT 20191213110412
#
ind: <table_nm>~0
sql: CREATE TYPE 2 UNIQUE INDEX "<table_nm>~0"
ON "<table_nm>"
Read more...
Environment
-
IBM Db2 LUW
-
SWPM heterogeneous system copy
. . .from . . . IBM Db2 LUW
. . . to . . . IBM Db2 LUW
Product
SAP ERP 6.0
Keywords
KBA , 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.