Error: Realignment for planning object structure & terminated with errors

[Former Member]

Hi All,

I usually encounter this error when running program /SAPAPO/TS_REALIGN_COPY in the background. Whenever, this error is encountered the realignment table is cleaned from where the status was not updated. In addition, the unix file is also cleaned. These are just a work around. Is there a permanent way to eliminate this problem??

Hope to hear a feedback soon.

Thanks a lot.

[Former Member · Accepted solution]

Hi Timmy,

Could you post the error which you see so that one of us can help you

Regards

Kumar Ayyagari

[Former Member]

Hi,

The error is : (as mentioned in the job log)

Step 028 started (program /SAPAPO/TS_REALIGN_COPY, variant ZCOPY_NEW, user ID SAPBATCH)

Realignment of generated selections in planning area /data/xfer/bap/DP/pipo/realigntotal.txt

SQL: 22.05.2007 21:50:53 SAPBATCH

DELETE FROM "/BIC/FZDP_WER" WHERE KEY_ZDP_WER1

IN ( SELECT "DIMID" FROM "/BIC/DZDP_WER1" ,

"/BI0/SPLANT" , "/BI0/SSALESORG" ,

"/BIC/SZMATATTRN" , "/BIC/SZMATERIAL" ,

"/BIC/SZTRDPARTN" WHERE

"/BIC/DZDP_WER1"."SID_0PLANT" =

"/BI0/SPLANT"."SID" AND

"/BIC/DZDP_WER1"."SID_0SALESORG" =

"/BI0/SSALESORG"."SID" AND

"/BIC/DZDP_WER1"."SID_ZMATATTRN" =

"/BIC/SZMATATTRN"."SID" AND

"/BIC/DZDP_WER1"."SID_ZMATERIAL" =

"/BIC/SZMATERIAL"."SID" AND

"/BIC/DZDP_WER1"."SID_ZTRDPARTN" =

"/BIC/SZTRDPARTN"."SID" AND (

"/BI0/SPLANT"."PLANT" = 'P260' ) AND (

"/BI0/SSALESORG"."SALESORG" = 'PLFG' ) AND (

"/BIC/SZMATATTRN"."/BIC/ZMATATTRN" =

'9907F10WP055' ) AND (

"/BIC/SZMATATTRN"."SALESORG" = 'PLFG' ) AND (

"/BIC/SZMATERIAL"."/BIC/ZMATERIAL" =

'9907F10WP055' ) AND (

"/BIC/SZTRDPARTN"."/BIC/ZTRDPARTN" = 'PLDUM' ) )

Realignment for planning object structure ZDP_WER terminated with errors

Job cancelled after system exception ERROR_MESSAGE

Thanks a lot.

Regards,

Timmy