Planning Area Activation - Invalid Column Name: LOCUM/PRDNUM

[marc_laberge]

Hi,

We are currently moving to our production system. I have exported our PA & MD Types from our development system. When I try to activate the PA in the production system I get errors:

E - ERROR: Activation log contains exceptions, check the entire log for exceptions

This points me to errors like these.

I have no MD attributes that are named LOCNUM or PRDNUM. I have no issues in the development environment. I've read another message here that it could be related to LCODE implementation (I have no custom LCODE).

pa-log.txt

I - transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE#stb2#20161022162857"": line 8 col 3 (at pos 185): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE": line 101 col 9 (at pos 6938): [129] (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE_INTERNAL"": line 448 col 13 (at pos 28245): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_CREATE_MD_TABS": line 426 col 17 (at pos 26736): [129] (range 3): transaction rolled back by an internal error: invalid column name: LOCNUM: line 1 col 135 (at pos 134)

I - transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE#stb2#20161022162857"": line 8 col 3 (at pos 185): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE": line 101 col 9 (at pos 6938): [129] (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE_INTERNAL"": line 448 col 13 (at pos 28245): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_CREATE_MD_TABS": line 426 col 17 (at pos 26736): [129] (range 3): transaction rolled back by an internal error: invalid column name: PRDNUM: line 1 col 90 (at pos 89)

I - transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE#stb2#20161022162857"": line 8 col 3 (at pos 185): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE": line 101 col 9 (at pos 6938): [129] (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE_INTERNAL"": line 448 col 13 (at pos 28245): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_CREATE_MD_TABS": line 426 col 17 (at pos 26736): [129] (range 3): transaction rolled back by an internal error: invalid column name: PRDNUM: line 1 col 68 (at pos 67)

I - transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE#stb2#20161022162857"": line 8 col 3 (at pos 185): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE": line 101 col 9 (at pos 6938): [129] (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error:  [129] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLOBJTYPE_INTERNAL"": line 448 col 13 (at pos 28245): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_CREATE_MD_TABS": line 426 col 17 (at pos 26736): [129] (range 3): transaction rolled back by an internal error: invalid column name: PRDNUM: line 1 col 90 (at pos 89)

[marc_laberge · Accepted solution]

Well ... well ...

I've ran activation again (without selecting activate related master data) and it worked !

Any ideas ?

[marc_laberge]

Hi,

No these master data are not in development. From what I understand they are technical fields created in the DB by IBP.

LOCID becomes LOCNUM basically.

[former_member235875]

Hi Marc.

i have a question? on the development environment you have the master data LOCNUM or PRDNUM, and when you try to pass to enviromente prod this MD are not in development prod?

Jorge