Skip to Content
0
Former Member
Sep 18, 2013 at 01:23 PM

The associated partition function 'BI TABLE_PFUN000' generates more partitions than there are file groups mentioned in the scheme

112 Views

Dear Friends,

I'm migrating a ABAP BW production ( SAP NW 7.31) system from Source (Unix+ Oraclde ) to Target ( Windows + SQL Server).

We imported the exported data into the target system first time and it went very well without any errors. During the real migration, we tried to perform the Database Refresh / Move option in SWPM and tried to import the latest dump.

This time we faced some issues related to partition tables. The error log is as follows

(SQL) INFO: O:\ABP_Export\export\DB/MSS/DODS.SQL opened

DB) ERROR: DDL statement failed

(DROP TABLE [BI TABLE])

DbSlExecute: rc = 103

(SQL error 3701)

error message returned by DbSl:

Cannot drop the table 'BI TABLE', because it does not exist or you do not have permission.

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE PARTITION SCHEME ["BI TABLE" _PSCH000] AS PARTITION [BI TABLE_PFUN000] TO ( [PRIMARY], [PRIMARY], [PRIMARY] ) )

DbSlExecute: rc = 99

(SQL error 7707)

error message returned by DbSl:

The associated partition function 'BI TABLE_PFUN000' generates more partitions than there are file groups mentioned in the scheme 'BI TABLE_PSCH000'.

(DB) INFO: disconnected from DB

J:\usr\sap\ABP\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

J:\usr\sap\ABP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20130914052847

I did a comparsion with the DODS.SQL file and found the partition in the source system and the SQL file is similiar .

As a work around, I deleted the partition functions & Partition Schemes using SQL Studio and tried to re-trigger the import monitor in the Target system . This time the partition function / Scheme was created successfully by SWPM.

Now my main query is whether this will have any negative impact in the system or is the procedure followed is correct ?

Can some one help me on this issue ? This is bit urgent

Thanks in advance

Vimal