Error activating infoobjects

[Former Member]

Hi Guys,

I am facing an issue while making changes in Dev environment. To make an attribute of 0CUSTOMER navigational, I had to uncheck 'Attribute Only' flag of a an Infoobject (0CITY in my case). After changing this feature, I am unable to activate the infoobject as it is showing 'Error activating Infoobjects'. And the message is 'Value <Value_name> of characteristic 0CITY contains an error at position 2' (refer below screenshot).

Though I can understand it is because of invalid characteristics, but I am unable to identify the data record and the infoprovider it is used in. As it is a dev env, I can delet the invalid characteristic directly. Though I have tried using Where used list of the infoobject but was not helpful enough.

Can anybody suggest me how to trace the incorrect value and delete it please? Any help would be highly appreciated. Thanks in advance.

Regards,

Sambit

[Former Member]

Hello All,

Thanks for your suggestions but in first place, I am not able to identify where this error record is loaded to (any info provider name). Once I identify that, then I will be able to know the invalid record. As this object is used in many objects but the data record which I am trying to identify is unknown.

Can anyone suggest any other trick I can use to identify the same? Please note that this is a dev env, so I can experiment (if possible) without much worries.

Thanks in advance.

Sambit

[evgeni_novozhilov]

Did you tried the trick from my post above?

[RamanKorrapati]

Hi,

Have you maintained master data to 0city info object?

if yes then please check master data.

if not then please seek more information from error log.

Thanks

[Former Member]

Yes it says no log exists in the database.

[Former Member]

Hi Raman,

Yes MD is maintained for 0CITY infoobject but could not find the error record containign invalid characteristic and could not analyze the error message further. Is there any other way I can analyze the error message in detail?

Thanks,

Sambit

[RamanKorrapati]

Hi,

Go to your info provider 0city.

From there you can go to your PSA-->manage-->see here available requests. in that check  latest request data.

Keep filters on 0city or related ecc field at PSA and use wild chars along with text *HALLORAN HILL*.

You may find the wrong text data records. modify them and reload to info object 0city.

it may overwrite the old data.

Thanks

[RamanKorrapati]

Hi Dash,

Your settings are fine.

But the data which you already loaded/maintained without activation for city is wrong.

Mean BW server is not accepting ' (single quote), so you need to edit your city name - O'HALLORAN HILL.

The junk char which is exist in your city name between O and H is not allowed.

that's you got above error while activating info object.

at Tx -RSKC try to maintain that junk chat and later try to activate it.

Other wise ask source team and modify the record at at PSA.

Thanks

[evgeni_novozhilov]

You can try to delete the incorrect record in master data maintenance dialog. It will not be deleted actually because this record is in use, but it will show infocubes where this record is used either in dialog itself or in SLG1 (object RSDMD).

[former_member183334]

Hi Sambit

for this error please implement the note with support of BASIS Team.

Thanks

Regards.

[former_member186053]

Hi Sambit,

Can you please check infoobject in RSRV for consistency. Even you can check the error details in long text and do analysis based on that error.

Regards,

Vengal.

[Former Member]

Hi Vengal,

Tried your suggestion but it is not showing any error in RSRV.

Thanks,

Sambit

[sander_vanwilligen]

HI Sambit,

I am afraid that the error message has to do with not permitted characters.

Please have a look at my blog where I introduce a Character String Cleansing add-on. I sugest to implement in the Transformation rule for the affected Characteristic. Then reload and activate the master data. After that you can try again if you are able to make the change.

Best regards,

Sander