DSO activation Error - Error during in-memory activation

[Former Member]

Hi Expert,

i have the following error message when activating the data in DSO ( SAP BW on HANA )

Error during in-memory activation (see long text)

Message no. RSODSO_PROCESSING094

Diagnosis

SQL Code:129

SQL Text: transaction rolled back by an internal error: fail

Please, need your help.

Regards

Emile

[kishore_bhavaraju]

In my case it was just invalid data, SID error was causing "Error during in-memory activation", I would suggest to check data also.

[Former Member]

Hi Emile,

Is this note relevant for your support package?

1749282 - DSO activation terminates with SQL error 129

Is DSO partitioned? If yes, please check if all settings are correct according to SAP Note 1908073 and 1908075

Please check table RSTSODS field PARTNO where OSNAME = *your DSO*

Is this the only message you get?

Br, Andras

[bharadwaj_m]

Hi Emilie,

I am facing the same error now.

Error during in-memory activation (see long text)

Can you please send me the solution for the same.

Regards,

Bharadwaj

[Former Member]

Hi Bharadwaj,

try adjusting the settings in t-code RSODSO_SETTINGS.

For BW on HANA DB you've specific settings.

Details can be found here:http://service.sap.com/sap/support/notes/1646723

Best regards,

Markus

[former_member182599]

Emile,

We had the same issue. The issue is that the table RSODSACTUPDTYPE is defined as a row store instead of a column store. You can check this by editing the table in SE14 > Storage parameters. If the parameter IS_COLUMN_TABLE is FALSE then its a rows store.

Go through note 1888106  - Table RSODSACTUPDTYPE is not found when activating DSO

Basically execute SQL statement alter table SAPHBW.RSODSACTUPDTYPE column in HANA Studio to fix the issue.

I hope this helps.

Let me know if you have more questions.

-Sid

[former_member229456]

We had the same issue after upgrading to 7.31 SP11 (BW on HANA) and the solution described by Siddhartha Anand (note 1888106) helped us a great deal. The issue is now resolved for us.

[Former Member]

Hi all,

the problem is not solved, but i realized that, after the system update to Hana, some DSO where not optimized for Hana e.g  the DSO in which the data activation is not working. One of the message error is  the missing table RSODSACTUPDTYPE. I guess this table must be created during the migration to Hana. Please , could some one confirm this or am i saying something wrong? How can i optimized the remaining DSO for Hana? What is the purpose of the table RSODSACTUPDTYPE?

Regards

/Emile

[MGrob]

Hi

That is a pre step in the upgrade phase:

Run transaction RSSGPCLA for the regeneration of the RSDRO_* Objects.

Set the status of the programs belonging to program classes

"RSDRO_ACTIVATE", "RSDRO_UPDATE" and "RSDRO_EXTRACT" to

"Generation required".

Please check Note 518426 for more inforrmation.

hope that clarifies

Martin

[Former Member]

Hi Sm,

the request is a delta load with 2200 records

Regards

Emile

[former_member182470]

How did you close the thread without marking proper correct answer? if your question is still open, you should not close it. Have you followed my suggestion?

[former_member182196]

Hi Emile,

Kindly Check your reply i think you are replying to Mr.Surya Chowdary and marked it as a correct answer also,  but it is not a correct ans and  if you mark any ans as a correct one make sure that it is a correct one or if it is a helpful  one for you or to others.

regards,

SM

[former_member182196]

Hi,

Check this SAP Note 1392715 it will help you a lot.

With the help of this note you can resolve your issue..

regards,

Sm

[former_member182470]

Reduce the volume in data packages in RSODSO_SETTINGS t-code.

Don't try to activate too many requests together. If possible delete this request and reload in multiple smaller requests.

[Former Member]

Hi

Please check with your Basis team. They will help to increase your db space.

Hope it will help...

Thanks,

Purushotham.

[RamanKorrapati]

Hi,

Please check with your DB team.

how much data your activating?

Try to use some settings to improve the dso activation performance.

Tx - RSODSO_SETTINGS

Thanks

[Former Member]

Hi

May i know the data volume of the request.

Thanks,

Surya