ST22 Dumps in BI system while loading data

[Former Member]

Hello experts,

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

Please suggest if anyone has already faced this issue.

[Former Member]

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

[former_member182997]

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.

[Former Member]

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

[former_member182997]

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

[former_member189845]

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

[jay_reddy1]

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.