Error while activating multiple requests in ODS.

[Former Member]

Hi All,

I get a "ORA-12801: unable to extend temp segment" error while activating an ODS. The problem is I selected 7 requests for activation and my Basis guy tells me he cannot add any more files to the temp tablespace.

I guess the solution would be to re-activate one request at a time. However now the dependency has been enforced between the requests and I cannot activate a single without selecting the other requests.

I even, subsequently, selected "Do not condense option..." AND the "Process Request serially" options. I get the same error.

Is there a ABAP report that can turn off this inter request dependency ?

Thanks.

Dorothy.

[Former Member · Accepted solution]

Hi Dorothy,

Take a look at OSS Note:785732

Bye

Dinesh

[Former Member]

Hi Dorothy,

If nothing works then I guess you can open an OSS message to SAP and they would look into it.

Bye

Dinesh

[Former Member]

Thank you for the quick reply !

Dinesh: I looked at the note. It applies to oracle systems < 9.2.0.6. We are at 9.2.0.6. The paramter COMPNOMERGE is missing in RSADMIN table. The note however is right on the money for the problem I am experiencing.

Bhanu: I applied your suggestion. The test yielded no errors.

[former_member188975]

Hi Dorothy,

Please try out the RSRV test for the ODS changelog > Elementary > PSA Tables > Consistency between PSA partitions and SAP Admin Info.

Hope this helps...

[Former Member]

Dorothy

First identify the seequence of loaded requests and start activating one after other or ask your basis team to increase table spsce if they could.

Hope this helps

Thnaks

Sat