SAP Knowledge Base Article - Preview

2771459 - SQL0286N occurred in phase MAIN_SHDCRE/EU_IMPORT2

Symptom

 You encounter the following error during the phase MAIN_SHDCRE/EU_IMPORT2

(IMP) ERROR: Task failed with error: (DB6) DDL statement failed with SQL error!
(IMP) ERROR:   (CREATE GLOBAL TEMPORARY TABLE "<TABNAME>" (  "ID" SAPDB6FIXCHAR(1) DEFAULT ' ' NOT NULL ,  "COL" INTEGER DEFAULT 0 NOT NULL  ) NOT LOGGED ON COMMIT DELETE ROWS)
(IMP) ERROR: (SQL error -286)
(IMP) ERROR:   Error message returned by DbSl:
(IMP) ERROR: SQL0286N  A table space could not be found with a page size of at least "4096" that authorization ID "SAP<SID>" is authorized to use.  SQLSTATE=42727


Read more...

Environment

IBM Db2 on Linux, Unix or Windows

Product

SAP enhancement package 1 for SAP NetWeaver Process Integration 7.1

Keywords

DEMO_GTT , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-UPG-RDM , README: Upgrade Supplements , 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.