Restriction on no. of attributes

[Former Member]

Hi,

We are getting this error

"For batch ID 59e3245c47fa4c4d81e3ecfc7559cd0b, data processing unsuccessful in SAP HANA. Contact your administrator. Reason: SAP DBTech JDBC: [274]: inserted value too large for column:  [274] SAPSOP.SOPINTEG_PROCESSING_SCRIPT: line 187 col 13 (at pos 12328): inserted value too large for column exception: inserted value too large for column:  [274] SAPSOP.SOPINTEG_TARGET_TO_CORE_KEY_FIGURES_SCRIPT: line 362 col 63 (at pos 31607): inserted value too large for column exception: inserted value too large for column:  [274] SAPSOP.SOPDM_FILL_PLOBJID: line 71 col 2 (at pos 4609): inserted value too large for column exception: inserted value too large for column:  SAPSOPG.SOPMD_B1CURRENCYFROM, SAPSOPG.SOPMD_B1DISTCHANNEL, SAPSOPG.SOPMD_B1PRODUCT, SAPSOPG.SOPMD_B1SALESGROUP, SAPSOPG.SOPMD_B1SALESOFFICE, SAPSOPG.SOPMD_B1SALESORG, SAPSOPG.SOPMD_B1SOLDTO, SAPSOPG.SOPMD_B1USERGROUP."

while trying to load a key figure  in S&OP.Is there any restrictions on attributes to be used in  the base planning level for a keyfigure? Please help.

Kind Regards,

Sanjeev

[former_member217157 · Accepted solution]

Hi Sanjeev,

There is no limit to the number of attributes in base planning level. We had cases where we had more than 50 attributes and 10 Key Attributes in base planning level of the Key Figure and could load the data and plan. Could you also check that  length of the attribute value in the data file does not exceed what has been defined for the attribute.

The issue could be specific to the model you have. I see a ticket opened in this regard.

Thanks,

Raghav

[Former Member · Accepted solution]

Hi Raghav,

Thanks for your reply.

Kind Regards,

Sanjeev