SAP Knowledge Base Article - Preview

3031086 - SQL1754N while installing a transport package

Symptom

Installation of a transport package fails with sql error SQL1754N.
  
=======================================================================================
Table /BIC/PZCBSORPL must be created in the database  Adjust table in DB >>>  
sql:  CREATE TABLE "/BIC/PZCBSORPL"  
("/BIC/ZCBSORPL" SAPDB6VARCHAR(000003)  DEFAULT ' ' NOT NULL,  
"OBJVERS" SAPDB6VARCHAR(000001)  DEFAULT ' ' NOT NULL,  
"CHANGED" SAPDB6VARCHAR(000001)  DEFAULT ' ' NOT NULL)  
IN "SAP#STABD"  
INDEX IN "SAP#FACTI"  
LONG IN "SAP#STABD"  
SQL1754N The index table space or long table spaceis not in the same  database partition group as the primary table space. SQLSTATE=42838  DDL time(___1): .........5 milliseconds
=======================================================================================


Read more...

Environment

  • SAP Netweaver any version
  • DB2 (DB6) any version 

Product

SAP NetWeaver all versions

Keywords

-1754 , 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.