cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ST22 Dumps in BI system while loading data

Former Member
0 Likes
486

Hello experts,

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

Please suggest if anyone has already faced this issue.

View Entire Topic
Former Member
0 Likes

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 Member
0 Likes

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
0 Likes

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