alter table <FACT> CLUSTER <DIM> PACK returns -5015 during heterog migrat

[Former Member]

Hi

We are performing a heterogeneous migration from Oracle to MaxDB (NW70 SR1}. The Database load is failing on the SAPDFACT fact tables. It appears that the SQL engine is not aware of the enhancements delivered in the BW performance Pack (I'm assuming this from reading between the lines in the OSS notes - according to the online docs this alter table option doesn't exist..) . We are running 7.6.xx

We are performing this on a test system & this is our second attempt at migrating our Test BI system. The first attempt was successful. The SAP and MaxDB instances were deleted (SDBUNINST -all) and the system rebooted. I have performed the 2nd sttempt several times with the same result each time.

The load from R3load (R3LOAD_WL=1) is below:

-

---

E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64\R3load.exe: START OF LOG: 20080321211224

E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64\R3load.exe: version R7.00/V1.4

Compiled Apr 2 2006 22:45:33

E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 1100 -k 17egf5M50TL01eqtd1Ax3A17 -l SAPDFACT.log -nolog -c 0

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\bitadm\Application Data

CLIENTNAME=H1704688

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files\Common Files

CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

COMPUTERNAME=CMSAPDEV5

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=ada

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\bitadm

JAVA_HOME=C:\java_32

LOGONSERVER=
CMDC13

NUMBER_OF_PROCESSORS=2

OS=Windows_NT

Path=E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64;e:\sapdb\programs\bin;e:\sapdb\programs\pgm;C:\Program Files (x86)\Legato\nsr\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;e:\sapdb\programs\bin;e:\sapdb\programs\pgm;C:\Program Files (x86)\Legato\nsr\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=EM64T Family 15 Model 6 Stepping 8, GenuineIntel

PROCESSOR_LEVEL=15

PROCESSOR_REVISION=0608

ProgramFiles=C:\Program Files

ProgramFiles(x86)=C:\Program Files (x86)

R3LOAD_WL=1

SAPEXE=E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64

SAPINST_EXEDIR_CD=I:/MAXDB/IM_WINDOWS_X86_64

SAPLOCALHOST=CMSAPDEV5

SAPSYSTEMNAME=BIT

SECUDIR=E:\usr\sap\BIT\DVEBMGS00\sec

SESSIONNAME=RDP-Tcp#1

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP

TMP=C:\WINDOWS\TEMP

USERDNSDOMAIN=CSENERGY.COM.AU

USERDOMAIN=CSENERGY

USERNAME=bitadm

USERPROFILE=C:\Documents and Settings\bitadm

windir=C:\WINDOWS

(BUF) INFO: trying to allocate 1024 kB memory

(DB) INFO: connected to DB

(DB) INFO: The MaxDB logwriter is switched off#20080321211232

(TFH) INFO: Trying to open SAPDFACT.cmd

(TFH) INFO: SAPDFACT.cmd opened

(BUF) INFO: trying to allocate 1024 kB memory

(TFH) INFO: Trying to open
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.TOC

(TFH) INFO:
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.TOC opened

(TFH) INFO: Trying to close
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.TOC

(TFH) INFO:
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.TOC closed

(BUF) INFO: trying to allocate 1 kB memory

(RFF) INFO: loading table [HEADER]

(TFH) INFO: Trying to open
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.001

(TFH) INFO:
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.001 opened

(RFF) INFO: entering fread

(RFF) INFO: leaving fread

(RFF) INFO: end of data for table [HEADER]

(GSI) INFO: dbname = "BIT "

(GSI) INFO: vname = "ADABAS D "

(GSI) INFO: hostname = "CMSAPDEV5 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "CMSAPDEV5"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "2x AMD64 Level 15 (Mod 6 Step 8)"

(TFH) INFO: Trying to open C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\DDLADA.TPL

(TFH) INFO: C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\DDLADA.TPL opened

(TSK) INFO: Trying to open C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK

(TSK) INFO: C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK opened

(TSK) INFO: Trying to close C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK

(TSK) INFO: C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK closed

(TSK) INFO: Trying to rename C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK to C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK.bck

(TSK) INFO: C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK renamed to C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK.bck

(TSK) INFO: Trying to open C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK

(TSK) INFO: C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ADA\SYSTEM\CENTRAL\AS-ABAP\SAPDFACT.TSK opened

(TFH) INFO: Trying to open
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.STR

(TFH) INFO:
cmsapdev2\export_bit\ABAP\DATA\SAPDFACT.STR opened

(DB) INFO: /BI0/E0BWTCFC1 dropped#20080321211232

(SQL) INFO: Searching for SQL file DFACT.SQL

(SQL) INFO: Searching for SQL file
cmsapdev2\export_bit\ABAP\DB/ADA/DFACT.SQL

(SQL) INFO: Trying to open
cmsapdev2\export_bit\ABAP\DB/ADA/DFACT.SQL

(SQL) INFO:
cmsapdev2\export_bit\ABAP\DB/ADA/DFACT.SQL opened

DbSl Trace: EXECUTE on connection 0, rc=-5015 (POS(35) Missing keyword:DROP,MODIFY,COLUMN,ADD,NOT,SET,SAMPLE,FOREIGN,FACT,DYNAMIC,DIMENSION,BWHIERARCHY,ALTER)

(DB) ERROR: DDL statement failed

( ALTER TABLE "/BI0/E0BWTCFC1" CLUSTER ("KEY_0BWTCFC1T") PACKED )

DbSlExecute: rc = 99

(SQL error -5015)

error message returned by DbSl:

(DB) INFO: /BI0/E0BWTCFC2 dropped#20080321211232

etc

etc

[markus_doehr2 · Accepted solution]

> E:\usr\sap\BIT\SYS\exe\nuc\NTAMD64\R3load.exe: version R7.00/V1.4

> Compiled Apr 2 2006 22:45:33

Your R3load is ANCIENT

I highly suggest upgrading R3load and dbadaslib.dll and try again.

Markus

[Former Member]

The database version is 7.6.00.18

The strange thing is that the first trial migration worked with this version. Only after deinstalling everything and trying again are we getting this problem.

[Former Member]

Hi,

you spoke of kernel version 7.6.xx.xx.

Would you mind telling us the digits hidden by xx?

7.6.00.xy will not be able to handle this option with dbsl. Therefore, please check the exact version you are using and switch (if possible) to a newer one (7.6.01.00 at least).

Elke

[Former Member]

Thanks for the reply Markus.

I am getting the same error with the latest R3load (and library) as well.

I updated the DB.SAR files on the CD and received the error. Thinking there maybe a version mismatch somewhere, I reverted to the original DB.SAR files. Got the same error and captured the log above.

I have logged a OSS call as well.

Regards

Doug