cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle dumps while processing INDX in multiple sessions

Former Member
0 Kudos

Hello!

This table is used for HR functionality in a standart way for a cache of structure authorities. My programm performs indexing of stru. authorities in parallel dialog sessions. All the data is written to the INDX via EXPORT...TO DATABASE operation. So the size of the transferred data is from several KB up to 100 MB by one EXPORT.

I have started this programm on 6 different systems: dev - 1, tst - 1, pre-prod - 4. This dumps occurs not at all of them. Pre-prod systems has large and similar amount of data.

Here is the stat of multiple runs in the systems

DEV - OK all the time

TST - OK all the time

PRE-PROD - 2 systems - OK, 2 systems - FAILED.

As I said, I made really a lot of runs in different systems. That's why I consider that there is now problem in the data, but it is in the configuration of the Oracle or some profile parameters in ABAP instances.

Oracle specialists advised to upgrade Oracle server up to 11.2.0.4. This is long

Each Oracle is v 11.2.0.2.

How can I understand what is the real problem? PRE-PROD runs gives 50/50 percentage of success...

2 of PRE-PROD systems have Linux OS on the Oracle server and the other 2 have HP OS. Can it lead to the dumps?

Oracle clients on all of the ABAP servers are up-to-date.

Thank you for any ideas!

Accepted Solutions (0)

Answers (1)

Answers (1)

ACE-SAP
Active Contributor
0 Kudos

Hi Ivan

You do have problem with data as at least for one of the dump (ORA-01400: cannot insert NULL) the insert command you issue violates the NOT NULL constraint for field ENDDT of table INDX.

Regards