increase tablespace

[Former Member]

Hi All,

In MIRO transaction we are gertting dump as 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

when i analysed the issue, at one stage i found that "If the number range is OK, then contact your Basis team for help..

The problem may be with the Table space.."

In our PRD server size of tablespace are as follows:

Tablespace Size (kb) Free (kb) Used (%) Tab/ind Extents AutoExt (kb) Used (%) Status Backup

PSAPSR3 98,856,960 32,064 99 154,827 219,381 204.800.000 48 ONLINE NOT ACTIVE

PSAPSR3700 50,688,000 207,680 99 868 10,585 163.840.000 31 ONLINE NOT ACTIVE

PSAPSR3USR 20,480 18,496 9 30 30 10.240.000 0 ONLINE NOT ACTIVE

PSAPTEMP 2,396,160 2,396,160 0 0 0 10.240.000 0 ONLINE NOT ACTIVE

PSAPUNDO 9,564,160 9,316,544 2 22 199 10.240.000 2 ONLINE NOT ACTIVE

SYSAUX 389,120 66,816 82 986 2,305 10.240.000 3 ONLINE NOT ACTIVE

SYSTEM 880,640 13,376 98 1,204 2,768 10.240.000 8 ONLINE NOT ACTIVE

Kindly suggest should i need to increase tablepace.

Regards!!

[Former Member]

Hi,

As per the error message it does not look like a table space issue. It says SAPSQL_ARRAY_INSERT_DUPREC means its trying to enter a duplicate record in to table which already exists, please read the dump clearly and discuss with the ABAPER or functional consultant. Check from error upate in SM13 also. Since your table space is 99% used extend the same using BRTOOLS, extend table space option and after that monitor your table space growth and have a threshold like once it reaches 95% used, extend the same manually even though the table space in autoextend mode.

Regards,

Sharath

[Former Member]

Hi

I think the problem is in number range.

Check in SNRO

[Former Member]

As suggested in earlier post by Sharath, you need to discuss this with Functional and ABAP team. However, your SYSTEM tablespace should not be that much utilized. As per your inputs, it shows SYSTEM tablespace is 98% used and PSAPTEMP tablespace is 0% used. It could be due to that default temporary tablespace on your system is set to SYSTEM instead of PSAPTEMP. Please, check it and change it accordingly to avoid the trouble in future.

Thanks and Regards,

Kedar

[Former Member]

Hi All,

Above mail was not clear.

Kindly check the size of tablespace:

PSAPSR3 - 99

PSAPSR3700 - 99

PSAPSR3USR - 9

PSAPTEMP - 0

PSAPUNDO - 2

SYSAUX - 82

SYSTEM - 98

Regards!1

[Former Member]

Check what is your default temporary tablespace. If it is set to SYSTEM change it to PSAPTEMP and try it.

Thanks and Regards,

Kedar