Classical DSO Activation error

[adolfopeiro]

Hi dear experts,

I'm asking you for help since we have a classic DSO that returns the following error when we try to activate the requests loaded via "Get new data request by request":

Just to let know, we're on HANA 2.0 and BW 7.5 and recently migrated to Cloud.

Thanks in advance!

Adolfo

[MartinMaruskin]

Hi Adolfo,

see if Note 2148186 is applicable for your case. It also deals with DSO activation error in database.

Check if table <schema_name>:/BIC/A<DSO_name>70 contains 1 row with SID=-1.

Recreate or modify failing DSO in ABAP

cheers

m./

[adolfopeiro]

Hi Martin,

I'll check it right now and will let you know.

Thanks again!

Adolfo

[MartinMaruskin]

Hi Adolfo,

I'd say check your BW transformation to the DSO first. Is there any characteristics assignment that has is a check on InfoObject 's value that must not be empty? In case so, and there is no value that DB is rejecting such in insert/update..

cheers

m./

[adolfopeiro]

Hi Martin,

Thanks, we already checked that, but I'll double check just in case.

Regards,

Adolfo

[adolfopeiro]

Hi again,

We double checked and we couldn't find any empty infoobject assignment in the transformation:

Let me provide a new snapshot where the error seems to be a little bit different:

Now it doesn't appear to be due to null values, any other suggestion?

Thanks in advance!

Adolfo