Question Re: ST22 Dumps in BI system while loading data in Technology Q&A

ST22 Dumps in BI system while loading data

Former Member — Wed, 04 May 2016 12:34:36 GMT

Hello experts,

We are getting following dumps while loading the data in BI system.

Please suggest if anyone has already faced this issue.

Re: ST22 Dumps in BI system while loading data

jay_reddy1 — Wed, 04 May 2016 12:45:30 GMT

hi,

looks like dead locks occurring while loading .

check DB01/other dead lock t codes to find culprit.

if it occurs regularly chk with BASIS.

while loading to cube prefer delete index and load data to cube.

Re: ST22 Dumps in BI system while loading data

former_member189845 — Wed, 04 May 2016 12:46:06 GMT

Hi Prapat,

There is lock while accessing the data fact table, I suggest you to wait and re run the process or load the data, also check if there is any ACR of object in that info cube is running, if it so let the acr gets finishes and then re trigger your failed load

Thanks,

Siva

Re: ST22 Dumps in BI system while loading data

Former Member — Wed, 04 May 2016 14:46:00 GMT

hi Parab,

there are two different tables in your screenshot. I want to undertsand if there are dependecies between them. What is your dataflow can you tell?

Also , is the data going out from these tables to any other infoprovider?

Please tell about all these and a good suggestion can be given

thanks

Re: ST22 Dumps in BI system while loading data

Former Member — Wed, 04 May 2016 14:49:31 GMT

The error says that it is a temp space issue while running queries in parallel.

You should be able to fix it by increasing the PSAPTEMP space. Check note 659946 for this.

Thanks

Amit

Re: ST22 Dumps in BI system while loading data

Former Member — Wed, 04 May 2016 15:35:58 GMT

hi Amit

good catch ,,, in a hurry i dint follow this.
well it is occurring for the active table DSO as per screenshot , for which BASIS can increase the space . Parab please approach BASIS and once the space is increased dtp will be able to access the active table.

Re: ST22 Dumps in BI system while loading data

Former Member — Wed, 04 May 2016 18:55:09 GMT

Just to be clear, PSAPTEMP is not dedicated to PSA table. It is SAP database level default temporary tablespace so it is used in all the temp storage calculations at database level even in queries.

Check 659946 - FAQ: Temporary tablespaces for more clarity.

@Prapat: There SAP notes for recommendations on PSAPTEMP table spaces and extension, you might follow that with basis guys for that.

Regards

Amit