R3load table splitting into packages

[former_member270453]

Hello all,

We are running Software provisioning manager -> "table splitting preparation" with R3load. In Phase "Oracle table splitter" we receive error for 1 table.

From table split log file we have following error:

ERROR: partitioning of table APQD in packages of max. 1031669 rows is not possible. (screens attached)

Is there any parameter that should be set for this ? I have check sap notes about table splitting 1043380, 936441 but there are not mentioned any parameters that could be set.

Thanks for any suggestions

regards

Zdeno Makys

[former_member270453]

Hi guys, thank you for answers!

We will probably try to find another way to solve this (other than deleting data from table APQD). Since this issue happened in test we can expect more errors in production environment where deleting production data wont most likely be an option.

Thanks for any other suggestions

Regards

Zdeno Makys

[Former Member]

Hi Zdeno,

I am facing a similar error. Tried splitting with a lesser number of splits, but it didn't help.

Did you manage to get any work around.

Regards,
Dishu Thomas.

[Reagan]

Hello

Delete the unwanted data and then do an export of the table.

Truncate the table and then import the data back.

If you don't want to import them then do a quick truncate.

18307 - Batch input logs and reorganization

36781 - Table APQD is very large

Regards

RB

[ACE-SAP]

Hi

Table APQD should not get that big, may be there are cleanup jobs that are not scheduled on your system (=> job SAP_REORG_BATCHINPUT)

36781  - Table APQD is very large

16083  - Standard jobs, reorganization jobs

You could also use table splitting script from that note as you are using Oracle

  1043380 - Efficient Table Splitting for Oracle Databases

Regards